Recent content by pvg

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...

To Elizabeth.&nbsp;&nbsp;Thank you for replying.&nbsp;&nbsp;While the unmatch query wizard offers multiple fields to select, the result is a list of null records which do not show which FIELDS are unmatched.&nbsp;&nbsp;Again I am looking for this:<br>When 2 records match on a unique...

To DanAuber:&nbsp;&nbsp;Thank you for replying.&nbsp;&nbsp;I have already tried your suggestion and the result is that you just get a bigger key to match on but you still do not know which FIELD was unmatched.

To Elizabeth and DougP:&nbsp;&nbsp;Thank you for replying.&nbsp;&nbsp;The answers you gave were at the record or row level and I am looking for unmatched FIELDS.&nbsp;&nbsp;&nbsp;Your answers to this problem refer to the unmatched query wizard which does not solve the problem of matching each...

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...

To get the query to display ONLY the unmatched records, the solution is:<br> <br> Select A.cpt_code, A.Patient_name, B.cpt_code<br> From A left join B on A.cpt_code = B.cpt_code<br> Where (((A.cpt_code) NOT In (Select B.cpt_code from B)));

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?