I keep getting an error that says "Undefined Function" when I try to run my
query. My database is called ReHire.mdb
Here is my standard module:
************

Hello.
I hope someone can help. I have 2 macros which open 2 different forms but
they reference the same column.  The first macro opens the form and auto adds
my ClientID number to the new form (spouse details) using the SetValue

Advice on creating macros, I have a word template which I frequently copy
and modify certain entries example
the date or other strings in the copied document.
Appreciate how I could use say a macro enabling myself to fill in items

I've created a send object macro that runs everytime i open the main form in
my database.  THis macro is setup to email me a query. WHat i want is for it
to only email me when there are records in the query.  The way i have it set
up now, it emails me whether or not there are ...

Is there a way to delete data automaticly when the data base is closed.  I
currenty have a manual button that deletes data, date minus 30?  When the
database closes it does compress the files the tables automaticly.  I would
like to do it all when the database closes.

I've created a send object macro that runs everytime i open the main form in
my database.  THis macro is setup to email me a query. WHat i want is for it
to only email me when there are records in the query.  The way i have it set
up now, it emails me whether or not there are ...

I am trying to write code so that I can have a scheduled task run a macro to
perform the following steps:
1.  Run DB update
2.  Print a file to Adobe PDF Writer

Is there a way to do this?  I have an excel macro and an access macro set up
for the same process.  Can I write something which enables me to run both of
these macros under the same macro?

Hi- i was wondering if it is possible to make a field in a table that would
give you the current date when you query it or go to retrieve the value of
it? - i have a table called ReportFiles which holds an reportID link, a
filename(ex. Group31Export), a date, and a time. Im ...

I had a tx field (that should have been a date field) it read 20000101 I’ve
separated the tx in a qry and brought it back together in the right order 01
/01/2000 but it is still registering as a tx field,… i could simply go in an
d change the format of the field in the table design ...

I've created a "send object" macro that sends me an email based on a query
every time i open the main form. Now my question here is: how do i make it so
it only sends me the email when there are records in the query?  (the query
is to remind me when corporation returns are due ...

I have a real basic question. I want for Access to automatically enter
today's date into a "Date Updated" field when the form is updated. I am not
talking about entering the date when the data is first entered into a form,
but when data on the form is changed.

Can I use a message box like a warning? I have a field that can possibly have
duplicates, but it normally doesn't.  I want the user to get a message box if
they've entered a duplicate value for this field, but I want them to be able
to decide if they will continue or back out and ...

Can anyone point me in the direction as to how I can alter the format
of some table fields using a macro.
The formatting I require is to make certain fields display numbers in
2 decimal places and some date field display the date in mmm-yy

I have a query which feeds two different forms (both with subforms) - one is
an order overview which shows items, colors chosen, amounts, etc. - from that
form, I'm trying to create a macro that will open the detail form that
provides calculations for pricing, weights, shipping ...