Recent content by TheWedgie

Using Word 2007, is it possible to have repeating rows in a table as part of a template. For example, in the document below, I'd like people to be able to enter any number of crewing details, but only have the document show the table rows where there's data - whether this is by hiding empty...

Here's the test code, needs a bit of tidying up, but it works! Thanks again DCrake! Private Sub Command117_Click() Dim dbs As Database Dim strSQL As String Dim strQueryName As String Dim qryDef As QueryDef Dim EventName As String EventName = Forms!frmEventReport.cmbEventName.Value On Error...

Yeah - what I've been doing is creating Forms & Reports based off a test event table filled with data, then changing the RecordSource stuff... As an aside, this is how retarded the previous guy was - half the field names have spaces and slashes in them!

Looks like it could be a winner - thanks, will have a play. Assuming I basically use the Querydefs to create the query, and set my report's RecordSource to the Query name..?

Howdy all - is it possible to create a query with a dynamic RecordSource that can be changed on load? Basically I've taken over an event medical centre management DB from a retard, and it currently creates a new table for each event - so all my reports/forms that I've added to make it work have...

Essentially yes - but the messing around I've done it seems to print a row for each instance of each SecondaryCondition. ie i get "Headache" appear three times if there's three Headache cases - rather than just once with a total next to it. (I've got the DCount working fine, it's just that the...

Yeah - I think where I'm getting stuck is how to get it to dynamically list the fields from the SecondaryCondition table - then do a count based on what those fields are (ie if we delete or add one of the conditions, then the report list changes). As much as I'd love to restructure it, it'll be...

I have taken over a database for a mobile medical centre, and need to add a report summarising each event they attend. - Each event has its own table (easy enough to set the recordsource on loading the report). - Each patient record in that table has a "PrimaryCondition" and...

Excellent, that works well DevastatioN. I haven't bothered with OrderBy, as I've used the DLookup results to set off another Search/Filter function that was already implemented, and that'll do for now. Thanks again for your help.

Thanks, looks like I can do an OrderBy with ELookup, will have a crack later tonight.

Woo - it works, thanks DevatstioN! Here's what I'm currently using: If DLookup("[Job Number]", Me.RecordSource, "[Family Name] ='" & Me.Family_Name.Value & "' AND [Given Name]='" & Me.Given_Name.Value & "'") > 0 Then msgbox "It Exists" End if Any ideas how I can get it to return the highest...

Ahh, that makes a lot more sense - the Primary Key thing was getting me confused. At work today so will try it out tonight, thanks!

Couldn't get either of these to work - first one didn't make sense as I want to find any records where both first name and surname are the same as what was just entered - there is no PersonID field (or anything resembling it). The second one didn't like not having tblPersons (and everything I...

No worries :)

And you'd be 100% correct. I have no idea why the guy before me did it like that, but until I get the time to redo it from the ground up, I'm getting the critical features and GUI working. (As background, it's a medical triage system used for event medical services, so for some reason he's got...