Search results for query: *

Ok sounds like this has been around a little while so i'm going to put my 2 cents in. I had to do something similar to this and what I ended up doing is to add the excel object to the routine and then a few lines to format the columns as needed then delete the query def as in your example before...

the two different "names" refer if i'm not mistaken to the "text name" on the tab.. and the Index name/number workbooks("textname") and workbooks(1) for sheet1 textname(sheet1) as for the rest.. haven't done to much with dyamic coding.. but i'll give it a try if no one else has an answer

I have a database one table 50 fields, 3 groups of users, admin wholesale and retail. each access the table through a form populated by a query. all 3 forms have record locks set to edited record. no one in any of the groups will edit the same record (records are assigned to the users) so no 2...