How to Use the Immediate Window in Microsoft Access
HTML-код
- Опубликовано: 2 окт 2024
- In this episode, we're going to explore the Immediate Window, which is one of the most useful and important tools for the Microsoft Access developer. Even if you already used this feature before, you'll want to watch this video to get some tips on how it can work for you. We'll look at getting and setting values, expressions, running commands and code, and more. Let's go!
Check out my easy time entry system for your business:
system.billzon...
Join me on Patreon!
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.co...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a RUclips Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#msaccess #vba
1. To clear the immediate window, just do a standard Ctrl-A (to select all), then hit the delete key. Super simple.
2. When doing math calculations, the immediate window assumes integers by default, so ?256*128 will fail with an overflow error because the result is a long. Instead use type declaration characters at the end of each number to force the long type ?256& * 128&. In this case we are declaring a long using the & symbol. No overflow error will occur.
3. Just for added info about the question mark, it is simple a short hand for the 'print' command. That's why removing the ? runs commands. You are always running a command.
4. Current US national debt at time of posting is $34,040,048,481,071. Look back here in a few years and see just how crazy things are really getting.
Thanks for sharing!
Hi, Can u help us to use select command to retrive data from sql and display in continous form in access (All records) , but the form record source is not link with any table or query means use rs!field=yourTextBox.value ?
What you describe is kind of like "Unbound Forms" which is a thing that you can do with more advanced programming. Essentially you do your select as you describe, then populate your form with data from the recordset (rs in your example). The user can update the information then click on an "OK" or "Save" button which then will perform an update on the database without using "Bound Forms" techniques. This is really great when networks are slow, you have many users, or other factors. It is hard to do with a continuous form (you can with a temporary table); rather, it is better to use a listbox for user record selection, followed by population of an unbound form for updates.
Great video! Thanks Sean
My pleasure! Glad you're liking this series :-)
Hi Sean, was wondering would you be able to recommend good literature on access and vba in general.
This book is solid and has a lot of really good examples that you can learn from for VBA coding: www.amazon.ca/dp/1683928415?linkCode=ssc&tag=onamzseanmack-20&creativeASIN=1683928415&asc_item-id=amzn1.ideas.I4XZ8GYKJY0T&ref_=aip_sf_list_spv_ofs_mixed_d_asin
Check it out!
Thanks Sean.
Great video. Been using the immediate window for sometime but learnt new functions from your video.
Cool, thanks!
Hi Sean, it’s great that you’re producing videos on basic Access VBA topics, it is helping me greatly. I would encourage you to do more on this thread. Obviously advanced content is important too and I want to progress further in VBA. I have subscribed and am keenly looking for your next videos. Thanks very much, keep up the good work. 😊
Glad you're enjoying them! VBA coding is part of my desktop data fundamentals. If you're interested, here is an intermediate playlist:
ruclips.net/p/PLnfNzgd6iu9WyUfDZCdDwU5votl2-fkly
Also, and advanced playlist:
ruclips.net/p/PLnfNzgd6iu9XLiGYoAx3OWv1JZHPXFoq5