Microsoft Access

Microsoft Access GoTo Feature

The following are the step by step instructions on setting up a drop-down GoTo feature on a form to search, select and go to a record quickly. 1.     Set up a Query using the columns you want to see. Below is an example. 2.     Type <>Nz([Form]![ID],0) in the criteria line of the ID column. Remember, the name… Continue reading Microsoft Access GoTo Feature

Microsoft Access · Uncategorized

Microsoft Access Joining Names with Expressions

In this post I will show you how to join customer names (customer plus spouse) and customer salutations. This is very useful when doing Microsoft Word merges into form letters. Open up the Query that you want to create a field for joining customer names and salutations. You will need the customers first name, last name, salutation,… Continue reading Microsoft Access Joining Names with Expressions