Topics Search

Filter a continuous form

Filter a continuous form
Views: 60
I am trying to filter a continuous form to show only records between two dates. On the form I have a field call ScheduledStartDate and two text boxes one call txtStartDate and the other named txtEndDate. I allso have a command button named cmdApplyDateFilter with the following code.

Private Sub cmdApplyDateFilter_Click()
Me.Filter = Me.ScheduledStartDate = " Between #" & Me.txtStartDate & "# and #" & Me.txtEndDate & "# "
Me.FilterOn = True
End Sub

It 'appears' to work but returns no records when I enter a date in each of the ext boxes. The dates are in a valid date format similar to 0810/2011 and 08/31/2011

I know for a fact that there are records that fall into this date range
Sponsored Links:

More topics

 

Clear records off of continuous form

Preview
Im trying to find a command to clear all the records on a continuous form that were called up using a strWhere Filter and combo boxes.

There are four unbound combo-boxes in the header that the user can choose from and then I have a command button coded to filter (Me.FilterOn) for those criteria.
The matching records display in the details section of the form (continuous-style).

Is there a command to reset the details section of the form to be blank? Ive tried refresh, requery, repaint, etc. All of these leave the previously queried data. Removing the filter doesnt work because that display all the records. I basically want the form to look exactly the way it did when it was first opened.
 

Filtering a Continuous Form

Preview
I have a basic continuous form in Access 07. It has the following fields:
Serial #, Part Number, Model #
I want to put combo boxes in the header to filter the form. I have a combo box for each field. I named them:
SerialSearch, PartSearch, ModelSearch
The combo boxes are based on tables to automatically update when a new serial, part, model # is added. So, I got this far, so now I have a continuous form with three combo boxes in the header. I can select a value from the combo boxes. I have tried to put in code for the filter. It will filter perfectly in the ModelSearch combobox, but the others will not. Attached is my database. If someone could please take a look, it would be a great help. It will open to the form that needs
 

Filtering a continuous form

Preview
I have a basic continuous form in Access 07. It has the following fields:
Serial #, Part #, Model #
I want to put combo boxes in the header to filter the form. I have a combo box for each field. I named them:
SerialSearch, PartSearch, ModelSearch

The combo boxes are based on tables to automatically update when a new serial, part, model # is added. So, I got this far, so now I have a continuous form with three combo boxes in the header. I can select a value from the combo boxes, but I have no idea how get these to filter the records. I would like to be able to enter values into multiple combo boxes and have it filter, or when the combo boxes are blank, I would like it to show all records.
 

Filtering a continuous form

Preview
Wow, I feel like I'm loosing my mind at the moment! I have a basic continuous form in Access 07. It has the following fields:
Serial #, Part #, Model #
I want to put combo boxes in the header to filter the form. I have a combo box for each field. I named them:
SerialSearch, PartSearch, ModelSearch
The combo boxes are based on tables to automatically update when a new serial, part, model # is added. So, I got this far, so now I have a continuous form with three combo boxes in the header.

I can select a value from the combo boxes, but I have no idea how get these to filter the records. I would like to be able to enter values into multiple combo boxes and have it filter, or when the combo boxes are blank, I would like it to show all records.
 

Filter a Continuous Form

Preview
and have been trying to find a way to filter a continuous form using a combo box.

The database only as one table called Students, and the field that I use for the combo box is called TTS_Class.

What I want is when I open the continue form (called Student_attendance) that I use the drop down to display only those students that are in the selected class.

I have tried different methodes and just cant figure it out
 

Creating Filters on a Form

Preview
I have a form which has the following fields:

StrContactNo, StrLName, StrFName, StrAddressLine1, StrAddressLine2, StrParish, StrMale, StrFemale

The form is continuous and is a pop up form.

I would like to filter the data by Last Name on the form so as to the view a particular person rather than having to scroll down the list.

I tried the filter option which on Northwind database and cant seem to get it to work, I tried this link . not working, and several others on the internet cant seem to get the filter to work
 

Generating graph from continuous form

Preview
I got a continuous form (referred as Form1) which has a dropdown and a few textboxes to generate a filter for the from. There are also two command buttons, one for filtering the data, one for generating a graph in Form2.

The problem is with generating the graph. I'd like to use the form's filter for bounding the graph's data. So records shown in Form1 must be used for the new graph (Graph1 in Form2). Isthere a way to copy the filter to the new form or use the data?

I know that this is explained quite weirdly, but I cannot think of another way at this moment.
 

Form Filter "Missing Data" Using VBA

Preview
I have a continuous form and some of data is missing. (I'm making a Contacts Database). How would I filter out the missing info using the "Form Filter" feature. P.S, I want it so that when I click an option button it filters.

Private Sub Option25_Click()
Me.Filter = " "
Me.FilterOn = True
End Sub
 

Filtered Reports & Continuous Forms

Preview
I have a continuous form with controls in the header that filter the records. However, this doesn't seem to effect the underlining query (RecordSource=query) as in, after running the filter, the underlining query still shows all records even though my VBA uses my query. How do I then create a report that shows the filtered results?
 

Get position of record in continuous form

Preview
I have a continuous form that displays various data. I have a button on the form that opens a popup form, displaying content relevant to the current record in the continuous form. I would like this popup form to appear directly below the current record in the continuous form, if possible. I tried to use .Top property of any of the controls in the continuous form, but the .Top property is 0.

How can I get the screen position of a control for the current record in a continuous form?