Search results

Cool! That works too! You guys are the best!

Chergh you won! That works fine. Thanks a lot!

How to count records in the recordset? I tried rc = rs.RecordCount but it returns -1 all the time Thanks

Re: VBA and table design ok i got the concept. so the suggestion is to append all my weekly data to one table but add one column having a date of each download. then every week i should calculate how old is each record in weeks and put that an additional column having values 1, 2, 3 ... then i...

Sure i don't want to But i have 2 more million lines every week. By 52 weeks it will be 104 million records. i can't handle them everytime i run my queries. I have the best PC in a company but it's just getting red

When i change the disign manually in access disign view does it actually usues ADOX or DDL?

Re: VBA and table design ok spreadsheet does not work for me. I have 2 milion lines. how do you guys keep rolling historical data?

VBA and table design Hi, I just need a general idea how to manage table design with VBA modual in Access. I want to be able to add columns, rename columns or delete columns of some table in Access using some automated procedure. Basically i need to keep historical data and idea is to drop...

a) no it is not computable - just a set up. b) The array idea attracts me a lot. I just don't know how to do that. Can you give me a reference to read up?

i think it's possible to do it without VBA. Just make (or use existing) MakeTable Query pulling the data the way you need. It will kill the old table and make a new one with the same name. Than make the macro like SetWarnings - No OpenQuery - queryname MsgBox - Data updated Than make the...

O yee! I drive some inventory in Canada :) But can somebody help?

Neeee.... this table has about 2 mil lines and about 200 columns. That will work forever and Access will not be able to handle 2 tables like that at the same time just because of 2GB limit. And I have no chance to get SQL Server (predicting possible advices)

Hi Guys, We get data daily from outside database that has duplications. Sometimes I have the same line 3 or 4 times, but all the data is identical in all fields. I did the query that shows me those dups. SELECT Allinv.Fake FROM Allinv WHERE Allinv.Fake In (SELECT T1.Fake FROM Allinv As T1...

you opened my eyes. I read on those alias http://www.1keydata.com/sql/sqlalias.html I think i'll be OK soon Thanks a lot

Sorry 60 is on the list.

Hi, Nice to see you again. You do so many things with this T1 as usual! Where i should read up to understand better how it works?

Hi everybody, I just need the main idea what to do in this situation. Let's say we have predetermined numbers that we should roundup our purchases. Example list: 1 2 3 4 5 6 10 12 15 20 25 30 40 50 60 80 100 120 150 200 and so on up to 1000000 so if my calculation sais i have to buy 55...

it would be fine if i could use csv. i can't because the upload program is been done based on prn. we can't change this program, we only can trick it. in notepad txt having determined widthes and prn look same, but actually files have different structure. it looks like there is no answer...

well i did that, but the structure of txt file is different from prn. it's not visible in notepad. so renaimed txt file does not work for the upload we need.

is it possible to append to the existing prn file from Excel?