Search for date

[azhar2006]

Hello Guys


I have developed a drop-down list to choose a search for a specific date and its purpose is to process (search)
But show me this message
Are there other ideas

[azhar2006]

Brothers
To illustrate more
I'm working on a project and construction company to build homes for the poor. This company has daily transactions
Every day you buy, bricks, cement, building materials and other course also give wages to its workers
The other day opens a new page to work
Question
To return to a specific day or date of certain how?
Are ideas
Help

[rpeare]

That's an error in your code I think what is the code for the event that is triggering this message?

[azhar2006]

Thank you rpeare
There is no code vba
Combo box based on macro

[rpeare]

yeah, a macro is basically dumbed down vba .

So show the contents of your macro.

Alternately you can create a sample of your database, put in enough junk data to give an idea of what's going on then tell us how to find the form you're having trouble with (if it's not immediately apparent).

Then zip it up and upload it to this site for examination.

[azhar2006]

Thank you rpeare
OK
This is an example of
To see (frmMoney accounts daily)

[rpeare]

Ok, tell me what you are doing to get this error. I have put in dates in the fields labeled DAT and DAT1 and not encountered an error. Or alternately, tell me what you are trying to do with this form. I don't use macros, I prefer VBA which is more flexible but I have not been able to replicate this error.

[azhar2006]

Yes
It runs on a computer and another computer does not work
Is it possible to convert the event to Code VBA ?

[azhar2006]

Hello
Is it helping?

[rpeare]

You are not doing a very good job of describing your problem, for instance you didn't say that this was working on newer machines but not older etc.

Maybe you should just say what you want the behavior of this form to be.

Your embedded macros are just telling your form to go to a specific record not a range of records so you have to 'dat' fields on your form if you want all records between the two dates typed your criteria for the MAIN form would, instead of being TABLE1 would be a select query selecting all records relating to the values in your two dat tables i.e. a criteria of

between [forms]![frmMoney Daily Accounts]![combo13] and [forms]![frmMoney Daily Accounts]![combo15]

Without a very clear description of what you are trying to accomplish when changing the values in the two combo boxes I can't really help.

[azhar2006]

Thank you rpeare
What I want to do is to show the results of a specific date for the work
New macro works
But do I to turn to the phrase (vba)
See this

[rpeare]

Your DAT field is an unbound field. You can simply issue a

me.requery

command IF you base your form on a query that has a criteria of your DAT field like I mentioned in my prior post.

If you are searching for results for a single day you should be able to put

[forms]![frmMoney Daily Accounts]![combo13]

in the criteria of your date field

[azhar2006]

Thanks to the speed of response rpeare
Is it possible to modify the DB