Results 1 to 3 of 3
  1. #1
    anarchie68 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    1

    Please help me, I cant code but need to fix our programm..

    I started learning python like 1 week ago, Im still a complete beginner.



    However, my uncle and me use a little programm we made with the builder, but now its giving us 2 bugs
    that seem to be connected witheachother.

    Since i still have NO clue whatsoever about how to fix it, I would love to get some help from you guys.
    We use access 2013.

    First its "Run time error : 2200" "microsoft access cant open
    the file "\Logos\Ritter Wappen neu.jpg".


    Debugg :

    https://abload.de/img/1leunv.jpg

    Second is "Run time error : 94" "Invalid use of Null"

    Debugg :

    https://abload.de/img/2a8uxl.jpg



    Please guys help me fix this quick, I just started learning coding and I have no clue still what going.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,523
    in Access, you do not need any code to do this.
    in the report (or form) it is bound to a query,
    the query has the data and the photo
    the photo is bound to the field.

    so all you do is open the report:
    docmd.openreport "myreport"

    no code.

  3. #3
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    "Run time error : 2200" "microsoft access cant open
    the file "\Logos\Ritter Wappen neu.jpg".
    This file does not exist in the path specified or is corrupt. Find the file outside of Access and open it.

    "Run time error : 94" "Invalid use of Null"
    Click on Debug and it will show you the line of code that is causing the problem. Usually a field is null and it is not allowed to be, you need to check first, with something like
    If Not IsNull(fieldname) Then

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

Similar Threads

  1. Replies: 20
    Last Post: 10-13-2015, 09:05 AM
  2. Access - Programm Kinderferienprogramm
    By sebi95 in forum Programming
    Replies: 2
    Last Post: 06-16-2015, 01:32 PM
  3. Replies: 3
    Last Post: 10-16-2014, 08:49 AM
  4. Replies: 1
    Last Post: 05-04-2013, 12:19 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