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 offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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
    9,664
    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" =

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Looks like I'm late to the party again......

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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
    9,664
    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.........

  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
  •  
Other Forums: Microsoft Office Forums