Results 1 to 2 of 2
  1. #1
    Jen0dorf is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2015
    Location
    UK
    Posts
    453

    code error??

    Hi



    finaly have my first Database working as I want it, in the great scope of challenges not he biggest and best database but it's my first ;-)

    I have one issue left which I can see no logic to.

    In the attached database is a form called FrmYearOfDeathSearch

    It brings up a message box asking for a year - if you type in 1924 then two records come up.

    If you click on any of the record fields ( I have yet to work out how to change the curser to a pointer or hand) it takes you to a second form called

    tblDetail which in one record works perfectly and in the other just shows a white screen.

    NO error message! just a white screen and I have no idea how to approach this sort of error

    As usual will appreciate any hints/solutions

    Ian
    Attached Files Attached Files

  2. #2
    Jen0dorf is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2015
    Location
    UK
    Posts
    453
    Hi

    think I've fixed it, found that although I had deleted a field from the table, I left the call for it in the query.

    Access didn't appear to like that.

    Note to oneself, remember to delete all references

    Ian

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

Similar Threads

  1. Error in code
    By cbende2 in forum Programming
    Replies: 5
    Last Post: 06-04-2015, 10:39 AM
  2. Error in VBA Code
    By guillermoftw in forum Access
    Replies: 3
    Last Post: 02-10-2015, 12:12 PM
  3. error with a code
    By ashraf_al_ani in forum Forms
    Replies: 3
    Last Post: 08-04-2014, 02:56 AM
  4. VBA Code Returning Error Run Time Error 3061
    By tgwacker in forum Access
    Replies: 2
    Last Post: 11-24-2013, 11:00 AM
  5. Error in Code
    By Lockrin in forum Programming
    Replies: 3
    Last Post: 02-25-2010, 03:27 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