I have a database for my business that imports the previous day's
information.  This is done with a macro.  My question is, is there any way to
have the macro run automaticly durning off hours?  Idealy I would like it to
run at midnight and be all done by the time I get into the ...

I am trying to create a macro that will find and replace social security
numbers in a document with spaces.  My experience with macros is very limited.

I recently converted all my databases from Access97 to 2003. As part of the
database end users have been able to search a field on a form by double
clicking a text box and a search form appears that runs a macro. In the 97
database the macro was:

I have a macro in access which I would like to copy and paste into an excel
spreadsheet.
By this I mean the design window view of the macro.
Selecting the top left corner and then going to excel and trying to paste

I have a macro that I have pasted in the VB code for below.
This is for a file transfer to our bank.
The macro ends up creating 4 separate files which after I created this macro
the bank informed me that their systems see all of our data as one big file.

How do I get Access to assign a unique number automatically?  I have three
tables that need to have Access assign different number in each table.  The
first table will have a number like D809-00000 and needs to assign the next
higher number D809-00001 and so on.  The next table ...

This is a two-parter.  I need to transfer info to a remote database.
"Historical"
If I  use the transfer  command in a macro, should info go into a temp  table,
then go from temp into master table via append query?

The The form called by DoCmd.OpenForm should wait for a user to input proper
Utility Names, but doesn't. The form appears, but immediately the MsgBox
prompt appears on top of the form. The prompt has focus. This prompt should
not appear until the user leaves the other form.

I'm using an Output TO macro to export data to a specific worksheet with an
excel file. What is the format for specifiying the worksheet in the File Path.

Can someone help a novice with a problem he can't solve himself.  My Access
table (called Results) has a field called Name, the format of which is
surname:first names (eg Jones:Jim).  I want a query or a macro which will
update the field to First Names Surname (eg Jim Jones).  I ...

Anyone got any tips for me on how to write my own code? (Ive never coded
before)
-
Poni Kika

Recently upgraded from access 2000 to 2003. I have a simple macro that issue
2 sendkeys command ({down}) that direct the cursor to go to the subform after
entering the mainform. It works fine in ac 2000, but when used in ac
2003,after entering the main form (consisting of 2 ...

can i record macros in access or is there another way to work out vba code in
access . i know you can convert macros but what if what you want to do isnt
listed in the macros?

I'm trying to automate importing an excel template file in to an Access table.
I'm using DoCmd.TransferSpreadsheet and it works fine.
Only problem is that you have to state the full path of the excel file to be
imported.

I am trying to loop through records in a query and save a report to word for
each record. Steve Schapel kindly got me started with some code but I am a
bit stuck
So far