Search results for query: *

See Microsoft: Access Modules (VBA Coding) for the answer...

Just to say thanks for responding. I have tested out your suggestion, and it works perfectly. I programmed in assembler and other low level languages years ago, but VB is a bit like straying on to someone else's traffic management system whilst peddling a bicycle. If you or anyone else can point...

Hi I would like to be able to press a button on a form to generate a hyperlink to a web page. The hyperlink will be to an address like http://www.website.com/[EPIC].htm where [EPIC] is the contents of the EPIC field visible on the current record being displayed on the form. I have tried out...

Hi On a form, I'd like to have a button to press that generates a web address with a variable equal to a field on the form e.g. http://www.website.com/gerbil.htm where gerbil is in the field animal and it's visible on the form being displayed. I currently have extra fields set up of type...

Just to confirm that I tested out your suggestion successfully, including the sheet name with spaces, which would be: =INDIRECT("'"&A2&"'!a1") Thanks!

Hi I have a formula like: ='sheetname'!a1 but instead of hard coding sheetname, I want to take it from the contents of a cell. For example, cell a1 contains the word SummarySheet and I want to write a formula equivalent to the first formula above that substitutes the contents of a1 as a...