Search results

Now my DB is very nearly finished, I have had a last minute request to integrate a filter to separate out 4 departments involved. Currently the data in my reports represents all 4 departments. Do you know if there is an easyish way to create a filter from my menu screen to apply to all my...

Thank you, that's great, I'm still working on what the report will look like exactly, but now all the info is there its just a case of making it clear to read then building in a name filter. How did you manage to get the overall size of the database down so much too? It was getting fairly big...

Thank you, that should be everything in there now, but if it is not very clear (I will need to tidy up the format) the report needs to hold everything that could be entered in frmNewStaffEntry, to give a 'full staff record' as such. Many thanks

I have spent a fair amount of time learning/building my subreports, which although is not particularly attractive, it is holding most of the right information. However the problem I am having is that when I add a new record, the relevant subreport is updating to show this, but also duplicating...

I didn't even know that option was there! Thanks very much. Only the 3rd option would work. I had caused a slight problem by having a field from another table in the query, but removed that and it's all fine. Because I have related information stored across a number of tables, should I query...

Thanks Bob, The menu now only appears when the print preview is closed, rather than every time the filter is applied. I also had to change my open report command button to open in acViewPreview rather than acViewReport

It seemed that I was opening my report in report view, yet the filter was set to open it in print preview, so it was the changeover that was causing the menu to open. I am now trying to make another report to show all information related to each person stored in the database, the report...

Thanks Bob, I have had a good go at making this work but I am fairly new to access, especially coding, and have not managed to make it work yet. I made a new module: Option Compare Database Public blnNotOpenMenu As Boolean ---------------- Put this at the start of my filter: Option...

Hi everyone, I am having a few problems with a report which is filtered by a form which I have been unable to find a solution for. My report has an On Close event to open my main menu form, but this is being triggered by my filter command, ie- applying the filter seems to close and reopen the...

The DoCmd is in On Close of rptInstitutions Private Sub Report_Close() DoCmd.OpenForm "Menu", acNormal End Sub

I have a DoCmd to open frmMenu, which does work fine, but it is also being fired when I filter the report, almost as if Access closes and reopens the report to apply the filter

I also have rptInstitutions which On Close opens frmMenu, but this On Close is being triggered when a filter is applied through frmReportFilter, so I end up with my filtered report (good), frmReportFilter still open (fine) and frmMenu (not fine in this instance). Is there a way to make frmMenu...

I'm guessing this is bad practice... It is on a report, would it be better instead to add a print button to frmReportFilter? I would like the print button to open the window you get if you go menu > print > print, so the user can select the right printer / number of pages etc.

The remaining combo boxes have thankfully all worked, I tried adding a cmdPrint button to my report, but it was not allowing any print options, as it was just throwing the report straight to the (wrong) printer. I found the following module which I was hoping to use which should bring up the...

It works! I had looked at the 'str' bit before but thought it was just a necessary bit of code that I hadn't seen before, I had not properly adapted the example you gave me. I'll try creating queries for the other two combo boxes to check they are ok

The report needs to show 8 fields, although I only need to be able to filter on 3. I ran the same SQL in a new query, created a report from that, then changed the filter coding to use that, and still got the same error. I haven't changed any field names, and everything is spelled correctly...

I prefer this option, seems simpler so I might try that. SQL to the best of my knowledge (this is the first time I have accessed SQL) is: SELECT tblCountry.txtCountryName, First(tblInstitutions.txtInstitutionName) AS FirstOftxtInstitutionName, First(tblInstitutions.txtCity) AS FirstOftxtCity...

I am not sure what to do with this code? I have applied the code you gave me, and changed a few of my field names to make it clearer. My code is now as follows: Option Compare Database Private Sub cmdFilter_Click() On Error GoTo Err_cmdFilter_Click Dim strSQL As String Dim stDocName As String...

You will have to evaluate each control and add it incrementally to the WHERE clause of the query that supplies data to the report. Thank you. Unfortunately I don't know where to get started with doing that! Would you be able to give me a few more pointers?

I have created a query and report, which I now want to be able to filter from a form, which needs 3 combos to select. I have found the microsoft support example, which I have been trying to modify, but I just cannot get it to work. I get the error "Run-time error '2465' Microsoft office access...