Results 1 to 5 of 5

I have couple of issues with Access query and I need your help on it! Please!

  1. #1
    xboxown is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Posts
    22

    I have couple of issues with Access query and I need your help on it! Please!

    First Issue




    The first issue I have is when I click in any report in access whether it is invoice or not I keep receiving this error message.

    Click image for larger version. 

Name:	SnipImage.JPG 
Views:	12 
Size:	19.6 KB 
ID:	36799

    I have no idea what to do with this error message. It only happen in one computer but the other computers in the company it works fine without this error message. I am unsure what to look for. Can someone please help me on this one? Thanks in advance.


    Second Issue

    The second issue I have is that IN ONLY one certain date in the month I get an overflow error.

    Click image for larger version. 

Name:	SnipIt2.jpg 
Views:	11 
Size:	118.4 KB 
ID:	36800

  2. #2
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    1,823
    For the printer problem, reinstall the printer on the offending PC.
    For the overflow, probably best to post your DB here for analysis.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    5,514
    #2: you are probably doing a calculation involving BFF Foam and the result of the calculation is too large for the field. Tried to find that field or alias name in your query pic but can't see it.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    Sometimes I talk to myself - like when I need expert advice.

  4. #4
    xboxown is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Posts
    22
    Quote Originally Posted by Micron View Post
    #2: you are probably doing a calculation involving BFF Foam and the result of the calculation is too large for the field. Tried to find that field or alias name in your query pic but can't see it.

    I checked in the backend of the database and there is no calculation which should result in huge values. If worst case scenario it will spit out something like 40,000 as digit but access should be able to hold that number or else it should be placed in the shredder if it cannot take that much digits. When you checked in the relationship of the table and in how I did it...was it correct? Do you think I did something else wrong on it. Please can someone help me on this?

    Thanks in advance.

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,202
    Quote Originally Posted by xboxown View Post
    <snip> If worst case scenario it will spit out something like 40,000 as digit but access should be able to hold that number or else it should be placed in the shredder if it cannot take that much digits. <snip>
    Maybe, maybe not. It depends on the field data type.

    If the field type is Number and the field size is:
    Integer Use for integers that range from -32,768 to 32,767. Storage requirement is 2 bytes.
    Long Integer Use for integers that range from -2,147,483,648 to 2,147,483,647. Storage requirement is 4 bytes.

    It sounds like the field size is Integer instead of Long Integer.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. I need help with a couple of issues
    By jasonmcbee in forum Programming
    Replies: 1
    Last Post: 09-19-2018, 01:00 AM
  2. couple of query questions
    By Snickren in forum Access
    Replies: 5
    Last Post: 02-03-2017, 12:08 PM
  3. Replies: 4
    Last Post: 11-03-2014, 07:36 AM
  4. Replies: 1
    Last Post: 11-14-2013, 12:26 PM
  5. Couple Design Issues
    By dpasanen in forum Forms
    Replies: 4
    Last Post: 03-29-2012, 06:47 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
  •  
Tech Forums: Microsoft Office Forums