Is this your uni project or did you steal it

it looks like you've just pulled a bunch of files from somewhere and glued them all together, you are miles away from getting this working because not even your control names are lining up with the code, which makes me think (hush hush) are you cheating .........

Your going to have get a few things sorted and some information on a piece of paper before you will finish this or even get it working ............

If your code says 'Control1.text' you better have a control called 'Control1'.... not only that it needs a 'Text' property (likely a textbox, but could be a few things), what are they teaching in uni these days?

Your using a database and yet you dont understand what a query string is...hmm OK maybe you use the wizards (excel/access), Look in your code (you posted above) 'Function QueryData(Src, OutputRange)' The Src here is going to have a query string or some procedure call, you need to see what is passed through this variable...
if its "Select..........." then this is the SQL string. you need to write is down somewhere and list all the names between SELECT....FROM, these are columns of data, they are seperated with a comma, if you see SELECT Tbl.Col As NewCol FROM... this is Field (Col) but its being renamed to Field (NewCol).......

Now you can link all the data to your forms, sheets whatever easily you now have all the names corrected and a list of fields to map.......

no point doing anything until this part is fixed..


Paul S.