Search results

YOOHOOOOOOOOOOOOOO!!!!!!!!!!!!!!!!!1 Buddy you're good. Thanks for what you did! Have a good one, ha!

tried another time to upload I zipped it

yeee. but... still... damn

I uploaded it

It's 10th column Tyred both rs.Fields(10).Value = cumul rs(10).Value = cumul same thing

How do i post the DB?

Did 100 times Swr to got! Just getting creasy.

i did before same thing

OK what i'm trying to do is the only little thing I need to fill up the emty column in a table. It should have cumulative numbers made up of the column next to this one like ------------------------------ ! Lines ! CumuateLines ! ----------------------------- ! 100 ! 100 ! ! 50 ! 150 ! So i...

Can't find anything ueful there.... Sorry

Hi everybody, I use regular connection and recordset. By some reasons I can't change the record in a table. I do: rs.Fields(Field).Value = number rs.Update When run got the message Run-time error '3265' Item cannot be found in collection corresponding to the requested name or ordinal...

WOW That worked Thanks a lot.

Hi, I have a qry like this. DELETE T1.* FROM Table1 AS T1 WHERE Item = (SELECT Item FROM Table2 AS T2 ) WITH OWNERACCESS OPTION; It deletes lines from one table picking items from another table. I copied it from another database where it worked fine. Now i have a message "At most...

Hi everybody, I know how to do that using VBA, but I want to figure out if there is a ready made function for that kind of calc. Ok Lets say I have historical monthly sales for the whole year in 12 columns for each product. I need two things that I can easily do in Excel but not in...

that was fast! thanks

Hi Champions, Here is another challenge. My Access DB generates about 200 separated Excel files using Export. Each of Excel files has 3 tabs. If some data is missing, some tabs might be not generated and sometimes if there is no data for all 3 tabs - then the whole file might be not...

Hi everybody, I've got 250 branches. I need to rate them by sales descending. So I did a query to figure out their sales and sort them. Now I need to give a rating to each branch in this table starting from 1000 down. How to do that? If I put the key on it it's not going to be sorted right. Is...

I tried ClickYesPro. It works fine! Thanks a lot for your support. You are really COACH

Dir works fantastic! Thanks a lot! For the second one i can't see this site by our security reasons. Could you please to make a quote from there? Thanks again.

Hi guys, My VBA in access uses ready made Excel files and sends them out as an attachment to the e-mail to 250 branches according to the e-mail address list which is a table in Access like. BranchName EMail WXP Branch.Manager@Company.ca Each Excel file has Branch name as a file name like...