run access 2003 works fine.while synching one of the files to the palm it looks like the auto numbers has gotten corrupt. the last 2 numbers where...

I notice ur 10 commands say never expose the autonumber. I have 2 tables tblContracts and Lots linked 1 to many enforced on autonumber in tblContracts. That...

Hi I created a new database with all my required tables etc. The Ref # in the table is set to autonumber. The table name is "Trade Data" However I created a...

I currently have a table that has data in it. I would like to add an auto number field. Every time I add the field, make the datatype auto number the...

Hi I have an Auto Numbger Field... I have some test records in the database to test... How can I delete the test records and make the Auto Numebr Field go...

I have an auto number field in my table for primary key. It does not let me to create relationship when I have auto number field. Should I use long integer...

How do I reset my Auto number to 0000 after putting in some test numbers it now starts at 0010 even after I delete the data?

Hello, I have almost completed my database, but I am having problems with the auto numbering. It's a project database which is assigned a unique project...

I'm trying to number my job entries in a new database (one I'm creating). Can someone direct me toward the correct expression for this auto numbering...

I am creating a data base and want to add a formula to my table so that when a form is filled out an automatic number is assigned to each new document. The...

I have a field of Autonumber in my table i would like to start at 50000 so i use the method of appending a record with the value that i want the auto number to...

How do I make an ID number display the next avalible number when you get ready to make a new entry and then have the ability to overwrite it to create my own...

I was suprized to find out that there is almost no post info on automatically backing up databases. the one post i found had code for SOON (shut one open...

I have an Access data base that has acumulated 7 years of HR info. We plan to moving this info to HR Application. The new application has a field called field...

I have a table that populates specific data from a SQL view when I manually run an append query - works fine. What I really need to do is have that table...

How do I have a field(s) populate automatically based on a selection made from a previous field. For example, A user selects the employee ID in one field...

Hello, not sure how to do this but what I need to do is have one table get info for a field by pulling information from 2- 3 other fields and then use this...

I have the formula: =((()+(*)+(*))/((++))) * 100 which is supposed to find an overall percentage of the work completed based on monetary values entered in...

I have created a db that tracks equipment repair/expense. I have been asked to create fields in an entry form that would auto-populate based on information...

How do I create a process for producing a report based on an individual record in my database. I need to produce a report each time I add or amend a record in...