Search results

For Table A, the primary key is the field PKA For Table B, the primary key is the field PKB For Table AB, the primary key is concatenated: both PKA & PKB Table A has a 1 to many relationship with Table AB Table B has a 1 to many relationship with Table AB

I'd like to describe a scenario involving 3 Tables / Forms and ask a few questions. I think the answers may involve VBA code, which I am still trying to learn. Here's the scenario: TableA has 2 fields: PK field is populated with autonumbers which I will call PKA. The 2nd field is a text field...

Can I use the same field name in more than one table? (Though possible, perhaps it's not advisable?) For example, let's say that there are 2 tables in the db: one named Staff and the other named Client Contact The Staff table lists employees, so the fields might include: First Name Last Name...

It seems like I've triggered a debate of sorts ! I'll try the conditional formatting suggested by missinglinq. Thanks !

Are you saying that the form should not contain a textbox for the primary key? Or is there a way to keep the PK textbox on the form without showing the string "autonumber" every time a new record is added? The users appear interested in seeing the autonumbers once they are generated. But...

Is there a way to make the string "autonumber" invisible when adding a new record? Currently, when I add a new record, "autonumber" shows up in the primary key textbox. My preference would be for the textbox to remain blank until I have completed filling in the other textboxes (fields) of the...

Thanks to everyone for the advice / info. I will attempt a limited custom re-install of ACCESS 2003 in the next few days. Cheers!

A few months ago I installed Office 2007 on my home PC and uninstalled Office 2003. I am contemplating the re-installation of ACCESS 2003 on my home PC, but don't want to disturb my Office 2007 install. QUESTION: Is it possible to have both versions of ACCESS (2003 & 2007) on my PC without...

Many thanks, Paul. It worked exactly as you said it would.

It works, Paul. But I think I may need to "tweak" the coding a little. When I scroll through the records by clicking on the right-pointing arrow at the bottom of the Form, the Text Box remains invisible even when I scroll onto a record that contains the combo box setting that is supposed to...

Thanks, Paul. For the Text Box Properties, I have currently set Visible = No. Should I change that setting?

This is my first post. In one of my Forms, I have a combo box which allows users to describe a new record from a list of 5 possible options. If users choose one particular description from the 5 options, then I would like the form to display a previously hidden text box and label. I want the...