Search results

Well after 2 attempts i realized only zip was allowed, i can't zip due to office PC privelage restrictions. But im resourceful. I used a portable winrar, then it wouldnt let me upload a rar. So i renamed the rar to .zip HA...doh! Too big anyway. so i uploaded a zip to my personal FTP for you...

Ok i renamed the module to AutoUdateQnty The sub (i changed it back) is now named autoupdate i created a function in the same module called getupdate. All it says is Public function getUpdate() Call autoupdate end function Still does the exact same thing, just an hourglass, then nothing...

I can change it back to a sub, but im very new to this i didnt know how to make a macro run a sub. I read online that all i had to do was change "sub" to "public function" and it would run in the macro when called by its function name. Is there an easier way. Can i leave it a sub and simple...

Not sure if this will help but i use excel to autoupdate 4 different excel files that are read only except during updating. If you are having a problem where it sometimes is getting set to read only might try putting in just above the open statement to always make sure the file itself is set to...

Im not sure what happened but this module was written before my time with the company. And it has always run. I created a macro to run the module and a bunch of queries designed to update quantities in the database. For some reason the module has ceased to function. In order to make the module...

Thank you for the response and tips. Your suggestion would have worked except it would have doubled the length of my code. After meeting with my supervisor for a few minutes we came up with condensed code which ill post just to help anyone who ever runs into a similar problem. Essentially i...

No i checked most of them are text.... But what i dont get is even if i use " " with a space, the cell itself is still formatted to number with 2 decimal same as the acecss. Why would a space matter in access eyes as they are still the same data type. And if that is the problem what can i...

i have the fields being populated with scripts as well. If there is no data from the previous sheet, then excel populates "". I also tried " " with a space between to input a space so it wasnt empty, even then i still get a data conversion error. What baffles me is there are other empty...

I am relatively new, ok totally new to access and VBA but i pick up quickly. Im having a problem putting information into access from excel. I basically have a spreadsheet that i have doing various things and formatting data to the way it needs to be to be put into the table. Some of the fields...