Search results

I'm using the below code to import records from a CSV file. I'm running into problems when I run into double quotes with a comma in the field. This extra comma is causing another field to be created. Dim F As Long, sLine As String, A(0 To 4) As String Dim db As Database, rs As...

I've used the code below to import a text file(with header record) into Access, but I don't know how to take the header of my file when I bring the file. It's a small part but I'm not sure how to get it done. Thanks Dim F As Long, sLine As String, A(0 To 4) As String Dim db As...

I would like to print and save reports to txt file using part of the report name and timestamp using VBA. We open many reports and need them saved and printed and it takes hours to do. I would like to automate it thanks

We have many reports we manually save to PDF files and then print. This can take hours just saving to PDF and printing. Once a report opens we touch our PDF icon on our tool bar(I believe this was downloaded). Then it saves to PDF as if it was printing( i guess this is the norm since we have...

I'm trying to import a txt file with 24 columns into a table with 25 columns. Then I would like to update the one empty column with a string 3 characters long. I will be importing 5 different files into this table and I will need to update that blank column with 5 different 3 character...

Modifying the empty string does not work for me. My 1st string works perfect.......What am I doing wrong with the 2nd string? str_SQL = "Update tbl_078 Set Program_Type ='Both' where Program_Type = 'tttt'" str_SQL1 = "Update tbl_078 Set Program_Type ='Both' where Program_Type = ''"