Search results

In the pass through query the ODBC Connect Str property needs to be set like below ODBC;DSN=MyDSN;UID=MyUserID;PWD=MyPassword;

Not sure if this is possible by using a Macro. It can easily be done by using a VBA procedure. Sub ExportExcel() ' "Range" is a named Range defined in a worksheet of the Excel workbook DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Table", "File", True, "Range" End Sub

How is the RFID data being passed to the PC? I.E. like a barcode scanner (keyboard emulation)? If yes, then the RFID data should be scanned into a textbox on a form.

EDIT: Sorry bad info in my original reply. If using VBA you do not need to make a reference to use CDO. If using VB6 or VB .NET you will need to refer to Microsoft CDO for Windows 2000 Library On Windows 7 this is C:\Windows\SysWOW64\cdosys.dll

Take a look at the attached db and code and let me know if this works ok. Function LoadExpenditures() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strTable1 As String Dim strTable2 As String Dim intExpNo As Integer Dim strExpNo As String Dim strItem As String Dim lngExpYear, lngLifeExp...

Hi Clifton. I think one thing you may need to do in the Excel files is to define a named range for the rows and columns you will be importing data from. The named range can then be used to import data from Excel to Access see sample code below for importing data from a spreadsheet Sub...

Thanks Aleni - looking forward to it!

My name is Andy and I'm a new member here - I've been a frequent visitor to this and a few other Access sites for over 10 years. I work as an engineer in Tennessee and have used Access to help me analyze data and for reports. More recently I have been using Access to automate time consuming...