Search results for query: *

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

Bill, Thank you for the help. I did a repair reinstal of office and it works as before. On a personal note I am a former, present, and future TEXAN. willybgw

Bill - Thanks for the reply. There are no error messages. This is one of the first databases I ever did (originally built with A97 - now 2000). I seem to remember that Micosoft Photo Editor and some graphics filter had to be installed for this to work, one or both of which was not a default of...

Does anyone know why a form that displays a linked jpg picture that has worked for years would stop working with with no change to the database. I think something has made a change to something in the registry? Any thoughts. willybgw

I am using backup exec 9.1 with server 2003 to backup to an Iomega Rev Autoloader 1000. This has worked fairly well for about 2 years. I just reached the point where my backup is too big for one disk, and the rev drive is not unloading the 1st disk and loading the second. Anyone know how to fix...

When you link the file you should get a dialog box to select a unique record identifier, If you don't I don't think the file is updatable. I just tried this and was able to update an AS400 record. willybgw