All,
I have a record review form (with multiple subforms) that isn't
sorting as expected when I filter it.
It's a form used to review contract line item details by fiscal year.

I have two combo boxes that get their rowsources via a select query on
enter. currently, the first one gives company names, and the second
one gives salesperson names for whichever company was selected.
I would like the second one to populate with all salesperson names if

I have a 1:m form using 2007.  In the subform part of the form I would like
for it to look like a spreadsheet.  A datasheet view seems a good choice and
I like its looks and functionality; you can sort and filter the rows easily
etc.  However, at the present I am using a tabular ...

Is there a way to allow users to enter pictures on a form?

I have a form I use to Add/Edit Inventory.  I access it by part number, but
one particular part number has strange symbols in most of the fields, the
rest have incorrect information, such as a retail for $64,852,164,489,301.27
instead of $39.97 and a Last Update date of ...

I'm using SQL Server 2000 with Access 2000/2002/2003 (file is
formatted as 2000).
I have a field in a table in SQL Server that is linked to the Access
file.  The field was originally a bit, but I have also tested with

This is rather a lengthy one...I will try to be clear...
To handle our jobs I have a Main form and 5 subforms on tabs.
Each job is identified by Ref and Surname.
The parent-child link on all forms is Ref-Ref.

I need some help with a query.  I believe that a Union Query is
appropriate, but I am unsure.  I have two make table queries.  One
makes a table called QTY_RECEIVED that has the following field names:
Part#, Fiscal_Week, Fiscal_Year, and Receipts.

I recently posted this problem in "Forms" (Lost Focus of Form 7/27) thinking
that was the problem, but recently discovered the problem appears to be in
the query(ies).
I've dropped a from into a form that has multiple tabs/pages to consolidate

I have a listbox called lbSelectList. It has 5 columns. I want to rifle
through the selecteditems collection and use columns 1,2,and 3 in sql
statements (not column 0...). I can't seem to refer to the columns properly.
Can you provide some advice for me? I'd guess it's something ...

I've inherited someone elses work and I'm new at this.   Most recently in an
attempt to consolodate things, I've combined 9 different (small) pop-up forms
into one using a single Tab form (dragged and dropped forms into each tab).  
8 forms input into their respective tables (7 ...

In an application I have a main form that is tabbed.  The system menu does
not appear, and this is what I would like.  But when I open a report in
preview mode from within the application the system menu does appear .  What
visual basic code is needed to suppress the system menu ...

How do I input the first item of a list box to the relevant field of a
database, if the user doesn't select any other item. I want the first item to
be the default entry to the field if the user did not select anyother value.
Am I expecting too much from a simple list box?

I Just created a form but it wont print.  I view "Print Preview" and only the
Form header will print and not the Form Detail.
Any Suggestions??

When I select my combo box and either type of select a branch all of the
address information will come up but not the name of the branch which is what
the combo box is. It does the same things for my vehicles. Can someone please
help. Here is the VBA Code: