Search results

hi Paul that's what I figured too, except they're not bound.... but you made me think, and I noticed my form was bound to that table....for no reason! so I unbound it, and KAPOW! it works thanks mate

Thanks Paul. the controls (combo boxes) are not bound. they do have record sources tho. would this be an issue? when the form loads, the subform runs it's own query to return all results. As the combo boxes are update, VBA code runs to update the subform query. does this make sense? thanks Seb

Hi all I was wondering if you could guide me in the right direction....else, I might tear my hair out! ok, I have a form, with a subform. Based on 2 fields on the subform, I refresh the results in the subform. These fields are: CBOclientYTD: SELECT tblClients.ID, tblClients.Client FROM...

Sorry for the delay in getting back to you. Been on holiday ;) not sure really. I would prefer to do it on the fly.....the times will always be the same. you stop working at 5pm. you start resting at 5pm. your start working at 8am. etc... The query looked good but I would prefer to have it...

Hi Guys I know how to send emails from Access using Outlook. I use Access 2007 with outlook 2007. And it works fine for me....but when I try on a customer's system that is using Outlook 2003 and access 2007, it gives me reference errors. I know i'm using Office 12 but their versions will...

Hi Guys Not sure what I should do here. I would like to have a cell populate with the value of a specific cell previously. explain: in excel, we can use formulas like this: A1: 00:00 B1: 08:30 A2: 08:30 B2: 13:00 A3: 13:00 B3: 15:00 etc, etc Notice that each cell in A is the same as the...

boblarson, it worked!! just added the table twice! thank you

actually join the same table 3 times....Not sure if thats what I need to do or not, but how would you get Destination, Depot & Depart from tblDepots based on ID stored in tblDailyTriplog.depot, tblDailyTriplog.Departing; tblDailyTriplog.Destination?

Hi Guys Not sure if I'm going in the right direction, but am stumped at this one! I have a few tables: tblDailyTripLog ID; TripDate; Departing; ETD; Destination; Depot; Driver tblDepots ID; Name tblDrivers ID; Name Now, in tblDailyTripLog.driver, the tblDriverID is stored. Same goes for...

I know its cheeky, but how would you suggest doing this DB? I've told the client they're gonna have to capture actual times (not sure Total times for the day) Then how would I go through the criteria needed?

Hi Drak I agree SISO!! As for your question about the driver's sleeping.... The period is constantly rolling forward. So its not a matter of how many hours did you sleep/work/rest today but how many hours since your last sleep. If he has 2 sleep periods today (say 1am - 8am & 14pm - 21pm) his...

Thats defenitely along the right lines, but the bloody local government here in Oz are extremely strict on this. It clearly says you cannot work for more than 168 hours for any 14 day period??? So 14 days from today, then 14 days from tomorrow, etc, etc on another note: there's heaps of other...

HI All I have a question that I just cant seem to get my head around....so I thought I'd pick your brains! I have a table that has DriverID, Date, Work, Sleep, Rest. As you can imagine, this records their hours of work, sleep & rest. Now with new fatigue management laws in Oz, we need to...

Neileg. of course I like your advise!!!....I'm just used to scrolling down to the bottom of the page to view the posts, and didnt see yours. I'll give this a try during the weekend, and see how I go Thanks

Hi Guus Sorry for not getting back to you on this one sooner, been on leave. well, this is how it works: TblSubcontractors holds in the subcontractor information (name, address, etc) TblPolicies holds the policy details. (SubcontractorID, PolicyID, expiry, policyissuer, etc) TblPolicyTypes is a...

Hi GUUS2005 This is my SQL SELECT tblSubcontractors.SubbyName, tblPolicyTypes.PolicyType FROM (tblSubcontractors LEFT JOIN tblPolicy ON tblSubcontractors.ID = tblPolicy.SubbyID) LEFT JOIN tblPolicyTypes ON tblPolicy.InsuranceType = tblPolicyTypes.ID ; Obviously, this just shows each...

Hi guys I have a DB for insurance permits. tblSubtractors ID NAME ADDRESS PHONE tblPolicy ID SubbyID POLICYID Insurer PolicyNumber ExpiryDate tblPolicyTypes ID Name Most subcontractors will have a policy number for each type of policy in tblPolicy. But is there a way I can run a query to...

Hi All I've got a problem with my module which I cant fix???? Not sure why its notworking. The queries that I'm using all work, so not sure why? I need this module to go through all the usernames in qryContacts and send an email based on qryExpiringPermits to to each person!! I've attached...

This is the actual DB. The module is called mdlEmail2 please be gentle though as this is a work in progress and not very neat!!!

This is the code I've done so far. I know both queries (qryContacts & qryExpiringPermits) work ok - ie. they both produce results But now when I run the code below it says "No current record" Dim db As DAO.Database Dim rstContact As DAO.Recordset Dim rstPermit As DAO.Recordset Dim strCount...