SendObject Requires user intervention to send email
Wed, 10 Sep 2008 11:27:04 -0700
When sending an object through an Access database with Outlook 2003 it
requires a person to say yes to sending, otherwise it will sit there and do
nothing. Is there a way around this so that this portion of the macro can be
automated? We have a scheduler that has always sent certain reports out, but
ever s ...
|
Table cut and paste style macro
Wed, 10 Sep 2008 08:06:01 -0700
Hi there
Im not overly unfamiliar with Access, but need to create an macro on an
action that upon saving will move a record from one table into another. This
should occur when a check box is ticked under a yes/no function and should
work more or less as a cut and paste.
Any ideas or pointers?
Thanks ...
|
How do i run a Public sub from a macro
Wed, 10 Sep 2008 01:38:07 -0700
Hello
i have tried everything but i cant seem to get my module called CalEmail to
run from a macro (im new to VBA). the module starts with
Public Sub calemail(Optional AttachmentPath)
is this where im going wrong, please help
Thank you for your time. ...
|
Finding all records that contain a certain value
Tue, 9 Sep 2008 09:01:01 -0700
Hi all,
I'm currently working on an address book database with all information in
one form and I have a combo box to choose all businesses from a list. However
some names are preceeded by "Garage" or "Ets." for example and therefore are
quite difficult to find. I have created another box to use as a search ...
|
Run macro once every hour?
Mon, 8 Sep 2008 12:09:05 -0700
I have a macro that I setup in the Access database using Sendkeys. Is there
a way to tell the macro to run once every hour? ...
|
Macro Problems - SetValue and Dlookup
Mon, 8 Sep 2008 09:19:17 -0700 (PDT)
Sorry if this is the wrong place, but I'm looking for help with macros
and coding in an Access Db.
My problem is that an user has been forced to upgrade to Windows Vista
and Office 2007 and an old DB of theirs has stopped working, and I've
been asked to check it out. The problems seem to come from macros and
...
|
How to automatically stop a macro
Mon, 8 Sep 2008 08:37:01 -0700
I have a macro that I designed with Access 2003 to open a table, copy one
cell and paste the value to the appropriate blank cell in the next record.
The problem is, the data is derived from a .xls file that is always of
different lengths. One day it will be 140 records, the next 35. As such, I
want to com ...
|
|
|
My form won't open since I created a macro
Sat, 6 Sep 2008 10:08:44 -0700
Hi:
I created a macro (based on one that worked perfectly in Word) and set it to
run in Access when a particular field was filled in....or so I thought.
I can no longer open the form.
Is there a way to stop all macros/modules from operating in a form so I can
open it.
This is the first time I have attemp ...
|
Send Object Macro
Fri, 5 Sep 2008 13:26:53 -0700
Hi,
I wrote a VB code to send emails, the button is working fine in the computer
I made it but it doesn't work for no one else. What am I doing wrong? ...
|
Macro to create new column, rename it, and change data type.
Fri, 05 Sep 2008 18:32:46 GMT
Hi - I've been trying to figure out how to do the following - create a macro
(or code) so users can enter a new column in a table, rename it, and change
the data type. It's a birdwatching DB, and this function is to allow the
user to create a new bespoke tick list in a table of lists (life list, county
list etc ...
|
