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