Search results for query: *

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...

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...

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...

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

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...

I am getting undefined function error when trying to use InStrRev in Access 2000. Shouldn't this function be available? willybgw

I am trying to select records from two tables where it is not likely there will be an exact match. The data from sales will be 1401 ELM STREET, from pifile it will be 1401 ELM. Sales has 3,000 records, pifile has 58,000 records. The following query works fine, but takes about 20 minutes to...

I need to concatenate several fields (all text) with a total length of 94 bytes to a single field of 94 bytes. The output field needs to be spaced correctly, for example if the first of the concatenated fields is 20 bytes but only has 10 characters I want the second field to start in position...

My company has recently acquired 9 Fujitsu pen tablets with docking stations. When an access 2000 database (runtime) is opened on any of them it functions normally until closed. If the user then tries to reopen the same database, or another database a .ldb file appears but the database doesen't...

Last week I began getting a message on bootup that my hard disk was failing press F1 to continue. After pressing F1 the computer finished booting and functioned normally. I scheduled chkdsk with fixes checked and rebooted. When chkdsk started it displayed the message "cannot open volume for...

I am trying to import a picture into an excel 2000 spreadsheet based on the value in cell A1. The folling code gives me a #VALUE! error. Cell B12 has =MYPIC() in it. Any suggestions? Function MYPIC() As Object Dim myXl As Object Dim PATH As String Dim FILE As String Set FILE =...

I have an Access 2000 database with a query where the table is not visable in design view. The query works but I would really like to get the table back. If I add the table access appends a 1 (table_1) to the name and the query doesn't work. Any suggestions?