I have a form with two combo box value list fields: reportName, fiscalQtr
The form these fields are on shouldn't store the data.   When I created the
value list
I chose store the value for later use.  I noticed that there are 8 records

8 + 2      10
My accounting program does this

I have a form that contains 8 subforms (organized by tabs) and each subform
has it's own table. Each subform table is linked to the master through an ID
column. Data is entered into the form and then saved. All together on the
form there is about 200 fields. There are times when ...

the code below does not seem to loop properly, anyone have a notion? It runs
from a button on a form and it only writes the record that has Focus when the
button is activated.
  On Error GoTo ErrHandler

how to search records from the Right using the last 2 digits Ex.  "22" would
return record  "14522"

I have a combo box with the control source named Participant Name.  If a
particular name is selected then I want to have the current date
automatically fill into a different text box and keep that date.  Then if
that same name is deselected in the combo box then the date ...

Greetings all.  Is there a way to show an hourglass while a form is loading?  
I am using Access 2003.  I have seen references to this topic, but I can not
find an answer.  Thank you.

From the list box _Click event, how do you find out whether the item that was
clicked has been selected or de-selected?
Private Sub lstMyList_Click()
    if lstMyList.???.Selected(???) = True then

I have an empty form with 1 field.  It is fiscal quarter.  There is a fiscal
quarter table
with the fiscal quarters.  I want a value list combo box that allows the
user to choose a quarter to filter a report.  Here is the SQL:

Access2003   Have put into a form's OnLoad event:
DoCmd.MoveSize 4440, 5440, 3440, 3440
wanting it to open to about 3x4 inch size, located toward the right lower of
screen....yet it continues to open full size on top of the current screen.  

I have a database that currently has about 3000 records. There are about 8
users entering imformation through the day sometimes at once. As loans come
in, one person is entering the information but if everyone is in the
database, how are they able to see the new records being ...

I'm using this with Access VBA.
Open "Com1:19200,n,8,1" For Output As #1
Print #1, "Printer On"
Close #1

I'm not sure how to design this. I have a table with these 3 pertinent fields:
tblPKFMsMaterialLayers
txtProfileID (PK)
txtLayer (PK)

I have the following public function
Public Function Repeats(Combo As ComboBox, Combo1 As ComboBox, Optional
Combo2 As ComboBox)
It works fine when all the arguments are there, but i don't know what to do