Search results

There is no real evil, in and of itself. There are, however, errors that render results that do not serve us well. The greatest of errors is idolatry. No, I'm definitely not going all churchy on you. Let me explain. Idolatry is really the condition of mistaking a symbol that stands for...

Wow, such generosity! I hope you had all that in the can somewhere and just pulled it out for me instead of writing it from scratch. Got it. It wasn't wasted. You're the best thing since sliced bread.

Thanks for that. I realize my statement is broadly rhetorical and not the kind of inquiry that would engender a specific response. The real mystery to me is how to reference the public folder inbox (or any Outlook inbox for that matter) and what the code I posted would do. Does it say that it's...

Ultimately, I need to import a range of Excel spreadsheets that are attached to Outlook emails in a shared public folder--all from Access--because I am not (and cannot be) the owner of the account who could run internal Outlook VBA. One thing at a time: first, I need to get hold of these...

Thanks for that. I added the reference before opening the recordset using the same syntax as the sample shows: Set qdfResults = CurrentDb.QueryDefs("BatchOutQ") qdfResults![Forms!BatchesOpenF!Batch] = Forms![BatchesOpenF]![Batch] Set rsResults = qdfResults.OpenRecordset() But now...

Sorry, Here's what I have so far: Private Sub Batch_DblClick(Cancel As Integer) Dim XL As Excel.Application, wbTarget As Workbook Dim qdfResults As QueryDef Dim rsResults As DAO.Recordset Set XL = New Excel.Application Set wbTarget = XL.Workbooks.Open("G:\XE_ECMs\IPP...

I've been trying for days without success to do what should be a simple thing: double click a field in a subform and paste the query results into excel. I already have good code to paste in the recordset, but this recordset must reference a control value in a subform. The query works and shows...

I have a whole bunch of database tables in various databases to backup. Is there a standard or preferred way to do this? My first thought was to create a separate database with linked tables and run make table queries periodically to keep the backups current. Am I on the right track? Does...

What I'm trying to do is to automate an Outlook email response system (using linked folders) that automatically returns to the sender a data comparison check on an attached Excel spreadsheet. The first part that periodically checks the folder table, compares the data from the email body and...

Hi! I've been developing Access for about 15 years, mostly at the power user level, but now my job is asking more from me than my current understanding will immediately allow, so I need help learning to code and understanding the underlying concepts and syntax of VBA. The posts on this forum...