Search results

Hello, I'm doing some error trapping at the moment and i was wandering if there was a way to determine the current module/module type/proceedure name etc at runtime. Cheers Ben

Hi, I vaguely remember reading somewhere that you can use ADO to create a "connectionless recordset" in code. I have come across several situations recently where this would be handy but have been unable to get it to work with trial an error or found an example. What I’m basically after is an...

Hi, I've been trying to coax a bit of speed out of some of our applications. At present I do most (95%) of queries like this; mycon.execute(mysql) where mycon is an ADODB connection object and mysql is a sql query stored as a string variable. I do it this way because I find it convenient and...

Hi, We have inheritted a self contained (i.e all data/forms etc are in the same file) mdb based application that is shared by 5-10 users and accessed quite heavily accross the network. Twice recently it has become corrupt and we have had to import all objects to a new mdb in order to fix it. So...

Hi, I’m updating an application that I wrote some time ago. The application frequently uses a dlookup to validate data input by users in the form of a barcode. Now I know dlookup’s are inefficient so I am looking to get rid of them and use a recordset (ADO) instead. So my question is which of...

Hi, I was wondering if anyone could help with the following. It seems fairly simple but i cant work it out. How can I 'catch' a run time error and do my own thing so the user doesn’t get involved, for example I'm using the following code in a report; Which brings up run time error 2501 open...

Hi, I was looking for an answer to the following problem and stumbled here so I thought I might as well dive right in and ask!!! One of the reports in my application is based on a query that gets it's criteria from a vba function, not a problem until I wanted to use the Or operator in the...