I sometimes get a pop-up box that reads "Overflow" and the module that
is executing pauses. It doesn't get caught by my error trapping, and
it seems to be randow. By random, I mean usually in the same section
of code, but I can run the code a few times, then it appears. I can't

I was running a query to automatically send out excel file, which
including the list of people receiving gifts in 10 days.  I wonder if
there is anyway to check if the excel file is empty before sending the
file.

This is the set up:
      [Text6] is a date field on a form. Its control source is
the field "date_entered" in"Table1".  If there is a date showing
in the date_entered field (Text6) & the status in Combo box2

This is probably a very simple problem, but I can't figure out the
coding for it.
I have a list box that displays one of my tables. I'd the user to be
able to reorder the items in the list box as they please.  I've created

I almost dread posting this after the ruckas it caused last time, but
I am totally lost.
The reply I recieved last time is copied below...
------

It's been a while since I've posted.  I am an intermediate user of
Access.  I can read simple VB code, have done complex queries,
comfortable with event procedures, designing forms and reports.  I have
not worked with a split database before.

On my form when stirng records in a table I am using a form with text
boxes etc so the user can add records. This way the user can only view
one record at atime. Therefor I have created a lisbox on the same form
but on a separate tab. The listbox shows all the records in the table.

Hey, Guys,
I have a question when I created a query with date() in the criteria. I
want to generate a list of gifts sent in 10 days. The code I put in
criteria of query is

I'm trying to create a report that feeds from multiple Parameter
Queries; I want those queries to share one Parameter Form (by this I
mean a single form to alter the same criteria in my multiple queries);
and this are my troubles so far:

I have a comboBox with two columns. I would like to isolate each column so
as
to compare it to an entry in a table so as to be able to load a yet another
form. how can I do that?

I'm surprised that the Current event of forms always fires twice
(Access XP).
I have quite a lot of processing done in the current event, how to make
the code run just once?

I have just completed a basic course in Access.  I have some relational
b/g in DB2 and Cobol.  I have a question my instructor couldn't answer
(or maybe I didn't explain myself)
I design a simple form that has data from one table.  When I open this

Laptop lost power while on an airplane. No big deal, but the Access
database that I was working on at the time now won't open. I've tried
to repair it, I always get the error message about the file being
corrupted. I can, however, open tables and queries through Excel, so

I thought I could run docmd.SetWarnings in the
immediate window with no argument and A97
would return True or False, depending on the
current setting. I was wrong.

I have an Access 2000 database with one main form in which all subforms
are embedded. In this form I have a timer which closes the form,
detaches the linked (ODBC) tables and reopens the same form with a
login dialog (initiated in onOpen).