Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MelF
  • Order by date
  1. MelF

    Duplicating Record within Form and Four Subforms

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

    Duplicating Record within Form and Four Subforms

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

    Duplicating Record within Form and Four Subforms

    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!
  4. MelF

    Duplicating Record within Form and Four Subforms

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

    Duplicating Record within Form and Four Subforms

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

    Opening Linked Report

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

    Disabling Control On Click of Checkbox

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

    Duplicating Record within Form and Four Subforms

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

    Disabling Control On Click of Checkbox

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

    Disabling Control On Click of Checkbox

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

    Disabling Control On Click of Checkbox

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

    LIKE Operator and custom dialog box

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

    LIKE Operator and custom dialog box

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

    Customized Dialog Box

    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!!
  15. MelF

    Customized Dialog Box

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

    Customized Dialog Box

    O.K. - I am very confused. I don't know how to get this to work. I've tried your suggestions: 1. I put an OpenReport macro on the O.K. button of my form, it opens the report, but with no info. ??? The query that my form is based on works fine, using the parameters I've put into it (begin...
  17. MelF

    Customized Dialog Box

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

    Move Switchboard Item

    GHUBBELL & SEAPORT - Thanks a lot for your suggestion!! It worked!!! Thanks again!!!
  19. MelF

    Move Switchboard Item

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

    Sum within Union Query

    GHUBBELL - Thanks so much for your post. I copied your query and substituted the name of my query for the name you gave it, so it came out like this: SELECT DISTINCTROW ProductsUsedbyDateQuery.OrderID, ProductsUsedbyDateQuery.OrderDate, ProductsUsedbyDateQuery.ProductID...

Part and Inventory Search

Back
Top