How can I make access stamp date & time on a field in a
table when a user checks a yes/no box.
I have a form with a table when a user receives an item
it will stamp the date&time in a field, when he finishes

I have a machine containing Access 2000 on Win 98 (both
chinese)
and another machine containing Access 2003 (Eng) on WinXP
(Chinese)

I have a text Box in a report (txtJoiningStatus) in which the letters J F or
I are entered
from a form. I want to count in the report footer a textbox with the total
number of J's

I have created a database with many forms and macros. I
have properties set up in the macros to
close/restore/send keys, etc amongst the navigation of
the menus to open and close the forms. Upon opening and

Is have a macro that runs an append and update query.  I
need it to run automatically every day.  Is there a way to
actually do that without someone having to phycially open
the database and run it?

I need help making a macro to run the switchboard in the microsoft access.
Thanks in advance for your care.

I have a query which returns dates for 'initiated' new members, but some
members will not have dates in the initiated field.
So when I print the report I would like the date and label to be displayed
if

I am importing data into Access based on a calling
center.  The data is represented in CST (Central Standard
Time).  Is there a way I can have the data represented in
another time zone?  

I am attempting to create a macro that will open a
specific URL, but I am unclear as to how to do this. I
have tried Run Command & Open URL as well as Open
Hyperlink, but each time I get an error. Can someone

Hi, Thank for looking. (Access 2000) Ok, Right now I use "Export" from the Database Window to send the data in a query to an Excel workbook. Every time I "Export" the same Query Access tells me that the database object already exsists and asks if I want to replace it with the ...

I need to know if there is a way to have a user print a report based o
records
in a list box without selecting or clicking on a record???
This will return an record selected, but I am not sure on how to jus

I need to rename a table every month. New data comes in
monthly for a phone bill. I want to rename the table by
appending a date or sequence number. Then I'll import the
new data into a new table.

Please help!,
I am trying to update a checkbox - called 'invoiced' after a report (Used to
generate an Invoice) has run.
I have tried putting the macro on both 'on close' and 'on open' but it fails

I had a macro that worked in 2000 then in 2002 and now
won't work in 2003.  It was triggered by the change of a
value in one block, and updated the value in another.  The
first value was the button number pushed on a group

I am using a form date and text field to create a note on the Note Form #2
then using setvalue to paste it to the Progress Note #1 memo field of
another form. It works well but I need to open the Note form each day and
create a new note and add it to the Progress note. I did this a ...