Hi Groupies:
I found the GetOpenFile code while looking through some other
threads....thanks for steering me the right way!
I have used it in my code to export a query to excel, but I have one little

I have a Listbox.  I'm using an SQL statement to fill the rowsource.  Here
is the problem.  If there are no records in the rowsource from the SQL
statement I can click on the list box and nothing will happen.  This is
good.  However; if I set the listbox's rowsource as such Me ...

This statement is not updating.  All of the criteria is there, These are all
number fields.
Thanks
DS

I have a form hierarchy that's something like this:
Exam Mockup
   Category
       Topic

Any ideas why this runs slow??  Is there a faster way??
'Process Archives for old or missing data
For i = 0 To DateDiff("d", dStartDate, Now())
   strSalesDate = Format(dStartDate + i, STRING_IMPORTDATE)

I've been working on a copy of the office master database, and have made
some significant changes (added and updated forms, added tables and queries,
relationships added....).  ...); and am now ready to put the updated file
"on-line" for the office to use.

I experienced error messages when I wished to validate data in a text box
through the before update event in Access 2007. After multiple attempts to
find the problem, I finally created the simplest database with only a table
with two variables, a auto numbered and a text field ...

I have a form with a MT connections template (gathers the weight of pallets
that cross the scale) on it. It also has [Crew], [ProductCode] and [LotNum].
When each pallet passes the scale the weight is recorded on the table, but
the other 3 fields are not. I tried using ...

Hello All
I tried this post earlier, however got a web timeout so I hope not to have
repeated myself
I have a continuous form that can vary from 3 records to 65 records

I have created a combo box that is dependent on the table/query.  The combo
box is functioning flawlessly, but I need to be able to navigate the form
using only the keyboard.  Currently, 'tab' will bring me to the combo box,
but no keyboard control exists for selecting from the ...

I have a combo box whose row source is a table of company names.  If the
Company the user wishes to select is not yet in the table, I have allowed for
the dblclick event to open a form (record source company table) to input the
new company's information.  My question is this:  ...

I keep running into the issue of my forms being uneditable. So far, it
has always been a design thing -- I needed to separate the source data
into further tables, to avoid "overlapping" queries.
However, I am running into an issue now where *some* queries with

I am trying to figure out how to code a form so that when someone types in a
particular SSN (111-11-1111) it will prefill the first and last name. (WIC /
WIC)
The text box names are as follows:

Trying to populate an unbound field using continuous forms when the form
opens.  I have the following in the ControlSource of the unbound field:
=DLookUp("[" & Me.audField & "]",Me.audTable,"CourseID = " & Me.recordID)
Getting #Name? error in the unbound field.

1) I have a table, Scheduled Assessments, that consists of Question
Name [text, primary key], Scheduled Assessment Date [date], Assessor
[text], and Target Score [number].
2) I have another table, Assessment Scores and Dates, which is a