Search results

Okay. Makes sense. It doesn't explain though,why Excel will let you do it. Also, the data is coming from a query which is retrieving multiple records. the majority of results will be positive, but I have no way of knowing before hand if any of the components of the calculation are negative...

Hi, I have a query which returns colums based on calculations. One of those calculations can sometimes result in a return value of #Error (whenI translate it I get Error Number 5). My first question is why I get the error in the first place. The calcualtion works in Excel. Try: Dim a...

Got it. That's great. Thank you for all your help.

That's great thanks. However. How do I connect to one database or the other? Cheers

I need to be able to do it 'On the fly'. For example, allow a user to select whether running remotely or locally. Depending on the answer, link to the correct tables. Thanks

I am writing an application which requires a split database with forms, reports etc in an mde file. That mde links to tables on a server. So far, no problem. I want to be able to take the machine with the MDE off of the network and point to a local set of tables. Can this be done or do I...