Search results for query: *

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 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

...Me.sfrmCAS.Form.cmdEdit.Enabled = Not bLock Me.sfrmCAS.Form.cmdDelete.Enabled = Not bLock Me.sfrmCAS.Form.cmdAddNew.Enabled = Not bLock '*** Error Right Here Me.sfrmName.Form.cmdEdit.Enabled = Not bLock Me.sfrmName.Form.cmdDelete.Enabled = Not bLock...

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...

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...

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...

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 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?

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...

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.

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...

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...

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...

Thanks for your help. Got it working now

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...

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