Access 2003
I have a form that is very long (20in)
I have added a "Tab Control " to the form and sized it to about 19 inches.
Problem is that when you open the form (regardless of resolution, laptop, 22

Ihave two forms, called Form1 and Form2.
Form1 contains Command1
Form2 contains combobox1 and combobox2
I want to open form2 using command1_click.

I have a form with a subform. The main form has names and dates and the
subform has products. The only way the order will print is if the subform has
an entry in it. I would like to be able to print just the customer info at
times. I have tried putting code in the print command ...

Hy,
I have a question. When I open my form, but I decide not to save that
record, I delete everything from fields in form, but when I close my form,
and open the table, I see that I have 1 empty row in my table.

I have a form set up with the following as the Record Source:
SELECT DISTINCTROW tblDMInspecDet.*, tblQuestions.QstWithPtVal,
tblQuestions.QstID FROM tblDMInspecDet RIGHT JOIN tblQuestions ON
tblDMInspecDet.QstID=tblQuestions.QstID ORDER BY tblQuestions.QstSortOrd;

I have created a table which contains info about facilities; sample lines are:
   Course ID   Golf Course  Chapter Facility
      1                ABC            X3        Salinas
      2                XYZ            Y4         San Jose

I have a table that has only one line and one column (plus autonumber ID). I
know it sux but it's the only way I found to make a euro/dollar exchange rate
that user can change - I just need this one value.
I have managed to make a form to modify the rate (a simple SQL command), ...

I have created a crosstab query using a definition in VBA that calculates the
percentage. Is there a way I can reduce or eliminate the decimal places using
VBA?
thanks.

This is a new one that I have not seen before.  I have a client that when she
run my program she tries to print a report, ( I display the report on the
screen first) she get the following error message, it is an Access message
"There was a problem retrieving printer information ...

I have tried to prevent certain changes in an unbound listbox control
with the statement "Cancel = True" in the BeforeUpdate event, but that
doesnt seem to work. I have a single-selection listbox and all that
seems to do is not allow me to change focus to another control. I am

Hi....
I am learning about read only.   I  set read only but except one
field
that need to be edit.   I am not going to figure it all night long.

I've seen a few threads regarding a macro available to center the text
vertically within a text box or label, but it only works in Access 2000.  Was
this feature finally added to 2007?  If so, where is it hiding?  OR, does
anyone know of a new macro available that works with ...

This seems like it would be easy to do but I can't figure it out...
I have a login form where the user selects his/her User ID and enters a
password.  The user then selects a command button to sign in.  The command
button runs through some code which checks the password and then ...

I have a yes/no field set up in a table and on a form as a radio button
group.  I have the default value in the table set to be nothing, but every
time I open the form to add a new record, the default value of NO is
selected.  What am I doing wrong?

I have a combo box that is populated from a table. It has two columns. I want
to take the value from the second column and fill in a field elsewhere on the
form, on the afterupdate property. Right now i am using a macro to fill in
other fields, so would like to use the setvalue ...