Steve, thank you indeed for that meticulous work. If I had the opportunity to watch this back in 2000, I would have achieved so much more by now. Quite unexpectedly, I have to build some local applications in Excel with Access as the back-end. Your series come quite handy.
There does seem to be one useful distinction from 'CurrentDB.Containers("*").Documents' in that 'Application.CodeData.AllTables' will really only display table objects, it seems, and not odd queries as encountered when using 'CurrentDB.Containers("*").Documents'.
Thank you for the video Steve! I am opening the database1 with 1 form however it doesn't load automatically with the message box. Do you know why? Thank you!
Thanks. Had tried using that, failed several times, due to the unclear (to me) help file. Finally did get it, using the import method, with the correct syntax. Found that "optional" arguments/qualifiers were needed, and not optional. Anyway, another lesson learned.
Charlie Chromo I changed monitors which changed the screen dimensions. Don't worry though, I do go back to a widescreen shortly. Also, make sure you have the video resolution set to 720 on the youtube settings. It won't fix the size but it does make sure the image is sharp enough to see.
Steve, I'm trying to follow along with you when you are doing the OpenCurrentDatabase button, but for some reason it is not opening. I have the paths correct and the reference is linked but it won't open. However, I can open it manually.
Jaz Isom Make sure you are creating a new access object in your VBA and then running the OpenCurrentDatabase method from that object as I demonstrate in the video.
Jaz Isom Steve, once again I had to search google to figure what you did. I noticed you had the form in Database1 start when the database was opened. I do not remember you going over this at all. In order to open the database without having the form activate upon startup, I used app.Visible = True, and that worked, but it didn't do exactly what you did in the video. Why didn't you mention this before? It throws me off, I'm pretty sure if someone wants to follow along and copy everything you do, it'll throw them off as well.
Thanks, but I figured it out. Turns out that the form opens when you have it set to open the form when the database opens. If you don't have that set, then you have to do a .visible = true command.
After watching 44 videos, I am still not sure how to build the simplest application. How to compile the code into an EXE and which form the application loads as the first Form. How to tie that form into a database. Just found some of those information in the microsoft page. I thought to run the first application someone needs to know the options or autoexec macro early
Watching this series in 2024, thank you so much Steve!
Steve, thank you indeed for that meticulous work. If I had the opportunity to watch this back in 2000, I would have achieved so much more by now. Quite unexpectedly, I have to build some local applications in Excel with Access as the back-end. Your series come quite handy.
Excellent videos ! It's really helpful for developers . Thank you !
There does seem to be one useful distinction from 'CurrentDB.Containers("*").Documents' in that 'Application.CodeData.AllTables' will really only display table objects, it seems, and not odd queries as encountered when using 'CurrentDB.Containers("*").Documents'.
Steve, thx for all the great videos. I’ve learned a lot.
In Video 45 you show us how to add the reference Database1, but what about removing a reference, such as Database1?
Thank you for the video Steve! I am opening the database1 with 1 form however it doesn't load automatically with the message box. Do you know why? Thank you!
Thanks Steve
Thank you very much dear Steve...
Dear...
How to connect to other database and display that tables in listbox in current Database ?
I cover this in the advanced series.
I don't need to open other database ..
I just want to connect it and display tables in the Listbox
To connect to another database you have to open a connection to it. That's what the OpenDatabase function does.
When did you add modules to the database. I think I missed that.
Steve, Hi again. quick queston: Is Export XML and Import XML the best way to move a table from one db to another?
No I recommend you use the import tool to get tables from another database.
Thanks. Had tried using that, failed several times, due to the unclear (to me) help file. Finally did get it, using the import method, with the correct syntax. Found that "optional" arguments/qualifiers were needed, and not optional. Anyway, another lesson learned.
Hi, Steve. I have a quick question: why there is always a stop in the first line of the subroutine? What is the function of stop? Thanks in advance.
+Yujie Zhou Putting Stop in your VBA code is a way to set a break point by coding it. You wouldn't want to put them in any production code.
I see. Thank you very much for all the efforts to make such great videos!
Did you change video recording program here? Your previous videos filled up the screen and had better resolution.
Charlie Chromo I changed monitors which changed the screen dimensions. Don't worry though, I do go back to a widescreen shortly. Also, make sure you have the video resolution set to 720 on the youtube settings. It won't fix the size but it does make sure the image is sharp enough to see.
Thank you. Great video series! Very clear explanations.
One question. In video 45, you have stop statements after each private sub function. What is the purpose of these stops?
So he can manually jump to each line of code so you can follow the process step by step
Hey steve please tell me why you used 'stop' after every subroutine
private sub x()
stop ?
Just so I could pause the code at each point. You don't want the stops in your own code.
Steve, I'm trying to follow along with you when you are doing the OpenCurrentDatabase button, but for some reason it is not opening. I have the paths correct and the reference is linked but it won't open. However, I can open it manually.
Jaz Isom Make sure you are creating a new access object in your VBA and then running the OpenCurrentDatabase method from that object as I demonstrate in the video.
Programming I am doing everything that you are doing in the video up to this point, but Database1 will not open.
Jaz Isom Steve, once again I had to search google to figure what you did. I noticed you had the form in Database1 start when the database was opened. I do not remember you going over this at all. In order to open the database without having the form activate upon startup, I used app.Visible = True, and that worked, but it didn't do exactly what you did in the video. Why didn't you mention this before? It throws me off, I'm pretty sure if someone wants to follow along and copy everything you do, it'll throw them off as well.
Jaz Isom I'm still very confused on what it is you're saying isn't there. I wouldn't know where to begin.
Thanks, but I figured it out. Turns out that the form opens when you have it set to open the form when the database opens. If you don't have that set, then you have to do a .visible = true command.
After watching 44 videos, I am still not sure how to build the simplest application. How to compile the code into an EXE and which form the application loads as the first Form. How to tie that form into a database. Just found some of those information in the microsoft page. I thought to run the first application someone needs to know the options or autoexec macro early
Check the Northwind AutoExec macro
SUIIIIII