Search results

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...

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...

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...

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...

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...

Re: Double RS Hi Guys I need to find out how to have 2 recordsets as an example: I have a function that needs to get info from 1 table and send it via email to everyone in another table.... Would I have rstContact = db.openrecordset("qryContacts") and another called rstPermits =...

Hi all I'm tearing my hair out on this one, and I know its simple.....but.... I have 2 queries: qryContact = tblContact.contactname & tblContactEmail qryExpiringPermit = tblFleet.Fleet_Num, tblPermits.DateFrom, tblPermits.DateTo, tblPermits.PermitNumber, tblPermitTypes.PermitType Here's a...

Hi All Probably a simple one but for some reason, this takes around 30 seconds to open an email.....not sure why as the information is pretty basic and not like its running very labor intensive queries??? Here's the code I'm using....please dont criticise it just yet...its still a work in...

Hi All I have a form (frmQuote) with a field called txtQuotenum. I'm using this form to export to word which works fine, except when I use this line Set rs = Application.CurrentProject.Connection.Execute("SELECT tblItems.* FROM tblItems where tblitems.quotenum = " & txtQuoteNum) the error I...

Hello All I was wondering how to work around this: I have some fields in a subform. The fields are pulled from a TBL called tblQuoteItems. The fields in question are: Length, Width, Height, Qty I then have a formula which is calculated in the query which works out the cubic weight as such...

Here's one for you.... I have a drop down field that looks up 2 fields: SELECT tblSuburbs.Suburb, tblShires.Shire FROM tblShires INNER JOIN tblSuburbs ON tblShires.ShireID=tblSuburbs.ShireID; So I display field 1 (tblsuburbs.suburb) in the table and want to opulate another field with field 2...

why would this occur??? this is my query: strSQL = "INSERT INTO tblRunItems ( SiteId, RunID )SELECT tblSites.SiteId, " & Me.RunId & " FROM tblSites, tblRuns WHERE tblSites.CollectionZone = '" & Me.RunZone & "' AND tblSites.CollectionDay = '" & Me.RunDay & "'" This results in the same records...

Hi Guys this is a query I'm running, which I think is quite simple....why does it not bring anything across? INSERT INTO tblRunItems ( SiteId, RunId ) SELECT tblsites.siteId, forms.frmRuns.runID FROM tblSites INNER JOIN (tblRuns INNER JOIN tblRunItems ON tblRuns.runID=tblRunItems.RunId) ON...

hi Guys I have a request from a customer to create an form to view images in a table. The idea is this.... a really quick scanner scans 100's of images to a folder. But because they're all different, we dont want to use expensive OCR software....here's the thing: I can view the images if I...

Hello all Got a question that I've never seen done in Access.... I have a DB I'm creating that creates pickup runs....(guy goes out and collects stuff) I'll need to get a subform showing the run items and be able to move them up or down according to the way in which the driver is going to do...

Hi guys I'm kinda an intermediate Access developer.....but am still grasping a few things. And the one question I do have is what is the use of relationships when you can pretty much do everything anyway with queries, SQL statements, etc :confused:

Hi I have a CSV file that is imported that is some info from a scanning application. All is working ok, but it is imported as showing a few little "squares" or blocks at the end of the fields.... I've search all over and its seems to be the TAB ASCII field being imported but how do I remove...

I have a CSV file that is going to be imported into a DB. the CSV file has a field that has a date & time stamp and I need to be able to store this file as 2 seperate fields.... the field would look something like this: 5/10/2006 17:00 I would like to store the datestamp and possibly the...