Ok now Im confused, I changed the starting No of my autonumber the other week,
worked fine. I have now added a few more bits to my db and want to do it
again to clear it all ready for use and its not doing it, maybe me??
I am trying to make it start on 4183, so far all I have amaged ...

HI
Iam trying to display a form on its own without the access window
being visible, from previous posts I have got the following code,
Private Sub Form_Open(Cancel As Integer)

There are many forms needed and each one only has buttons, labels and
captions on it. Here is my design idea. I would like design one form and
reuse it with a different set of buttons, labels and captions.All these infos
can be retrieved from a table when a form is being built. ...

For the previous access versions I was using office developer for creating
installation sets for my Access program. In office 2007 how we can create
installation sets ?
Thanks a lot in advance.

I tried to go another route and use the form_Open
Using this code, how do i set this....If loop to any number (defaulted)
between 00 to any new year coming up?
If x = 10 Then

HI let say I have all the information I need in the recordset, if I need to
look for the # of Purchase Order to add to the order when is included, do I
need to do another SELECT….. to the number of the PO and  put the PO number
in the recordset and lost all the information I have ...

I have a form with 2 nested sub forms, but I can't get it to do what I what.  
If the forms are A, B, & C I want C continous in B and then B (along with
continuous C) contiuous in A.  What I get is C continous in B and B
continuous and C continuous. Huh???

How can I show two consecutive records on a form containing numerous records.

Hello, i hope someone has answer to this.
i have a list box on a form and from this i am creating a history table. the
list box has a row source a query that contains more column then what's
showing on the list. how can i append the rest of this column to this new

I have a command button that picks up the Supervisors name from my log in
table and using the send report option it places the report and TO:
SUPERVISOR NAME in my email along with a subject.  
It comes to the screen and I have to hit SEND to get it sent.  Is there a

I have a form that has three subforms that overlay each other depending on
what is requested on the form.
So, there's the main form with it's buttons and such
Then, there's subform1, 2,and three that lay directly over an area of the

I have a form that is baed on a particular query that contains two different
sets of date criteria.
By default, the form opens with the beginning date this item was generated
generated and ends with today's date.  But there's a search box on the form

I have a form with 5 tabs that I want to use as a data entry input form.  How
do I incorporate different tables into this form.  For instance, one tab
deals with types of boats and has a table while another tab on the same form
has information about the types of amenities at the ...

I have a table with 5 fields: ReportName, Export, Print, ExportTo, SaveAs
I'd like to have a form that when a button is clicked, it will look at the
table and if the Export field = true, then export that report using SaveAs as
the name to save the file as and ExportTo as the ...

Is it possible to filter a form (based on table A) on a value in a table B
where the tables are linked?
Table A
ID