Search results

When there error occurs I do not get the Debug pop up, it just has the error syntax and an OK button. It says: '[Part] = "150-AD220-NP" AND [Cus Order Date] < = # July 8, 2010# AND '. I don't know how else to get the error message to you.

The red is what I'm not sure of.

I'm not quite sure I understand exactly what to do here.. ?

It just keeps telling me there is a syntax error in the code...... "Syntax Error(missing operator) in query expression '[Part] = "150-AD220-NP" AND [Cus Order Date] < = # July 8, 2010# AND ' .....

No, unfortunately I don't have permission to send this database out.

We're getting there! so when both date fields are filled in and a part is selected, the filter works perfectly. When One or Both of the date fields are Blank, a syntax error comes up "missing operator in query expression..." And the Repair Checkbox still has no effect on anything.

Each record in the form has a checkbox called "Repair". I inserted a Checkbox in the Form Header called "Repaired". When that checkbox on the form header is checked, I want the report to show ONLY those records that have their "Repair" box checked. On the report I added a checkbox and its...

Private Sub QA_Report_Click() On Error GoTo Err_QA_Report_Click Dim stDocName As String Dim stWhere As String Dim stDates As String Dim blnRepair As Boolean If Not IsNull(Me.Combo44) Then stWhere = "[Part]=" & Me.Combo44 & " And"...

Ok so it somewhat works. When I click the report button it asks me to enter parameter value for the [Part] combo box. And when I click the Repair (Checkbox) it doesn't filter for records that are repaired. When I just have the start and end dates and leave the combo and the boolean blank, the...

Thanks for your reply Bob! I am going to try this out instead of trying to filter on the form, that makes more sense. For the Boolean, would you recommend that I use a Check Box or an Option Button? or does it make a difference? Thanks again

Hi All! I have a form based on a query, it is a continuous form that shows every record from the query. The form shows: Serial #, Order Date, Part #, and Repaired(yes/no). I would like to create multiple filters so the user can: 1. Choose a time period based on Order Date (Pick 2 dates)...

That sounds like a good idea, except the tax rate for each invoice is based on certain customer information. So when you choose a customer from the drop down list, it automatically chooses the correct tax amount for their province/state. It's to make it so the user never has to guess what tax...

Hi All, just ran into a new problem. On July 1st, 2010 we changed over to the new HST (Harmonized Sales Tax). In my TAX Table I changed the tax rates accordingly. This has now had a ripple effect on sales orders prior to July 1st. Is there any way to make these changes happen to orders AFTER...

ghudson.. that seems to work exactly how i need it to except, even when I click on the text box to enter the number, it automatically takes me to that folder, is there anyway to make it so that the command doesn't execute unless there are numbers in the text box??

Thanks for your response Apr Pillai. I'm just a little confused about some of this code, why do I need two text boxes? and what does the ".title=Select employee picture" have to do with anything? And is it not just possible to leave the original text box as a hyperlinked field that will find...

Hi All, I've been searching the forums for an answer to my question, but I probably didn't look hard enough. I have a form with a bunch of fields on it. One of the fields is a serial number field, which the user will enter manually for each new record. In the properties window I have changed...

Yes the form itself saves automatically, but the report generated from that form does not. I have a button on the form to save the report in pdf to a folder on the network, but i would rather the user not have to hit that button so that the report generated by that form automatically saves into...

hi everybody! was wondering what event procedure I could possibly use to automaticaly save a forms data when the user closes the form using the 'x' at the top right of the screen, would that be 'on unload' or is there something else I need to use? Thanks a lot

Thanks for all your help. I did change the whole thing to VBA, works like a mint now.

Hi, this is the vba event that calls the macro. Private Sub Emailb_Click() On Error GoTo Err_preview_Click Dim stDocName As String Dim stLinkCriteria As String Refresh stDocName = "S-Order Report" stLinkCriteria = "[S-Order].[Order ID] =" & Me.[Order ID]...