Search results for query: *

Its ok ive found it, thanks for the help xlbo!!

Could you tell me how to protect the sheet? Gazmysta

Hi all! Im trying to hide some columbs in excel that i dont want a client to see but once ive hid the columbs if i then send the spreadsheet wont he just be able to highlight the columbs and unhide them? Is there anyway i can hide them without him being able to unhide them or is there another...

Edit message is already set to no. Gazmysta

Hi, When my macros try to send an email they keep failing overnight because of the bar that tells you access is trying to send a message and you have to press yes. Ive set warning to no but it still asks, is there away to stop this happening? Thanks

Thank you that was very informative, good post!! Gazmysta

Hi all, Could someone please give me a brief description of what an ODBC database is and a DSN? Thank you!

Hi, Im trying to do my first macro, my first query makes a table which i need to change a few properties on (from long integer to decimal on two fields) before the next query updates those fields and then save this field in a certain folder on my hard drive. Is there a way of doing this in a...

Hi, Im trying to use the documenter tool in access, it told me it needed to install so i put the cd in and said yes but while it was installing it gave me the error "Object variable or with block variable not set" Does anybody know how to fix this problem? Thanks

Hi Guys, Im trying to create a query that will tell me the total qty sold and value for every stock code we sell for a particular customer within a particular time period. The data is held in three tables 1. holds the stock details 2. holds all transaction details and 3. holds customer info...

Hi Guys, Im trying to run a macro from my access database but everytime i start it access stops responding? ive ran some other macros in the same database and they are ok its just this one, has anybody got any suggestions for things i can look at for the cause of this? the error message in...

No, its just text.

Im running office XP and he is opening it in office 2000

144 kb

Hi, Im sending a colleague a word document but he says that its taking ages to open on his computer, does anybody know why this might be and any way to resolve it? Thanks

Hi Guys, One of my macros that runs every day is stopping half way through with the error "The microsoft jet database engine could not find the object 'MSysDb'. Make sure the object exists and that you spell its name and the path name correctly." then exits. Can anybody help me with...

Thank you!

Hi, Just wondering if anyone can help? Im tryin to work out the total value of stock we have using a query on a table e.g Quantity Price 62 4.95 12 3.00 43 6.72 How much stock value we have? Thanks