Dear Sirs,
I have a project to complete for an independent study assignmen
based on a language with which I am unfamiliar: VBA.  I only need
couple modules to provide the necessary functionality to my databas

Have an mde that has a bunch of queries,
one macro ("Autoexec") which runs the
queries.
Would like to compile code in VB/VBA

I have some macros that works well in Excel. I have Access
reports that pulls from the Excel file successfully. I
would like to use my main Access application to run the
macro in Excel prior to running my reports. Can anyone

I am also trying to open a word document from Access, but
have had no success.  I've tried what you said, but I keep
getting the message below.
"Document name or path is not valid.  Try these

(Access 2000)
Does anyone know how to automatically run a macro, when the db is opened if
it is the 1st monday of each month?
I would like the macro to print out several reports automatically if it is

Using Access 2003, I have a macro which uses sendobject to send an emai
confirming sucessfull completetion of the macro. I am seeking to total
automate the process, but cannot get past the message box from Outloo
stating " A Program is trying to automatically send email on you

I want create a macro that export data to Excel, with a filename that is
variable, but automatic.
The filename can be de data in a field of the table.
Thanks.

I am trying to open a sub form using the Openform macro
I want to open the subform displaying a certain record from the main form… I can do that using the “Where condition” in Open form – but then it is creating a filter and I cannot navigate between the rest of the records in the ...

In the subject all my question, but if it's not enough, I'll try to
explain it with more detiles.
For example I have application for University Entrants.
I have a list box with all examinations. And I need for definite

I hope I'm in the right forum.  I have a macro that first opens an update
query.  I enter data and click ok, then a report opens.  This is fine as
long as data is entered in the update query.  What happens is occasionaly
data is not entered in the update query and the the "OK" box ...

Is there a way to show progress (progress bar?) when doing something from
access that may take some time. I need to connect to an ODBC data base and
use a pass through query to gather data before I run a make table query in
access.

I trying to write a macro or VBA to close one DB and than from the same
macro open another DB by just pressing one button.
Any ideas ????
Thanks for your valued help !

I need help making a macro that will bump all user off so I can make changes to the database

I am somewhat new to vb.  Is there any way to get the selection from the
a textbox?  
So if I have....
"Yadda yadda yadda, blah blah blah"

I'm an Access Novice, and I'm trying to create a macro or grou
of macros to open a Excel spreadsheet, save it, and then close Exce
and the spreadsheet. I've tried using the SendKey option, but it end
up closing Accesss instead of Excel. Any help would be muc