Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Running a query on startup and displaying msgbox
hi. I've got a table in my db which is called ProjectBookings. The table holds details of different projects booked for this company, with the following main fields: ProjectID BookingReceived ClientID InvoiceSubmitBy InvoicedYesNo there are other fields but these are the main ones. The way...- djjay
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with negative time calculation
I'm developing a system which is used for calculation of employees hours worked and rates of pay. I currently have a query which is calculating the hours worked between a [StartTime] and [EndTime] primarily using the DateDiff function. This works great most of the time however on some...- djjay
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
-
Limiting number of records in a subform
Hi. I have a main form in by system [Projects] with a subform which is used to allocate employees to each particular record. On the main bookings form there is a field which states the number of employees required for that project (this is always stated in advance). I now want to know if it's...- djjay
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
