Thanks a lot PHV
it works great
Can you tell, where does this files is saved, i was not able to find it in any folder. I am thinking it is internally saved, but what if someone needs to use the form/program remotely, will that person have any problems if the file is not local?
yeap,
no auto updates, only search and replace, make sure you replace exactly what you need.
e.g.
you need to replace a variable Myid for MyPK but then you have calls for subs Myid_routine, then all Myid's will be replaced including the ones not desired.
Hello everyone
I am dealing with something apparently simple. Hopefully it is.I'm using ms access 2003
I am trying to import a csv file with the statement below:
DoCmd.TransferText acImportDelim, , "myacctable", _
Application.CurrentProject.Path & "\myfile.csv", 1
but i am getting a...
Thanks a lot dhookom, i appreaciate your help
your suggestion works quit well
although this is just an example and i have lots of analytes(ABOUT 40 on each table) in about 6 tables that i need to join and that may make to run the query slow.
I have come up with this idea and it also gives the...
Hello everyone, I need to create a query(ies) that allow to display all Subjects and Tubes with all the Analytes, notice that TABLE1 has Analytes1,2,3 and TABLE2 has Analytes4,5. Subj 1A has all 5 Analytes, a Subject could be in table 1 but not in table 2 or viceversa, or could be in both. The...
I forgot to add that, the csv files comes out automatically from a medical machine with this long column names. so i need to create a vba process to read the csv files and then rename the columns to a shorter name, for several files a day and each file hold around 300 cols.
Thanks a lot
Hi all
I need to open a csv file using vba and just rename the columns for a file that holds around 300 columns. I know that msaccess can handle only 255 columns. The questions is "does anyone know if handling 300 columns can be done in access without opening the csv file in a table just...
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.