Good Day All,
I have a form that I use for order entry and from my frmmain I can open the
form in edit mode (with a password) or read-only mode.
The code that I use to open the form in read only mode is as follows:3

I have a drop-down box that I only want to display values from this criteria:  
Based on these tables:
tblEmployee (EmployeeID - PK) with a 1-m relationship to tblVacation
(VacationID - PK, EmployeeID - FK)

I have a report form with fromdate, todate, and admin as parameters.  Admin
is a drop-down list of admins. I have several reports on this form.  When I
click on a report, I'd like to filter the report based on the above
parameters chosen.  I'm using the following in my report query:

Can I control toolbar visibility from code?  I have an application which
will be used by most users as an MDE.  I would like to detect if it is
running as an MDE (I've figured out how to do that), and if so, turn off
most of the standard toolbars.  I've looked in many places, but ...

Database is mdb with SQLServer2000 back-end, Access 2003 front-end. I create
a local (Access client-side) table. I add a single row to the temp table with
"INSERT INTO tmpTable (Field3, Field4) VALUES (xyz, abc);" Then,
myComboBox.RowSource = tmpTable

I'm pulling my hair our...
Table Name=Excel
Form = freports
I am trying to run a Select statement from the Excel table where the

I'm not sure it's always so hard to find help on common coding, so here is my
question.  I am using Access 2002 and I have a database I use for work.  It
has a main table, and I have a form that allows a user to edit the records in
the main table. I would like to create a change ...

I want a certain form's ControlBox to be set to True or False depending on
certain conditions.  This should take place upon form Activation.  The
default condition is False.  However, if I try to change it to True I get an
error on code execution that tells me "you can't assign a ...

Is this product available? Where can I buy it? Or if anybody has a legal
copy they want to sell,  I can pay you with paypal.
Thanks
Jack

I have a theory-type question.  Can someone explain to me what the difference
is between DoCmd.RunCommand acCmdSaveRecord and saving Recordsets (e.g.
updates, edits, etc.)?
I am having problems with the DoCmd.RunCommand acCmdSaveRecord and am

I have a query in Access 2000 where I am using the "between" clause to
return rows based on a from and to date. The format for the criteria field
is as follows...
"Between #25-Sep-2005# And #04-Oct-2005#"

What is the maximum (limit) for number of fields you can define for a form?
Greathings from Gustaf

I have two tables:
Vehicles (PK: VRM)
Awards (PK: AwdID.  Other fields:  AwardString, VRM)
Tables are joined in one to many using VRM (ie Vehicles is on "one" side.)

I have developed an Access application.  On one form I have a button that
will "browse" for a file.  I have used code I found on this site that
requires a reference to Microsoft Office Object 11.0.  All is working well on
my computer that is running XP and Microsoft Office ...

I want to force users to create a record using the main form before they add
records to the subform/linked table.  If they try to add data to the
subform/linked table a message box should display, undo the change to the
control's data, and set focus to the txtNew_Bill contnrol.  So ...