Everything you said is right...I completed all projects and even completed this one two different times but it wasn't what he wanted. As for posting....I just needed the help so bad and thought that if I posted in two different forums I would have a better chance for a response. I thank you for...
I just want to say thank you ...you have helped me lots of times with my codes....I got noone else to respond except you...THANKS!!! Thumbs up to you hun!!!
Thank you very much for your help...I have it working now!
All I did was take out the word TRUE in this line of code:
Set dbsProjectcsv = wrkJet.OpenDatabase("C:\Projectcsv.mdb", True)
You have helped me before so I still vote for you...A big thumbs up!!
Tammy, Indiana
I am trying to populate the current database with this code I have...I get the error that the database is already open. It is open in code form not table form....I need to populate it with the records of my .csv file. It worked yesterday but not today....why?
Here is my code:
Option Compare...
There isn't an .ldb file. Can you do this code within the database your currently working in? I have the database open and working within the module section of this database. Do I still have to use the line
Set dbsProjectcsv = wrkJet.OpenDatabase("C:\Projectcsv.mdb", True)? If I don't...
I am trying to populate the current database with this code I have...I get the error that the database is already open. It is open in code form not table form....I need to populate it with the records of my .csv file. It worked yesterday but not today....why?
Here is my code:
Option Compare...
Here ya go...just replace with your file name
DoCmd.TransferText acExportDelim, "Standard Output", _
"External Report", "C:\Txtfiles\April.doc"
(If you need more help here is a copy of the info from the help file:
The TransferText method carries out the...
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.