I hope this has only been posted once.
The query below is giving me a 'not part of an aggregate expression' error
for the ORDER BY VID.CategoryKey line below:
SELECT Sum(VIDetail.InvUnitPrice) AS UnitPrice, First(VID.QtyInvoiced) AS

For my question, I have a main form, MyMainForm, and a subform, MySubForm,
which are based on tables with a one-to-many relationship.  The main form
shows records from the "one" side of the relationship; the subform shows
records from the "many" side of the relationship.  The main ...

I have the below code on current.  Works great only I can't use the combo
box to look up another coil as it to won't allow edits.  I have tried
putting Allow Edits = True in the OnClick event to no avial and can't use
the Get Focus event as it is the first field the form goes to ...

I'm having trouble with a pesky bug.  I'm trying to lock a text box with
VBA, but I keep getting error #2166: You can't lock a control while it has
unsaved changes.
The textbox is disabled on the form by default, so there can't possibly be

Good Day,
I have have a form (frmneworders) that is based on my tblorders. The fields
are ordernumber, ordertype(based on cboordertype) for Custom, Program, or
Sample, and orderdetails.

The code I have pasted below checks my form for values in all the fields and
gives me a message box. However, the message indicates which fields have been
filled in and I want to know which fields are NOT filled in.
Any suggestions?

I have a control in a table that I want to puts is value into a string
variable for testing purposes.  The data type of the table control is Text
so sometimes it is null. If I try to load the null value into the String
variable I get the dreaded Invalid Use of Null error.  Is ...

I don't remember how to suppress the Access
"flash-window" when one starts an application.
Can anyone refresh what's left of my memory?
Bill

In Outlook 6.0,  if I get an e-mail with a web site address in it, I can't
access the web site.  The cursor turns into the hand, I click on the web
address, it shows up down below but nothing happens.  If I try to move down
to cut and paste the web address, it goes away.  I can ...

I am looking for the correct code for an event procedure for a command button
in a form. I have Access 97. This event procedure should be should be tied to
on "On Click" event.
This code would Run an Application program (in my case paint shop pro) and

On a form I have a button that runs an update query.  I need to pull the text
selected on a combo box to use in this query, how do I retrieve the data
that the user selected on the combo box?

Hoping someone can answer a couple of questions for me. I have found some
code on the Microsoft website to set up dsnless connections. I've inserted
the code below. I am at a bit of a loss as to when to use the code. I have
10 tables that I would like to attach to.

Hello;
I have 2 reports,named OrdersRpt and PricesRpt,and want to print them by two
separate printers connected to my system.I use this code to print them by
default printer:

How do you treat relationships with frontend and backends,
Do you specify them in only one area or both?

This should be simple.   I have a combo box that creates a filter on a form
after it is updates.   I've set the On Change event to cause the combo box to
drop down.   I like this because is shows me the selections available as I
narrow things down.   I want to be able to select ...