id #'s jumped from 1,2,3,4,...906,60839234 why
I was expecting the next number to be 907

Sorry about the previous post.
I am changing the data type for a feild and it seems that there are a few
records in that feild that won't fit the mask. I don't want access to delete
them, but want to find the record and fix the three that will not work. The

I am a new user and is trying to create a Form that should do 2 basic
functions
1. Provide users with periodic infomation from another Data base which I
have done using Query?  

Is it possible to print a list of tables in a database.
I am using Access XP with Visual Basic 6.0 SP5.
I would like to print the list from either program.

I have a database that is on a Citrix server.  There is only one user for the
database.  There is one main form that has three subforms on it and is the
main form for entering data.  When the user tries to enter data into the
fields on the form, Access will just close ...

I have a main form (which contains Box Number Details) and a sub form # 1
that has the contents of each box (each form is connected to a separate table
but joined by a primary and foreign key) - this works fine.
Now what I would like to achieve is to have another sub form # 2 ...

I've been asked  to create queries (for example all songs by an artist) in a
CD Collection database. The query can only retrieve some songs for some
artists and no songs at all for other artists. I've checked the query which
seems ok. I think the problem could be because it is a ...

I've recently experienced a problem in an Access application I have
developed. I stumbled on a user that uses this application on a compter set
to a different screen resolution that the others.
The problem is that I have so MoveSize actions in my VBA code and it has a

I appreciate the value of this helping community!
I have a question that follows an earlier response that helped me in dealing
with a many to many relationship but has me currently tangled up in my
re-design.

I have a Select Query that has a criteria to only pull the record based on an
ID# from a Form.  However, the Query is pulling 2 records, the record that
matches the ID# and the AutoNumber Record that doesn't yet exist.  There are
default fields in the form, could this cause it to ...

I'm a complete newbie trying to design a relatively simple data base for
organizing choir music.  I need to store arranger and composer names and be
able to search for them.  I will not need to track or display first and last
names separately, so I would rather not use separate ...

I have an Effective_Date field in my table and need to calculate due dates.  
If the date is before or equal to the 15th of the month, show the Effective
Date, if after show the first of the next month, that would be the 1st due
date.  Then I need to show the second date as 30 ...

I'm trying to remove a blank field in my report through visual basic but it's
giving me a syntax error--I'm new to Access so i'm probably missing something
simple. Here's my code:
Option Compare Database

I have another easy one for you guys.    I need to convert 20100805 to a date
format of 08/05/2010.   Any suggestions?

I have 2 tables that both include ID numbers.  Table 1 has payment data for
each record, which I would like to add to table 2, but the data being updated
in table 2 needs to match by ID number.  example:
table 1