Search results

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 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

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...

Hi There, I have created a database that keeps track of employees time cards. I need help on writing code to make a field that has a default number in it to 0. For example, if an employee enters a number into field 2, field 1 will go from 12 to 0. Can anyone help? Thanks, Jen

I have a problem with writing code for multiple selections of check boxes to produce a single report. For example, the person selects sick, vacation, holiday, I want to produce a report to show all of the options selected with the times. There are 15 options to choose from. Someone told me my...

I have a form and a sub form and I need to write an If Statement in the subform. If someone chooses an item from a drop down list say "field 1", I need to force the user to input data into one other field say "field 2". How is this done? Thank you for your help

I have created a database and one of the forms is a time sheet form that keeps track of employees time. I need to write code to stop employees from entering time in twice on the same day. For example, John enters time for todays date, then forgets that he entered the time in and enters it in...