Search results

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

yeah.....Mayb I'm not explaining properly? I think I'll post another thread and start on another note..... thanks for your help guys

Hi Chergh I know its probably not right...but changing it to Movefirst still doesnt work. All it does is pops up saying "No Current Record." I think I'm confused as to how to handle 2 different recordsets in a query

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

never mind Thanks all, but I found a different way to d owhat I wanted thanks

Hi Pete Its defenitely numeric only....but I did try that anyway....and no luck!!

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

Roy. you're a star. So simple, but I couldnt see it!

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

I did name it txtsuburb....I've gotten into the nasty habit of leaving the fieldnames that Access creates.....stupid & lazy...I know:D Once again, thanks for your help

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

Even when frmRun.runZone = "" (so its blank) and there are matching records in tblSites (where the zone is blank) should this not pick it up? not quite sure, but I think I'll just put some error handling into it forcing them to enter some info.... Thanks again guys

Thanks....did what you said and it worked....except when the tblsites has blanks is it: this is what I have thus far: INSERT INTO tblRunItems ( SiteId, SharedSite, RunId ) SELECT tblSites.SiteId, tblSites.SharedSite, tblRuns.runID FROM tblRuns INNER JOIN tblSites ON (tblRuns.RunZone =...

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

Thanks for that....but thats what I wanted to do.... the form creates a new run and issues a new run number (autonumber field) then I need to run the append query that will put the runId & tblSites.siteID into the tblRunItems table.... do you get what I'm trying to do?? The query needs to run...

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

Lightray, I was thinking the same thing.....but then MSTCYR did it exactly the way I wanted it. MSTCYR you're a legend! Could you kinda explain the logic behind it though? I've never seen the rs.bookmark thing before but its exactly what I was thinking

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