Search results

OK, thanks heaps! i'll give that a shot and let you know what happens. Yes I've used CDO so I don't encounter the security warnings. I've just checked the report filtering based on 2 tests records in the query. You were right, even though 2 PDF's are created with 2 unique OrderID's, the content...

Apologies for my the delay in my response, I've been unwell for the past couple of days. zzqryTrialBatchInvoiceScreen2SUM2 is a query & my report does in fact open filtered (it's filtered by OrderID) DoCmd.OutputTo acOutputReport, strRptName, acFormatPDF, "C:\TempInvoicePDF\" & ![OrderID] &...

Yes of course! Here is the code that I have adapted from the initial example in this post: Private Sub MakeReportSendEmail_Click() Dim MyDB As DAO.Database Dim MyRS As DAO.Recordset Dim strSQL As String Dim strRptName As String Dim count As Integer Dim strFilter As String Dim imsg As Object...

Ahh yes, stupid me!! Thanks heaps for that. I can only make this work for the very first record on my form. It doesn't loop through all of my records, I'm unsure as to why this would be.

OK, thank you pbaldy. I've fixed the SQL now, that makes sense to me. However I'm a little confused with this line of code from the previous example: DoCmd.OpenReport strRptName, acViewPreview, , "[VARBOrder].Invoice_ID='" & ![Invoice_ID] & "'" I'm unsure what [VARDOrder].Invoice_ID is...

Hi, I've tried using something similar to this but with a Ms Access 2013 Frontend and SQL Server 2008 backend. I receive the following error: Runtime Error 3061 Too few parameters. Expected 1 The code breaks on: Set MyRS = MyDB.OpenRecordset(strSQL, dbOpenForwardOnly) Is there something...

I can't get it to work for me like that, I don't know why. Thanks anyway for your response. I've got to work this way: Create a Module: Option Compare Database Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, _ ByVal lpOperation As String, ByVal...

Hi all, In previous versions of Access (i.e 2003 and prior) I could use the following code in the On Click event of a form's command button to open an external file: Dim stAppName As String stAppName = "C:\Program Files\Cadro\TransPost Plus\TransPostPlus.exe" Call Shell(stAppName, 1)...

Hi Mark, yes that makes perfect & total sense to me!!! Thanks heaps, works perfectly! Cheers!

OK, i could probably approach this a different way. Does anyone know of way I could augment this OnLoad code to work as a VBA Module and then call it by placing ColorChangeJW in the OnLoad event of each form in my application? Function ColorChangeJW() Dim tb As Control If fOSUserName() =...

Hi all, I have a new staff member in my office that has informed me that she has a degree of dyslexia. To assist her I've trialled changing the textboxes on one form in my Access 2013 application to a light pink color & this has instantly helped her to read/input text. Is there a way to...

Just to close off this post, I've re-created the queries that generate the Dlookups & all is working now. (Strange why I'd have to do this in the first place though!)

I've checked all of the references. I also created a new fresh blank database in Access 2013 format and imported all components, all to no avail. I'm stumped, don't know what to do.

OK thanks, i'll try that now and post my result.

Hi Dave, Thank you, I gave that a shot however I'm still receiving the same error. I'm perplexed as to why this is happening. I've checked on another workstation in my office that is still running Access 2003 and I'm not receiving this error.

Hi everyone, I've just upgraded to Access 2013 (after using Access 2003->2007->2010 over an 11 year period) and I'm having a infuriating time trying to figure out why my continuous subform field is now displaying #ERROR in Access 2013 (after working successfully in all previous Access...

Hey pbaldy, I've solved it! I decided to recreate my report. My original report had a macro on the OnOpen event which triggered a Start/End Date filter. I removed the macro & coded the filter into the query instead, that fixed it. It all works!! Thank you for the brilliant code from your site!! :)

I can't post it, it's pretty large & it's connected to SQL Server backend. It's driving me banana's trying to get this to work!!

Hi Pbaldy, I was having some syntax error issues (crossing over from Access 2003 to Access 2010) with my multi select listbox. I tried using your code from your Baldyweb site, it helped to eliminate the syntax error, however I cannot get your code to filter my report, instead it shows all...

Thank you MLUCKHAM, I've taken you what you have said on board and try to simplify the nested query. Thanks heaps!!