Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2020
    Posts
    4

    I have no freaking idea why this doesn't work.

    Click image for larger version. 

Name:	faking jebise.jpg 
Views:	22 
Size:	198.0 KB 
ID:	41085



    This is my ongoing problem. I have the issue with the top picture, right one is only for example.
    Infuriating.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,892
    First case:

    Left field is autonumber (a number type), Right field is text type - must be a number type.

    Second case:

    Left field is number type, Right field is autonumber (a number type).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Feb 2020
    Posts
    4
    I hope the right picture was clear enough, but on the second case, I was connecting "nottheid" field and "ID" field. I just inserted the numbers on the left field (and now it's a number type field), but I also did that on my first case with the right field.


    To make a long answer short, how do I make my text type to a number type? My boxes contain all numeric characters and no alphabetic.

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,684
    Click image for larger version. 

Name:	Faking jebise 1.jpg 
Views:	21 
Size:	63.1 KB 
ID:	41086
    According to the Error message, you should change the FK field (in the right table in the image above) from a TEXT type field to a NUMBER (Long Integer), providing that the PK field in an autonumber/long integer.

    What are the two field data types??
    "ID Prilavlien" =
    "ID naroZnika" =
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,684
    Looks like I'm late to the party again......
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,892
    Open table in design view and change field type to Number Long Integer.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Join Date
    Feb 2020
    Posts
    4
    Quote Originally Posted by ssanfu View Post
    Click image for larger version. 

Name:	Faking jebise 1.jpg 
Views:	21 
Size:	63.1 KB 
ID:	41086
    According to the Error message, you should change the FK field (in the right table in the image above) from a TEXT type field to a NUMBER (Long Integer), providing that the PK field in an autonumber/long integer.

    What are the two field data types??
    "ID Prilavlien" =
    "ID naroZnika" =
    Phew, well therer we go. Completely crazy, I was tearing hair off my head over it, calculating and comparing to others why it didn't work. And I knew somethign was off when I wrote the line that it was indented to the left, but then I completely forgot about it. Dammit.


    Anyway, hats off for getting so into it as to actually editing and fixing my picture!
    You sir are a certified MVP, let me say.

    THANK YOU to all! This was really infuriating haha

  8. #8
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,684
    From both of us, you're welcome.

    Yes, it took a little the time to edit the image, but I'd bet you understand RI a lot more now...


    Good luck with your project.........
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  9. #9
    Join Date
    Feb 2020
    Posts
    4
    Thank you very much.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Why doesn't this DCount() work?
    By tim_tims33 in forum Access
    Replies: 1
    Last Post: 12-16-2014, 07:14 AM
  2. Replies: 4
    Last Post: 06-12-2014, 02:05 AM
  3. Replies: 5
    Last Post: 04-14-2014, 12:37 PM
  4. Just doesn't seem to work!
    By txmmoore in forum Reports
    Replies: 9
    Last Post: 01-16-2014, 11:39 AM
  5. Need Help/Idea with making query work
    By SilentReyn in forum Queries
    Replies: 9
    Last Post: 03-06-2013, 02:49 PM

Posting Permissions

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