Search results

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??

So with my report that is unlinked to a particular FID until the script, when i just open the report by itself and give it a FID, the subform does not link to that FID? Does that make sense?

So I have got the code working but my report was originally being generated by choosing from a combo box on the main menu for what FID to display. So I made duplicates of the report and subreport and their corresponding queries however, the link on FID between report and subreport is broken and...

Thanks alot for this. Something like this? Private Sub Command115_Click() Dim MyRs As DAO.Recordset Dim rpt As Report Dim strPathAndFile As String, strDate As String strDate = Format(Date, "ddmmyyyy") strPathAndFile = "L:\Lab_NickH\Seb\Database Work\Family Reports\" &...

So i have a report in my database which is generated by FID, and i would like for a button that I can use to export a PDF for every ID to a designated folder named by the FamilyName associated with that FID? Is this possible with VBA? I'm not great at coding? I know how to get to...