I constructed an SQL Statement in a string variable, strSQL.  When I run the
query I get a type mismatch error, however if I place the value of strSQL in
the QBE Grid, it contructs a valid query which runs fine.
Here is the value of strSQL:

Can someone help me,  I've looked at several samples of this type cbo on a
form but I can not get this to work.  I have a table called Type - which has
the fields of TypeGen and TypeSpe  (these stand for Type-general and
Type-Specific).  In this table I have several books names ...

I'm pretty new to Access programming and I am fumbling thru my first database
so far so please bear with me.
I'm trying to create a form that (like a slideshow) will open and display the
fields on the form based on the records from that table for a certain amount of

Two users (including myself) are running an mdb through the full version of
Access, while six other user are using the runtime version. A strange effect
is that those of us who are using the full version of Access opens a form in
about 5 minutes and 30 seconds, while the users using ...

i use three levels of forms in my application.
[main] > application logo, main navigation buttons
[subform1] > specific control buttons, user tips
[subform2] > datasheet

- Open Access 2003
- Create new database (2000 or 2002/2003 format)
- Create a report and insert a label in its Detail section
- Save the report as Report1

Allen et al,
I'm still having problems with the routine to gather my
required fields into one msg box.
I enter a name and save, skipping all required fields.  I

I am trying to run this make table query and and gettig the following error:
Query input must contain at least one table or query.
I copied this from the QBE grid and modified it slightly.  Before the
mofications the error appeared.  I also took out a where clause which has

I'm trying to move or reposition a tab control on a form in the runtime
environment.  When I try either the MOVE commane or position commands like
LEFT etc.... it just make the tab control bigger, but it does not move it or
reposistion it on the form.  what am I doing wrong?

I intended to create a SubFrom to be called by multi-MainForm. While the
SubForm be called, a return path "Forms![abc]![cde].[Form].[field]" value
will also be given to the SubForm from MainForm and stored at a textbox of
SubForm. After the process by the SubForm, a value will be ...

I am using A2002.  I have a list box with two columns (one hidden).  The user
selects an item and then the VIEW command button shows.  The ONCLICK event of
the the VIEW command button outputs a query to excel.
I am trying to get the value of the hidden column passed to the query.  ...

I want change a string text to be Form Object. How am I do.
e.g.
Dim a as Form
a = "Forms![frmWIPEntry]![frmWorkDone].Form![Begin]"

A main menu opens 30 different forms. For each form there is a command button
with code to cancel the open event if there are no records.
I have tried to create a private sub that can be used in the code for each
command button to save typing the routine out 30 times, but it ...

Let's say I have a form with two controls: ITEM_TYPE (a combo box), and
OPTION_1 (a check box). I want OPTION_1 to be invisible, except when
ITEM_TYPE is equal to "X", in which case OPTION_1 becomes visible so the user
can choose to check the option box if they wish.

We are looking for a way to 'lock' records after they are entered into a
form-- either in code on close of the form or behind a Command Button.  We
currently have forms in a series that you get to by hitting a 'Next' Command
Button.  This button has code to go back to the ...