Search results

I’m sure at other company’s vacation could start on any day. But the company I work for vacations always start on Mondays, and there are always a full week. There are other holidays to consider but if I get this problem worked out I’m sure I can figure out the holidays. I will try to restructure...

The six vacation fields represent the week of the vacation the employee has chosen for the coming year. Example: Bill Smith has three week vacation per year and has chosen 4/16/ 02 for his first week 6/12/02 for his second and 10/12 /02 for his third. He selects these weeks at the first of the...

I created a simple database to track employee’s vacations. One table with EmpName, Vacation1, Vacation2, Vacation3, ect. Employees can have up to six week of vacation depending on there time with the company. With over a 100 employees our company will only allow so many employees off per week. I...

I've created an access database that has hidden menu's. I would like to place filter command buttons on my forms (that operate like the ones on the menu bar. However the ones generated by the wizard do not work the same. I've also tried changing the code on the buttons useing the...

It started working. I did a compact and repair database, then it worked! Go figure. Thanks for the help.

Thank for the reply Jack, you are correct, it is currency. Your suggestion was one of my first attempts, but the value in the price text box still did not change. Any Ideas? Gary

I built a form (Access97) with date fields and part number fields. When a part has been replaced in the equipment, I need to track the expense. To simplify data entry I used Dlookup (After Update) to lookup a price from a parts price table. This works great, but my problem is if someone enters a...

Sorry, I should have been more specific. The “Prs” stands for Price. The fields in my table that are relating to price are named, fldPart001Prs, fldPart002Prs, fldPart003Prs, ect. There are approximately 50 fields relating to price. On my form, all of these fields are shown. I have an unbound...

I have a form that has approx. 50 textbox fields that display the prices of parts. All of these field names end in Prs, (Table1Prs – Table50Prs). I would like to have a text box displaying the total of all 50 boxes. I know you can use =[Table1Prs]+[Table2Prs]+ect. this would be very long. Can...