Search results for query: *

I am trying to write over 20 IIF statments in one query, but Access tells me that the statement is too long. Is there a function that can be used instead of IIF that has no limit to the coding that can be entered. I have also tried the SWITCH Function and come up with the same problem. Thanks

Hows it. I was wondering if it was possible to write script that would automatically send a print job to an LPT port. Cheers Guys/Ladies

Please ignore..Found a result

Is there anyway you can copy a worksheet to a New Book , keeping all formats and values without copying the links across. I using a marco for the copy ,and don't want to use Paste Special.

Thanks Mate

Change event

The problem I have with that is, that the Database query will be run many times during a day, with different parameters being entered by the users. I need to protect the worksheet once and not have to worry about it again.

I have created a pricing grid, and are using a database query to populate the grid. I want users to not be able to touch this query. But everytime I protect the worksheet the query will not run.. Is there anything I can do. I have tried everything

I have this major problem with my laptop, and I have tried everything expect reimagining(which I really don't want to do). The problem seems to be effecting my INTERNET EXPLORER. Explorer opens and I am able to browes for at least 3-4 pages, before the whole page freezes and I cannot open...

IGNORE ALL..SOrry...

I have this major problem with my laptop, and I have tried everything expect reimagining(which I really don't want to do). The problem seems to be effecting my INTERNET EXPLORER. Explorer opens and I am able to browes for at least 3-4 pages, before the whole page freezes and I cannot open...

All good fellows..SOrry I left this open for so long..The problem has now been resloved..Thanks for your input

AFter trying numberous times to install a blackberry , the OS (XP)is still telling me that the USB device is Not Recognized .. I have installed many blackberries before and never seen this before. I'm using version 3.6 install, but believe it has nothing to do with the software and believe it...

Questioned - Every morning one of our laptop users seems to accumulate viruses from the past day. Even though we have permanently deleted them the previous day. It seems that a system restore is happening every morning as a new Restore folder is created in the System volume, and these are were...