Search results

I had managed to do it before using two textboxes with Between DateSerial([forms]![main]![cboYear],[forms]![main]![cboMonth],1) And DateSerial([forms]![main]![cboYear],[forms]![main]![cboMonth]+1,0) placed in the Cirteria part of the query, I cant get it to use one textbox. The plan was...

Maybe not, the textbox displays todays date as on the forms load Private Sub Form_Load() DoCmd.Maximize monthtext = Date End Sub The user then changes the month using command buttons one to go back and month and one to go forward. I though it would be the same format but im no expert.

03/01/2010 is the format in the table

I have tried to do it that way but I have no joy so far, only if the data is from the same date of the month as today. I think it is because the textbox shows the day month and year

Hi guys, My mind has gone blank with this one, I have a textbox on the main form called monthtext. I want to use the data from this to filter a query to display records from only the month selected. I have tried a few ways but for the life of me I cannot work this out. Any help would be great

I have created a new form and put the combo boxes on and changed the query criteria to point at them but i still am getting the same error when I try and open the form

Rich do you have any ideas on what the issue is?

that has been removed

still if i remove the criteria from the query it will open the form and then if i keep the form open and place the criteria back into the query it works. Just not when I close the form and reopen it. I have been through the VB coding on the form and cannot see anything wrong except two...

where does it show monthtext

i dont think so, If i remove the criteria and open mainmenu form then add the criteria back in the query it works up until i close and reopen the mainmenu or close and reopen the database

in the criteria on the query, it did work until i closed the database then went back in

uploaded if anyone wants to look

It wont open I get that message

if i delete the Between DateSerial([forms]![mainmenu]![cboYear],[forms]![mainmenu]![cboMonth],1) And DateSerial([forms]![mainmenu]![cboYear],[forms]![mainmenu]![cboMonth] +1,0) and then open the mainmenu form then add criteria back in it works until the mainmenu form is closed and reopen or...

Between DateSerial([forms]![mainmenu]![cboYear],[forms]![mainmenu]![cboMonth],1) And DateSerial([forms]![mainmenu]![cboYear],[forms]![mainmenu]![cboMonth] +1,0) now gives me "This expression has been typed incorrectly, or is too complex to evaluate..."

Is this ok, or is there a better way Private Sub cboMonth_AfterUpdate() DoCmd.OpenQuery "Data Query" DoCmd.Close End Sub

What a star, thanks so so much, now if I use after update to rerun the query it should update each time its changed

it doesnt show me anything for this month and i have 1 record :(

Between DateSerial(Year([forms]![mainmenu]![cboYear]),Month([forms]![mainmenu]![cboMonth]),1) And DateSerial(Year([forms]![mainmenu]![cboYear]),Month([forms]![mainmenu]![cboMonth])+1,0)