Recent content by matt467

Any other way it can be done without a macro?

Yeah thats correct, heres the code; Object type - Object name - Record - First Where Condition - ="[Company] = " & "'" & [Screen].[ActiveControl] & "'"

Rightio ive got a form which shows customers details, and i wanted to create a dropdown list so i can scroll and click on a customer.. then shows the details.. simple right?! -Create the box using 'Find a record on my form based on the value I select' -Select Company field All works fine...

This is my form; Im looking how to link the Website button at the top so that when clicked on it, it opens the link in the txtWebsite field. Ive rigged it up for the email one already but cant seem to get the website one working at all and tried all the codes i can find! Anyone got any tips?

That worked perfect, thankyou so much :)

http://i30.tinypic.com/21ex00j.png theres my database

In the table that the form links to, both fields are under Text, but the website one works under text And the data in the field is a valid email address, mail@address.com

Nah first it comes up with a security error, then after i click yes to continue it comes up with a runtime error 490

Got it for hyperlink, now just need to work it out for an email address to open up a new email to the address thats in a text box

As an expression or code?

Ive got a form with a few Text Box's in it with one of them with the customers website and another with their email, is it possible to put a button beside it to go to the website or email Like i can click the button and go to whatever is written in the text box its linked onto

Ive got a form in access ive coded up buttons to open different word documents, everything working all okay. However one of the documents has a mailmerge from one of my queries in it When i open the document by going to the folder, it opens and the mail merge works perfect, but when i open...