Search results

I've finally got around to finalizing the design, creating the forms, and am hoping to put it to use soon. I don't have anything in place for security yet, but I think it's only going to be used by a data entry clerk for now. Later, if they decide to let the employees start using it, I'll go...

I learned a lot about data validation today. Multi-field indexes are very handy for what I'm doing. I still don't know if my design is very good but at least the data isn't getting to far out of whack.

Well, for better or worse, I decided to change things around a little bit. This will keep service companys and places from being duplicated. It got so bad that my countries were even being duplicated in the old design. Here's the new one. It seems to be working ok so far. The new table...

I'm developing a temporary access database to enter services. I'm really hung up on one part - How to enter Service Companies, and Places (place of service). I've already got about 50 records entered into the current database. My Places are already getting duplicated because there are multiple...

It's taken a back seat to some financial reports I've had to design over the past week for an audit, which is just as fun :D I plan on hitting it once I get some more free time, though.

Thanks for the info. I thought you were asking for help with a problem.

JEA, I can't answer your question but it might be in your best interest to start a new thread. While our questions are similiar in nature (at least that they pertain to timesheet design ;)), they are different enough that this thread could get cluttered very quickly. Also, people will be able...

Here's a screenshot of the relationships I've got setup so far. The two tables to the side that start with AR are from the accounting software we use. I might try to put something together later on that will allow someone to click on a ticket number to see the details of the job from the...

Each charge code is a different code that a technician uses while out on a job. Charge codes include Straight Time Work, Straight Time Travel, Overtime work, OT Travel, holiday, sick, vacation. Currently they find the column in the timesheet spreadsheet that they need to clock hours for, go...

Thanks for the reply. I haven't read a whole lot on normalization yet. I'm reading a book called Inside Relational Databases with Examples in Microsoft Access, which is an excellent, easy to read book. It has brought a lot of stuff I knew about into sharper focus. This is my first database...

Rabbie, Thanks for the reply. I feel that I have normalized the data the best I could to this point. The TimesheetDetails table is the child of another table called Timesheet. I have another table for TimesheetChargeCodes, and another for Employees. A couple fields I haven't mentioned are...

Hello all... Nice forum you have here. I'm in the process of developing an Access 2003 Timesheet database. I'm basing it off of an excel spreadsheet the company already uses. This spreadsheet has the charge codes as columns, the date and hours worked as the rows. I'm trying to work out the...