I would like to find out which property I need to set so users can not type
in a combo box but only select the text in the predefined list.

I want to open a form ("MenuForm") and assign a value of a control on the
present form ("CaseID") to different controls (specifically, a ListBox)
called "CaseList".  The CaseList is assigned the same CaseID in Column(0).

I am using a listbox in value list mode as a status log for the user - much
like the Immediate window in the VB environment.  Using VB code, I am posting
events in this log to provide the user with an idea of where they are in a
long rollup process.  In addition, this provides ...

I have a form with a subform.  I would like to add a command button which
will give the user an option to expand the subform to "Full Screen".  I tried
using the wizard (open form), but doesn't work.  I also tried a macro, but
could not get that to work. It shows all the data not ...

I have several forms, all with some programming behind them, that take a
long time (up to 30 seconds) to load, causing the end users to think that
the program has crashed (and it sometimes does).
What types of programming or other issues could cause this?  What should I

I have two situations where I would like to save a setting so that it is
available the next time the program is run.  Firstly, I would like the user
to be able set a default path (images, exporting docs,etc.) which will
operate until the user decides to change it.  Secondly, I would ...

Where can I find the complete list of errors and their error numbers?
More specifically I have an error: number 2293 - which is to do with the
sendto command not working ie cannot send email.
Not sure why the error is ocuuring. It occcurs on one laptop conected to a

Can anyone direct me to a link on Microsoft.com to purchase the SDK witht
the runtime to distrubute a Version 2002 project?
Thanks and God Bless,
Mark A. Sam

i have an error trapper that goes something like this:
private sub MySub()
on error goto Err_MySub
some code here

Is it possible to save a list of records accessed via a form so if you move
to another record you can then view that list and move to that record if
required.   This would be a most useful thing as many times you are part way
through editing a record, the phone rings and you have ...

The filtered report I am working on comes up with the goods when I
preview it, but when I try and output the file to RTF, it prints all
the records!
I only altered the last line of code, hoping it would do the job, but

I'm using Office XP. Access 2002. All available updates have been done.
When I try to exit my mdb database I get this error message..
"You attempted to open a database that is already opened exclusively by user
'Admin' on machine 'DELL'. Try again when the database is available."

Is there a way to get rid of the blank row in a subform (created using a
query) that's residing within a main form? It is the row that has the * but
is showing up as a blank line.
Also, if I am linking the subform in within the main form using a primary

Hi;
Can i disable the predefined action of functional keys such as F1 (Access
help),F2,F3,F11 and so on,and use them for another purposes in my program?
Thank you.

I am changing an .mdb to a project and opening one of the primary forms
seemed to take an extraordinary amount of time.  So I opened my .mdb which
is attached to an .mdb on a network server.  This took 20 seconds.  I then
timed the same form in the Project, attached to SQL Server on ...