I use Remote Admin to access my home computer from work. My home machine is
running ME and my work dinosaur still has 98. The Remote Admin works great,
but doesn't have a way to simulate Ctrl+Alt+Del remotely. Remote Admin will
do this on XP and NT machines using an Ctrl+Alt+F12 ...

My macro sets  a rectangular box to visible, then runs
through a number of instructions and then sets the
rectangular box to invisible. When running this macro on
single step it works perfect every time, but when running

I'd like to place a command button on an access form to import an excel work
sheet.
Can someone some one help with the syntax?
My excel file name is "Import_Labor.xls" the sheet name is "Labor" and my

i am designing a database which will envolve the sale of
can crisps and popcorn for film showings, does anyone know
if there is a way to make a macro that adds 1 to a record,
eg a button to add 1 pack of crisps to a persons tab.

I have Access2002 and to be able to use the F12 on the keybord to go next
record in subform..I am using Autokeys.
Everything works fine pressing F12 and the subforms goes to next record,
except when any changes has been made in the subform...I have both Before

When I open my database at night, with windows scheduler
to perform some procedures I use a comand line which runs
a macro upon opening. During normal hours I open it
without running the macro.

I want to "push" data from an Excel report to an Access database.
Do you know if there is a VBA script that saves an Excel sheet as an Access
table?
Do you know if there is any other way to "push" data from an Excel report to

Creating autokeys macro for global key assignments.
Can create Ctrl + P by entering ^p in name column - OK.
Can create Shft + L by entering +l as well - OK.
The manual I've got also says that the % symbol can be used for the Alt key

Does someone know how to simply take all the records in a
field, add the numbers together, and then update the sum
in to a record at the bottom of the field?  I need this
to happen each time a new record is added to the field,

I think this is done through a macro, but I can't get it
to work.
We have several linked tables. One is a set of maintenance
activities, with info of "activity", "unit", and "cost per

I keep getting handed all sorts of Access related problems at work
despite the fact that I am not all that great with it, so I apologise
in advance if I am missing something obvious....I am trying to take
the opportunity to improve my knowledge of Access.  The problem this

I think i'm a bit out of my depth here!
I want to use the macro to open a Word template document.
I've selected the RunApp action, but what should i type in
the command line?

I have a data entry form that contains a checkbox, currently the macro executes as soon as the box is checked . I would like the macro to execute when the save record button is clicked is there a way to attach this macro to the automatically generated buttos on the form or is ...

I have a form, and I want to create new Label controls at runtime (no
in design mode). I know in VB you can use something like
Set myLabel = Controls.Add("Vb.Label", "LabelName")
But this doesn't work at all in Access. The CreateControl method seem

My General Manager has rquested that when certain changes are made to the fields of an application I have created, he receives the information as an email. My approach has been to use the SendMail object in Macros however there are two stumbling blocks:
1. When the macro executes ...