Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Moving from A2k to Access 2007 (12.0.6562.5005) SP2

    Iím starting to implement databases and code that have been working in Access 2000 through 2003 with
    Access 2007 (12.0.6562.5005) SP2

    Programmers worst nightmare, something that worked in an earlier version does not work the same way in a more current version

    Are there any notes/websites/papers available that reference any gotchas between Access 2000 and 2007?

    Thanks, John
    11397335

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    I don't think there are any definitive lists, just postings here and there.

    What kind of problems are you having?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts
    10/09/11

    Hi Mark

    No problems at the moment. But have stumbled across the following two problems:

    John


    This worked in 2000-2003, but errored in 2007
    Form, Event On Dbl Click =[lngIDJump]

    This worked in 2000-2003 & 2007
    Form, Event On Dbl Click =lngIDJump()

    Function lngIDJump() ' this is fired when user double clicks in any field

    Call lngID_DblClick(False)

    End Function


    ----------------------------------

    This worked in 2000-2003, but errored in 2007
    Public Function OpenReportToLastToFirstPagePreview2k(strRpt As String)

    Dim strPages As String
    Dim intLen As Integer
    Dim n As Integer

    DoCmd.OpenReport strRpt, acViewPreview
    ' Determine number of pages:
    strPages = CStr(Reports(strRpt).Pages)
    ' Specify Zoom percentage:
    DoCmd.RunCommand acCmdFitToWindow
    DoCmd.SelectObject acReport, strRpt
    ' Use SendKeys to select Navigation box Page number:

    SendKeys "{F5}", True 'select navigation box page number

    SendKeys strPages, True 'last page number
    SendKeys "{ENTER}", True 'go last page

    'Pause 1 second, then go back to Page 1:
    Sleep 1000
    DoCmd.SelectObject acReport, strRpt

    SendKeys "{F5}", True

    SendKeys "1", True
    SendKeys "{ENTER}", True
    SendKeys "%vzz" ' Alt v = Menu, z=Zoom, z = 100%

    End Function


    This worked in 2007

    Public Function OpenReportToLastToFirstPagePreview2007(strRpt As String)

    Dim strPages As String
    Dim intLen As Integer
    Dim n As Integer

    DoCmd.OpenReport strRpt, acViewPreview
    ' Determine number of pages:
    strPages = CStr(Reports(strRpt).Pages) ' save last page number
    ' Specify Zoom percentage:
    DoCmd.RunCommand acCmdFitToWindow
    DoCmd.SelectObject acReport, strRpt

    'Use SendKeys to select Navigation box Page number:

    SendKeys "%{F5}", True 'select navigation box page number
    SendKeys strPages, True 'last page number
    SendKeys "{ENTER}", True 'go last page

    'Pause 2 second, then go back to Page 1:
    Sleep 2000
    DoCmd.SelectObject acReport, strRpt

    SendKeys "%{F5}", True 'select navigation box page number
    SendKeys "{BACKSPACE}", True '41 - clears 41 from box number
    SendKeys "{BACKSPACE}", True '821 - clears 821 from box number, if over 9 checks
    SendKeys "{BACKSPACE}", True '1251 - clears 1251 from box number if over 99 checks
    SendKeys "%{F5}", True 'select navigation box page number

    SendKeys "1", True 'set to page 1
    SendKeys "{ENTER}", True 'go to page 1

    SendKeys "%vzz" ' Alt v = Menu, z=Zoom, z = 100%

    End Function

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    One of the most complete list of issues that I know of is Allen Browne's Converting to Access 2007 or 2010.
    Last edited by WendellB; 2011-10-11 at 09:50. Reason: Add missing text in URL
    Wendell

  5. The Following User Says Thank You to WendellB For This Useful Post:

    hasse (2012-03-23)

  6. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Perfect!

  7. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    What is the Declare statement for Sleep and where do you put it?

  8. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    I googled it, don't worry about it

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
  •