I have a form structured as such:
* The main form is a query with a criteria specifying
department.
* The form has a linked subform (linked on department)

I am trying to create a macro that will open a report from
another application. I keep getting an error message about
the path i am using, could this be because i am trying to
access a central server and not running from my hard disk

I am using a Text Box - Format property set to
Medium Date. Now whenever I enter invalid date and as soon as I came out
from text box, Standard Error Message of MS-Access pops up and asks for a
valid date.

I have a macro that will run a module that writes
password on a table.
I don't want anyone to run it accidently, and overwrites
the password table.

Hi, I have 3 subforms in a form.  There is one subform
that most of the time will be blank.  I have saved my
forms as reports and have a print button on the bottom to
print the current record.  The report must print the

I am trying to create a conditional macro and am having
considerable difficultly finding the correct syntax (I'm
very much a newbie to VBA and SQL, I can't even figure out
which one I'm supposed to be using here).

I have written a macro to import a table into a database.  
If the contents of the imported table are not complete,
the macro will then open a query, RunCommand (Windowhide)
and then STOP the macro. The user can then print off the

I have one database and two jobs.  All they have in common
is that they use tblMasterList
Job 1:
Database to open by itself, run a few queries, run some

Hello: I want to create a macro called Open LJSCHOCOLATES
Form that will open that form. Can someone tell me how
please.
I also want to create a new toolbar with an icon on it

I have a "Build All Tables" macro, which calls 8 macros,
each of which calls several queries.  I would like to be
able to have a way to display the progress of all this.
The status bar displays little bar graphs "Run Query",

I can open an excel worksheet with a cmd button in access,
but how do I then run the macro contained inside that
worksheet??  I want to open the excel and run the macro
with the click of the command button...

I'm trying to write a function that will look for a
specific text file and, if present, import it into
Access.  I want to use this function as part of a
scheduled macro.  I know how to check for the presence of

I am trying to export a query to a text file when a user clicks a button.
Is there a way, using the TransferText function, to export a query to a
given path, with a
delimited format?  I am looking to manipulate the file to get no delimiter

Is there a way to create a macro to runny multiple Append Queries?  I actually have 5 append queries and 1 Update query I need to run and it is too time consuming running each one separately
Also
Is there a better explanation for importing a text file using a macro?  I can't get it ...

Can anyone explain the procedure for importing an Excel
spread sheet? I keep geeting an error message that I
don't understand, and the "help" just does not seem to
help.