Results 1 to 10 of 10
  1. #1
    hany1002 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    6

    Convert Access form from access 2003 to 2010


    I receved error whin i convert my access form from access 2003 to access 2010 .accdb
    Erorr in this line (Set rst = DBS.OpenRecordset("Accounts", dbOpenDynaset))

    Please Support

    -----------------------------------------------------------
    code
    -----------------------------------------------------------
    Private Sub Form_Load()
    Dim DBS As Database
    Dim rst As Recordset
    Dim nodX As Node

    Set DBS = CurrentDb
    Set rst = DBS.OpenRecordset("Accounts", dbOpenDynaset)
    Set nodX = TreeView1.Nodes.Add(, , "A", "دليل الحسابات")
    With rst
    Do While Not .EOF
    Set nodX = TreeView1.Nodes.Add("A" & CStr(Nz(!ParAcc)), tvwChild, "A" & CStr(!AccID), CStr(!AccID) & ":" & !ArAccDes)
    nodX.EnsureVisible
    .MoveNext
    Loop
    End With
    rst.Close
    Set DBS = Nothing
    For Each nodX In TreeView1.Nodes
    nodX.Expanded = False
    nodX.Sorted = True
    Next
    End Sub

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What is the error message?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    hany1002 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    6

    Need very ergant help

    Please I whant to convert this database to access 2010 .accdb

    But i receved error in forms


    Please download database from this link

    https://rapidshare.com/files/3789137177/Accounts.rar

    Need very ergant help

    Thanks for your Support

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What is the error message?

    Not sure I can extract rar compressed files. Use Windows Compression and I can get the file. In order to download, that site requires me to establish an account, which I don't want to do. Use something like box.not and that is not required.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    hany1002 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    6

    Please Help

    Tray this Link

    http://www.4shared.com/file/egYdwP7k/Accounts.html


    Please tell me the Problem


    Thanks

  6. #6
    hany1002 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    6
    I whant to convert this database to access 2010 .accdb

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Did you try importing everything into a new project file? I tried working with you database but there seem to be protection settings and the foreign language that make it too hard for me to do anything. I tried import but it failed with error message that my system couldn't handle the language characters.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    hany1002 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    6

    urgent Please

    Quote Originally Posted by June7 View Post
    Did you try importing everything into a new project file? I tried working with you database but there seem to be protection settings and the foreign language that make it too hard for me to do anything. I tried import but it failed with error message that my system couldn't handle the language characters.

    Please Can you add me in Hotmail and connect to my computer

    by teamviewer to solve this Problem

    My Mail : Hany-1002@hotmail.com I waiting for your add to tell you my ID & Password

    Thanks For your Help

  9. #9
    hany1002 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    6

    Error

    Hi

    This is the error in this line

  10. #10
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I don't know what teamviewer is nor how to connect to your computer.

    You have identified the line that causes error but what is the error message? The line looks fine to me.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Change Access 2003 mdb workgroup using Access 2010
    By metsmaniac in forum Security
    Replies: 6
    Last Post: 04-06-2012, 08:56 PM
  2. background image on Access 2010 form
    By lkspitz in forum Forms
    Replies: 2
    Last Post: 06-16-2011, 08:35 AM
  3. Replies: 2
    Last Post: 05-11-2011, 09:06 AM
  4. Replies: 1
    Last Post: 01-11-2011, 12:31 PM
  5. Convert access 2003 to access 2010
    By Vera in forum Access
    Replies: 3
    Last Post: 07-16-2010, 11:01 AM

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