Search results

I am having a serious issue with some of my VBA code in my Access front end. It links to a SQL database. Here is my code: Private Sub New_Record_Click() Dim MySerial As String Dim rsCriteria As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim Feedback Set db =...

Hello. I am working with an Oracle database which I have linked to in access using the ODBC drivers. I have an excel sheet which is currently working to dump the data needed. Here is the critical part of the code in the excel sheet that I have: With ActiveSheet.ListObjects.Add(SourceType:=0...

My database was working fine until I split the database and now I'm having issues with this function: Public Function OpenFirstAttachmentAsTempFile(ByRef rstCurrent As DAO.Recordset, ByVal strFieldName As String) As String Dim rstChild As DAO.Recordset2 Dim fldAttach As DAO.Field2...

Multiple Selection List - Comma Separated String - Run Query & Create Report I've been battling this for a couple days now and I'm stumped/overwhelmed. My SQL experience isn't great. I've been doing a lot of VBA programming though. I'm using Access 2007. So far I have a Multi Select enabled...