Hi There,
I have a form that people use to edit information. The problem is that it is using tomorrows date, not todays date. I have checked and can't find anything wrong.
Any idea's
Thanks,
Jen
Hi Jack,
I have 12 different queries and reports from sick, vacation, loss time, ect. In the queries, I have a parameter that filters out the crew and views the report with that crew.
Does this help, is what I want to do possible?
Jen
Hi David,
I appreciate you trying to help me. The people that are using this database work at a power plant. The people work 12 hour shifts, and there is 4 crews to A-B to cover a day. The supervisors want to be able to pick either 1 crew and veiw the reports on just that crew, or pick all...
Hi David,
Each report has different data in it. For example, the sick report has all their sick time. The vacation report has all their vacation time in it. I had to do separate reports for all the options because the supervisors wanted to be able to choose what data they wanted to view.
Thank you for your help, but a case select won't work. I will explain my form a bit clearer.
it has 1 list box, Crew A - D. Then I have 10 check boxes Sick - Vacation. it has a preview button.
you pick the crew, then you pick the reports sick, vaction, Banked time ect. that you wish to...
Hi There,
I have a form that has a list box that has the following choices: Crew A, Crew B, Crew C, and Crew D. You pick which crew you want and then choose a report you wish to view. The data is that of the crew. The form is linked to a query that has a parameter to filter the crew picked...
Hi There,
I was wondering if anyone could help me. I have a combo boxes that has four choices to choose from: A,B,C and D. you click on one and the report for that choice would come up. Now I need to be able to choose All and have the report come up with all the data for A,B,C and D.
Any...
Hi there,
I have three crosstab queries that I put together in a select query. I have a date field and I want to be able to pick between dates. I get the following error:
The Microsoft Jet database engine does not recognize [Form] as a valid field name or expression.
I am using Between...
Hi There,
I was wondering if anyone knows how to have reports open to fit to page. I don't want to have to use the scroll bars to view the page.
Thank you
Jen
Hi There,
I have three crosstab queries that display different information for time sheets. The problem that I have is when I put the three queries together, it makes 5 or more duplicate copies of all the records. One of the fields is a date field that I need to pick dates from. I have made...
Hi There,
I was wonder if anyone knows how to setup a database to automatically compact? I would like it to compact automatically once a week if possible