Search results

Union Query How do I create the union between the two queries to enable the correct results?

I have a query qryChillers that includes IDChiller and dtmDate from tblROrderDetail. Currently the query pulls up any records from tblROrderDetail that show IDChiller has not been cleaned in the past seven days. SELECT tblROrderDetail.IDChiller, Max(tblROrderDetail.dtmDate) AS MaxOfdtmDate...

Thanks for the help! The record locking options worked for allowing multiple users editing access. Are there any other ideas on Workgroup Security or User Level Access for the issue I stated in problem one? Thanks again!

Problem One: I have attempted to create workgroups and user accounts in my db, but each time I attempt to save the information, it gives me the error - file is write protected... What I've run into is my companies security for the application is not allowing me to create my own mdw file for...

I am attempting to create a form "frmROrder" with two command buttons, daily detail, and annual detail. Is there a way for me to set frmROrder up so that If I click on cmdDaily it opens subform frmROrderDaily or if I click on cmdAnnual, it opens subform frmROrderAnnual? Thanks for your help!

I am having trouble figuring out a combo box issue. I have frmSelection the holds two subforms: frmOrder & frmOrderDetail. Is there a way for me to make the forms work together so that a combo box selection in frmOrder affects the view in frmOrderDetail? Example: If I select "Press 1" from...

I am trying to remove the built in form views from access 97. Is it possible to remove the navigational functions of the form while in view mode (ie first record, previous record, search, next record, and last record)? There is also an arrow bar that has no functionality to it placed at the...

Thanks Jon K! it worked!

Is it possible to have the database converted to load in access 97? sorry.. i dont have a newer version.

Is there any way that I can set the query up to return either the selection only or all of the values? example: combo box selection 1 returns only press 1, combo box selection empty returns all presses?

I am attempting to query details of an order that has been entered based on multiple criteria that is entered on a form. The SQL for my query is below. Unfortunately, I have everything querying if the fields are left blank, but if I fill in Form Field IDPress it wont give me the specifics for...

Found it! The query requires a "like" statement instead of a "where" statement. Thanks for your try!

Already unbound fields I looked into my form to double check your suggestion against my system, but the fields in my search form are not bound to a table or query.. Any other ideas?

I have a form that calls for a combination of combo boxes, date fields, check boxes to be filled in. I am using this form as a "user interface" for querying specific orders in my table tblOrderDetail through qryOrderDetail. The results will then be posted on report rptOrderDetail. I have all...

You're Awesome! Thanks for your help!

Hello there. Thanks for your help in advanced. Let me outline my database for you before I start. I am dealing with the following tables: tblPress, tblPressCategory, tblProgram, tblOrder, tblOrderDetail Each press(intPress) from tblPress falls under a specific category(intCategory) from...