Recent content by TomPose

yes, thanks Cap'y dog... I am trying to fix the code - perhaps you could tell me where the problem is. As far as posting the code, it is rather long and I don't know which part is failiing. MoLaker, I do not know where to put the break? I would like to have a way to stop the code by key...

I am trying to stop the execution of code with a keypress. I seem to have runaway code and can not determine why. I need to be able to stop the code from executing by pressing a key during the execution. The ctrl-break does not work, so I want to use something similar to Basic's A$=inkey$. Any...

P.S. I need to monitor Explorer to make sure that the page has fully loaded before trying to print it and, by the way, I am opening multiple pages at the same time with different information in each, and need to monitor those as well before printing. Thanks again

I am trying to open Internet Explorer from within MS Access using code. I have done the call to Explorer using Call Shell("""C:\Program Files\Internet Explorer\IEXPLORE.EXE""http://webaddress.com/Summary.aspx?PrntId=" & prntid & "&Language=1", vbMaximizedFocus) where prntid will tell explorer...

This is Great!! with one caveat... When the pass through is created, it generates the following: SELECT DISTINCT table1.no, table1.name FROM [d_base].table1 WHERE table1.no= '123xxx' The brackets around d_base, after the FROM, are creating errors - ODBC Call Failed, invalid tablename...

I am trying to make a pass through querie on the fly. I want to select a series of variable by either drop down box or typing in the filter in an input box and then make the SQL string that defines the pass through. The code snippet at the bottom works to some extent. But, when I open it, it...

Yes, I want the "EnterNumberHere" to represent user input. I know that when running a regular query it will work, don't know if it would work in a pass through so if a variable would be better suited I would need to know how to get the input into the variable first.

I am trying to make a pass through querie on the fly. I want to select a series of variable by either drop down box or typing in the filter in an input box and then make the SQL string that defines the pass through. The following works to some extent. But, when I open it, it will not...

How do I prevent MSExplorer 6 from opening an excell links in an excell window within explorer? I want to have the link open in an Excell window outside of explorer. This happens also with powerpoint. I want to have the powerpoint open in powerpoint proper, not within another explorer window...

I have an issue which is the same as another users but the answer was not clear. I have a database in which I am trying to run some basic queries using the Now() feature. It used to work... ubt now it doesn't. The error I get is: Compile error. in query expression 'Now()' The other users...

I have the same problem as stated above, however, I don't know what to do with the Debug>Compile solution presented above. Help please

I have been trying to retrieve Blob memo fields from an Oracle database – unsuccessfully, for some time. When I open the oracle database using Access I see ‘OLE object’ in the field, but cannot see the underlying text. I can see the underlying text using other software (TOAD) but that does not...

I just received a new computer and corporate had it set up to auto install everything upon boot up. When it came time to select my computers ID name, I did. It said that name already existed, kept on going asking a little more info and rebooted. When it came back up it asked me for my login...

When I double click on an Excell sheet's icon, it is opened up in another currently open Excell application. I want to be able to double click on an icon and have it spawn a new occurence of the Excell application... I want each Excell sheet to auto-open its own individual Excell window and...

When I click on a cell in Excel, the program doesn't recognize the release of the button. Only Excel does this, all the other software running acts fine. After clicking, the mouse drags a selection window all over the worksheet. Even if you take the pointer out of the window, excel still...