Search results

I've posted this before, but never got any responses. Maybe someone has some suggestions: 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)...

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 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: - Record...

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...

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...

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...

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 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 Source. Does...

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?? Thanks in advance for...

O.K. - I'm still new at this, I don't understand this. Can't you open a subform with a command button? I created and named my subform (Subform - Reimbursement). When I invoke the Command Button Wizard and it lets you select which form you want opened - This Subform is not listed. ??????????

O.K. - I know this sounds stupid, but when I scroll down my form in Form View, it's not a "clear scroll". Everything is flashing very fast, and you really can't make out the text as you scroll. Any ideas on what might be going on? Thanks

Here's my daily dilemma: I want a Message Macro to display when one of my product's (Quick Start Cards) Units Available drops below 11. So I wrote a Message Macro with the following expressions in the Condition field: [Forms]![Products]![ProductDescription] In ("Quick Reference Card - Up &...

I know this isn't an Access issue. I've posted it on the Excel page, which doesn't seem to get much traffic, so I thought maybe someone here might have an answer: Some time ago I was messing around with macros in a couple of my worksheets. I've since deleted them, but every time I open these...

I have a report that contains multiple subreports. My report is fine to begin with, then I go into Design view, and put a report footer in the first subreport. Then I switch back to Layout view. My subreports are then all screwed up. The data from my last report has now replaced the data in...