How to Use the Immediate Window in Microsoft Access

[@RungeCarl]

Great video. Been using the immediate window for sometime but learnt new functions from your video.

[@seanmackenziedataengineering]

Cool, thanks!

[@davegoodo3603]

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. 😊

[@seanmackenziedataengineering]

Glad you're enjoying them! VBA coding is part of my desktop data fundamentals. If you're interested, here is an intermediate playlist: kzbin.info/aero/PLnfNzgd6iu9WyUfDZCdDwU5votl2-fkly Also, and advanced playlist: kzbin.info/aero/PLnfNzgd6iu9XLiGYoAx3OWv1JZHPXFoq5

[@miles6875]

Great video! Thanks Sean

[@seanmackenziedataengineering]

My pleasure! Glad you're liking this series :-)

[@michaelkrailo5725]

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.

[@seanmackenziedataengineering]

Thanks for sharing!

[@ballaomer6738]

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 ?

[@seanmackenziedataengineering]

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.

[@dainisbren1525]

Hi Sean, was wondering would you be able to recommend good literature on access and vba in general.

[@seanmackenziedataengineering]

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!

[@dainisbren1525]

Thanks Sean.