Recent content by willybgw

lameid - thanks again for the help. This works to get the query information from FIND_MDB_OBJECT.MDB. The problem with that is I want the query information from the 491 records in table MDBLIST. willybgw

Could someone please explain what should go after the IN. This is from dhookom's post in linked thread. SELECT * FROM MsysObjects IN 'YourMDBFileNameWithPathHere'; folder: C:\MY DOCUMENTS database name is: FIND_MDB_OBJECT.MDB table name is: MDBLIST field name with path is: MDB_PATH Thanks...

Lameid - Thanks for the response. I am out of town until Monday and will check out your suggestions then. willybgw

I would like to have a database of all queries in all databases with the database path, query name, and last change date. The thread below is what I am trying to accomplish I think. I have created a table with all (491) database paths, but I don't know what to do from there. As always all help...

Thanks for the suggestions and examples. But I really just wanted to know if there was any way to highlight and copy non-contiguous items from a given column. willybgw

The purpose is to allow the user to select account numbers of properties (from a select query of like properties) to use as comparibles (5) to a subject property. These selected acct nos. are then used as input to pull all fields necessary for the comparison calculations. These numbers can be...

Thanks for the reply. When I hold down the ctrl key it doesn't select the record. I am using access 2000. willybgw

You can select contiguous values from a table or query by clicking in a column, holding the shift key, then clicking in the same column (either up or down) - then you can right click and copy. Is there a key or combination of keys that will let you chose non-contiguous items? Thanks for your...

I figured this out. It was a problem with ms photo editor. I did an add/remove on office and discovered that photo editor had not been installed with office, so even though the program was on the computer it wasn't in the folder that access wanted it to be. willybgw

My old computer died. I got a spare one (xp) to use until my new one arrives. I installed office 2000 premium and now an access database that displays images (has worked for years) now doesn't display the image. I changed the file association for jpg to microsoft photo editor - no help. I know...

Try start, run, cmd. 1.At prompt type NET STOP SPOOLER 2. Go to c:\windows\system32\spool\printers and delete all files. 3. Go back to cmd prompt and type NET START SPOOLER. This should clear the problem computer. willybgw

The following function which uses Greg's excellent pattern finder will do what you want. Function FindAndCapture(INFIELD As String) As String Dim X As Integer Dim CNT As Integer Dim TARGET As String CNT = Len(INFIELD) - 6 X = 0 START: If X < CNT Then X = X + 1...

Does anyone know anything about office 2003 lite. Like where does it come from? Is it legal? I installed it on a test machine and it seems to work great. willybgw

Use the unmatched query wizard.

Check out logmein.com. I use it to access my home computer from work, or any other computer with an internet connection. I use real vnc to get to my work computer from home. Logmein is much better. willybgw