Help in programing in Access 2003 > Partner Forums > PartnerPoint

Register Login

March 15, 2010

Home

Companies
       A Directory of Microsoft Partner Companies

Software
       A Directory of Microsoft Focused Software

Documents
       A Microsoft focused Document Repository

About Us

Get Listed

Partner Community
       Partner Forums
       Chat Rooms
       Member Map
       Member Spotlight
       Virtual Campus
       Webcasts
          SEO Webcast Series
          Microsoft Matchmaker
          LinkedIn for Microsoft Partners
          Building Sales Compensation Plans that Work
          Twitter Webcast
          Connect: Microsoft Dynamics Partner Community
       Social Networks
          LinkedIn Group
             LinkedIn Search
          FaceBook Group
       News/Blogs
          PartnerPoint Blog
          Microsoft News
          Partner News
          Microsoft Guest Blogs
          Blog Submission Form
          Bill Gates History

OnlineChatSoftware

Partner Community

Partner Forums

Web Site


	Important Tip You must be logged in in order to create or reply to Forum posts.

PartnerPoint Member Forums

Unanswered Active Topics

Forums Search

Forums > PartnerPoint Community Forum > Technical Topics

Subject: Help in programing in Access 2003

You are not authorized to post a reply.

Author

Messages

landtech

User is Offline

Posts:1

12/17/2007 7:16 PM
I have a problem that I need help with the issue is I need an auto number created with a variable created from another field in access

Sco

User is Offline

Posts:1

12/18/2007 7:39 PM
It's going to take some code. Depends on exactly what you want. Although it will not be exactly what you are looking for, you'll find a starting point at http://support.microsoft.com/kb/210194. If you Google for access custom autonumber, you'll find a ton of articles. Good luck. Sco

bhicks11 (guest)

03/10/2008 6:41 AM
I use this also and it's easy. It takes a real autonum field (autonum1) and another field to create your calculated autonum. You place a control bound to the custom autonum field (autonum2). We'll call the field you want to grab the variable from variable1. If you are using a form, set the default value of the custom autonum to the autonum value plus your second field. Like: autonum2=autonum1 & variable1. Easy peasy lemon squeezy. If you aren't using a form, do it through an update query.

You are not authorized to post a reply.

Forums > PartnerPoint Community Forum > Technical Topics > Help in programing in Access 2003

ActiveForums 3.7

Minimize

Partner Forums - Share this page -

email |

digg |

	Home\|Companies\|Software\|Documents\|About Us\|Get Listed\|Partner Community
	Copyright 2007 by PartnerPoint Terms Of Use Privacy Statement