Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    85

    Unanswered: Search Bar Access Report

    I have been having trouble creating a search bar. When i try to create a macro for it keeps saying error macro contains error or it just go through where i told it to look individually. This is what i did....

    I have a report with 52 different funds. They all have individual table and a graph. I but a text bar at the top of the report with a label saying "Searh". I went into properties and went to the ''event'' tab. ''On enter'' i clicked macro builder.

    This is what i have:
    searchforrecord
    Object type: report
    Object name: Fund Report (report name)
    Record: First
    where Condition: description=[Fund Name]

    when i begin typing in the name i want it to appear in the search bas as your typing in highlighted form. then once you hit enter i want it go to that part automatically so i dont have to scroll down to it.
    This is what my report template looks like:
    Header---------------------------------------------------------
    Search Fund_________________

    Fund Name
    TABLE _________________________________________________






    Chart/Graph_____________________________________________






    Chart/Graph_____________________________________________





    Now i have 52 of theses. So its a pain to scroll through. i want to have the search bar at the top filter through and give me the fund i wish to view. Let me know if you know how to do this or, if there is a better way of presenting the data
    Thanks,

    Mike
    ________
    Last edited by Mike02; 06-11-12 at 16:51.

  2. #2
    Join Date
    Jun 2012
    Posts
    85
    ok, so I still havent been able to figure it out, but, I believe im closer. I have now set up a macro to do this:

    FindRecord: [Fund Name]
    Match: whole field
    Match Case: Yes
    Search: Down
    Search as Formatted: Yes
    Only Curren Field: Yes
    Find First: No


    This is in my reports as mentioned before. I have placed a combo box in the page header. By having the combo box it allows me to begin typing in it and having the criteria appear as i am typing. Essentially im half way now. If anyone has any idea please let me know

    Mike
    ____________

Posting Permissions

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