Need to modify code below to be able to search entire database for term in table tblSearchTerm.Term field.
dim tbl as tabledef
dim fld as field
dim rs as recordset
for each tbl in dbEngine(0)(0).tabledefs
for each fld in tbl.fields
set rs = dbEngine(0)(0).OpenRecordset("Select " & fld.name & " from " & tbl.name & " Inner Join tblSearchTerms On " & fld.name & "=tblSearchTerms.Term")
if rs.EOF then
debug.print "keywords found in table: " & tbl.name & " field: " & fld.name
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…