Search results

Good Evening All, I have a simple data entry form with drop down facilities on 2 fields. One of these fields incorporates a drop down list from a table but there are occasions when I wish to make a free text entry for the single record, but do not wish to add it to the drop down list. I have...

Many thanks for your very helpful suggestions which are duly noted. You have greatly assisted me in putting together a more secure system. Regards, jcbhydro

Dear Pat H, Many thanks for your useful suggestion. I can see the logic of the proposed re-structuring. However, I have a few supplementary questions before I embark on the re-modelling; a) I currently have a PK for the Table 1 (Members) on the member ID. This is an inherited database and the...

Many thanks for the response on this subject. I had assumed that the structure for Table 2 (Groups)was suspect, but was unsure as to how to reconfigure it. Are you suggesting that each group should have a separate field titled with the Group Name, with the members being records for each field...

Many thanks for such a prompt response. In response to your request for details of the 2 Tables; Table 1 is a membership list with First & surnames, addresses, 'phone numbers, email address and several other fields such as Subscription data, newsletter requirements, etc. Table 2 consists of...

Good Morning from the UK, I have a Membership List Table with a calculated field entitled Member Name. The second table entitled Groups contains only 46 records each of which has up to 30 Fields also containing member names. I Have written a query to establish which of the members from the...

Hi, I have already introduced myself at registering, but it obviously hasn't found its way to this forum. I am a retired consulting engineer with about 30 years of computing experience, including dBase 3, Lotus Smartsuite and Office. I have very limited experience with Access and am hoping to...