can you use webbrowser control?
see sample db in post #12 of this thread:
https://www.access-programmers.co.uk/forums/threads/access-product-catalogue-website-style.333196/
SELECT tblHousehold.ID_Household,
tblHousehold.[Family Surname] AS [Household Name],
tblHousehold.[Family Address] AS [Household Address],
tblHousehold.[Family Phone] AS [Household Phone],
(select top 1 Person_First From tblPersonal Where ID_Household = tblHousehold.ID_Household And...
Date format is not an issue.
the problem are those people, not having guidance as to the Basics of
Ms Access.
It is a good advice to Read the Manual first before you try to Operate.
alternative use tLookup() and other domain lookup alternative:
https://www.access-programmers.co.uk/forums/threads/replace-dlookup-with-as-sql-query.319710/#post-1787342