Textbox display month and year with buttons

[SOS]

does it help if i tell you guys the textbox is eg. march 10 and the field value 14/03/2010

Yes, it helps because you are trying to compare apples to watermelons like that. The field and the text box need to be the SAME.

So, it is back to the drawing board as we need to instead of building what you have on your form we need a date and use a date range or we build a field to include in your other form using a query and create a month year field so we can compare the two.

 

[Wilse]

ah got you sorry guys I did say I am new to this all,

so if I run a query to change all the date data to month and year it should work

 

[SOS]

ah got you sorry guys I did say I am new to this all,

so if I run a query to change all the date data to month and year it should work

No, you don't want a query to CHANGE the date data. You can use a query to pull all fields and to sort of create one that doesn't really reside in the table.

Like this:

MyNewDateField:Format([YourOriginalDateField], "mm yyyy")

and then you use that query in place of the table for your form's recordset. So it has all fields PLUS that bogus one which is used only to filter.

 

[vbaInet]

You don't need to do that. Is there a pattern to the dates that you're saving? Maybe it doesn't even need to be saved. That's a side note.

Do you really want to filter by the exact date specified or what SOS is advising?

 

[Wilse]

but does it matter it come out 03.11 and not march 11

 

[SOS]

but does it matter it come out 03.11 and not march 11

Why does it come out as 03.11?

If you have a date that is input as 14/3/10

and you use the format on it to be mm yyyy (it should be 03 2010)

 

[vbaInet]

At this stage maybe you want to explain everything about your date field?

 

[Wilse]

is it easier to email or upload it

 

[vbaInet]

That wouldn't be necessary for now. I trust you can hack this

Did you see SOS' last post?

Have you got anything in the Format property?

 

[Wilse]

no not now

 

[Wilse]

i have mmmm, yy to give the same format as text box in the query

 

[Wilse]

run time error 3075

syntax error in date query expression '[dateofwork]'=#march10

 

[vbaInet]

Alright. I believe SOS would still like to know ...

Why does it come out as 03.11?

 

[Wilse]

it isnt coming out as that now

 

[vbaInet]

Why did you put that format in the query?

 

[Wilse]

so it match the textbox so the form displays it like that and then the form can be filtered by whats in the textbox, is it wrong

 

[vbaInet]

Don't put it in the query. Use it on your form controls.

 

[Wilse]

still no joy, same error msg

 

[vbaInet]

That was just one step.

Right, so I don't keep on rambling, post your db. Remember to zip and remove sensitive data before posting.

Also tell me what form you want to open and from which button on which form.

 

[Wilse]

its almost 1am here now