Search results

Dear all Thank you so much for pointing me in the right direction. I looked at the references from the original database, and replicated them. I also changed the Dim statement as advised. Worked first time.

Greetings, I only use MS-Access occasionally. I wrote some querydef/recordset to iterate reports for single institutions some years ago and tried to dust it off for a new project. I am trying to iterate writing totals to individual spreadsheets. I seem to have got the first section working...

Dear all I am trying to match records in two tables (tblNicksExtract, xlatest) using four fields. In both tables there are alternative soundexes, dates of birth, patient numbers, and I may also substitute further matching criteria, such as postcodes. In all there may be a hundred or more...

Another work around: My main form is now based upon the table. My sub form now has a header with a text box with the formula: =Max([sampledate])+84 Changed the subform to continuous. Added On Load to main form Private Sub Form_Load() Me.sbfMonitoring.Form.FormHeader.Visible = True End...

Uh oh! This is not a good work-around. Because my form is based upon a totals query, I can't add a new record. Back to where I started. Mark

I had a similar problem but found a work-around. Scenario: I have a database of at risk Health Care Workers, with a subtable of dates and results of tests. I needed to generate a date twelve weeks after the maximum date entered for each HCW. No problem. I added a text box to the footer of...

I realise this is a very old thread, and I'd be very interested in looking at the vba solution. I have a similar scenario, where I need to compare an existing value with changes and produce a report. Below is a simplified version of my rather basic solution. SELECT tblNewVersion.UniqueID...

Hi I'm Mark I have about ten years experience using Access, sometimes delving into vba. I think I belonged to this forum in the past, and look forward to a) standing on the shouldersof others, and b) maybe contributing where I see something relevant. Thanks for reading Mark