Search results

The regional settings never change because it is on a server. Any other suggestions? Thank you, Jennifer

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

Thank you so much Jack, it worked. Jen

Hi There, I would use an option box and set the default to none 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...

Thank you, Forcing the query parameters worked Jen

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

Hi There, I have a report that says #error because there is no data for it yet. How do I get rid of that? Jen

Hi there, I was wondering how to use the wildcard to search for dates in a query. I have tried many ways, but nothing works. I need to search on all the 2001 dates and my format is 1/1/2001. I have tried #/#/2001 but it didn't work. Any help is great. Thanks, Jen

Hi There, I have two crosstab queries that I have created. The first crosstab query works great, but the second crosstab query keeps duplicating records? Any Suggestions? Thanks, Jen

Good Day, I was wondering if anyone could tell me if there is anyway to have two columns in a crosstab queries? I have two fields from two tables that need to be in columns in the query, but it doesn't allow me to do that. If I make two crosstab queries and make another query so I have those...

Hi There, I have a form for employees to enter their vacation time in. I have two list boxes and one text box. The first list box 0, you pick your crew, then automacatically in List box 2, the employees names come up, then you enter your vacation time. Then it is suppose to save the record...