Recent content by Sebbyy

The reason you may think the tables are screwed as all those queries are combinations of many tables. The base tables work well.

Ok - I needed to limit it to main mutations then redesign the multiple mutation part. Thank you.

19 times in the query that is record source of the child report. I should mention there is a subreport inside the child report as well, however, the linkage is working perfectly between those two.

SELECT Individual.PID, Individual.FID, Individual.OncogenomicsID, Individual.[Epi ID], Individual.[NSW ID], GenerationID.Generation, GenPositionID.GenPosition, Individual.Proband, GenderID.Gender, Individual.Age_at_last_update, Individual.Date_of_age_update, Individual.Age_at_death...

SELECT Fam.FID, Fam.Oncogemonic_Family_ID, Fam.FamilyName, Fam.SourceName, Fam.Article, Fam.JournalName, Fam.LabName, Fam.Contact, Fam.Pedigree_Attachment, Fam.CountryName, StateID.State, Fam.Descent, Fam.Comments_Family, Fam.Individual, Fam.Date_Edited_Family, Fam.FGID, Fam.Main_Fam...

I thought that was probably the problem after reading your post but I went back and none of the queries underlying the reports have duplicate FIDs. I think opens on the single FID then access freaks out and opens all????

See attached.

Hi, So I have a report and subreport linked on a long integer "FID" and I have currently got the main report set on a particular FID for testing purposes while I've designed it. However, when I added the subreport that is linked on "FID", access nearly crashes as it pulls every single record...

I think I might have got it to work with !FID

I have my report set to the me.txtFID but my debugger is pulling up an error on .FID. Should it be !FID?

Sorry, I've been busy and now had a go at this. I understand how it would work but don't get how to make the code to set the textbox to set the FID, output then cycle onto the next in code? Private Sub Command115_Click() Dim MyRs As DAO.Recordset Dim strPathAndFile As String, strDate...

I have had a go at this but i'm fucking it up. this is what i have. strFamilyName = List119!FamilyName strDate = Format(Date, "ddmmyyyy") strPathAndFile = "L:\Lab_NickH\Seb\Database Work\Family Reports\" & strFamilyName & " " & strDate & ".pdf" For i = 0 To List119.ListCount...

I'm quite new to using VBA so I don't really understand what you mean?

So I have a report that i want to auto output for all FIDs with the date attached in a PDF and I can get the main report to cycle through the FIDs. However I have subreport linked through FIDs to the main report which does not get the linked FID so my subreport ends up being 200 pages of data...

So I figured out that my subreport wasn't linking to my main report through the FID because apparently my FID is in binary data type in one of the queries and I have no clue how??