Results 1 to 6 of 6
  1. #1
    Gdm is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    28

    Question Form crashes after upgrade-please help...

    I have an access application that was working well in version 2000.
    I upgraded to Office 2010, now I get a crash on a form, saying a reference to a control (ListBox) is Null.



    What has changed? How can I make this application work again?

    Help would be most appreciated.

    Gdm

  2. #2
    PianoMan64 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    29
    Hey Again Gdm,

    It sounds like you're going to have to check through each of the librarys and make sure you're using the current versions of all of the 2010 of MS Access.

    Since you didn't say if you converted your database or simply just openned the MDB in Access 2010, both of these will make a difference as to how it is going to function.

    If you can post specific errors, I can be more of a help.

    Joe P.

  3. #3
    Gdm is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    28
    <...check through each of the librarys ...>
    How?

    <...converted your database or simply just openned the MDB in Access 2010...>
    MDB was opened in Access 2010.

    <If you can post specific errors...>
    I have a fairly simple form with a ListBox called ProgramList.
    In my code, I try to use such variables as '[ProgramList].ListCount' or '[ProgramList].Column'; in both case, when I run in debug, [ProgramList] shows as Null.

    How is that possible?

    Help would be most appreciated - a business is losing data, and potentially money because this is not working.

    Thank you.

    Gdm

  4. #4
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    I have virtually no experience with the newer versions of Access, so this may not help, but. . .

    If ProgramList is a ListBox and not a field name from a Table, it should be referenced in your code like 'Me!ProgramList' (or possibly as just 'ProgramList' depending on the context) instead of as '[ProgramList]'. You only use square brackets ([]) when an item is being referenced by an external Object (like a Query or Report, etc.) or if it's a field in a Table.

    I would try changing your code to Me!ProgramList.ListCount and Me!ProgramList.Column and see if that helps. Of course, if your code is being referenced by anything outside the Form where the ListBox exists, you'll want to reference it as [Forms]![frmFormName]![ProgramList] (where frmFormName is the name of the Form containing your ProgramList ListBox) instead.

  5. #5
    Gdm is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    28

    Question

    Thank you, Rawb, for your quick reply.
    I tried all your suggestions, and nothing works.
    I am at my wits' end - how is it possible that a reference to a control that exists on a form would yield Null?

    Help would be most appreciated.

    Thank you,

    Gdm

  6. #6
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Maybe if you could post your VBA Code we might be able to help more?

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

Similar Threads

  1. Replies: 2
    Last Post: 05-19-2010, 02:01 PM
  2. Access 2007 crashes on the network
    By riit in forum Access
    Replies: 7
    Last Post: 11-26-2009, 08:37 AM
  3. Access Crashes When Wizards are Used
    By DCSwearingen in forum Access
    Replies: 6
    Last Post: 04-12-2009, 07:35 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