Results 1 to 2 of 2
  1. #1
    Glyn is offline Novice
    Windows Vista Access 2003
    Join Date
    Dec 2009
    Posts
    1

    Automate field in a table


    Is there a way to automate a field in table on report to allow the following to display and change as you create new entry 2009/0001. I want the year to change when year passes and the 0000 represents documents so when I create a new record I would like to automatically change to 0001, 0002 etc,

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows XP Access 2003
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    before i comment on the problem i must know do you intend your number to have have only a digits e.g. 0001.
    once you make this clear i will give u the solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Automate Compact and Repair process
    By tracerbullet in forum Security
    Replies: 2
    Last Post: 01-14-2010, 05:12 PM
  2. Replies: 4
    Last Post: 09-03-2009, 02:01 PM
  3. Automate....
    By kusamharsha in forum Queries
    Replies: 3
    Last Post: 05-14-2009, 03:02 AM
  4. How to automate a access query ... Help me
    By kusamharsha in forum Programming
    Replies: 0
    Last Post: 02-25-2009, 09:44 AM
  5. How to automate printing and saving reports
    By lilynet in forum Programming
    Replies: 0
    Last Post: 02-10-2009, 01:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums