I certainly agree that using the wizard to enter the values is a horrible idea. But if you have set up the lookup table, the wizard does a very good job of setting up a combo box and setting up the relationship. So, like many things, how you use it will determine whether it’s evil.
@Shadow.Dragon8 ай бұрын
Thanks for the informative video! I did not know you could "copy/paste" values into a table. I have always just typed them in... 😞 LOL!!!
@xavierbatlle18288 ай бұрын
😂😂😂 so do I!
@markfannin39758 ай бұрын
Pure gold! (yes, I'm a gold member, but if the shoe fits...). I don't skip around in your videos because you share great tips for using access. At minute 6:10 in this video you demonstrated how to copy from the expression builder into the new table column. Valuable tip for me at least. Thanks for another great video.
@erlenditland36698 ай бұрын
I get the point about usuing them for value lists, but are they still "evil" if you set them up with a table reference?
@donharrold13753 ай бұрын
Completely understand why you wouldn’t want lookup lists inside tables. However, I hear a degree of opposition against lookup functions using dedicated external tables too. Some people think it will corrupt the database. I don’t understand why? Can you explain if there are any risks with the better approach?
@shanebuckham7029Ай бұрын
Would love an answer to this too!
@easyspeak1018 ай бұрын
Just in case you happen to read youtube videos .. Thank you Richard for all the worked examples, much appreciated.. I find details hard to remember.. even if I work material, , it's an age thing for me or something...lol 👍👍
@RandalSullivan-n4b7 ай бұрын
Another great video, informative as always thank you!
@599CD7 ай бұрын
You're very welcome
@raphaelwanyoro94605 ай бұрын
Hello Richard. Can I send you a database project problem for you to break down and make a video tutorial.
@shailendrasoliya8 ай бұрын
Sir i have linked sql server with ms access in sql server table one field is varbinary (max) in which student photo are store but i am not able to upload photo on this field using ms access and not see photo on form and report Please make a video on this problem