what is wrong with this code:
Private Sub cmdExportToExcel_Click()
   Dim savePathAndFileName As String
   Me.txtCompleteFileName = Format(Me.txtFilterOrderedDateFromHidden,

I have a function that checks a record's Status field and, based on the
status, calls a status-specific Sub. My problem is I don't know how to make
the Sub see the current record in the recordset opened by the Function. I
could write all the code inline in the function, but it ...

Need to programmatically link a new table to an external DB.  First, I  would
export the table to the backend, and then I want to create a link to this
table.  I know how to Refresh an existing link (using code that I found on
this site), but can't figure out how to create a new ...

Is there a way to programmatically create a link to an external database
containing multiple tables?
I am working under Access 2003 and distribute an *.mde file to 6 different
location with out any tables linked, all the locations use the same tables

Hi,  I'm completely new to VBA so need a very lay-person's answer.
I need to send an email to 900 email adresses, (Table A = a list of the
email addresses each with a unique identifier).
Each recipient must have have thier attachment, (Table B has the required

An SQL stored procedure returns 0 if it completes correctly and a negative
number to reflect an error.
When calling a stored procedure from Access, how do you capture this return
integer in order to capture whether the called stored procedure has succeeded?

I'm trying to use the .Net interop assembles as a test-bed for an Access 2003
application.  This appears to be the best tool since I can traverse the
objects on a form, etc.
BUT - how the heck do I click a command button??  Here's my code so far:

Hi there, im running in to some major problems with this Replication crap in
Access.
So we had a corrupt db and I recreated it in to the common drive. When I go
to the VBE in the common drive and open the immediate window and type in the

I have a form in my scoring database where I use SendKeys to fill the form
with scores ranging from 0 to 10.
In order not to enter the score and having to press enter I use the send key
where I hold the control key and then use the number 0 - 9 to send the

Overview:
My database has many users who input data throughout the day.  The database
can become corrupted if someone attempts to add data at the same time I'm
making design changes.   The compact/repair utility in most cases doesn't

I have two different databases where I want to simply copy a number of
network files to a folder on my c:\ drive.  In one case it works fine; in the
other I get a Runtime Error 70, Permission Denied.  I've closely examined the
properties of the two destination folders and can see ...

I deal with a db that has many linked tables.  Because the db is live and
constantly being used, I make no direct changes to the live db environment.
There are 3 dbs (temp, data, hist).
All dbs are protected by a workgroup login (via access not by OS).

Where can I find a complete list of the keywords (e.g., .Body,
.Subject, .DueDate, etc.) that are used with VBA to work with the
Outlook objTask collection? Better yet, is there a list of all the
Outlook keywords?

I am trying to download a compiler and text editor for "C" , "Visual Basic",
and
"java script",

Please help me obtain Access (2000) script that check each table in the
database that will display all of the table columns where every row is null.
Thanks,