Search results for query: *

I entered:- Address: " " & [address1] & [address2] & [address3] but it returned nothing. Have I missed something? Thanks Philip

I have 3 address fields 1, 2 & 3 and would like to merge these into one field using a query. I have done this using vbCrLf in forms, but would like to do this in a query - can it be done. I have tried various ways such as Chr(13) & Chr(10), but no joy. Thanks Philip

Thanks for that lupins. I followed up on your piece of code and ended up using... Me.Parent.Recordset.FindFirst "contactID=" & Me.contactID ...which worked fine, but is this the best and correct way? Regards Philip

I’m using Access 2K on XP Professional with reference to DAO 2.5/3.5 Compatibility library I have been trying to find a way to go to a record on one subform with a button click from a subform, nested within it There is a main form with company details, subfrom A with employee contact details...

when clicked. Is this possible in Access 2000 I would like to insert a link in an email, that when clicked will launch an MS database and go to the record specified in the link. i.e. attaching a link for a prospects record in a sales db that can be emailed to a field sales person and when...

I came across this site the other day, one of the best I've found for VBA for Access http://www.functionx.com/vbaccess/index.htm Astrofax