Compare Column Headings to Saved Data

[MacroAlan]

In our application, we save the scheme of the headings when a file is copied in for possible later re-use. That part is working splendidly.

Now I am opening a new file and want to compare the headings on this file to those that were saved. I find the exact row with a DLookUp.

ScemNum = DLookup("SchemaID", "Schema", "SchemaName=" _
   & chr(34) & cboChooseSchema & chr(34))

And the SQL to get the saved headings

SELECT Schema.SchemaID, Schema.SchemaName, Schema.MapTo_Description, Schema.MapTo_Category, Schema.MapTo_Family, Schema.MapTo_Name, Schema.MapTo_Publisher, Schema.MapTo_Version, Schema.MapTo_FileName, Schema.MapTo_AssetID
FROM [Schema]
WHERE (((Schema.SchemaID)=89));

89 is the number derived in ScemName.

Do I need afunction, SQL, RecordSet? What? Am I asking for the impossible? A code starter would help.


Alan

It is easier to apologize than ask permission!

 

[Crowley16]

you could either open 2 recordsets and start comparing each value in each field between the 2 recordsets

or

you could just concatenate all the fields together into 2 big strings and compare those strings...

--------------------
Procrastinate Now!