Search results

That worked....I appreciate the help. Thank You! Jim

I thought this may work, but when I try it the query returns all the data. I have several test records and one is showing 223 days open. When I run the query with 100 in Text105 on the form, I still get all records returned. I do not get any error messages. Any suggestions? Thanks, Jim

I appreciate the help, but I am not totally following your instructions. I am using a Value List of "Open";"Closed";"*". In the After Update event I have the following code Private Sub cbo_filter_AfterUpdate() Me.Requery End Sub I don't understand what you mean by Again, I appreciate...

That worked great! Thanks. If you don't mind, I have a followup question similar to this one. In this same query, I have the following field code. DAYS_OPEN: IIf([Status]="Open",(Date()-[Start]),([Complete]-[Start])) This calculates the days open. On the same form mentioned above, I want...

I have a report query (qry_Data) that contains a field called "StartDate". I have a report form (frm_Data) where I want to put 2 text boxes (Text101 and Text102). I want to create the Query Criteria code for the StartDate so that it will look for start dates between the dates listed in Text101...

As part of my job, each month I have to select 20 problem report resolutions and grade them on quality. Typically we have about 100 problem report resolutions per month. Is there a way I can use a query to return a random selection of 20? Thanks, Jim

I would like to build a filter on a form using a combo box. I would like the options to be "Open Records", "Closed Records" and "All Records". I already have a combo box that has the options "Open" and "Closed". This combo box is set to Open when a new record is created and the user selects...

It worked great. And I took the # out of the field name. I should have known that. I appreciate the help. Jim

I added a combo box to a form to go to the record selected in the combo box. Access added the following code to the AfterUpdate event of the combo box. Private Sub Combo37_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone...

Thanks...... Jim

It's not a subform. Just a regular form.

I have a form (frm_data) that shows my data (tbl_data) via a query (qry_data). One of the form fields is a combo box "Status". The options for the combo box are "Open" and "Closed". The query I the form is based on has a criteria to only show the Open items. When I change the status on my...

I know there a many posts about eliminating duplicate records because I did search, but I did not see anything that really answers my question. I have a query in a local Access database that is using a Linked table from an SQL database managed by our corporate IT department. I have read access...

I have a report with 2 headers that contains the following fields [resp_group] [resp_team] I want my report to have a page break so that each [resp_team] report is on a separte page. I went into Sorting and Grouping for the [resp_team] header and tried several options with the "keep together"...

I have a report which is sorted using a group header. Beside the group field in the header, I would like to show a count (total) for each group. I tried usin a text box with the control source being =Sum[resp_user_group_cd] and also tried =Count[resp_user_group_cd] but neither seems to work...

I understand what you are saying except this part I don't know how to do that and can you export them as PDF? If so, how? Thanks, Jim

I don't know if this is the right place to post this, but here goes. I have 4 reports in an Access database that I alone run. I store the database on a LAN that out group alone has access to. However, I need others who do not have access to our LAN to view the reports. So is it possible to...

Thanks Bob. What if I have several combo boxes that I want to apply this functionality to on the same form? How do I set the form's On Current event since it would involve multiple combo boxes. Below are two examples; cboBox1 Yes = cboBox2 Visible cboBox3 Yes = cboBox4 Visible cboBox5 Yes...

Is there a way I can make a field (combo box or text box) visible on a form only if another combo box on the same form is set to a certain value? For example, lets say I have a combo box (cboBox1) on a form and it's possible values are "Yes" and "No". I have another combo box (cboBox2) on...

Thanks. I did not know this. It works now. I appreciate the help. Jim