Search results

Thanks David - I'll give this a try.

Sorry Atomic Shrimp - I'll be more explicit. These are numeric fields. I have a form that collects data on the age of individuals. If for example they are aged 4 then they would enter a value of 1 in the 0-5 field, if they were 10 they would add a value of 1 in the 6-10 field ... and so on...

Hi All I have a report that has several fields on age: 0-5, 6-10, 11-13 etc. What I would like is for the field with the greatest value to be highlighted in the report. Is there a simple way to do this? Many Thanks JP

If I understand this right ... You want to open a report where the report is filtered to only include records Matching same Reference Number on the form. You can do something like this: In your form create a command button then add the following code to the on Click Event. DoCmd.OpenReport...

I found what I was looking for. I modified the code for the combo box example - see below. Public Function Update_cbSelectFile() On Error GoTo Err_Update_cbSelectFile Dim sPath As String Dim sFileList As String Dim sFileName As String sFileList = "" sFileName =...

Hi All I've just been looking at this great example on file browsing (as produced by ghudson) and wanted to use one of the examples - either fScanDirSelectFileFromCombo or fScanDirSelectFileFromTable...

Thanks Dennisk I used the unique compound key idea.

Hi All I have two tables - Services and Performance. Services is a list of Service details and Performance contains performance data on the Services. They are linked by the Service_ID. The Performance table has fields for year and quarter. So, in theory, I can get an overview of how a...

Hi JR I'm not sure this is going to work - I assume I would add the Report_Open code to the Main Report and not the Sub Report? My aim is to filter the main report to only show Services that contain indicators from the filtered Sub Report. Hopefully this makes sense?

I have a an open report button which contains the following code: Dim stDocName stDocName = "rptServices" DoCmd.OpenReport stDocName, acViewPreview, , "Service = '" & cboService & "'" In the above case 'Service' is a field in both the form and the report. This is the bit that works. I...

Hi All I have a report called Services. Within the Header I have a Subreport called Performance_Indicators What I would like to be able to do is filter this subreport report using a combobox from a form. I can filter the main report using this method but not the subreport - can this be done...

Thanks tarcona. That is exactly what I needed. Also, I've just learned a bit about using DAO - which was a bonus! Many Thanks Again :D JP

Hi All I have an Access 2000 Database that has been secured using user groups. When you open the database it asks for a name and a password. I want to see who is adding information to the database. Is there a way to add the Name of the user to tables in my database. E.g. If they add a...

Filter Report Using Form - solved I had to change my method - rather than running a macro I used vba code instead. I had a form with three combo boxes: cboQuarter that contained the values 1 - 4. cboQuarterCriteria that contained the values =, >,< cboMonitoring - this was populated with a...

Hi All I have a macro that I use to open a report using a filter from a form. On the form I have a combo box called cboQuarter. In my macro I add the following to my where condition: [Forms]![frmReports]![cboQuarter]=[qryOutputVariance]![Quarter] This works fine and what I get is a filtered...

Hi Bob Thanks for that - I changed the code to your suggested line and it works a treat. Can you talk me through how this works : stSubject = Nz(rsEmail.Fields("Intervention").Value,"") Cheers JP

Hi All I've robbed this code form this forum - thanks v much. And I can get it to work if I put "" marks around stSubject on the DoCmd line. But I don't want people to see "stSubject" but rather the content of stSubject. How can I do this? Sub test() Dim rsEmail As DAO.Recordset Dim...

Thanks Tim Sometimes I try and charge in forgetting about the basics! The tables that feed the sub form and main form are now linked together so the sub form shows all the correct info. (I didn't get the figure 8 though - I'm using access 97 - so I'm guessing that's not a feature it has?) It...

I feel like I'm being a bit thick here - hopefully this is the case and this is easy to do. I have a Subform that is linked to a Mainform by a unique key field [FinanceCode]. The sub form shows all the records that are linked. What I want is to, when I click on the create rew record button...

Is it possible to filter a combo box to display only those records available after FilterBySelection has been applied? If so how would I go about it?