Recent content by DuckyMinotaur

Dim qdf AS DAO.QueryDef Set qdf = db.QueryDefs("previous query") qdf.Parameters("[Forms]![Form]![Date_from]") = [Forms]![Form]![Date_from] qdf.Parameters("[Forms]![Form]![Date_to]") = [Forms]![Form]![Date_to] Set rs = qdf.OpenRecordset(strSQL) maybe something like that, though I'm new to vba so...

Hi, I'm using the following vba to calculate the Median, and the Median Absolute Deviation Public Function DMedian(FieldName As String, _ TableName As String, _ Optional Criteria As Variant) As Variant ' Created by Roger J. Carlson ' Terms of use: You may use this function in any...

I've found out how to do it now I have something like Private Sub cmdMatchRecord_Click() a = form.subforma.fielda form.subformb.fieldb = a End sub I originally had the user having to copy and paste the data from one to the other and wanted to make it more user friendly

I can't upload my data :/

The problem is that the data was manually entered elsewhere and so there is errors that a human can pick up a lot easier so it needs to be a manual match

That's what I've done for the first one, but the user needs to manually match the other records, I was just wondering if there was a way to make it more user friendly?

Hi guys, I have a database where records from two tables can only be matched automatically if certain criteria are met (e.g. the name is the same and the D.O.B is the same ect...) I have a query that matches these records together if all criteria are met (this is done by copying the primary key...