Query1:
tDate         TrapNo     Species    AmtColl
1/1/2000      E1            TAE         100
1/1/2000      E1            COL         150

Probably very easy question.
I have a list box and have selected several items.
I then create table entries for each item selected.
the list box 'contents' gets smaller since there are less things to

Hello everyone.  I have a table linked to an excel spreadsheet.  I have
an append query based on this link table.  I receive an error when I
run the append query "numeric field overflow".  I have noticed that
when I open then save the append query and then run it I get no error.

I have conditional formatting set up on a subform based on a calculated
value in the underlying query. For instance, if Sales are >$1000, the
query displays "Yes," otherwise it displays "No." The conditional
formatting is set up to read the 'Yes' or 'No' value and color the text

Is it possible to join on an alias for a field value on-the-fly.
Something like the nz() function, but not only for Null values. I want
it to be for anything I stipulate as equivalent.
For example:

Can you create name tags with pictures using A2000?
I have a table with an Employee name field and a field with a link to their
gif picture.
I was able to get a form to work using the Image Control and setting its

Howdy,
Saw a couple threads from the past few years on this topic, but didn't
really find any solutions.
Here's one I found:

I'm writing vb.net code with MS Access as the database using
OleDbConnection.  The problem I'm having is, I write to the database
then I read back what I just wrote.  The read appears to be from an
older cached version because I get the previous results.  If I read

I am trying trap Runtime error 3022 (duplicates) in the click event of
a command button that closes the form. I have code in the Form_Error
event that does a good job of providing a more meaningful error message
than the default. It works in every situation except when the user

I'm writing code to backup the back-end file from my front-end. The code will
automatically run the routine when the main app is closed and when certain
critieria are met.
The question is:  What are those criteria??

Can you update the caption property for fields in a database using code?

I have a form (I won't bore you with the details of the necessity of
this, but), I need to have a textbox that uses DLookup to get a value
from a table with both being keyed to a common field "DMSID".
Because of various issues I need to get the textbox to simply display

I have a custom message form that I want to display when the user shuts down
my app.  Some clean up needs to be done during shutdown and I want to display
this form and then display various messages in the label on the form as the
shutdown cleanup proceeds.

I have a list box on a Form labeled "txtSortBy".  How do I pass this
field to a Report to order the way I have chosen on the Form?
Currently, I have created 3 of the same reports and hard coded the
sorting within each Report.  (What a drag to maintenance when I want to

I have been working on a database to perform some of the tasks that I
have been doing manually in Excel. One of those tasks is to sort and
exclude duplicate data. The fields are as follows
Building