Does anyone know how to create a temporary table in Access DAO?  I have a
complicated data entry form that requires a temp table be created and then
update the underlying tables before closing.  The actual record source is
from a make table; however, I need this make table to be ...

i use the following vba code in a button on the mainform ("Screening Log
(Review Only)" in my a2k application:
Private Sub FilterDates_Click()
On Error GoTo Err_FilterDates_Click

Please excuse my use of MSaccess terminology, in advance. It has been
years since I wrote my last database.
I have an error "Run time 2113. Value entered is not valid for this
field."

    Good afternoon.
    I often need to update the contents of other forms.  If a form is not
visible, I would like to skip it, to avoid unnecessarily opening the form.  
I've tried using "If Form_Name.Visible," but it is not always correct - I've

I have two copies of the same Access file, one I use as a draft the other as
a hard copy. I created some coding on a form in the draft version and copied
it to the hard copy, everything is the same but it doesn't do anything!!!!!
Please Help!

I update values in three combo boxes in a form on a monthly basis.  I'd like
to be able to clear all the "old" values prior to entering the new ones each
month.  I want to do this without deleting records.  
(I do this because I use the data for reports on a monthly basis, and then

I have a form with mostly numeric data, but with one combo box that
holds a site name. I would like to be able to type a numeric code in
the combo box, but have the associated site name appear in on the form
(in the combo box or in another box). I need to be able to see the name

I am struggling with what seems like should be a straightforward task.  
Unexpectedly however it has become an infuriatingly difficult one (no doubt
due to my complete novice status).
I have a very basic d/base (3 tables) that I have been searching using basic

I have an employee form with a subform in datasheet view.  the subform has a
column for employee travel miles. I have a total working on the form for the
column, but I need to filter it by a date range.  Any suggestions, thanks in
advance,

I have created a main grants form called 'frm_GrantPot' that consists of a
sub form in datasheet view with several fields. The most valid fields in the
subform for this problem include:
AmountGrantAllocated, GrantSpentToDate, AllocatedGrantRemaining

I have both MS Excel 2003 and Access 2003.  I am getting an Excel module
that will connect to the internet and download some information.  I will
only use Excel for this single feature.  I always work within Access and now
I need to know how to run that Excel module within Access ...

I have a combo box named cboProducts based on a sql rowsource:
SELECT tblProductGroup.ProdGdr
FROM tblProductGroup
GROUP BY tblProductGroup.ProdGdr;

Hi I have a form with a field called "Field137" if this field is left blank
for any reason when trying to print out certain reports using the following
code:
Private Sub Command258_Click()

I am using Access 2000 on WinXP.
Something strange on my database.... out of the blue, I am now getting an
error msg "Run-time error 2046:  The command or action 'Save Record' isn't
available now".  When I click debug, the code has stopped at this line:

I have a command button on my main form that shows VIEW JOB IDI want to be
able to press this button and it opens up my normal JobDetails form using a
different query, somehting like this;DoCmd.OpenForm "JobDetails",
QUERY??whats the exact coding for this or even better i want to ...