Search results for query: *

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

Leslie, I played around with the query for a bit longer and, by accident, cut out the join on TxtInitials. After that, it worked. I need to make a few checks before I am certain but it certainly looks like the Initials were confusing the issue - probably because some were entered in upper...

Leslie, I constructed your code from scratch and got rid of the syntax error warning. However, when I ran the query, it still did not extract all the details from TblClass/Peters for each of the competitors in TblCompetitor. My code ended up as follows: SELECT [TblClass/Peters].TxtName...

Thanks Leslie and cmmrfrds, Leslie, I keep getting the error message "Syntax Error" when I try to run the query. I have checked through but I cannot see where the problem is. Could you please check the code for me. cmmrfrds The reason for the WHERE clause is to remove blank records. Each...

I have two tables, TblCompetitor and TblClass/Peters. TblCompetitor has 93 records, one for each competitor for the current year. TblClass/Peters lists all competitors for the past four years, thus many of the names have an entry for more than one year. Using the names and initials from...

PHV, That's done it. It just remains for me to say a big thank you for all your patience and help. It is very much appreciated. Best Regards John