Page 2 of 4 FirstFirst 1234 LastLast
Results 16 to 30 of 48
  1. #16
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530

    Is this what you require:
    Attached Files Attached Files
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  2. #17
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116
    Many thanks Bob! I'm being a bit dim, but I can't see what you did! Can you talk me through it please?

  3. #18
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Very simple, really.
    Right clicked the textbox
    Clicked Cut
    Clicked the second tab
    Right clicked and pasted
    Then just aligned the controls and saved the changes 😀

  4. #19
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116
    That's what I thought you were going to do, but it looked the same when I checked! I'll have another look later.

    I tried to do the same thing, but it wasn't working for me!

  5. #20
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Before you continue, I would suggest you fix the relationships.

    Consider:
    Click image for larger version. 

Name:	Relationships1.png 
Views:	16 
Size:	103.0 KB 
ID:	42135


    My 2 cents........ (or is it pence??)

  6. #21
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116
    Thanks ssanfu! I'll have to wait until the morning now to check, but thanks for checking that for me. I'll get back to you tomorrow morning.

  7. #22
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Steve

    MANY years ago, when I was a lad, the phrase often used was, "My two pennyworth"..........But my memory is not as good as it once was
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  8. #23
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116
    Morning Steve and Bob (assuming it's morning for you too!),

    I just uploaded my edited db. The only thing I'm not sure how to fix is the look up fields in the T-Payments table. I think I used a wizard for this initially. Could you possibly talk me through how to fix that please? Also, why is it considered bad practice to have a look up field in the table?

    When I checked my main db, I must have spotted the dodgy relationship between the T_Engagements and the T_Payments, because it seemed to be correct there. I've changed that on the practice copy. Does it look ok now?

    I also changed the field names to PlayerId. Thanks for that suggestion.

    How's it looking so far?

    Many thanks.
    Attached Files Attached Files

  9. #24
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116
    I've attached my db again. I must have done something funny! On the FrmMusicians form you set up for me Bob, when I search for musicians in the Find Musician box, it doesn't seem to work anymore. Do you know how I can fix it? Many thanks.
    Attached Files Attached Files

  10. #25
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by neilsolaris View Post
    I've attached my db again. I must have done something funny! On the FrmMusicians form you set up for me Bob, when I search for musicians in the Find Musician box, it doesn't seem to work anymore. Do you know how I can fix it? Many thanks.
    The "Find" combo box has the following line of code in its AfterUpdate event:

    20 DoCmd.SearchForRecord , "", acFirst, "[PID] = " & Str(Nz(Screen.ActiveControl, 0))

    PID was the Primary key of the table used for the form's data. You have changed that fields name to PlayerID so the line of code needs to be changed to:

    20 DoCmd.SearchForRecord , "", acFirst, "[PlayerID] = " & Str(Nz(Screen.ActiveControl, 0))
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  11. #26
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116
    I see! Many thanks Bob. I'll see if I can change the code now.

    Edit...I changed the code, but it doesn't work just yet. Is there something else I also need to do? Thanks.

  12. #27
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by neilsolaris View Post
    I see! Many thanks Bob. I'll see if I can change the code now.

    Edit...I changed the code, but it doesn't work just yet. Is there something else I also need to do? Thanks.
    Not that I'm aware of. It worked for me. Perhaps you could post your latest version with the code changes that you made for me take a look at.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  13. #28
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116
    That's strange! Here's my edited version.
    Attached Files Attached Files

  14. #29
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by neilsolaris View Post
    That's strange! Here's my edited version.
    If it doesn't work for you then that is very strange because the file you attached last work fine for me, although I did need to click on the "Enable Content" button in the security warning bar just above the form.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  15. #30
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116
    I think my db has a mind of it's own! Before, once I selected the player, I'd click on tab or return, and it would bring up the relevant player. I'll keep trying to solve it. Thanks for your help.

Page 2 of 4 FirstFirst 1234 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 02-10-2020, 07:28 AM
  2. Replies: 21
    Last Post: 01-21-2014, 05:04 PM
  3. Replies: 1
    Last Post: 01-11-2014, 12:39 PM
  4. Replies: 1
    Last Post: 03-30-2012, 11:57 PM
  5. Active X form control
    By amitsingha4u in forum Access
    Replies: 2
    Last Post: 05-18-2010, 12:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums