Search results for query: *

How to put in a display only area on a form, Customer name & address when their code is entered on a form after the user leaves the custid field.  The display only area shows the info if found and does not enter the box with the customer name&address but goes on to the next field...

I have created an index name in a table which has multiple fields in it that provides a unique key.  How do you use an index name in a query.

How do you Password Source Code behind a Form.

Problem: Compare 2 tables and list the unmatched FIELD NAMES.<br>While the unmatched query wizard in Access offers multiple fields to select, the result is only a list of null records and it does not show which FIELD NAMES are unmatched.<br>For...

The goal of the project is to achieve very high accuracy for our database from our data entry operators.&nbsp;&nbsp;Two different operators would perform data entry on our records into 2 different tables and then a query would compare the 2 tables to identify unmatched fields. Our Quality...

Table #1 &quot;A&quot; (patient transaction records)<br> Patient_name (30 Char)<br> cpt_code 5 characters indexed dups allowed<br> <br> Table #2 &quot;B&quot; (master table of cpt codes)<br> cpt_code 5 characters indexed no dups <br> <br> Objective of query in Access 2000<br> Show patient...

Database has a transaction date field that is formatted as mmddyyyy. Need to know in an Access 2000 Query how to test if the date is greater than today or older than 4 months. I tried using the datediff expression ie: datediff(&quot;d&quot;,([transdate]),date()) which returns a number that is...

Access has an option to print the documentation of a table showing Name, Type and Size. How can this be modified to print Description in a column?