I have some old code that I tried to fire up this morning. I'm using
MS Access 2000 with the DAO 3.6 Object Library reference at its
highest priority.
When I try to compile I get the "Method or data member not found"

Peeked around here but didn't really see an explanation as to the
varied "Invalid Argument" errors that appear in Access sometimes. I'm
using Access 2003 and trying to import an Access table of ~200,000
records into my DB. I've tried importing, linking, exporting the

I have a field with a text property used to store SSN. It has this
format: 123-45-6789
Is there a way I can update the field to show 123456789. I would like
to remove the dashes. Thank you.

I have a report that is based upon a crosstab query which return only the
columns (fields) it has data for.  When my report runs it sometimes fails
because some of the text boxes don't have a field in the query.  I've
written some code to "fake" the missing field names which ...

How do you pass more than one argument using OpenArgs?

I open a report with a button on a form and I'd like to have the report
open to the last page. I tried using sendkeys and it works when I
manually open the report from Reports on the msaccess screen, but when
I use the button on the form the report opens to the first page. It

I do not know what happened, but all of a sudden, a particular row of
records had changed to "#Deleted" to all of them.  What might be the
cause, and how to prevent this?  This is not the first time, but it
usually involve a field within a record, but this time it involved all

I've seen how to use VBA code to concatenate two fields into a third by
using an expression in the "After Update" property in fields 1 & 2.
field3 = field1 + field2
The above code would go into both fields 1 and 2.

I have two queries:
qReg:
SELECT tblRegionalExperience.ConsultantID, tblRegionalExperience.RegionID
FROM tblRegionalExperience

I have "cmb A" and "cmb B", "cmb A" lists tables names and "cmb B"
should list the fields of the table name selected in "cmb A".  I've
tried to implement it but I it doesn't work!  Any help would be
appreciated.

Probablly a simple answer but I'm not sure where to begin. I have one
customer form that can be opened two ways. One of the fields in the customer
table is ActiveCustomer. If users open the form from a main menu I want the
form to open but only contain records where ...

      I am having a problem with a MS Access 2000 Database that I
partially helped create. I am recording visits that registered
customers make to our store. I have a list of all the elidgible people
that can shop, and when I click a button, it records a visit for today

I am front ending a SQL Server database with MS-Access 2000. The UI has
many buttons that launch VB code. One of the buttons launches a lengthy
process that takes 20-30 seconds to complete. If the user starts
clicking their mouse off of the active window the Access Toolbar

I am trying to create a subform that will display images related to the
parent form.  The subform is a continuous form as there will be several
images that relate to the parent form.
I checked Access help and it gave me the following code, which I have

Can any one pleaset tell me how to i add AM and PM with that line. So
that according to the time it will be shows AM or PM.
Me.lblTime.Caption = Format(Now(), "HH:NN:SS")
Thank You.