Search results for query: *

I have an Orders form that includes a Kit Ready date. On this form also is a command button (Packing Slip) that opens up the Packing Slip (report) associated with that order. I want to make a report or make a macro to put in the OnOpen event of new report that pulls up all Packing Slip reports...

I have a form that has four "sub" forms. (They're not technically "sub" forms, but regular forms, linked to the one main form.) They are all linked using the Customer ID (primary key in Customers table). The record source for all forms are: Form...

I have a checkbox (LocationDataCheck), and a text control (LocationDataEntered). When LocationDataCheck is checked, I want LocationDataEntered to be disabled. I've put the following code into the OnClick of LocationDataCheck: Private Sub LocationDataCheck_AfterUpdate() If...

Question of the day: I have a custom dialog box (form) that prompts for criteria, then opens my report based on the specified criteria (Begin date, end date, and ProductName) It is working fine, and the query behind my report is: SELECT DISTINCTROW ProductsUsedbyDateQuery.ProductName...

I've created an unbound form that prompts for report criteria. I know I've left something out somewhere, because when I run the report, which pulls up this dialog box, I enter the criteria I want, then I get this error: The object doesn’t contain the Automation object ‘DateRangeForm’. You...

This sounds so simple, but I can't do it. I'm in my Switchboard Manager, trying to move the item Enter/View Orders by Employee to the second from the top of the list. I click on the Enter/View line, then click the Move Up button. This doesn't move what I've selected, but merely selects the...

I have the following query: SELECT[OrderID],[OrderDate],[ProductID],[ProductName],[Quantity] FROM[UnionQuery1] WHERE (OrderDate Between [Enter begin date:] And [Enter end date:]) AND ProductName LIKE "*" & [Enter Product Name:] & "*" UNION...

I have this query: SELECT[OrderID],[OrderDate],[ProductID],[ProductName],[Quantity] FROM[UnionQuery1] UNION SELECT[OrderID],[OrderDate],[ProductID],[ProductName],[Quantity] FROM[UnionQuery2]; I want to add two parameters: One that prompts for date range (between1-1-00 and 1-28-00), and one...

I have a report based on a union query. When I run the query, it's fine. It's pulling in all the correct data; however, when I create my report, and open it in Print Preview, only two out of the five fields are pulling the data in. Every other field just has the label, but no data in the...

Just don't know how I should be doing this: I have a query including two tables, Orders (Prim.Key=OrderID) and EmployeeShipping (Prim. Key = OrderID). The Orders table contains an OrderDate field. The EmployeeShipping table contains an EmpOrderDate field. Since both primary keys are called...

O.K. - This is what I did with my forms and I'm wanting to mimic this with my DAP's if possible: I had two forms. I wanted one to act as a "subform" of my other form, so that when you opened up the Customer form for Smith you could click a command button that would then open the...

I have a data access page that has a drop down list in it. This control is bound to the EmployeeID field in my Orders table (2-column field). I cannot figure out how to get this to show ONLY the employee name, and not ID. When I go into my DAP and properties for this control - There isn't...

There's a field in my Orders table called Employee ID. This field has a Number type, but displays the names of the employees. In the table, this field has a query (lookup)for its row source. This is fine in the table, but I need to get these values into a combo box in my DAP. I fill in the...

I have a form based on the table Customers. Now I've developed a DAP that also has the Customers table as its record source. My DAP fills out fine and saves fine; however, this data is not populating the Customers table. Any idea what's going on?

I have a form based on the table Customers. I then created a data access page also based on the Customers table. When I go into the data access page, all my data looks as it does in the form. However, when I go to add a new record, a few of the fields won't let me save any data to it. It...

I have the following code in a command button: Private Sub PackingSlipButton_Click() On Error GoTo Err_PackingSlipButton_Click Dim stDocName As String stDocName = "EmployeePackingSlip" DoCmd.OpenReport stDocName, acPreview Exit_PackingSlipButton_Click: Exit Sub...

I have this option button. When I click on it it gives me the message, "Control can't be edited; it's bound to unknown field 'Office Type'." There is no field called Office Type anywhere on my form, and when I go into the properties for this option box, there isn't even a Control...

I used the Label Wizard to create my labels, with the data source being a query. The data gets into the report fine, but I can't edit where each label goes in the report. I'm thinking that there's no way to do this. Anyone know?

I have a report called Packing Slip. When I click on this a dialog box comes up that allows me to enter the info. that will be put onto the packing slip (date, number, etc.) When I fill this info. in, it takes me to the report, but I don't know how to edit the dialog box itself. Anybody?

Hello everyone. Current dilemma: I have a form that I enter data into. When I exit the form the data is saved to the appropriate table; however, when I go back into the form the data is gone. Why is this data not being saved to the form, but it is saved in the table?? I'll call the form in...