Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TomPose

    User prompted "Stop" while executing code.

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

    User prompted "Stop" while executing code.

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

    Automating printing to Internet Explorer from MS Access

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

    Automating printing to Internet Explorer from MS Access

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

    Coding Pass through queries with "On the Fly" input.

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

    Coding Pass through queries with "On the Fly" input.

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

    Pass Through Queries on the Fly

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

    Pass Through Queries on the Fly

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

    Excell/Powerpoint won't run independently

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

    Compile error in query expression Now()

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

    Compile errors on common functions (Month, DLookUp, etc)

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

    Retrieve Blob/Memo text fields using MS Access

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

    Windows 2K Domain Logon problem

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

    Excell auto-open

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

    Excel - Mouse grabs left click and won't let go

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

    CD Rom drive does not refresh

    Thank you both for the information you provided. I have switched the Autoplay option to Take No Action, and am going to locate the SP1 for XP. Perhaps one of these fixes will work. Tom
  17. TomPose

    CD Rom drive does not refresh

    When I switch cd's in my drive, my WinXP Pro does not recognize the files on the new cd. Mostly... On the directory panel, it might change the directories, but the file panel does not update/refresh. I've tried using the refresh/F5, I've tried using the eject command via right click on the cd...
  18. TomPose

    Creating a hyperlink with a Query

    I have a database with a field that is set up as a hyperlink. That works fine. Now I want to extract part of that field using a query that strips off the filename, leaving only the directory. The field I created in the query is called goto. goto: (Left([path],(Len([path])-1-Len([filename])))...
  19. TomPose

    Extraction of portions of a cell

    I have the need to extract sub portions of a cell. The catch is that I need to get the portion according to what is in the cell. For example: If I have a path and file name in the cell \Directory1\directory2\anotherdirectory\filename.ext how do I get just the name of anotherdirectory, or...
  20. TomPose

    Directory listings and databases

    Can anyone tell me how to get a full directory listing of a folder and its subfolders? I want the name, size, last modified, and creation date. I would like to be able to put the filename and the directory it is in into a table. Thanks, Tom

Part and Inventory Search

Back
Top