Search results

Oh gemma thanks for the reply. YOu are always saving me here :) About the US date i found it out earlier but thanks a lot for the tip because this is indeed tricky........ my code now look like this: Still getting an error.............i'll make a few tries with the msgbox to see what i can...

ok...the static statement is solved Now ill work on the dynamic I have no clue what is wrong here Can anyone help please? Ive tried adding a msg box to see if the string was being passed and it seems that neither tha table nor the mindate, maxdate are :(

Awesome, the code works fine. I actually think ill make this as a module. Maybe it will be easier. So far I have this code Ill make an array with the table name and maybe 2 strings with the dates. The code doesnt seem to work tho. It doesnt have any error messages but it doesnt open the query...

Hey Guys. I was wondering if any of you know how to make a Query that would get all the tables names. Thanks in advance :)

Im trying this code: But i cannot make it to work because of the objconnection

@grnzbra - The macro works like this: I make an array with the name of the .txt files inside of the folder and if it does not exist as a table in access it creates a nem one. And it also updates the old ones. So far i dont have a ID field because i could not set the date as ID field and some...

@grnzbra - Actually im kinda stuck with the .txt files design. So i have only 2 columns for them (DATE,VALUE) @gemma-the-husky - What im trying to do is to get them all in a main table. I still dont have this main table with all the data unortunatly. What i have so far are many individual tables

its for stocks when a new stock is lanched in the market a new .txt file is created with the data series from it

Hey guys, Ive been enjoying a lot being part of this community. 1st of all i want to thank all the memebers who replyed for my previous doubts. I guess i still have one last one. My database (tables) are being automatically updated by a module. So its not unusuall that i have at least one new...

Ok. I managed to solve the import problem. Aparently i have to copy the linked table and copy as a non linked one. The problem to Make a dynamic SQL statement is still on :(

oh ok...........Because basically now it works perfect the auto update and importing from the text files. Ill try to find out some way out of this to import it into VB, or maybe, even think about another program that could suite me. In case i want to join all the tables i created into one do you...

No, actually what im tring to do follows: I dicided to manage the database at access and make the program in VB.NET. So i tried to import the .mdb file into VB.Net using ADO.NET. IT worked fine, i can see all the tables in my database at VB.NET, but when i try to access an specific table i get...

by the way, is there anyway i can declare in my module code the "Apollo Link Specification1". BEcause im importing the database to vb.NET and i get and error because this is not declared there i guess

Hey gemma-the-husky. THAT WAS JUST PERFECT!!!!!!!!! Damn you are good (^.^) Many thanks again you rock!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! And Thanks for the tipo on the MsgBox...ill use that!!!!!!!!!

Actually i found a bug. The 1st file is not being uploaded. I dont know why. Im confused. It seems that its looping from the 2nd file in the folder until the last one.

Thanks a lot for all the help gemma-the-husky. You really saved me here and i really appreciate all the tips :). It works perfect now. I'll post the final code here in case someone need it in the future :)

aha. It might be the extension then. My files are all .txt Then the table in access are filename_txt instead of .txt That might be the problem. How can i delete the file extension then? I might need to make a new restriction to the FileName then. Because this is the actual name of each table in...

I think i could solve this problem if i create 2 arrays, one for the true and one for the false. And then make the Docmd only for the false. What do you think

Ive tried both of them and for some reasons all the tables that exist already and the ones that dont are both being created again. I dont know why

Im trying this code, but for some reason they are all going to both satements THEN and ELSE. I dont know why