K
Kevin
Hi All
I have developed an application in Acces 2000 on a Win XP
Pro machine. Now I have a form, and on it I get to choose
dates and variuos other info from combo boxes that are
filled with valid data from a table when the form loads
up. What I do is select the criteria from these combo
boxes and I have a command button that runs queries, and
these queries use the values that I have chosen from the
combo boxes to generate a report.
e.g I choose start date, end date, Driver, and motor
vehicle..Now when I click the "fetch Report" button, the
code behind the button runs a query that lists all the
drivers of a particular vehicle between the start and end
date. The criteria field in the query points to a function
in a module that fetches the chosen data on the form. I
have a report that is based on this query, so by calling
the report, I am essentially calling the query.
Now this is where my problem comes in. In Access 2000 I
can view the report and everything works just fine, but as
soon as I deploy this database to an Access runtime, when
I click "Fetch report" absolultly nothing happens, I don't
see a report, nothing!
Does anybody have any ideas as to why this might happen?
I'm pulling my hair our with this one. It seems the more
and more I use Access runtime, the more crappy I think it
is!
Any help would be greatly appreciated
TIA
Kevin
I have developed an application in Acces 2000 on a Win XP
Pro machine. Now I have a form, and on it I get to choose
dates and variuos other info from combo boxes that are
filled with valid data from a table when the form loads
up. What I do is select the criteria from these combo
boxes and I have a command button that runs queries, and
these queries use the values that I have chosen from the
combo boxes to generate a report.
e.g I choose start date, end date, Driver, and motor
vehicle..Now when I click the "fetch Report" button, the
code behind the button runs a query that lists all the
drivers of a particular vehicle between the start and end
date. The criteria field in the query points to a function
in a module that fetches the chosen data on the form. I
have a report that is based on this query, so by calling
the report, I am essentially calling the query.
Now this is where my problem comes in. In Access 2000 I
can view the report and everything works just fine, but as
soon as I deploy this database to an Access runtime, when
I click "Fetch report" absolultly nothing happens, I don't
see a report, nothing!
Does anybody have any ideas as to why this might happen?
I'm pulling my hair our with this one. It seems the more
and more I use Access runtime, the more crappy I think it
is!
Any help would be greatly appreciated
TIA
Kevin