Search results

To help me explain my filter, I have attached a screen shot of the form (see attached image). On the upper left of the form there are three Combo Boxes, each limits the data in the sub form by its respective value but Null values are ignored. On the upper right are the three Radio Boxes...

Yes, that is where I need help. I need to figure out how to combine the last three If Then statements into one with three OR's. I will experiment with it. I am certain it can be done but I just don't have the programming expertise to do it...

I have been working away on a form designed to serve up many combinations of data depending on what the form controls are set to. I have three combo boxes, each of which limits records when populated and returns all when NULL. I have three radio buttons which set the values for three text...

I have a very straight forward (I think) combo box that I would be using to look up a record in a form: 'Find Survey# Record Private Sub Combo201_AfterUpdate() If IsNull(Me.Combo201) Then Me.FilterOn = False Else Me.Filter = "Survey# = " & Me.Combo201 Me.FilterOn =...

I have been filtering a subform with two combo boxes without any troube but when I tried to add a third I started getting errors. Here is the code I have: Private Sub RunFilter() Dim strFilter As String Dim bFilter As Boolean bFilter = False strFilter = "" If...

I have a main form which allows for the viewing and entry of individual survey information and a subform which shows all the surveys for the location of that survey. These are linked by the location field but also share the survey# field. There may be times when one would need to navigate to...

I have managed to get my access form to carry values from the previous record entry forward but when I close and then re-open the form the default value has been set to the last value entered. I need to clear these default values when I close the form to make other features of the form work...

I have a query with totals grouped by date and by survey section and I am trying to include a column with the proportions these section totals are of the total for each date. The Totals are an expression sum of several fields. Date Section Number Prop A 1 # #/Sum(#) Where...

I've created a db using Access 2007, but saved it as .mdb format because a collaborator has Access 2003. I now discovered that all the action buttons I created with the button wizard are "embedded" in the forms, and Access 2003 can't run/access them. Is there any way of easily...

Yes, when I first created the subform by linking an unbound object to my query, Access did not create a form so there was no properties page except that which belonged to the control. When I used the wizard, Access did create the form and I was able to remove the navigation bars. Thank you.

I have seen a number of posts online regarding removing navigation bars from subforms, but the straightforward solution is not working for me. I am having an additional problem, with no "navigation" property on my subform property sheet. I select the subform tool from the toolbar, create an...

I am having a related problem, with no "navigation" property on my subform property sheet. I select the subform tool from the toolbar, create an unbound subform and link a query that gives totals for the linked record in the main form. Having done this before in Access 2003, I select the form...