Search results

NBVC, The first solution doesn't work and the second one does, other than not including all the types of paths. Thank you for your efforts!

These worked quite well except some of the links begin differently. I'm going to experiment with using OR to include them: http://wsldocs.sos.wa.gov/library/docs/iii/charts/spokesmanreview.htm

I have to repeat the second one because there is often a lengthy list of hyperlinks in one line. It has to be repeated for each new ;

Hi NBVC, only the hyperlinks with the sos chart path are needed. Other hyperlinks need to be removed from the string. The rest of the rows will have "No Chart Listed" placed into the field. HEre's what I've been working with...the problem is that I have to repeat it and I'd like to be able to...

Hi, I have another string processing question: Here are sample rows of the data I am working with: http://www.thedailyworld.com/ View The Daily world website http://chroniclingamerica.loc.gov/lccn/sn87093039/issues/ <b>View digital version 1904-1922...

Thank you for your help. Here are my 3 functions: =TRIM(RIGHT(SUBSTITUTE(H2,"Washington",REPT(" ",99)),99)) =IF(VLOOKUP(LEFT(I2,FIND(" ",I2)-1),counties!$A$2:$A$40,1)=LEFT(I2,FIND(" ",I2)-1),VLOOKUP(LEFT(I2,FIND(" ",I2)-1),counties!$A$2:$A$40,1),VLOOKUP(LEFT(I2,FIND(" ",I2,FIND("...

Hi NBVC, Thanks so much. I would like to clarify that there is only one state and 39 counties. Only the county and city names need to be extracted and put into separate columns. I'm assuming there's a way to compare each county name in an array or lookup to the string and then extract the...

This would need to work in Excel 2007 :)

Hello, I need to work with columns with text data similar to the following: United States Washington King Seattle;"United States Washington Grays Harbor Aberdeen What I would like to be able to do is compare a list of all the counties in the state to the string and then extract the rightmost...

Hi JD, We're very simply clicking in the navigation panel to open the form. There is a macro but it works just fine on my machine. Thank you for your reply!

Hi James, Thank you for your reply. The version for both systems is Access 2007. The form just doesn't open. We don't see it minimized on the screen. We can access the form by going to design view with right click and then to form view at the ribbon. Rhonda

I haven't yet received a solution or reply to this. Please take a look.

The form is opening at the top left of my Access window so that I don't believe it is hidden from view on the other computer.

Hello, I've designed a form in Access 2007 that opens fine on my computer, but will not open from another computer. We can, however, right click to design view and then open form view. Does anyone know why clicking on the form in the navigation panel will work on one computer but not...

Hello Spikepl, Thank you for the reference. It has been bookmarked!

Hello MSAcessRookie, Are you saying that you found instances where the solution suggested by Nigel doesn't work? Thank you for your efforts. Also, could you (or anyone else) outline your testing strategy? I'd like to adopt a rigorous and reliable testing strategy for my queries. Thank you!

I used concatenate to add # to the front and back of each hyperlink in Excel before importing into Access. It looks like this: concatenate("#",column,"#")

I am working with Access 2007.

Hello, I have imported a table with a list of hyperlinks from Excel. When I open the hyperlink editor, it shows the link address in the text field with nothing listed in the address field. Is there a way to transfer the link address in the text field to the address field so that the link will...

You know, it seemed like the type of problem that might have been seen before. Thanks again!