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!

  • Congratulations bkrike 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: jryan3
  • Content: Threads
  • Order by date
  1. jryan3

    Subform displayed data does not update as data updates

    I have a form with a subform. The user selects a button on the form to cause data to be transferred from another database to the current database. The data transfer is divided into sections based on certain criteria. The subform is used to show the progress of the transfer. Each time a...
  2. jryan3

    Need script to detect broken Hyperlinks in Excel

    I have an Excel spreadsheet that contains more than 2000 hyperlinks. I am trying to write a VBA script that detects if any of the hyperlinks are broken. Any suggestions? Joe
  3. jryan3

    Can no longer enter new data into a cell that has a drop-down

    I have two spreadsheets. The first spreadsheet contains cells that use a drop-down list from the second spreadsheet. I was able to enter new data into the cell by either selecting an item from the drop-down list or I could type in new text that was not on the list. This all worked fine...
  4. jryan3

    Need to Globally chnage hyperlinks in Excel

    We have an excel spreadsheet that has many hyperlinks to bookmarks within the same word document. We have replaced the word document by an excel spreadsheet containing the same bookmarks. I am trying to do a global replace of all hyperlinks to point to the new document. When I use the edit...
  5. jryan3

    Adding an image to the background of an existing form

    I have an existing form and would like to add a picture as the background to the form. Currently when I try to add the image it is displayed on top of the buttons and text fields that are already on the form. As a workaround, I can create a new form with the picture and then paste the buttons...
  6. jryan3

    Need Subform to point to new Record

    I have a form containing a subform. Two fields are used to link the form and subform. The subform displays with its record selector on the first matching record in the subform. I would like to have the record selector in the subform pointing to a new record so that the user can start entering...
  7. jryan3

    Reinstalled Windows 98 causes Error "AcitveX component can't cr

    After I reinstalled Windows 98 to a new directory I get the error message "ActiveX component can't create object" when I use Access 97 databases. What components need to be installed to restore the AcitveX connection? I have both the Windows 98 and Office 97 CDs.
  8. jryan3

    Trying to export a report where lines are not lost

    I have a floor plan report generated in Access that I want to export so I can e-mail copies. Rich Text Format losed the lines and boxes. I tried importing the data into word but could not match the floor plan layout. Any ideas on a method to use to solve this problem.

Part and Inventory Search

Back
Top