I have created a autoexec macro that runs according to a task scheduler. This
macro runs a query over a Linked table(linked to sharepoint list). now when
this scheduler open the access db, it gives me a dialog box specifying that
execution will affect the change in the lnked ...

2003
I would like the data imported into a table in a non-current() database.
DoCmd.TransferSpreadsheet acImport, , strTableName, myPath & strTableName & ".xls", True
(The above command works but .... I want the data to go to strTableName in another database]

FYI - I'm using Office 2007 saving my Excel files in the 2003 format.  The
Access database I'm working with is in 2000 format.
I'm attempting to use import functionality of the TransferSpreadsheet macro
as part of an autoexec macro.

Will a macro close print preview. I had a macro perform other tasks, and then
open in print preview, however it will not close the preview.

I am trying to create an Inventory Log and I would like for the
quantity of parts entered in the form to either increase or decrease
the value in the table, but I'm not sure if I need a macro to do this
or what exactly I need.

I am trying to create a code in an Excel workbook that when I run the macro
it will perform the following functions in the following sequence.
1.  Open an Access Database called Asset
2.  Copy each record (126 total) from the table called Product Information

I have a databsae that includes the invoices of different companies. I have
created a sendobject macro for each indvidual company that send emails to
their company if they have not paid for their invoice. I have also created a
macro that sends all the emails at once with just the ...

2003
I am not sure which Access group is the best for help below:
The VBA module exists in Tools.mdb
So I run NewAccessDatabase() from Tools.mdb

2003
Just imported 1MM records from text file.
The first three records are a Mainframe header using three records.
Need the VBA code to delete those three records.

I ran into a puzzling problem that I haven't been able to figure out. I have
several functions, that when called, iterate through each of 9 tables and
process data from them into 9 other tables as needed, through append or
update queries. I am creating the SQL string via code, to ...

I would like to create a setvalue macro that populates a field based on the
value selected from a combo-box in another field.
I would set the value of the field based on the result of a saved query.
I'm not quite sure of what I should place in the 'expression' of the macro.

I recorded a macro that I wanted to close the print preview option at the
end. It will perform all of the other tasks, including going to the print
preview, but it will not close the preview and go back to the document. What
can I do?

Ganhar dinheiro rápido e honesto
meu blog http://jet72.zip.net/

I was hired at my company about 2 months ago, and I am trying to automate
monthly reports that have been created in Access 2007.  In the past,
everything was done manually.  I have already automated up to the point that
the main reports have parameters and output nicely rather ...

I would really appreciate if anyone tells me how to do that:
I have a word document that includes a long list of particular hyperlinks
and web links, and I need to know a macro that can run on that document, to
open every link, meaning to open every web page, select all the ...