Search results for query: *

I recently switched to Access after working with Paradox for 12 years and I used compound primary keys a great deal. Nevertheless I will use autonumbers to get the form to behave properly. My database is normalized. The relationship of employees to subforms/tables is 1-M. I appreciate your...

Recordsources are: Main form: tblEmployees, pk EmployeeID Subform1: tblPayroll, pk EmployeeID-WeekEnding-Paytype Subform2: tblPhones, pk EmployeeID-Phone Both subforms are linked to the main form by EmployeeID.

I put 2 subforms on an Access 2000 employee form. Both are linked by EmployeeID. The first is payroll data and the second is phone numbers. When I go in and out of design mode twice the phone number subform becomes a payroll subform and then I have 2 payroll subforms and no phone numbers...

Hi Gus, I have used Paradox for 12 years and I'm setting up my first Access database. I entered your question into Access2000 Help and did not get the AutoLookUp Query answer. Can you provide it please? Thanks, Sue

I don't know how to override the dataLookup action in the action event() or add code before the default behavior to replace the built-in lookup code with my own. Can you give me example code please? This problem has caused me grief for years.

The changeValue value event is not triggered when a value is selected from a lookup table. How do I overcome this?

I added 2 new fields to end of answer table to hold data selected by users who scroll a table displayed on a form. Then I put the fields on a report. I did not see how to make WriteEnvironmentString() work. Then I decided I didn't want to use it in this case anyway because I want the selected...

How do I get form variable to print on report?

What is code to add new field to table?