Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: chew1920
  • Content: Threads
  • Order by date
  1. chew1920

    Locate Conditional Formatting

    Is there a way in excel 2003 to locate all cells that contain conditional formatting? I have an inherited spreadsheet that has about 300 rows by 13 columns with varying levels of conditional formatting. Is there an easy way to find all of those cells without going one by one? Also is there a...
  2. chew1920

    Print button questions

    I have a flash presentation (CBT) that needs to have 2 print buttons, one to print the entire CBT, and one to print the last screen (certificate of completion). How do I make this happen? So far I have been able to get one or the other to work, but not both. Any help would be appreciated.
  3. chew1920

    Subform Control Focus

    I have a form with multiple subforms, and on each subform there are command buttons that I enable/disable from the parent form. When I have clicked one of the subform controls, I have the focus shifted back to the parent form which works fine, but when I try to disable the subform controls from...
  4. chew1920

    Nested Subform Question

    On my main form, I have a button that will lock and unlock the controls on the form. On one of my subforms I have a nested subform. I woul dlike to be able to turn off and on the AllowAdditions on the nested subform. I am able to do this on the subform, but not the nested subform...
  5. chew1920

    Active / Inactive data visibility in combo box

    I have a combo box that uses a list from a table that has both active and inactive rows in the table. I want the users to only be able to select active rows, but still be able to display records that are inactive when the combo box is not selected. When I use a query that only lists the active...
  6. chew1920

    Large Drop Down Lists

    I have a large drop down list of product numbers, and in that list there are a ton of products that begin with 0. Is there a way to allow the user to start typing the number and filter the selection list based on what was typed? This is being used on a request form where people are requesting...
  7. chew1920

    Large Drop Down Lists

    I have a large drop down list of product numbers, and in that list there are a ton of products that begin with 0. Is there a way to allow the user to start typing the number and filter the selection list based on what was typed? This is being used on a request form where people are requesting...
  8. chew1920

    Continuous Form as a SubForm Problems

    I have a Continuous form that I am using as a subform to display detail information. On that subform I have two check boxes, one that is dependent on the other, so I have written some code that changes the enabled status of the second checkbox. The problem is that it changes the display on all...
  9. chew1920

    Option Groups and Tabs

    I have an option group set up that has 40 choices in 3 different subgroups. I am running out of real estate, so I was wondering if I could keep the one option group but have it spread to 3 tabs, or if it would be better to have controls over lap and just change their visible status base one the...
  10. chew1920

    Subform cmd button

    I have a main form and a subform, and on my subform I have a command button that I want to be disbaled unless a button on the main form is clicked. The only way that I have figured out so far is to disable the entire subform, which is not what I want to do. Can someone please point me in the...
  11. chew1920

    Email file from users PC

    Is there a way to create a form that will allow the user to select a file from their computer and then submit the file and have it automatically emailed to a list of people? I have already gotten forms to work where they email a list of people, just not where I can attach a file to the email...
  12. chew1920

    Filter form using OpenForm from a cmd

    I have two searches that return the user to a summary screen, and when the user clicks on the row, it goes to a detail form. One of the searches is working and taking the user to the row by filtering the results, while the other does not apply the filter. Code that Works Private Sub...
  13. chew1920

    Sums and Percentages

    I am trying to write a report that has a column that is a count of the number of occurances that has a running sum total in the report footer section. With those two columns, I want to determine a percentage of the number of occurances for the one type divided by the sum of the entire group...

Part and Inventory Search

Back
Top