I am trying to append multiple text files into one text file. The only catch is...we don't know the name of each text file. They are located in tht same folder...just have unique names. Currently we are importing one text file at a time...and would like to append the files to save time. The...
The database is updated on a daily basis...sometimes several times. I'm pulling in a text file into Access 7.0... through VB6...then printing the reports in CR8 through VB as well.
Yes. The database has changed as far as the data...but the layout has not. In testing, we have imported from...
I am using VB6, Access 7 and CR8. My program used to work...until yesterday.
The end user tried to run this program...and it gave them an "automation error". When I walk it through step by step...I get a MS Visual Basic window with:
"Run-time error '-2147417848 (80010108)' --...
I am using VB6, Access 7 and CR8. My program used to work...until yesterday.
The end user tried to run this program...and it gave them an "automation error". When I walk it through step by step...I get a MS Visual Basic window with:
"Run-time error '-2147417848 (80010108)' --...
Using Access '95, I have created a very simple database that has only 1 field. I am trying to import a text file into this database. One line of the text file equals one record in my database. I have written the code behind a form's button in VB6...and it works... sometimes. I may have to...
I ended up creating one report to print to printer... and another report where the fields are moved around for the print file. I just moved lines around until they looked right in the print file. The print file report isn't pleasing to the eye, until it's sent to a print file. Works fine...
Ken,
It isn't wrapping...at least that I can see... and everything on this page is one record in the database tables. I couldn't see a true pattern either. Looks like it prints 5 lines with spacing in between, then two lines together... prints 6 lines with spacing, then two lines together.
Hi!
I am using VB 6, Access 97 and Crystal 8.
I have a "Crystal Reports Control" on my VB form...and I've set it's properties to "print to file". When executed, the Crystal Report is saved in the the Word document...but the Word file has blank lines in the report...
Thru VB I clear out a database then import a text file in Access '97... here's the import:
Private Sub cmdImport
Set FSYS = CreateObject("Scripting.FileSystemObject")
Set F = FSYS.GetFile(FileLoc + "textfile.txt")
Set TStream = F.OpenAsTextStream...
Thru VB I clear out a database then import a text file in Access '97... here's the import:
Private Sub cmdImport
Set FSYS = CreateObject("Scripting.FileSystemObject")
Set F = FSYS.GetFile(FileLoc + "textfile.txt")
Set TStream = F.OpenAsTextStream...
Is there a limit to the number of fields on a report in Crystal Reports 8.0?
I have about 1000 fields I need to place on one page of a Crystal Report. I can pull up the report in design... but cannot add another field, delete fields or preview the report. It was working fine up until about...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.