Recent content by Squizzla
-
S
Adding Attachments to Outlook - Runtime Error '13' Type Mismatch
Excellent in-the-dark shooting - it sorted it perfectly. Thanks! Any idea why that might have been the case?- Squizzla
- Post #3
- Forum: Modules & VBA
-
S
Adding Attachments to Outlook - Runtime Error '13' Type Mismatch
Hello everyone, I'm having a bit of bother with a Access VBA function that attaches files to an email and sends them to a specified list of addresses. Here is the function: Function SendEmail() As Boolean Dim olApp As Outlook.Application Dim olMailItemObject As Outlook.MailItem Dim...- Squizzla
- Thread
- Replies: 3
- Forum: Modules & VBA
-
S
Using Access Recordset as SQL Variable
Boom! Jackpot! It needed on little tweak as follows: Site = "'" & RsSites!SiteID & "'" rsSites.movenext Do while not rssites.eof Site = Site & ",'" & RsSites!SiteID & "'" rssites.movenext loop But it now appears to be working perfectly. Amazing - thanks!- Squizzla
- Post #5
- Forum: Modules & VBA
-
S
Using Access Recordset as SQL Variable
1) OK, thanks - I'll start doing that from now on 2) They have to be strings to work against the Oracle database - I've tried passing actual dates to it before, and that failed 4) The SiteID is a 13-digit number stored as text, so again it needs to be a string. So are you suggesting that...- Squizzla
- Post #3
- Forum: Modules & VBA
-
S
Using Access Recordset as SQL Variable
Hello all. This is my first ever post on an Access forum, so please be gentle (and feel free to move this is I’ve put it in the wrong place). I am currently building (despite my limited previous Access experience) a customer reporting database. I’m having issues with one VBA macro which no...- Squizzla
- Thread
- Replies: 5
- Forum: Modules & VBA