Register   Login  About Us  |  800-401-8413     
 


    September 3, 2010
Home
       Microsoft Dynamics
          Dynamics CRM
          Dynamics GP
          Dynamics AX
          Dynamics NAV
          Dynamics Blogs
          Dynamics Social Mashup
          Microsoft Dynamics Resource Center
       Microsoft SharePoint Partners, Software & News
       Microsoft Exchange Partners, Software & News
       Microsoft Biztalk Partners, Software & News
       Alphabetical Partner List

Company Directory
       A Directory of Microsoft Partner Companies

Software Directory
       A Directory of Microsoft Focused Software

Document Repository
       A Microsoft focused Document Repository

Targeted Search

News

Membership
       Basic Membership
       Silver Membership
          Silver Membership Upgrade
       Banner Advertising
          Banner Advertiser Management Page

Community
       Partner Forums
       Chat Rooms
       Member Map
       Member Spotlight
       Virtual Campus
       Webcasts
       Social Networks
          LinkedIn Group
             LinkedIn Search
          FaceBook Group
       News/Blogs
          PartnerPoint Blog
          Microsoft News
          Partner News
          Blog Submission Form
          Bill Gates History
 		 
 
CommunityPartner Forums  
spacer spacer spacer
spacer
Browse Partners
spacer
spacer spacer spacer
PartnerPoint Member Forums
Forums > PartnerPoint Community Forum > Technical Topics
Subject: Help in programing in Access 2003
Prev Next
You are not authorized to post a reply.

Author Messages
landtechUser 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
ScoUser 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
 
120*600
spacer spacer spacer
spacer
Quick Links
spacer
spacer spacer spacer
 
 
Home|Company Directory|Software Directory|Document Repository|Targeted Search|News|Membership|Community |  
Copyright 2007 by PartnerPoint Terms Of Use Privacy Statement