I  have a query based on another query with multiple criteria. I want my
query to return records based on a multiselect listbox in a form. How can I
achieve that?
I have looked up the subject in other questions that have been answered and

I have a tab control on a custom switchboard form. I would like a way to fix
the size of this control but I don't see any obvious way, such as a "can
grow" property I could set to a value of False.
I have a series of command buttons that move around on the form (don't ask

I have a program to allow the user to allow his client to register a course.
After register for the course, the system will gerenate a list of item that
the user had to pay like the registration fee, the course fee for every month
and a sub fee that had to be paied every year as ...

I have a Client table and three additional tables Screen , Assess, and Follow-
up.
The Client table  automatically assigns the Client_ID. This ID is carried
over to the other tables.

I'm just after an idea of how I could go about doing the following:
0 0 0 0 0 8 4 4
2 1 2 1 2 1 2 1
The top line of numbers is just a formatted number that will change but

I have a comobo box that get a value programatically, and I also set the
cursor to go to the combo box. All works well.
Howevere sometimes the value is not part of the list and if the user goes to
a different control The limit to list event does not fire up.

I have two unbound combo boxes (c1 and c2) that based on the value of c1,
will determine what shows for c2. By selecting c1, it will correctly limit to
what c2 shows, but when I select the option for c2, it is not choosing the
correct value.  The result set for c2 is based off a ...

Repost from last week.  
I have a combo that uses the NotInList event to trigger a custom message box
and open up another form.  The standard error message that Access gives when
something is not in the list is still being displayed, despite my custom

I have a status combobox that has a few choices (Pending, Approved,
Completed, Withdrawn).  On initial entry the status is Pending.    I also
have a subform that totals up the cost approved of items requested.  Only if
the cost approved is >0, do I want the user to be able to ...

I learn that Global Recordset which is always open can improve multi users
performance from here
http://www.granite.ab.ca/access/performanceldblocking.htm
I beleive that it must be connnected when user running the program.

I need to create a control whether it is a button or a TextBox that the user
can click on that would bring up all of the .xls files in a variable
(strFilePath). they will then be able to click on one of the files and import
it using DoCmd.TransferSpreadsheet acImport function. ...

First, please don't suggest using export to excel. I need a much nicer
presenentation than what that does.
I've used some code for some time now that opens Excel and creates a nice
file using vba automation from MS Access. But it's really slow. All the

I have created an input form for new records from our main production form.
The main form does not refresh after the new record is added.
A "requery" command works when the form is opened from the Form objects menu
but not when initaited from our "Main Switchboard" form.

Hi all.  Please help!
My form allows add, delete, edit but not data entry.  I use this form to
view and edit vacations and I wish to also be able to add a new vacation(s)
via a command button.

I have a form that enable the user to enter comments. I want to add a button
where the user can Zoom the comment line. However, this is a comment that
will be add to a table.
I use the following code and I'm getting a run-time error 2046. The code that