Is there a way to rename a table imported via VBA to the current date? And
the same the following day?  A user here wants to keep a record of the
imported report for about 3-4 days...any suggestions welcome!
Thanks in advance!!

Can someone tell me a method of returning the total # of days for a given
month, when that month is not the current month necessarily.
I'm trying to filter a date field to a given month that is always 3 months
prior to the current month.  So for example, since it is currently July ...

My code works fine in Access 2000, but when I tried to run it under Access
2003 got "function not defined" errors on something simple as LEFT(),
RIGHT() which I thought pretty basic commands.
In references nothing marked as missing.

I have a check box called AllRe
I'm trying to automatically have it checked once all other checkboxe
are completed
Here's the setup of my form..

In Access 2000 how can I identify Queries and Macros that are not used by any
Forms or Reports to comfirm that they can safely be deleted?  
Also, How can I determine where a particular Query or Macro is used so I can
identify which Forms or Reports will be effceted if I modify ...

I have a DB in production mode and a copy in development.  I have made
changes to a form and wish to export these changes from development into
production, however every time I do the old form re-appears in production.  I
have deleted the form, compacted and repaired the db and ...

I have designed a telephone call log database and have a tabbed menu system
with 10 pages each containg code on the on timer event to make them requery
every 1 minute, this works in the main but every now and then I get an error
message saying Field 'Tel ID' cannot be found.

   I have a subform with link master on a listbox.  It works perfectly
(when an item -pk is selected in the listbox, data in corresponding record is
retrieved and populated into subform).  However, it doesn't work under the
following scenario:

Recently I made a form that prompts my user for the year they would like to
enter with the code below. I would like to modify the code to prompt my user
for the date they would like to enter in short day format. So when my user
opens the form, I would like for the user to be ...

I have a  main form with a list box displaying contact info i.e, First
name,last name,address etc.... There is a button on that main form that opens
an other one to insert a new contact. I want the listbox on the main form to
show the most recent record inserted. I use the ...

Hi I have the following code in my Text330 field
=LiscYrs([LicHeldDate]) & " Yrs " & AgeMonths([LicHeldDate]) & " Mths"
if no date is entered I get an #Error how do I set it up so that if me
LicHeldDate Field is blank my Text330 field is blank.

Does anyone know the syntax to check if someone tries closing a form using
the Windows "X"?  I want to isolate the "X" for error checking, without
affecting my Close, Quit buttons on the form.
Thanks!

I am trying to change the column of a table from Text to Date in Access97.
With the same database connection, I do an OpenRecordSet() and use movenext(),
update(), and close() to modify the text into the correct format for
conversion to date. Then my code goes to add a column to the ...

I know this may sound basic, but I need advice from experienced programmers!
I am trying to use the update method to change from false to true a check
box a yes/no field only for the record I'm working with after it sends an
e-mail, but it keeps updating the yes/no fields of all ...

I need some desperate help.  
BACKGROUND
I have some users that can't grasp the concept they need to download (from a
mainframe) a report before the go clicking buttons in an Access database.