I have a cell i want to multiply by 9. I have a lot of them. So I'd like a
macro with a shortcut to do it for me. For Example: cell c62 has a value of
177. I want it to have a value of  1593.  Instead of manually editing each
cell (F2, home,=,end,*,9,enter) each and every time, a ...

I'm trying to enter the Transferspeadsheet action in a macro but the dropdown
does not contain the Transferspreadsheet.  What is wrong?
Thank you.

I have problem in importing Excel spreadsheet (name is 'C:\data\ADHOC' on
'Page1' tab) to Access db (table 'Agreement') in Macro. Mostly, I know how to
put it in Macro, except the tab on excel file.
Transfer Type: Import

Hoping that somebody could help me with this problem
I have an access report which have a Sum on each page total page 5.
Now I'm trying to add a grand total on page 5 of all the Sum.
How can I do this?

I am using 2003. I  use  transferspreadsheet to send many (10) access tables
to excel files. I run this once a week and manually type in the current date
for each transfer, the rest of the name remains the same. Is possible to
include a date function in the file name so that it ...

I'm having trouble tying in a macro to a command button I place at the end of
a Word form. The Macro exports the filled-in info to a spreadsheet, but I
don't see anything in the button's properties that would execute the
macro...???

I have a database whose table data receives updates from external, csv text
files. This database tracks student attendance information at our continuous
enrolment, alternative high school (read: too many many-to-many
relationships!!!)

Hi.  I have a maco that works of a master sheet and creates a new
worksheet for every block of 25 records.
FirstSheetname = ActiveSheet.Name
Lastrow = Range(Cells(1, 1), Cells(Rows.Count, 1)).End(xlDown).Row

I split my access 2007 contacts database so that I could create one
front-end environment that would later link to all of my databases.
The problem I am experiencing is with a macro to save outlook
contacts. The macro works great when I have the table in the same

How can I use IsLoaded in the condition column of a macro?
I tried IsLoaded([forms!]![frmCalendar])
I tried IsLoaded([frmCalendar])
No luck.

Is there a way of preventing the AutoExec macro to start when using /
decompile in command line. I'd like to schedule /decompile action on
an MDB file but every time I execute the "<Access Path> <File path> /
decompile /nostartup" after the decompilation process it starts the

I would like to know if the AutoExec macro is executed only when the
database is opened using Access or is it also executed when the database is
opened from within a program using the odbc Microsoft Access Driver?
Thanks,

I'm not sure whether this would be possible but I want to set the value of a
control with the input mask 9-99-9-99-999 to automatically be determined by
the values inputted into 5 other controls previously (one for each set of
numbers in the input mask).

In the older verison, when writing a macro I used to have the option
DeleteObject.  Does anyone know what replaced it or where it is hiding?
(I used DeleteObject  to delete tables & then replace them - I have found a
work around, write a delete query to delete the data & then an ...

I have an excel spreadsheet I have been transferring into an access database
for a while. I had to make a change recently so that it would leave blank
cells as blanks instead of putting in zero's. Now when I run my macro to pull
from excel to access I get a type conversion on all ...