I have used the lookup wizard in a form to select a field that is in another
table but I only want it showing up once, not mutiple times as in the table
otherwise its too long.  I need multiple entries in the table but not to be
constantly repeated in a list box on another form.  If ...

I created a query to pull records based on dates. I then
added a button to my switchboard to run the query. I
would like to have a box pop up after the button is
pushed where I could enter a date range. I would like it

Using Access 2000, I want to create a table containing a list of products
(product code #, product name, description, price, etc..) and Export it into
a Pipe Delimited file.
Some of the Product Code #'s are 12 & 15 digits long.  I have selected

When i click on mmy command button an error message comes up telling
me that i can only reference a control if it has focus. How can i fix
that?
Here is the code for that command button:

I run the shipping department at work and would like to know if it is possible to configure access to print a delivery ticket, packing list and a box label from one set of data. each form printed would contain similar data yet not neccesarily the same, or at least in different ...

I have two calendars on my  form. How can i make it so that when the
user clicks a command button it checks to see if the first calendar
date is greater than the second?

i want to add a receipt printing capability to my
developed programs. are there receipt printers available
that are treated like an ordinary printer. Or are there
OCX that can be used so the receipt printers can be

Hi Group,
I am using Access97 on WinXP platform.  I have a form frmAttendances on
which there is a control fldDate. Basically I display a list of people and
if a date is selected in fldDate by clicking on a records date field I

Is it possible to change a public boolean value in a module (e.g. blOK as
boolean, blOK = True), close the database, reopen and have the boolean value
in the same state it was left in ?
When I've tested it out it keeps on setting blOK back to false when I

Hi i was hoping someone could give me a brief explanation, or point me at a
tutorial that explains how the Count and DCount functions work. I have a
report with 4 different groups of people on it. Im trying to make a text box
for each group that counts the number of records in the ...

I wish to run modUpdate which includes an Append Query, Delete and Make
Table, but the following hangs on DoCmd.
I would appreciate any help.
Function UpdateRG()

Can you import a Microsoft Access table to either the Microsoft Works
Spreadsheet or the Works Database?  I am planning on creating a database to
keep a log of the books in my church library.  I have Access 2003 at home
and my church has Works 4.5.  I want to use Access because you ...

I'm a computer student with a few questions, I'd be very glad if you could please help me.
Can you please give me the definition of access?

I need help...I have created a 2nd switchboard and it is not visible on my db.  It doesn't show up in my table listings nor my forms.  It is visible in my switchboard manager.  What do I need to do to make that switchboard visible?  OR do you only have one switchboard show in the ...

I am working on a DB that has Inventory of spare parts.
one field is "Qty on Hand" and one is "Qty Used". How
do I get "Qty on Hand" to change when I enter a qty
in "Qty Used" and then reset "qty Used" back to Zero? Any