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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.