Hi,
Can anyone show me the correct syntax for changing a tab control to a
specific tab in response to a button's on_click event? The button is on a
separate form from the form that contains the tab control.

is there a way i can make it so they can fill out a form but it doesnt save
it to the table until they click the next button to go to next form of the
survey?????
i want this because if i was just to show someone the form(ie open it, i

I am returning the Min and Max of field [Period] by making two passes through
the database as follows.  It is very slow.  How can I speed this up and do it
with one pass and speed up the process also?
Thank you for your help.

I have coded an purchase ordering routine that will create multiple
instances of a purchase order form that the user is able to fill in and then
print. From the main form that will be generating the purchase order, i have
information such as who the order will be issued to, etc. ...

i need to change my code so that the
Private Sub Command75_Click()
event doesnt happen unles the user chose "yes"
when prompted to save record, because then they choose cancel or no to not

Does anyone know the code to set the height of the rows in the detailed
section of a pivot table form?

Is there a way to jump ahead in the tab order?
I have a form where the user enters an ID number.  If the ID already exists,
the customer information is populated, and I'd like to skip to the shipping
address.  I can't use SetFocus because I'm checking for the ID in the

I have a form that shows one record from a table at a time. I want to
know if I can turn off and on the editing of these rows. Some rows I
want to allow the user to edit others I do not. Any help is appreciated.

Private Sub Form_Load()
Dim strNextNumber As String
strNextNumber = Nz(DMax("ID", "General Housing Survey"), 0) + 1
strNextNumber = Me.ID

I have used the following code which works great, the only thing is that I
want my subform to open as a dialog form.
Private Sub Inactivate_Click()
' This code created in part by Command Button Wizard.

hi i need this code in form load but i dont know what the code is to put it
in form load im sure one of u guys can quickly answer this lol.
private sub formload?hehe
Dim strNextNumber As String

I have a command button on a form that is linked to a macro that runs queries, saves the data to the form's table, etc. The table has required input fields and so when the command button is selected without all fields entered an "Action Failed" error message appears with "Halt", ...

Hi, I would like to ask about how do i pass the parameter which i used in a
subform to be displayed in the main form. The parameter is used to relate
both table. The user will not have to type the parameter again as it will be
insert into the field when it is being queried.

I'm working with a new client that upsized from A2K to SQL-S. Access is
using SQL-S as linked tables. Many of his forms retrieve all the records from
tables, via queries. Big time delay now that SQL-S is the backend.
All he ever works with is one record at a time. A combox exists ...

Hello,
I think this is probably an easy question, but I need a
little help.  I have a combo box on a form that locates a
record.  It works fine except for the rare occasion when