I am getting an error message "Too many expressions in ORDER BY Clause" on
several different macros that I am trying to execute that just open a form
with a Query and display some records.  What is odd about this is that I
haven't made any changes to any code or forms.   When I ...

Is it possible to create 2 or 3 columns on a form?  I have a form with a
single field in the Detail Section and an Option Group/various buttons in the
Form Footer. Instead of scrolling the detail section up/down in Form View
mode; I would prefer to contain the whole dataset in ...

I know how to open MS word, but I want to be able to open a specifi msword
Doc using a button on an ACCESS 2000 form. Any tips?

I've been trying to do this for some time but just cant seem to get it right,
please help.
I have one form called"Job Details" which is like a work order. On this form
i have a feild called"QuoteNumber". From the Job Detail form i have a command

I am having dificulty reading data from a nested subforn i.e mainform -
subform - subform.
I can read from the main form "Forms![customer].customernameI ".  I can
read from the 1st subform "Forms![customer]![equipment

I use the following methods but fail, #Name? appears......
[Forms]![History Result
List]![Holdings].Form![subform_control].Form.RecordSource = sub_subform_sql
history Result List is a Form and Holdings is the control name of the first

I'm unable to save the data entered in a form after it is closed everything
disappears.  I would like to be able to enter certain permenant text in the
design view also but when I switch to form view it says #name?.  Please Help!

what is the visual basics code to create a command button to open an excel
file?

I currently have a macro that populates a Word Doc and and Excel Spreadsheet
based on values from my form.  However, I would like Word/Excel to be visible
after the macro is completed, so the user will be able to see that a
document/spreadsheet has been generated and is ready for ...

Private Sub GetEIDDate_Click()
Access 2000.  I'm trying to get this code to work by joining [EID] and
[Current_Date] below.  I have two textboxes and a cmd button, hoefully will
send my form to the record with the two criteria selected.,Thanks...Randy

Hi, using Access 2003, I like “DPN” to be populated in Form [ReceivingLog14]
control [TransActionType15] when data is inputted in ReceivingLog14 Subform
[DeptNonStock Number Subform] control [Description].   Thank you for your
assistance.

How do I get an address from a table to automatically populate in a form

I have a form FOfferTransform and I have put a button to do the following:
*******************************************************************
Dim x As Integer
x = DCount("OrderID", "Orders", "[OrderID] =  Forms![

I have a form with various text boxes displaying the data in each. The REGION
is selectable by the user. I set up a query That retieves data based on the
region selected. When the query runs it pulls the data I need and pops up a
table. I want the data it retrieved to update the ...

My users often use other applications (Excel, proprietary apps on the server,
etc.) to do their work. They work with drawings that have numbers
("123XYZ45678") as identifiers. They are used to using a cmd button that
opens the ctl F find dialog and then pasting the # in there to ...