Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bxgti4x4
  • Order by date
  1. bxgti4x4

    Selecting fields on a form for inclusion in a report

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

    Selecting fields on a form for inclusion in a report

    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
  3. bxgti4x4

    Selecting fields on a form for inclusion in a report

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

    Selecting fields on a form for inclusion in a report

    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
  5. bxgti4x4

    Unable to amend data via a query

    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
  6. bxgti4x4

    Unable to amend data via a query

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

    Unable to amend data via a query

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

    Unable to amend data via a query

    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
  9. bxgti4x4

    Unable to amend data via a query

    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...
  10. bxgti4x4

    Unable to amend data via a query

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

    Selecting fields on a form for inclusion in a report

    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
  12. bxgti4x4

    Unable to amend data via a query

    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...
  13. bxgti4x4

    Selecting fields on a form for inclusion in a report

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

    Selecting fields on a form for inclusion in a report

    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...
  15. bxgti4x4

    Joins Problem

    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
  16. bxgti4x4

    Joins Problem

    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...
  17. bxgti4x4

    Joins Problem

    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...
  18. bxgti4x4

    Joins Problem

    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...
  19. bxgti4x4

    Joins Problem

    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...
  20. bxgti4x4

    Updating a single record in a table

    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

Part and Inventory Search

Back
Top