Chris Green
58-Year-Old ASBO Material
- Local time
- Yesterday, 17:44
- Joined
- May 10, 2008
- Messages
- 8
I've set up a database to record the hours of a small group of co-workers, and so far the results have been impressive, proving to be 100% accurate compared to the legacy nightmare of an Excel arrangement previously in place which was not robust to change without lots of de-snagging.
However, now that we have several records in place, the specter of having to find a specific one has reared its head. My initial input form has drop-downs for month, week number and name, and so I'd like to create something similar to go straight to a specific record with a view to editing it.
So far, I've managed to 'drive' a query drawn from the time-sheet table using similar set of drop down lists on a new form (let's called it 'Find Single Record') which the query then uses as its criteria, but where to next?
I'd really like to mirror the format of the initial input form so that any typos can be amended and re-input to the database.
Or is there a way the the initial input form could perform both functions?
However, now that we have several records in place, the specter of having to find a specific one has reared its head. My initial input form has drop-downs for month, week number and name, and so I'd like to create something similar to go straight to a specific record with a view to editing it.
So far, I've managed to 'drive' a query drawn from the time-sheet table using similar set of drop down lists on a new form (let's called it 'Find Single Record') which the query then uses as its criteria, but where to next?
I'd really like to mirror the format of the initial input form so that any typos can be amended and re-input to the database.
Or is there a way the the initial input form could perform both functions?
