Recent content by fburges

In case anyone is interested, I've figured out what to do myself. Since the solution caused me so much headache, I thought I'd post it. My original intention was to copy each line of text from each module in the target db into a table in my current db for the purpose of documenting (allow me to...

SmallTime I've encountered that same error. I played with the references and found, as you thought, it is the result of a missing library reference. This is a wierd one. If you convert a 97 db to a 2002 db the error may occur if you have code. Try going to the VBE, select Tools || References and...

I like the code ED2020 used. I'd like to share an idea I once acted on. Several years ago I used DBEngine.CompactDatabase in a standalone db. The only thing the standalone db does is compact other db's. It can compact more db's in a shorter period of time than it takes me just to open one db...

I second what RandyMyers said about macros. The way I see it, there are 3 occasions when macros are fine to use. 1) When you are developing an app and want a quick prototype. In the end though, you plan to convert the macro to code, which is much more robust. 2) The end-user doesn't expect...

Have you tried multiplying your text value by 1 in a query? This simple approach works for me. It causes Access SQL to coerce the text value into a numeric value. Example: numericvalue = [textvalue] x 1. Here is some example SQL for your query: SELECT Mytable.TEXTNUMBER, [TEXTNUMBER]*1 AS...

Hi anyone I'm new to tek-tips, & have a puzzler. With code in a source db in Access 2002 I want to open a target db's Access Modules collection, iterate each module by name, and use the Lines property of the Modules collection to copy the module's code to a table in the source db. Problem is...