Recent content by Anthony.DG

  1. Anthony.DG

    Solved Small problem with VBA when opening on new record.

    So I tried this and ran into some weird errors. The first part I think is what I needed for sure. Did a little editing to it, changed the Else to ElseIf (i know someone said ElseIf make your code sloppy but its working with and for this instance) If Me.NewRecord = True Then ElseIf...
  2. Anthony.DG

    Solved Small problem with VBA when opening on new record.

    First one is the one that debug stops on.
  3. Anthony.DG

    Solved Small problem with VBA when opening on new record.

    So I have a bit of code on my form to make a textbox invisible when the record is equal to zero and visible if >0.01 . Code works fine when opening a previous record. When a new record opens I get runtime error 2427. I'm still new to VBA so I have no clue what to do differently. Any suggestions...
  4. Anthony.DG

    Solved Query for Datasheet SubForm referring to Form Controls for Search

    I see what I was doing wrong!!! OH THANK YOU!! I was being lazy and just Typing "Is Null" into the criteria when I should have been putting the whole thing in for the null criteria. Column MaterialName ([Forms]![frmLandScapers]![txtSearchFilter]) Is Null I can duplicate this now you are a...
  5. Anthony.DG

    Solved Query for Datasheet SubForm referring to Form Controls for Search

    So you were using the SQL View to edit it? I just want to be able to repeat it when I need to.
  6. Anthony.DG

    Solved Query for Datasheet SubForm referring to Form Controls for Search

    Ok I see what you did in the query, adding the "Is Null". But how did you add that line of code in the columns to the right? I tried adding the same line to mine but it slaps an "Expr1:" on to it everytime I try and wont work the same as yours.
  7. Anthony.DG

    Solved Query for Datasheet SubForm referring to Form Controls for Search

    Ok Im done banging my head against a wall... for now. Here is the low-down: 2 2 Forms 1 query I have a form frmLandScaper and a subform sfLandScaper. frmLandScaper has 2 controls. One is a combobox called cboQuarryFilter for QuarryID_FK the other is a textbox called txtSearchFilter to search...
  8. Anthony.DG

    Consolidating Similar Tables or Bad Idea?

    I have a database that has these different tables that stores records pertaining to Material. tblTicketing - Materials put on a truck weighed tblInvoiceMatDetail - Materials selected for estimates tblDemoDeposit a. Bank of construction site demo material in our yard that we will later recycle...
  9. Anthony.DG

    Solved Guided data entry

    This is beautiful. Exactly what I needed. Thank you for the guidance everyone! HAPPY HOLIDAYS ALL!
  10. Anthony.DG

    Solved Guided data entry

    I like this one too. I'll use this in other places as well. Thanks for that!
  11. Anthony.DG

    Solved Guided data entry

    I have a form for customer orders and once the order is complete the user is supposed to enter the date in the "completion date" and then check the box that says complete(Y/N). Well, some people forget to enter the date and it causes some information to go missing on the sales report. I was...
  12. Anthony.DG

    Solved Textbox Calculation, a question of conditional value

    Thank you I will try this out!
  13. Anthony.DG

    Solved Textbox Calculation, a question of conditional value

    Thank you so much! Worked like a charm! :giggle:
  14. Anthony.DG

    Solved Textbox Calculation, a question of conditional value

    I have a form for calculating freight for an order with a textbox that works just fine. BUT my client says they want to implement a minimum freight charge of $80. (they deliver, dirt and gravel). So the client asks that if the calculation of the freight is less than 80 then they want the...
Top Bottom