Recent content by bxgti4x4

Ken, Thanks for that, I'll give it a try. Best Regards John

Ken/PHV The code works fine and makes the appropriate controls visible or invisible. However, when it makes a control invisible you are left with a gap in the report between the visible controls either side of the invisible one. Is there any way that this gap can be closed? Best Regards John

Ken and PHV, Thank you both very much. Now I have the way in, I have it working well. Best Regards John

Ken, Sorry to be a pain but I have searched everywhere to find a reference to Before Form Event so that I can start building, but I have been able to find anything. I would appreciate some pointers on how to proceed. Best Regards John

Remou, That did the trick, I set both indexes to Yes(No duplicates) and I can now add update as necessary. PHV, Thanks for taking a look, it looks as though Remou's advice was enough to solve my problem. Thanks to you all for your help. Best Regards John

Remou, Thanks for all your help, I'll try this and let you know the outcome. Best Regards John

Remou, Do you mean that I should add a second primary key, or is indexing a more complex process? Best Regards John

Remou, Alias is unique in both tables but neither is indexed. In TblPassport Details there is a record for each Alias Name, whereas Tbl Master Address List contains about 600 records, only 30 of which contain have an entry in the Alias field. Best Regards John

Sorry Remou, I copied the wrong query - I had been experimenting with various ideas. The correct code is: SELECT TblPassportDetails.Alias, TblPassportDetails.DateOfBirth, TblPassportDetails.PlaceOfBirth, TblPassportDetails.CountyOfBirth, TblPassportDetails.CountryOfBirth...

Remou, The SQL is as follows: SELECT QryPersonalDetails2.Alias, QryPersonalDetails2.DateOfBirth, QryPersonalDetails2.PlaceOfBirth, QryPersonalDetails2.CountyOfBirth, QryPersonalDetails2.CountryOfBirth, QryPersonalDetails2.Nationality, QryPersonalDetails2.P1PassportNo...

Ken, Small problem - I have created the button on the form which will open the report but I cannot find the "beforeformat" event to which you refer. Could you please tell me where to find it. Thanks a lot, John

I have a query (QryPersonalDetails)which extracts data from two tables, using a common field (Alias). TblMaster_Address_List contains 600 records and TblPassportDetails contains 21. My problem is that the data is extracted OK but I cannot amend it. I assume that Access will not allow me to...

Ken, Thanks for the idea. It may take me a while to try it out but I'll let you know. Best regards John

I have a form which displays personal information for an employee (name, adddress, passport details, visa details etc.) The form contains 40 fields. I would like to have a tick box alongside each field so that the user can select certain fields (e.g. passport details) and then press a command...

Leslie, Having changed the data in the TblClass/Peters to match that in TblCompetitor, everything worked fine. Also I can now understand the use of the Union part of the query. The final report gives me just what I wanted. Many thanks for your help. Best Regards John