Recent content by Melody

PAT & CHARITY - Thanks for responses. I've taken a different approach to this. I've eliminated the query but kept all the rest of the code, minus the CustomerID. I've been told that it's probably easier to have a Duplicate button within each form rather than asking the one duplicate button to...

PAT - Thanks so much for your feedback, and taking the time to post all that code. This is what I've done since my post - I got on the Microsoft web site and found an article titled "How to Duplicate a Main Form and its associated subform detail records", so based on this, I put this code into...

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

O.K. - I think I got it to work again - We'll see! I added this code to the On Current in the Form: Private Sub Form_Current() If Me.LocationDataCheck = -1 Then Me.LocationDataEntered.Enabled = True Else Me.LocationDataEntered.Enabled = False End If If...

RICH - Thanks for the suggestion. I tried it, and now I have a different problem - Now it's saving the control as grayed out, but it's not saving the check in the check box. I put this code: Private Sub Form_Current() If Me.LocationDataCheck = -1 Then Me.LocationDataEntered.Enabled =...

O.K. - This is working, but when I close and go back in, it's not saving it. (When I click the checkbox, it grays out the other control, but when I exit and go back in, the control is no longer grayed out, just the box is still checked.) Here's my code that's in the checkbox: Private Sub...

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

O.K. - I just got it to work. I switched my True and False statements, and it's fine now. Thanks!!

RICH & LLK - Thanks for your replies. I put the following code: Private Sub Form_Current() Private Sub LocationDataCheck_AfterUpdate() If Me.LocationDataCheck = -1 Then Me.LocationDataEntered.Enabled = True Else Me.LocationDataEntered.Enabled = False End If End Sub in...

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

Never mind - Problem fixed.

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?