Recent content by R9772

thanks.

i just tried that and unfortunately the file can still be copied. is there a way to disable the copy function via visual basic?

i haven't tried that. just as a little back ground i have a spreadsheet that i want people to only be able to edit certain areas. unfortunately, if they copy and paste the spreadsheet into a new spreadsheet all of my protection passwords are null and void. is there a way around this?

can anyone help me protect a workbook so that it cannot be copied from one place to another and then ammended? Or is this even possible?

Thanks for the heads up!

Thanks!

can someone help me find a way to hide a work sheet in exel...or is this even possible?

i apologize for being unclear. i hope the following is a little better description than i provided earlier. my first table has the following columns cn(customer name), prod(old products) and funding. my second has designs(new products), co(company), funding(new funds allotted) and cst(cost)...

can someone help me create a function in Access that uses if statements to act on tables. for instance (select *,if [my design] = [new product] then [new funding] / 12 into [new column] from products) thanks

thanks, that worked perfectly.

i have an existing table that i want to run calculations off of. my current code looks like this: myStr = "select *, (tDollars * sTax) as nAmt, into nFile from dFile " i would like to be able to open and close this from visual basic

can anyone help me create a query through visual basic code that i can manipulate from visual basic in Access?

i am attempting to import multiple tabs from a single excel file. each tab has a different name and i have over 50 of them. unfortunately,i have been unable to pull them all in without manually importing each one. can anyone help me with this? Thanks.

can anyone help me to create an import specification in Access. i cannot seem to find the advanced tab that is ususally used to create the import specification.

can anyone tell me how to show all of the formulas at once in a workbook(sheet). my goal is to print this information.