I have a login form I've created for an Access 2007 database.  There are
three controls on the form; a username and password textbox, and a command
button.  When a user enters his name and password and then clicks on the
command button I have code that validates the username and ...

I've tried repeatedly to make a part number combo box work.  All other combo
boxes on my form work, but for some reason this one will not.  I have tryed
to use this field in other forms (by itself) to try to figure it out, it
doesn't work on the others either.  Could there be ...

To quote the Access online help:
You can use the AutoExpand property to specify whether Microsoft Access
automatically fills the text box portion of a combo box with a value from
the combo box list that matches the characters you enter as you type in the

I have a barcode (2D) which transfer the information to my form.
The last recod in the form is like 005} and it stay there (textbox)
And I want to move to a new record so I wrote
Private Sub Suffix_Dirty(Cancel As Integer)

Created a simple continuous form in Access07.    Used basic form design;
assigned the record source as a query and then used the field list to drag
fields onto the form.
The record source query runs fine.   But the form throws parameter prompts

Very rusty beginning access user wants to create db to track, record,
and calculate car payments made by customers at used car lot.
Currently using excel spreadsheet for each loan.
Need help with structure of db.  I think I need the following tables:

I have a query in which I am calculating time between 2 procedures with this
formula:
Time1: [Procedure1]/60 & Format([Procedure1] Mod 60," ")
I am trying to create a report with all the entries.  At the bottom of my

I have a Form that pulls information from different tables and queries but I
would like to be able to filter only certain information if its possible.
here is what I currently do.  I have a mainboard with buttons.  I click a
button to open the Form.  The Form shows job numbers, ...

I have a form that contains a combo box and two text boxes (among other
things).  When the user chooses a name from the "students" table the other
two text boxes get populated with the corresponding values "age" and
"gender".  this is working fine.

Why won't this work?
I have already got Microsoft Access 11.0 Object Library ticked.
Dim strFileName As String
   With Application.FileDialog(msoFileDialogFilePicker)

I am creating a database where the user needs to view photos linked to
each record.
I want to add a browse button somewhere to find the path these will be
stored on, and another to browse to the actual file and store the

Hi everyone, I am using the following code in the event an item isn't in my
list:
Private Sub Plaintiff_s_Firm_NotInList(NewData As String, Response As Integer)
Dim strSQL As String

I'm so bored with this! I have googled it to death.
Is anyone clued up on a OpenArgs bug? It's the same old issue that has come
and gone over the years.
Form1 has OpenArgs set to a value be it through a string variable or

Hi......i've set up an option group on a form which has 6 possible
selections. It is bound to a field in a table and seems to be working fine.
However when i generate a report from that table, i get the numeric value
displayed but i'd prefer the text. Any ideas how i'd get around ...

I have a form set-up with combo boxes from multiple tables.  Once all of the
data is entered into the form I would like to press a button and have the
information from the form export into a separate table.  Example: from a
combo box the person could choose the origin city (from ...