Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: USD $50.00 via Paypal. Complete database "filter","ammend",and "print-to-tearsheet"

  1. #1
    Join Date
    8th June 2011
    Posts
    15

    USD $50.00 via Paypal. Complete database "filter","ammend",and "print-to-tearsheet"

    With my limited VB knowledge, I have created a framework database with userforms for company acqusition targets. A user opens the file, and is greeted with the Database Menu contained in "Database Menu" worksheet, and is able to navigate different user forms from there.

    I feel pretty good about the userform ("CompanyInput"), however my filter database form ("filterform"), ("ammendform"), and ("print selected companies to individual tear sheet") macro within the filterform, are fairly incomplete. The following is what needs to be completed:

    1. Use the listboxes within the "filterform" to search the database and filter records accordingly, showing the results in the listbox at the bottom of the filter form.

    1.a. Ability for user to then select individual or multiple companies from filtered list and have all of the information for the selected company(s) populate to the template I created in the "tear sheet" worksheet. If more than 1 company is selected from the filtered list, they would all populate separate tear sheets, each on 1 page.

    1.b. Within the filterform, the entry fields for "annual sales","growth rate%","gross margin%", "operating profit %, and "# of employees", should be set up as a drop down menu selection, only including the available data already in the database. Sorted smallest:largest would be preferable as well.

    2. From the "ammendform", a user selects a company from the drop down menu, selects the "edit company details" button, and the existing data re-populates the "companyinput" form. From there a user can ammend any data, which would then overwrite the old entry in the master database.

    3. Minor Bug Fixes

    a.
    In the "companyinput" user form, restrict a users entry to only allow numbers & decimal points (no $,%,or letters) in the following fields: "annual sales","growth rate%","gross margin%", "operating profit %, and "# of employees".

    b. In the "companyinput" user form, when a user "adds a new item to list" for either the Products, Strategic Relevance, or Distributors categories, the new item adds to the list, which currently updates correctly, however all previous selections are then unselected. Not a big deal, but I wouldnt want someone selecting 15 items, realizing something is not there, adding the item, and then having to go back and reselect everything again.

    3. One final requirement...please no laughing at my previous code..as I said, this is my first week ever using VB, however I'm eating up too much time trying to crank through the more complicated items. Also, it would be great if whomever takes on this project would allow me to call them and give me a quick 15 minute run through of their code so I can try to go back and make sense of it later. Please get a hold of me with questions about the project and what timeline I can expect if you take it on. Please PM me with your phone number if you have specific questions. Thanks!

    Database.zip

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,639

    Re: USD $50.00 via Paypal. Complete database "filter","ammend",and "print-to-tearshe

    I will have a look and revert in an hour if I would be able to take this up

  3. #3
    Join Date
    8th June 2011
    Posts
    15

    Re: USD $50.00 via Paypal. Complete database "filter","ammend",and "print-to-tearshe

    Great, thank you!

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,639

    Re: USD $50.00 via Paypal. Complete database "filter","ammend",and "print-to-tearshe

    1.b. Here, the entry field has drop down to chose the operators like >,=,< etc, text boxes to enter the data. Do you want this to be changed to drop downs also?

  5. #5
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,639

    Re: USD $50.00 via Paypal. Complete database "filter","ammend",and "print-to-tearshe

    Also, what is the expected completion date or what is the amount of time you could give for completing this task?

  6. #6
    Join Date
    8th June 2011
    Posts
    15

    Re: USD $50.00 via Paypal. Complete database "filter","ammend",and "print-to-tearshe

    SMC,

    I would like the operators to remain as drop down selections. I would also like the text fields to be changed to drop down selections, however the source should be based only on existing data previously entered in the database. For example, if company x, y, and z with annual sales of 5, 10, 15, respectively, were already in the database, I would like the drop down in the filterform to only list those 3 available values as potential selections. If you think there is a better way of doing, I'm definitley open to suggestions. Thanks.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,639

    Re: USD $50.00 via Paypal. Complete database "filter","ammend",and "print-to-tearshe

    Done. Payment received. Thanks

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 3
    Last Post: February 9th, 2011, 21:12
  2. Replies: 2
    Last Post: February 1st, 2011, 15:47
  3. Replies: 1
    Last Post: July 22nd, 2006, 01:20
  4. Replies: 2
    Last Post: August 27th, 2005, 18:19

Bookmarks

Posting Permissions

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