I have a form that accesses the query below. When opened by clicking on
the query in the database directory it works by opening a small dialog
box asking for the machine ID. When opened using the switchboard it
doesn't ask for the machine id. Why is there a difference and how do I

I want to create a combo box in my form.  The combo box must equal to the
machine that I pick so that the right material I use for the machine would
come out on the list.  Please Help.

How do I write an expression using sum iif ?
I'm trying to sum Ten textboxes in one textbox base on IIF a value
is greater or less than in one of the Ten textboxes.
Floyd

I have a subform in datasheet view that keeps getting altered by users.  Is
there a way to maintain a specific sort order and also lock the columns so
that they cannot be hidden?
Thank you!

Hi all..
 I know I have seen this before..but I could not find it.. So know I am
asking.
I have a table setup: tblReports

Hey all, using MS Access 2000.
I've created a form that allows the database user to browse for and
insert the file path for a video library of sorts.  I used the standard
"Browse" code located at http://www.mvps.org/access/api/api0001.htm.

I am using Accusoft ImageGear to display images in my application.  In
order to pass the image to my function, I am calling
Application.FileSearch.FoundFiles and randomly getting Run-Time Error
9:  Subscript out of Range.  I realize that the FoundFiles is an object

Hello everyone and thankyou for taking your time to read this. I
apologize for posting in multiple groups (for some of you have noticed)
but I need maximum feedback. Here's the nitty gritty.
The database is for BF Goodrich (Michelin's company). This could be

I was making some changes to database forms, and noticed that the form
properties window was gone.  It isn't hidden off screen.
None of these will restore it:
Alt Enter,

I have a form that is based on a query. There are 7 fields in the query
and they are all represented on the form. Six of those are combo boxes.
The form returns a total of 5742 records. I would like to filter those
records based on what is chosen from the combo boxes on the form. ...

Ok,
First let me thank you for all of your help.
I have a process that has a start time and an end time that needs to be
recorded.

I have tblCustomers and tblInvoices linked in a one-to-many relationship with
key field [CustID]
I have frmCustomer with my customer demographic information and frmInvoice
which shows all the invoices for a given customer.

All,
I am trying to create a form to easily input into a table, employees who
attended a training seminar.   Training is conducted every other week, and
the topics change.

I have a form with subforms on it.  I need the form to start as a blank
form.  Now, when a user types some info in the form, on the next new
entry that info is on the form.  Is there an easy way to get a clean
forms.  If not, I have check boxes and text boxes that need to start

I need to know is there a way to format the date going from a access
table export to xml so that instead of <DOB>1961-08-07T00:00:00</DOB>
in the xml file I get <DOB>1961-08-07</DOB> in the xml file.  In access
the field is all ready formated as a date/time, and short date.