Search results for query: *

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

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

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

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

I have a form with a series of unbound text boxes and combo boxes that are used to set the query parameters for a report. Once the user chooses the criteria from the various boxes, the desired report opens in preview mode. The text boxes used are for capturing beginning and end dates and use a...

I have a form with a series of unbound text boxes that are used to set the query parameters for a report. Once the user chooses the criteria from the various boxes, the desired report opens in preview mode. I want to add a command button to my form called "Clear" that would be used to reset...

How do I change my query so that it recognizes <ALL> when <ALL> is the choice selected from an unbound combo box on a form? On Form1 I have 3 unbound combo boxes that are used to set the parameters for a report. Using the following union query, I added all to the combo box called Occassion...

Can someone please provide some coding help. I currently have a form, that in the header has an unbound multi-select list box. I also have a command button that is used to take the names selected in the multi-select list box and when clicked, automatically populate the fields on the form so...

I am having a problem with defining the appropriate query for a form (Form2). This form is used to create an event specific mailing list. Form 2 is a filtered form that automatically populates with the mailing list names based on selections made in Form1. Form 2 should allow the user to input...

I want to automatically set the checkbox value of field called "Invited" to true, if another checkbox on the form called "selected" = true. I have tried If ((Me.Selected=True)) Then Me.Invited = True Nothing happens. Any suggestions would be greatly appreciated.

I want to open a form to a blank record but I do not want to allow additions. My form has a list box in the form header that is used to restrict records shown on the form. When I open the form I want just the list box to show without all the records from the list box showing below in the form...

I have a form called CreateMailList that consists of a multiselect list box,two fields (MailingListNameID and MailingListName) and a command button. The Command Button is being used to restrict records shown on the form. This finally works great.(Thanks to the help of others) I now want to add...

Is it possible to automatically have a selected check box revert to an unchecked state when the form is closed. If so how would you do this? Any suggestions would be appreciated

I am not sure if this is a table structure issue or if I am just being clueless... but here goes. I currently have three tables in my database. Table1(tblPerson) includes all info about the person including PersonID, LName, FName,Address, MLName(MailingListName)etc. (NOTE: MLName can refer to...