This is my first time creating an Access database. I am currently using Access 2007.
The database is to track billable and unbillable hours, employees, clients, milage and insurances.
My first problem is this:
I have created reports that utilize queries to display data. The queries are ran by supplying parameters into an unbound form and using the following syntax:
Like “*” & [Forms]![BHRB]![BHRBClientName] & “*”
My parameter collection form collects the client name, employee name, and date range of records to be pulled using syntax similar to what I’ve listed above. The report then pulls it’s data from the query fields. PROBLEM: When I open my report, my form loads and asks for my parameters, and when I execute the form, no data is retrieved.
Even if I fill each parameter with data that I know exists, my report ends up blank. How can I get my data to appear on my report? Is there some common error I am overlooking?
My second problem is this:
I am using Access Developer Extensions Package Solution to prepare this database for the end user. I want them to be able to open the database in 2007 runtime, and have my default Data Entry Form appear upon opening. Whenever I package one of Access’s online templates everything goes smoothly. However, when I package my own database, my default form does not load. Nothing loads; only a blank runtime window is displayed.
HELP!!!!! Google can’t seem to find answers to any of this.
