Recent content by MelF

GORD - AWESOME! It worked for my main form (Site Information). However, it's not working for my "sub" form. Let me explain how these forms are set up: Site Info (Primary key - CustomerID)is the first form they'll enter. This duplicates fine. There is a command button on this form...

GORD - O.K. - I'm beginning to think my way is going to be impossible. Back to your earlier post: "MelF, it's still kind of a dangerous proposition in any case... You might be better off to run one at a time as per MS, then do something like: Forms!nameOfForm.setfocus...

GORD - I'm a little confused. Are you saying you don't think there's any way to programatically fix this AutoNumber duplication problem?? Thanks!

GORD - Thanks for your response. To explain: Yes, that is my goal. This will eliminate A LOT of data entry for the employees. There will no doubt be minor changes to be made to each added record, but will still significantly reduce the typing within EACH added form. I do want each added...

UPDATE: I've put the following code into the command button that duplicates the record: Private Sub btnDuplicate_Click() Dim dbs As DAO.Database, Rst As DAO.Recordset Dim F As Form 'Return Database variable pointing to current database. Set dbs = CurrentDb Set Rst = Me.RecordsetClone On...

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

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

OMEGA - I just got it!! I just switched my False and True statements! Thanks again!

OMEGA - Thanks for the response. Someone suggested that I take the brackets off the field names, so now I have this code: Private Sub LocationDataCheck_BeforeUpdate(Cancel As Integer) If Me.LocationDataCheck = -1 Then Me.LocationDataEntered.Enabled = True Else...

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

GORD - Thanks again!!! I was trying to do this in SQL view and not having much luck, but tried it in regular design view - And it works!! Thanks!!!! -Melody

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

GHUBBELL - Thanks for your reply. I just got it to work!!!!! I was missing the >= signs in my criteria in my query. That seems to have fixed it. We'll see!! Thanks again!!

Correction on above: The query that my REPORT is based on, not form . . .