K
krzysztof via AccessMonster.com
Good Day!
I have a form that has two date fields that are date/time pickers, a combo
box and a button.
i also have a query that uses serveral tables from an odbc from a pervasive
DB. That query is bound to several reports. keep in mind they all use the
same query.
now on that form, the user chooses the date frame of the query, (the query
criteria is bound to these date/time pickers), and then chooses an option
from the combo box, then then clicks the button.
when the button is clicked, there is a 'select' that is based on the option
selected from the combo box, and then opens the corresponding report.
However, when i run the report from the form, i get a msg box that states
"ODBC - Call Failed" - and that's it.
Now, if i run the query, without the form open, i have to manually enter the
dates, but it works fine. if i run the query with the form open (the query
is looking at the form for the dates to do a criteria), i get the same ODBC
error. the same goes for the reports as well.
This used to work, but i have done so much with it, i cannot remember what i
did to screw it up.
Any ideas?
I REALLY appreciate any help!!!!!
I have a form that has two date fields that are date/time pickers, a combo
box and a button.
i also have a query that uses serveral tables from an odbc from a pervasive
DB. That query is bound to several reports. keep in mind they all use the
same query.
now on that form, the user chooses the date frame of the query, (the query
criteria is bound to these date/time pickers), and then chooses an option
from the combo box, then then clicks the button.
when the button is clicked, there is a 'select' that is based on the option
selected from the combo box, and then opens the corresponding report.
However, when i run the report from the form, i get a msg box that states
"ODBC - Call Failed" - and that's it.
Now, if i run the query, without the form open, i have to manually enter the
dates, but it works fine. if i run the query with the form open (the query
is looking at the form for the dates to do a criteria), i get the same ODBC
error. the same goes for the reports as well.
This used to work, but i have done so much with it, i cannot remember what i
did to screw it up.
Any ideas?
I REALLY appreciate any help!!!!!