Hello, please help me if you can.
I am automating Access from Excel. Primarily, I need to
switch data entry "Required" to "No" for various fields
after the table structure is in place (therefore ADO is

This macro works without the conditions, but once I put
the conditions it, it just stops at the first step. If the
copy is 0, I want to add a new record and set the copy
value to 1. If it isn't, then I want it to sort. I can

I am in Access and am trying to use the Send Object section in the macros. I have everything set up correctly and it runs however, I wanted to know if there is a way to automate the message. I have several managers that I am sending emails to and did not want to have to copy an ...

Is it possible to pass parameters into a macro, similar
to parameters in a query. My goal is to be able to have
the user enter a parameter like " Last Name" then have
the macro open one of many forms for data entry based on

I do not have indepth knowledge of macros.  I am creating
a small invoicing data base.  I have created data bases
and a macro to allow me to input a month and automatically
print out invoices due that month (based on set reocurring

I need to open a form, select a field called InvoiceDate,
select all records, and set the date to the current date
using a macro. The first problem I run into is the date. I
can open the form and set the date, but the date set is

There's gotta be a way to make Access read data from a webpage. I just
don't know how to do it.
I just want to open a datastream of any sort, to be honest. I'm just
not at all sure where to start on this. I assume there is some sort of

The basic layout of the macro is this:
OpenQuery
OpenQuery
SendObject

I am currently using MS Access XP for a form I use for work for books that
are on a circuit.
I have 6 Statuses for each book:
Received

OK. I need a macro, I think, when I click on it on a form
from a button I want it to run a query and transfer data
from one field of the query to my form. How is this
possible. Please reply asap coz me assignments in very

I have created a workspace and I am doing 3 dbs.Execute
functions.
wrkDefault.BeginTrans
Set dbs = OpenDatabase(dbName)

A form opens a table such that a macro that updates the table receeives a
"Locking" error. The form only needs read access to the table. Is there a
way to either lock the table or otherwise eliminate the error?

Small firm... Four full-time consultants and approx. one dozen part-time
consultants... Need to create appointment db to run numerous reports by
consultant, date, clients, etc... Want db to automatically input appt
information into Outlook...

I have some update queries being run in macro actions and I have conditions that either RunMacro or SendObject.  The SendObjects aren't happening.  I'm in 2000 on Win2000.  The SendObject condition results in TRUE (I'm using the Step Run feature).  However, no email is created or ...

I am working with a school database and I'm trying to make a report that can be printed as a directory.  In my database I have addresses for the a student's mother and the same student's father.  Can i use a macro in a report that will not list the same address twice if both ...