Search results for query: *

PHV, Thanks for the help! The DOEvents solved my problem. Joe

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

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

Skip, The range 'Master Links.xls'!Documents was not sorted previously. Now it is sorted alphabetically. The Data/Validation was the same previously as it is now. Even though the allow list option was used previously it still allowed text not on the list to be entered. I did an...

The Data Validation - List Reference is Validation criteria: Allow list Source is =TheDocuments where TheDocuments names the range ='Master Links.xls'!Documents Master Links.xls is the second psreadhseet containing the list. Joe

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

ALL, It feels so good when you finally stop banging your head against the wall. Tony, The changing of the Hyperlink base did the trick. Thanks! Joe

PeterMoran, I used the code and it successfully changes the address of the hyperlink. Thank you. I tried to change the hyperlink name as well by adding the line oLink.Name = Application.WorksheetFunction.Substitute(oLink.Name, sFind, sReplace) I get an error telling me " Wrong...

PeterMoran & TonyJollans I appreciate the help! I am getting closer. I am in the process of trying the code, Got interrupted. I did try the Alt+Shift+F11 and then did a global Find and Replace on the HTML. It looked good. However, When I saved the spreadsheet and then opened it back up...

To: PeterMoran I was unable to get to the 211304 post on the WOPR site. To: GlennUK We had two word documents. One of the Word documents had bookmarks in it. The other word document contains hyperlinks to bookmarks in the other word document. We are switching both documents from word to...

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

kjv1611, Thank you for the help. You solved my problem.

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

I already tried the code: private sub ... On_Open() DoCmd.GoToRecord , , acNewRec end sub It works OK when the subform is displayed directly but not when it is displayed as a subform with fields linked to the parent form.

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

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.

Appreciate your response about using snapshot. We thought about using it. However, I have no guarantee that the individuals receiving the e-mail will have it on their machine. Some of the systems that our users have are very controlled as to what can be installed.

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.