I can't figure out how to create a drop-down list box. The help file
says it exists. The icon in the help file matches the combobox in the
toolbox. I tried using a combox box, both with and without using the
wizard, and it will not "drop-down" - the list is horizantal. I don't

I'm a beginner of MS Access, I need adequate knowledge on how to
programme. I have a challenge in my office to write a pragramme that
will calculate a compensation for all our distributors. This is a
network marketing company that has so many distributors, and almost

What is the proper way to reference code snippets that are copied from
usenet group examples?
What about when a developer posts code that is copyrighted and they
allow you to use it in a commerical application but they say not to

What is the proper way to reference code written by others in your
database applications?
If it is a code snippet from a usenet group, should you refer to the
posting?

MS Access 2000 Help says there is an Switchboard Manager in
Tools->Add-ins. Only Add-in Manager is there, and no Add-ins are
listed. Clicking Add New takes me to an Add-ins directory on C: (empty
list) rather than the install CD, which is already in the computer.

Thanks for your replies.I have to develop an application which will
read a .DAT file.There are several hundred records in this file.Also I
get another excel file with adds and deletes.
There are records in this Excel file with matches in the DAT

I currently have a form which contains a macro.
When a button is pressed, the macro opens up another form to allow a
user to add data. When the form is closed, I want the macro do do a
Requery so that the new data is instantly available.

I have a requested date field which is a date, I need to create a form
with start requested date and end requested date with who it was sent
to......
So I need 2 date boxes in a popup form with these dates in, then press

Is there a way to make a report that works like an excel spreadsheet?
I want to record a set of values related to sales data every day and
then see it in a report with Mon-Sun at the top of the columns and the
sales depts and info down the left labeling each row of data.  See the

WHen I bought my new computer I only installed A97 and A2003, since
those are the versions I use.  However, a utility I depend on
(SpeedFerret) requires an interim version (A2k or AXP) in order for it
to work.  Apparently I can install A2k and not use it; but it must be

Hi can someone give me a hand with this please?
I'm trying to build a search filter that scans through a list of
client names in a database as you type into a text box and filters the
form records accordingly. The problem is my database structure is

I have a form that opens another (intermediary) form.  The user selects
an option on the intermediary form and it opens another form and the
intermediary form is closed.  Ex:
From MainForm

This was an interesting problem.  I open a form, CalledForm.
When a record is presented in CalledForm I needed to check the status of
something.  If the status is met, I needed to present DialogForm prior
to allowing access to the record in CalledForm.  So in the OnCurrent

How do I able to locked users from pasting records from column datasheet to
another column? My case is I have a form that has a check box that determines
when it is checked, the subform datasheet will be locked from users to edit,
otherwise they can edit. I done this by locking each ...

I recently had a motherboard failure that took the drive with it. When I
finished reloading everything on the new system, I have a new problem.
I can not seem to open a simple recordset in VBA.  The following code fails
at line 5.