Search results for query: *

Thanks so much for your help. It works great.

I have a mailing label report that opens after the user determines certain critieria to include on the mailing label. In addition to selecting the information they want to see on the label, I would also like to provide the user with several formatting options that they can choose. For example -...

Thanks for the suggestion. I appreciate the time and effort. In the end this is how I solved the problem. In my query I created a field called TaxAmount TaxAmount: CCur(Nz([taxrate] * [Cost] / 100, 0)) As you had suggested I had the TaxRate as a bound field on the form and now also TaxAmount...

I have a continuous subform that is used to input items and costs. I want to create the subform so that the user can EITHER enter a tax rate and then have the tax amount automatically calculated (ie [taxrate]X[[Cost]/100) OR if the user prefers, to just enter a total tax amount leaving the tax...

I believe I need help in contructing an Insert Into statement. Here is what I am trying to do. I have a main form and subform. The main form is used to identify a specific event, while the subform is used to develop an event specific budget. When I link the master/child fields to "EventID"...

I too am trying to use a filter on a subform. On the subform I have an option group which is used to filter records alphabetically (since there are potentially hundreds of records.) Through much trial and error I have gotten most of this to work (and who really knows if I am doing this right)...

I am attempting to add command buttons to a main form that control both the actions on the sub form. For example I want to add a delete button on the main form that would delete a record on the subform. Equally, I would like an UNDO button on my main form that would undo a record on the subform...

Thanks to all for responding. I tried all suggestions including decompiling and then recompiling. No luck. I finally tried the same procedures with another form and subform and it worked. I then recreated a whole new form replacing the subform that was problematic, this seems to have worked...

When I close a form using a command button on the form Access shuts down saying "....Access encountered a problem and needs to close......". This error does not occur if I use the close action in the toolbar or on the menu. My form is comprised of a main form and a subform. What am I doing...

I am having a problem getting a subform's filter to work properly. I have a from called "Phone" and a subform called "Phonesub". On the subform I have an option group called LastNameFilters that contains alpha buttons. As a subform everything works great. As expected, when an alpha button is...

Duane; Just wanted to let you know I finally got this to work using the following code. Dim ctl As Control For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acLabel ctl.FontName = [Forms]![LabelsDialog]!SpecificEvent.FontName I appeared to just be missing...

I have unhidden Text40 and renamed it "SpecificEvent". SpecificEvent does not show a font name. It displays the results of the Select statement used to create the records in the drop down list in cboEventData.In the properties section of this control the FontName is Tahoma The Select statement...

No matter what I try i cannot get this to work. On my form I have the following: - an unbound combo box called cboEventData that is used to identify a parameter for my report. -I have a text box "Text40" that is hidden. Text40 has as its control source the results of the selected choice from...

One last try. When you said in your last message you added a control cboEventData with a value of "Arial" what exactly do you mean. Is the control source set ="Arial"? How the control is set up on my form is the only potential difference I can think of. The report I am trying to change the...

Thanks for the quick response. I respect your opinion on providing this functionality and on the whole agree. There are however, selected instances such as mailing labels, and a few reports that will be distributed to others where this functionality and ability to personalize is important. I...

Hi Duane; Thanks for the response. This is the second time you have graciously responded to my requests for help and have offered advice to me. It is greatly appreciated. Anyways..If you will bear with me me I will try to execute your suggestions. Part 1 - Loop through the controls on the...

Is it possible to have the end-user select/change the font style, font size etc. used in a report when the end-user can only preview or print selected reports? I have a series of predefined and formatted reports. The end-user chooses the report they desire and then can both preview and print...

Thanks to all for responding. I really apprecaite the different suggestions and solutions. It makes life much easier. I went with the following code behind a command button called "Clear all Criteria" located at the bottom of the form Dim ctl As Control Dim Response As Integer For Each ctl...

Thanks so much for the response. It sure does the trick. I would however, like to understand the code you have furnished and how it works. What does strWhere = "1=1 " mean? I am not sure how the code you provided in fact is setting the parameter to either the value chosen or if null --all...

Thanks so much! Your solution works great