Results 1 to 3 of 3
  1. #1
    CNW is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2012
    Posts
    5

    Access 2010 splitform issue in WINXP 32 bit and WIN7 64 bit - splitform not display

    I have a database I have set up in WIN7 64 bit system. I transferred database to a WINXP 32 bit system. I modified the main form in the XP system to be a split form. I then copied the file back to WIN7 64 bit systems and have found that the datasheet portion of the splitform does not display on the WIN7 system. I have checked many settings to include that it is shown as a split form, checked the record source setup on the property sheet, data tab, and all is set up the same but datasheet does not display on the WIN7 systems. It seems as if this may be a bug with Access. Has anyone else run into this issue? I am uncertain if it is a 32 bit verses 64 bit issue or if it may have something to do with screen resolutions or what. I have also read that the splitforms tend to be buggy in other posts. If so may try to figure out how to simulate the splitform with a subform instead. Any suggestions or thoughts would be greatly appreciated.
    FOLLOW UP - Have done some more experimenting with this issue. I had backups of database and pulled form off of 64 bit design. I was able to set up split form without issue. I am going to confirm if the 64 bit designed form works on the 32 bit system tomorrow. Based on these results believe issue is either with 64 bit verses 32 bit system or WIN7 verses XP. If all works out it appears the "fix" is to do the design work only on the 64 bit system. I will confirm in this post once known.
    06/21/2012 - Confirmed issue is with 64 bit WIN7 system verses 32 bit XP system. Form edited on 64 bit system works fine on 32 bit system but if you reverse and edit form on 32 bit system it does not work on the 64 bit system, at least with split form.
    Last edited by CNW; 06-21-2012 at 07:25 PM. Reason: Issue resolved.

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Out of curiosity was your datasource ODBC or was it a local table?

  3. #3
    CNW is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2012
    Posts
    5
    Datasource is a local table. Table is transferred from work system to home system. I found if I edited it on work system, Windows XP 32 bit, and then copied it to home system, or any other WIN7 Home Premium system, that the split form did not show up. If I edit the form on WIN7 system I can successfully copy to WIN XP system and all is fine. Hope this helps.

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

Similar Threads

  1. From subform to splitform
    By webisti in forum Access
    Replies: 1
    Last Post: 02-13-2012, 10:26 AM
  2. Replies: 4
    Last Post: 01-12-2012, 11:56 AM
  3. Replies: 37
    Last Post: 08-10-2011, 09:43 AM
  4. Question about Northwind Splitform Controls
    By ajetrumpet in forum Forms
    Replies: 2
    Last Post: 09-13-2010, 09:08 PM
  5. Replies: 2
    Last Post: 01-29-2010, 11:30 AM

Tags for this Thread

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