Make Records in an Access Cross-Reference Table with VBA
Do you have multiple values in a field that you can't sort or group by? Separate values into their own table and add cross-reference records quick and easy using VBA code you can download from MsAccessGurus.
Microsoft Access is most helpful when your data is normalized. Use this free code to help you get there.
(00:21) explain application I'm developing to manage my website
(00:44) HTML tags
(01:10) category
(01:48) filter
(02:30) The problem is the multiple values.
(03:03) Table1.
(03:07) TextField1
(03:12) Pk1
(03:16) Table2
(03:22) TextField2
(03:27) Pk2
(03:31) TableX
(03:38) relationships
(03:54) Here's the module, with all the magic code.
(04:01) fill in your table names and your field names
(04:20) message box that its done
(04:50) data needs to be refreshed
(04:53) Quick Access Toolbar, QAT
(05:17) The code looped through each record in the Tag table.
(05:25) and added each value to the category table
(05:43) record created in the cross-reference table
(07:04) To Access, upper and lowercase are the same.
(07:26) edit just one value and the change will ripple through
(07:38) count how many tags are in each category using a Totals query
(07:59) download from MsAccessGurus.com
(08:40) Let's connect
(08:50) I hope you this helps you normalize your databases.
~~~
Download the VBA code
VBA -- Data -- Make Cross-Reference Records
http://msaccessgurus.com/VBA/Code/Dat...
~~~
video: Quick Access Toolbar (QAT) -- Customize and Share
• Quick Access Toolbar (QAT) -- Customi...
Download my Quick Access Toolbar from MsAccessGurus.com
http://msaccessgurus.com/tool/QAT.htm
For remote training, let's connect! Email Training AT msaccessgurus.com
Visit my website for free code, tools, articles, and consulting
http://www.msaccessgurus.com
Please share your comments, thanks.
kind regards,
crystal
Remote Training and Programming
Let's connect and build your application together!
http://msaccessgurus.com/training.htm
#database #Cross-Reference #Records #VBA
#microsoft365 #microsoftaccess #access #MadeWithCamtasia
#training #msaccess #remotetraining #elearning #tutorials #videotutorial
@YouTube @Microsoft