Scheduling Macro to run automatically
Thu, 14 Aug 2008 14:53:02 -0700
Hi.
I'd like to email a report from Access on a weekly basis aithout having to
go into the database and run the macro. Is there a way to get the macro to
automatically run once a week?
Thanks in advance! ...
|
The expression you entered has a function name that Microsoft Offi
Thu, 14 Aug 2008 14:42:00 -0700
Using Access 2003. Macro suddenly stopped working and displays the following
message:
"The expression you entered has a function name that Microsoft Office Access
can't find" appears when the DIR() function is used but does not if it is
removed from the condition statement on the macro.
The macro perfo ...
|
Delete Macro on Menu bar
Thu, 14 Aug 2008 13:35:00 -0700
I accidentally dragged a macro to the menubar (right next to the Help menu)
and I cannot figure out how to get rid of it. It sits there every time I
open Access. If I left click on it, it tries to run the macro, and if I right
click I get the typical selection that I get when I click on an empty spot on
the ...
|
Distribution of macros in a thin client environment for specific u
Thu, 14 Aug 2008 09:36:00 -0700
I have a set of macros in my desktop that I would like 2 users out of 60
users to be able to use. Unfortunately, they are using thin clients instead
of a desktop. Is this possible?
Thanking you in advance. ...
|
Enabling Macros and Code in MS Access 2003
Wed, 13 Aug 2008 15:51:00 -0700
I've created a small database for users to look up information using a form
that has a series of dropdowns and text boxes. I created this database using
Access 2007, but some of the people in my company have Access 2003, and I
want to make sure they can open and use the database properly.
My problem is that ...
|
Using macro to perform a sequence of events
Wed, 13 Aug 2008 18:39:02 GMT
Hello
I am trying to use a macro to open a form which accepts a value from the user,
this value is used to create run 2 queries whic create 2 tables....these two
tables are then used to open report. The problem is that when i use the
openForm to get the user input , the macro opens the report without allowin ...
|
Assigning e-mail addresses to an Access macro
Wed, 13 Aug 2008 10:28:07 -0700
I am trying to send out automated e-mails to a varying group of individuals
via a macro in access. There hundreds of different possibilities so I don't
want to set up a different macro for each scenario. Ideally, I would like to
assign the e-mail recipients based on a query result. So far - no luck.
Anyo ...
|
|
|
Printing from a macro
Wed, 13 Aug 2008 09:26:09 -0700
I am executing a macro from a Switchboard selection. The macro is very
simple - "open report" and "printout". The report prints correctly, but
after the report prints an image of the Switchboard screen also prints. I do
not understand what is causing the Switchboard image to print. ...
|
FindRecord
Tue, 12 Aug 2008 13:23:02 -0700
I would like to use a macro to run a find command but I can't get it to work.
I want it to bring up a pop up in which I type the item I am looking for
(more or less like the find command button) can anyone help me with the
proper coding of this?
...
|
Quick Macro Question
Tue, 12 Aug 2008 11:20:04 -0700
Hello,
I'm a bit out of my league here with this question. I want to see if it's
possible to write a macro in Access that would input items in the Access
table into an internal company system. Can that be done in Access or Excel
or does that have to be SQL?
Thank you. ...
|
