Search results

I have two subforms. They are in nice neat grids as access setup for me. Both of these forms should have similar data, based on a upc. What I need to do is turn the text of an entire row to red when there is no matching upc in the other subform. The two problems I cannot figure out is as...

I am using Access 2003. I have three databases on three different servers. I have a program that query's each of these databases. Each query takes between 3 and 4 minutes. Right now my program takes between 10 and 12 minutes to run. I was wondering if it could be multithreaded to run all...

I have a form that connects to three different databases on three different servers. Each query takes about 3 minutes. When run this form takes about 9-10 minutes to load while the servers are busy. I was wondering if it is possible to multithread these queries and run them all at the same...

First just paste those lines after your sql statments. Change the word subForm to the actual name of your subform. It will work. Reason: There is a bug in access that will not requery your subform. If you try to just do something like subForm.SourceObject=subForm.sourceObject, it kicks...

I ran into this exact same problem, and nothing worked. the way I got around it was to use something similar to the following code. dim temp as string temp = "" temp = subForm.SourceObject subForm.SourceObject = temp

oops oh yet the strFileName is actually strFileName = Environ("Temp") & urlFile sorry bout that:) thanks again

Thank you. For anyone else looking for the same thing this will work with only a few changes. first change the that has urlFile = Mid(urlPath, InStrRev(urlPath, "/") ) to urlFile = Mid(urlPath, (InStrRev(urlPath, "/") + 1)) without the +1 it will put a "/" on the front of the file...

i did try a microsoft browser control, but could not figure out how to have it display the image. When I tried to click on the custom in the design view, it comes back telling me that it is not registered or something.

I have a form that has an image name. The image is stored on a web server. The image can be accessed through a URL. The problem is how can I show the image on my form. When I try to change the picture property of my image control it tells me that it cannot use a web address. Any help would...