Hi. I am fairly new to macros and visual basic. I hope someone can
steer me in the right direction.
Every week a new .csv file needs to be imported into one table of
information. (One table contains weeks of data) The .csv files are all

I have several sub functions in my form's macro page, some of the sub
function has the following codes:
Dim myDB As Database
myDB = DBEngine.Workspaces(0).Databases(0)

Please can anyone help me with the following problem:-
I have created a Transactions form, where users can enter data when they
sell a shoe.
At the bottom of this form, I have two buttons, one to add the record to the

I would like the SendObject Macro to automatically enter the value of a field
in a form that call the SendObject Macro into the To: field of the macro.  
The data for the To: field will be pulled from the Forms]![Work
RequisitionsBackup]![Therapist] field of the open form (which ...

In Access 2003, is it possible to call a Sub from a macro? I know you can
call a Function, but I am not passing any information. In my macro, I run 4
queries. Query 1 clears a table that will receive the final data.Qquery 2
updates a date field for all records in a second table. ...

Can I create a macro to record who last made changes to a table?
Or maybe at least just to a database?

here's what i have set up:
.bat file - copies a database to a second file
.bat file - opens the copy "db2"
db2 - autoexec macro

I have always (with Access 2000) used the wizard to go from a button in a
list of records to a form with the selected record - it generates VBA. All
fine.
Now I have 2007 and it creates a macro. It opens the form but does not go to

I have a DAP which I'm using at work to track IT Issues that users on a LAN
are having. I'm using Access 2000 and what I would ideally like is help with
the following:
When someone goes onto the DAP, I want to make a Save button on the page

I have 2 tables
1 has all customer data
1 has ranking system I created that rates them 1-5
I import new customers everyday and cant keep up with typing in the rating

I have my database linked to some tables ODBC, I have queries that run off of
these tables that puts only the information I need into some other
(non-linked tables). I want to have this get updated automatically, my on
issue is the linked tables have to have a log in and password ...

Hi.  I'm new to all this, but I have a question that hopefully someone can
help me with.  I e-mailed a data analysis page to my home computer, along
with the spreadsheet containing the macros to upload the data onto.  My
question in...since my version of excel is 2007, and the ...

Is it possible to have a database run a macro when the database has not been
opened by a user? If so how would I go about doing that, also I need the
macro to only run on certain days, I have a table with the days needed to run
alreay setup. Thanks

I have set up a macro to run my queries, however, i need to change the data
type of one of the tables created from "memo" to "text". How can i
incorporate into my macro?
Would i need to add a sql statement, if so can i use the RunSQL function in

I've got a table of a million records, with between 60-120 keys (it varies).
the listbox is built from reading the table to produce the unique keys.  
every time I select a key, the process takes about 10 minutes to loop thru
and produce a report which I then dump to a pdf.  I'd ...