User Profile

Collapse

Profile Sidebar

Collapse
aaronyoung
aaronyoung
Last Activity: Sep 29 '08, 08:19 PM
Joined: Feb 1 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • aaronyoung
    started a topic Custom Menu Bar similar to Window's Taskbar
    in Access

    Custom Menu Bar similar to Window's Taskbar

    Is there a way, in Access, to create a custom menu bar that can be used as the default menu bar that will, in essence, function like the Window's Taskbar?

    I would like the menu bar to show all currently open forms, and by clicking on one that form would get the focus.

    So, when the database is first opened, only the switchboard, or "Main", would be on the tool bar. Opening the various forms that are in the...
    See more | Go to post
    • aaronyoung
      replied to Custom Record Indicator not updating after requery
      in Access
      Thanks for the explaination. You got me on the right track, and explained why my method wasn't working. The code I ended up with is

      Code:
      Private Sub Form_Current()

    Dim rst As DAO.Recordset
    Dim lngCount As Long

    Set rst = Me.RecordsetClone

    With rst
        .MoveFirst
        .MoveLast
        lngCount = .RecordCount
    End With
      ...
      See more | Go to post

        Leave a comment:

      • aaronyoung
        started a topic Custom Record Indicator not updating after requery
        in Access

        Custom Record Indicator not updating after requery

        I have created custom navigation buttons and Record Number indicators on several forms that are used to review and update records based on a query.

        My On Current event to update the "Record X of Y" is

        Code:
        Private Sub Form_Current()

   Dim frm As Form, LastRec As Long
   
   Set frm = Forms!ReviewSearchRecordsForm
           
   If Trim(frm!txtRecordNo & "")
        ...
        See more | Go to post
        • aaronyoung
          replied to DoCmd.GoToRecord , , acNewRec
          in Access
          Hi - Thanks for the quick reply.

          Yes, it was working at one point, but after reading the link you posted, I guess I'm not sure how.

          At one point, I believe I had this loaded into an OnClick event, but decided on the BeforeUpdate so that if the form was dirty, it would force the user to either save or undo before moving to the next record (using the navigation buttons) and just confirming the desire to save the changes...
          See more | Go to post

            Leave a comment:

          • aaronyoung
            started a topic DoCmd.GoToRecord , , acNewRec
            in Access

            DoCmd.GoToRecord , , acNewRec

            I have been using this forum to answer many questions regarding an Access database I am building (my first attempt at something like this - teaching myself as I go), and I've always been able to find solutions. My problem now has been addressed in other posts, but none of the solutions given are working for me.

            The database will be used for tracking changes that I make to a customer's pricing, with forms based on queries that will...
            See more | Go to post
            No activity results to display
            Show More
            Working...