Recent content by mickey_lin_uk

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.