search and update
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: search and update

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    how would I create a button that basically allows a search to be made.
    activates the find action. asks for a user name (initials for example) and then number to be found in a column. then takes you to the requested row, and also updates the corresponding columns (eg Columns E - the word 'Active',F- current date,I - initials,J-the word 'customer')

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Open the Forms toolbar (View|Toolbars) and place the button control on the worksheet. Then assign a macro to the button that is going to perform all tasks you need. You have to be familiar with VBA.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com