Recent content by Sean91

Cheers, I'll have a go at it once I finish my other work :)

That's good at least it filters the report, is it possible to show all the results of the filter by clicking generate report or can you only show them in the report one at a time?

Basically you open up frmView, click search enter the search criteria and it filters the records (select asset type in combo and type PC into textbox...Just a simple example), then when i click the generate report button I want it to show only those records and not every record

Using this code on a button "generate report" I can bring up a report with all my records displayed. Private Sub Genrpt_Click() 'Open report DoCmd.OpenReport "rptassets", acViewPreview, , GCriteria End SubI would like to know, is there a way to modify this code so the report uses...

Other way around the records, the form is displaying to be shown on the report, hence the filtering of the records in the form

SELECT * FROM [IT _Assets_table]; It changes depending on the search criteria. Is there away to add a wild card?

Using the search button I made, I filter the results and then I have a button to generate a report but atm it just shows all the records and not just the ones left after i have filtered it, I would like to just see the filtered results on the report

In access 2003 is there a way to generate a report that only contains the records from a filtered form and not every record? Cheers

Thanks for the help, got one of the developers here at work to help me out Final code finished like this: Private Sub cmdSearch_Click() Dim GCriteria As String Dim txtSearchString As String If Len(Form_frmSearch.cboSearchField) = 0 Or...

I have added Dim GCriteria As String Dim txtSearchString As String Which has stopped all syntax errors but now it isn't reading the data entered in the text box "txtSearchString"

I have done a bit of searching but I can't seem to find why I'm getting this error 'runtime error 2465' Private Sub cmdSearch_Click() If Len(cboSearchField) = 0 Or IsNull(cboSearchField) = True Then MsgBox "You must select a field to search." ElseIf...

Thanks for the help I am still having a few problems with these lines 'Filter View IT Assets based on search criteria Form_View_IT_Asset.RecordSource = "select * from IT_Assets_table where [" & cboSearchField.Value & "] & GCriteria & " * "" Form_View_IT_Asset.Caption =...

Forgot to add using XP and access 03. The form that uses the search button is frmSearch which is accessed from clicking search on the View IT Assets form.

Yeah I'm using a combo box to select the field I wish to search

Here is a sample of the database