Search results

Date Query in Access XP Hi, I am trying to run a query that when you click on it, it shows any due dates for inspections test to appear for the month your in. E.g. I want to know all the inspections tests that are due in June. I have the following code but it doesn’t seem to work, it will...

im sure you understand it better than me but i works so im happy with that at the moment. Michelle

Hi All, Thanks for all your help, thought I'd let you know that i've got it working by using the following code: Dim Date_Due As Date 'Build criteria for Date due for Beginning / End Date If IsNull(Me.txtbegdate.Value) Then If IsNull(Me.txtenddate.Value) Then...

thanks for your suggestions, as i said before I haven't been writing VB code for very long thats why its a bit hit & miss.. Michelle

If I select/type Commercial- Angie Beginning Date -10/1/2004 End Date -10/30/2004 It brings up the error 13 msg & if you click debug it highlights the below line. 'Build criteria for Date due If Not IsNull(Me.txtbegdate) Then Date_Due = "=#" & Me.txtbegdate & "#" End If...

Thanks! I'll try that. Michelle

Thanks for the quick reply. Sorry im new to writing code, how would i write the #? do you mean: If IsNull(Me.txtenddate.Value) Then Date_Due = "Like # Else Date_Due = "='" & Me.txtenddate.Value & # End If Michelle

just to say i'm using Access 2002

Hi all, I'm trying to write some VB code, the user selects data using a form & when they hit ok it brings up a report displaying all the records that match. The form has three combo boxes & two text boxes. Commercial (combo) Customer (Combo) Status (combo) Beginning Date (txt) End Date (Txt)...

Thanks for all you help! It works!! I made a new query & used SQL to write the code NOT the design view. When I used the design view it replicated the same line loads of times, so it was very hard to see anything in the SQL view. Thats why I thought it was best to start again. The SQL on...

Thanks for the replies. I used the query builder. Do i need to get rid of all the "«Expr»" Pat, now the query brings up All records matching Commercial- 'Angie'. The dates are ignored. Thanks for the help. I'm fairly new to all of this! Michelle

Hi can anyone hlep? I have written a query In Access 2002 that runs off a form. The form has four combo boxes & two text boxes. Business Development (Combo) Commercial (combo) Customer (Combo) Status (combo) Beginning Date (txt) End Date (Txt) So the user could be really specific & use all...

Hi all, Have run into difficulty again, I have added another combo box 'Business Development',when i run my form now it doesn't display all the information that matches the search criteria.I know there are more records that should match the criteria, i don't understand why it brings up some...

Thanks, it was the AND. I checked it so many times, can't believe I missed it! Michelle

none of it is. a message box appears to say there's an error & there is only OK or Help buttons(which don't tell you anything). it doens't let you de-bug it.

Hi, I have a form with a filter of 3 combo boxes, which the user select to specify the information they want to find.A report will then display all information matching the search criteria. i keep getting the error message of : 'Syntax error (missing operator)in query expression.' Below is my...

Thanks managed to get it working. M

i've just realised im in the queries section should have posted this in the report section!! oh well, any help would be appreciated.

they are text. M

I'm trying to get 3 combos on a form to select the records to be shown in a report. have used some VB code on a command button, which should run the code & bring up the report. code is: Private Sub cmdapplyfilter_Click() Dim stryourname As String Dim Strcustomer As String Dim...