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 Wanet Telecoms Ltd 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: *

  • Users: JMCONNOR
  • Content: Threads
  • Order by date
  1. JMCONNOR

    VBA is opening Excel as "read only"

    I'm trying to update an Excel spreadsheet using VBA in an Access database. I'm opening the spreadsheet like this: Set ExcelApp = CreateObject("Excel.Application") Set ExcelWkb = ExcelApp.Workbooks.Open(Addr) Set ExcelSht = ExcelWkb.Worksheets(WkSheet) Where Addr is the path to the spreadsheet...
  2. JMCONNOR

    Printing IE6 Web Page via VBA

    I have a VBA routine that I run from MS Access 2003 that will open IE6 and go to a selected web page and print it using ExecWB 6, 2, 0, 0 Is there any way to specify that only page one should print in case there's more material than will fit on a single sheet of paper? That is: Print one...
  3. JMCONNOR

    Replacing IE with Firefox in VBA code

    When my group switched to IE7, certain web page graphics that were available in IE6 (and Firefox) are only showing up as placeholders now. I have searched and searched and can't find a way to turn these graphics on. Some graphics are still there, so graphics are not blocked. I'm accessing IE...
  4. JMCONNOR

    Opening a non-Access file from within Access

    I have an Access 97 database that stores the contents of specified directories in an Access table. The database contains a form on which I can search for a specific file to see where it is on the drive. I would like to know how to open the file (say, a ".doc" file) from this form. I know how to...
  5. JMCONNOR

    Sharing linked tables

    I have a couple databases that at times need to share the employee table. The problem is that both databases can't be open at the same time on the same PC. Both databases can be open and working properly as long as they are on separate PCs The error I get is: "Couldn't use ...(path); file...
  6. JMCONNOR

    Positioning a form on the screen

    I'm using Access 97 and I have a simple database that I use to help me keep track of tasks I need to check on from time to time during the workday. To that end, the database opens three forms at once, each of which has a different use. It's really helpful to have all three open at once rather...
  7. JMCONNOR

    Open specific web page with IE, then print and close.

    I have a module that successfully opens IE and brings up the desired web page. What I need to do now is print the page to the default printer and close IE from within the module. The user never even needs to see the page on the screen. The pertinent lines: Set IE =...

Part and Inventory Search

Back
Top