Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    database conversion hell (AccessXP)

    Hi,

    we have just converted an Access97 db to AccessXP and are experiencing a number of errors.

    The most perplexing so far is that whilst navigating from one sub form to another (with the same parent) using the Tab key a field in the first is reset to 0 despite having just been amended to any value. The field changed is the penultimate in the first sub form, pressing Tab once moves the user to a checkbox and then another press moves the user to a textbox in the next subform (and the value is reset). Moving from the textbox in subform 1 to the textbox on subform 2 doesnt reset the value in textbox 1. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    any thoughts, experiences with upgrades gratefully welcomed.

  2. #2
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: database conversion hell (AccessXP)

    I had a similar experience where I had to explicitly reference the controls with something like forms!frmName1!ctrControl.value and make sure the parent child link in the properties box was correct.
    Hope this helps.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: database conversion hell (AccessXP)

    Is it the checkbox that's being reset? Is there some code behind it to navigate to the next subform or how are you doing this?
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: database conversion hell (AccessXP)

    The control being reset is a textbox.

    I cannot find any code to control the navigation so i think it must be the tab order of the parent form that is controlling the movement

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: database conversion hell (AccessXP)

    Could you post a stripped down copy of the database? Remove everything that is not necessary to illustrate the problem, and remove almost all records from the remaining tables - just one or two should be enough to see what's happening. Scramble sensitive data. Then, do a compact and repair, and create a zip file containing the database. It should be below 100 KB. Attach it to a reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •