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!

Register Log in
  • Congratulations Chriss Miller 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: *

  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

    Set field properties based on different field in form

    I would use Conditional Formating for those fields. I have tried in the past to use the on current and other events, but that only works for one row at a time, but changes the look of all of the rows. I just did a quick test using the conditional formatind, and that appeared to work. HTH Matthew
  4. chew1920

    Subform Control Focus

    When I open the form, I click the disable code that is listed below (this works fine), after that I click cmdEdit on sfrmName which opens a new window. I immediately close the new window, and before I click anything else on the subform, I click the disable button again and I get an error that...
  5. 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...
  6. 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...
  7. chew1920

    Active / Inactive data visibility in combo box

    After some playing around, I think that what I really need is for the listbox to have 2 different rowsources. I have tested using the GotFocus() and LostFocus() to switch between the different rowsources that will be needed, so that users will be able to see historical data, but if they want to...
  8. chew1920

    Active / Inactive data visibility in combo box

    When I use a query in the rowsource that is looking for active records, the rows from the main table do not show up in the list. I am trying to link based on the foreign key and then display the value associated with that record. TableA ID TableB_ID ----------------- 1 1 2 1 3...
  9. 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...
  10. 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...
  11. 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...
  12. chew1920

    Continuous Form as a SubForm Problems

    I am using a bound subform and I tried to use the conditional formating but it didn't allow me to use it on check boxes. Is there any way in the code to select one row in a continuous form and then modify just that one row?
  13. 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...
  14. chew1920

    Option Groups and Tabs

    Thanks for the help. I have decided to use toggle buttons and show and hide the different groups based on which button is pressed, that way I don't have to rewrite some of the code for what each option does.
  15. chew1920

    Option Groups and Tabs

    When the user first gets to the form, they see all of the options with one of them selected. The options are split apart by labels and creating the subgroups. The users like seeing all of the options on the screen to make it easier for them to enter information for multiple groups by just...
  16. chew1920

    Option Groups and Tabs

    Of the 40 options you can select only one of them. The options are divided into 3 types to make it easier on the user to find the proper selection. These types have no bearing on the data other than to help the user. Once any of the options are selected, common fields are modifed to display...
  17. 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...
  18. chew1920

    Subform cmd button

    Thanks for your help. Got it working now
  19. 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...
  20. chew1920

    Email file from users PC

    How do I save the file to the server, and how do I do that without everyone needing full access to the server?

Part and Inventory Search

Back
Top