Search results

It would help if could be it with using the code.

how do I ignore commas until the next double quote?

not an option

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...

Thanks I've been looking at so much code I simply blew it.

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...

thanks to everyone who reponded. I'm looking forward to going to Access2007, I'm currently in Access2003 and used Stephen Leban's site and it worked perfectly.

How do i created it without the prompt? I need thiis prompt for PDF file option

Ken When I set it to the PDF to print(saving to PDF) it's asking me for a name for the file. This is not a problem when I'm doing manually, but when i want to give the file a name and save it thru VBA I don't know how to do it. HGMonaro I will give it a shot....Thanks

The problem I'm having is saving the file as PDF. I can save the file manually as PDF because I set up a PDF printer and I can run DoCmd.OpenReport "rpt_078", acViewNormal, to save the report. What I can't seem to do is get a a file name put in there thru VBA and save it. DoCmd.OutputTo...

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

access 2003. I'm able to creat PDF's......it's just trying to automated it I'm having problems

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 think my error is one file I'm bringing in......I will play with the file I will update the file as I bring them in. Thanks

I will be importing the data into the same table all the time. The first time it works, but I get an error once I try importing into the table with 25 columns.

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...

thanks I don't why i didn't use null

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 = ''"