Can someone please help. I am using Access 97 and am considering inflicting
serious damage to my pc to allieviate my frustration...
I`m trying to create a macro that will update a field (called, DATE
COMPLETED) on a table (called, POST) when a button (called COMPLETED) is

I have case managers that input cliet information for medications in a form.  
I have a linked Report that will summarize the needed info for the doctor.  
The problem I'm having is running a macro on the form to print the current
record on the report.  Thanks

HELP ... Have an Access 2000 databse that has been working well for years.
Now when I try to run it on Acess 3000 it fails on various expressions. Get
an error message like "expression entered has functiion name that Microsoft
Access can't find".

I want to use the SendObject command to send an email to all the 'people' in
table [locums] for whom there is an email address in field 'email'. I know I
could simply 'hard code' the list of email addresses in the To parameter of
the SendObject command, but obviously this would ...

I am looking for some help to run a validation macro on multiple fields.  
Specifically, I have 11 fields on a form, each one a YES/NO data type, and i
would like to run the condition macro on the Before Update proerty, such that
if the field is set to YES and the user resets it ...

I am running a macro that opens, selects all and copies records from a
query. If there are no records, it halts the macro. Any way to avoid
this? The records are being appended to an existing table if that helps.
SKB

I have this project i have to do for work and i want the commandbuttons to
open seperate sheets within the workbook - but i dont understand all this
visual basic language stuff so can someone please translate it into a dummy
version for me - i can run a macro by recording it but ...

I would like to be able to find everywhere that a specific table, query, form
or report is referenced in my macros.  Is there an easy way to do so (similar
to being able to view object dependencies)?
DKennedy

I am using the send object macro, when it starts i Have a message pop up that
lets me know I am sending an email automatically.  Is there anyway I can stop
that from coming up every time I use the Macro.
Donbenz

I am trying to unlock a file so that I can modify it.

I have a table in Access with 250 rows and 3 columns.
The operators input a number let call it A.
I need a macro in VBA to search A to see if there is a match or closest
number to A on column 3 (let call it B) and then return the data on the same

I have an import macro which runs multiple instances of Transfer Text
on a fixed width flat file using specifications.  There are 26
different specs, one for each table that I need the data imported into.
Using  =InputBox("Enter the path and filename:") for the filename

I have a linked table whose primary key data type needs to be text instead of
numeric to create a specific join. I want to create a macro that will:
a) Copy my linked table - table name SURVEY
b) Paste the table in the same db as WEB_SURVEY with "Structure & Data"

I want to querry to a bunch of PDF files and open the querry automaticly.

I'm populating the listbox with query having a where condition in VBA
code. the first time list box fills correctly but when I change the
WHERE condition which is coming from the combo box in the MS Access
Form it doesn not clear the list box values from the query done first