41. VBA - CurrentProject (Programming In Access 2013)

[@user-yk2sg5pd5g]

Mr. Bishop, had to thanked you long time before but now here i am. Im at the moment, at chapter 41 but it is quite familiar to me as I have made some excel VBAs for my friends. Though it is quite nice for me to learn but still I have got Qs on 'how I can put the database into my websites'. Maybe there would be one lecture for it after this chapter but I still can't find better way beside Caspio which ain't for free. Thank you as always. Gilbert

[@rogerio74c]

Excelent as always! Thank you for yours videos!

[@jerzykepinski]

this is fantastic

[@Steven-xf8mz]

Before I ask a question. I just wanted to say that I started watching your video about a month ago, and I am on 40s, and I love your work! I'm followed on you, so i see that you're still uploading interesting videos :) Quick question on your creating a new folder "pdfs" will the code that i use to create folder in excel vba work here as well?

[@ProgrammingMadeEZ]

Steven Chen yes

[@hofanwu3872]

I guess the imgGood is the caption of the image box on the right side of the form. There’s a big square space with nothing inside on the right side. You can see it when it is on the design mode.

[@hongchungchow4663]

I am curious why the word 'STOP' is needed in the 2nd row of all the sub-routines?

[@johnmansour8776]

how can we do that code to import image from the table for each record ex. for each customer show his photo

[@mohammadgilani9900]

Also when the image comes . it disappear after I exit from form view.

[@kuldippandey9672]

Hi Steve, Could you please help me . How to import CSV file it has more than 500000 rows data into Access with excel vba ??? I m stuck and not getting help from anywhere

[@mohammadgilani9900]

Hi Steve Happy New Year. i have a question. For AddSharedImage Sub. the program, at the Me.imgGood I got an error say" Method or data member Not Found". Please Help me in this matter. Cheers

[@GuitarMom146]

Hi again... coming from an ancient version of Access, I am trying to wrap my head around how the resources work. Are they linked (ie if the resource image file changes, changes will be incorporated, and if file is moved to different location, there would be an error?). Or does Access embed a copy into the accdb file that is it's own as long as the resource is assigned? THANKS AS ALWAYS! ~alyssa

[@ProgrammingMadeEZ]

Alyssa Siegel It stores a copy of the file in the database itself.

[@joem112]

Steve. Thank-you so much. You are a great teacher.! I often use MKDIR to create folders. That seems simpler than using the filesystem object. Do you have a reason you prefer the filesystem object?

[@ProgrammingMadeEZ]

I prefer FSO because of the flexibility. I can edit files, delete files, see if a folder or file exists, and much more.

[@mohammadgilani9900]

Hi Steve The previous problem resolved . Also when I put "Stop" at the beginning of the sub it doesn't work, and go to debug situation at design view.

[@hofanwu3872]

Mohammad Gilani Steve want to go to the debug mode so that he can take us through the codes. (This mode can let us compile only one line at a time) You don’t need the stop in your code if you just want to make it work.

[@saqibiqbal8661]

Dear Steve: Following VBA Code is NOT working: Private Sub btnAddSharedImage_Click() Stop CurrentProject.AddSharedImage "GoodImage", "c:\test\good.jpg" Me.imgGood.Picture = "GoodImage" End Sub The file is placed at "c:\test\good.jpg"

[@ctcgem]

Steve, In the CurrentProject section, I am having an issue with the btnAddSharedImage_Click() code. The line Me.imgGood.Picture = "GoodImage" throws this error “Complie error: Method or data member not found”. It highlights the “imgGood” part of the line. Is there some property that also needs to be set? It looks like I have typed the code correctly. I have a jpg file in the c:\test folder as well. Any help on this will be appreciated. This is what I have:Private Sub btnAddSharedImage_Click() Stop CurrentProject.AddSharedImage "GoodImage", "C:\test\good.jpg" Me.imgGood.Picture = "GoodImage" End Sub Also the Intelisense does not show imgGood as a property of Me.

[@networksofmikeang]

Hi. I have the same problem. I am using Microsofy Access 2010

[@gokulkrishnan885]

Try taking off imgGood and use Me.Picture = "GoodImage"

[@fredevans2360]

Hello Steve and thank you for the excellent tutorials in this series. please tell me how to open the "my current project" . Is this a seperate data table ? I am using office 365 and cant find anything called "my current project" Best regards fred

[@programminghub7802]

nice work

[@ProgrammingMadeEZ]

Thank you.

[@detroitwillwinsuperbowl59]

Can we purchase source files or transcripts?

[@ProgrammingMadeEZ]

I don't have any transcripts, but you can view the source files for free. There is a link in the description of every video to the work files.

[@mohammadgilani9900]

This is a compile Error.

[@coaching_engineer]

Steve, I am really not happy with all the changes that you make between videos and not briefly going over what you've done. In this video in particular I wasted a good 10 - 15 minutes just trying to create a picture frame so I could follow the code. Once again, I am not just watching this video, I'm trying to follow every single detail. It is hard when you don't go over or review the changes that you make. Yes you have to setup your files and code for the video. Yes you don't want to make it all in the video. Show your changes that you've made so people can pause the video and create all the changes you made for themselves, then make sure you keep track of any new concepts you've added and address them before you go over the subject, then proceed to explain the point of the video. This is really the main issue with all of these videos. Some are better than others. But this video and last video have so far been the worst as far as changes that been made or new forms that are added. I hope that you can take my criticism to heart and be more considerate of the people that are trying to follow every single thing that you do in your videos in the future. I do love how you explain the key concepts and operations in the videos and I'm going to continue to watch and subscribe and hopefully view your more advanced videos because, as people have commented, your video tutorial is probably the best on youtube and you should be proud of the work you've done. Regards, Jaz Isom

[@ProgrammingMadeEZ]

Jaz Isom Understand Jaz.

[@anouar3103]

Jaz Isom it's already a big big BIG and GREAT job in every video so he can't do all you want in this video .thanks a lot Steve

[@aprildu2056]

+Jaz you do realize Steve is doing this for free right? He can't cater to everyone's needs. If he did everything you wanted then some other people would think he was doing it too slow and complain about it. Appreciate what he has done. If you have questions, ask away. If he has time he may get back to you or other people may help you.

[@coaching_engineer]

Chunxun Du you must not understand why I am having a problem. When you make video tutorials for a computer application, or instructional video for something like, but not limited to, programming in a new language, where you have made programs in one video and it is expected of you to continue talking about that same program in the next video, making changes outside of making the video does not help anyone who is following along. It is frustrating to advance to the next video expecting to have the same exact settings, or in this case have the same VBA code and Microsoft Access tables or queries made that was at the end of the previous video, then come to the realization that you need to waste time finding out what changes were made between the previous video and the current video. It doesn't matter if you are teaching someone for free or getting paid, you need to be conscientious of the people that are learning from you. You need to be aware if and how people learning from you can become confused and then try to avoid it. Making changes between videos without specifying it can EASILY make someone following along exactly confused. I am thankful for the videos, and I believe I have specified this to Steve. If someone cannot except constructive criticism and then try to become better from it, then don't make video tutorials. I believe that Steve can speak for himself (and he has a while ago), and I hope that he will take my advice for the sake of the people following along with his videos. With this said, I don't believe I would be as skilled of a VBA coder as I am now without Steve's tutorials because they are very helpful once you get over the "changes between videos frustration". So in response to your comment Chunxun Du I WOULD like to thank Steve for his videos and I do not wish to offend anyone by my words. You or him. Thanks and Regards,

[@abhimanyuambastha2595]

I am sure my comment wouldn't be relevant now, yet I would write it down. Do not always be expected to be spoon-fed, there are tons of tutorials out there that don't do half as much as this one does. And this probably goes for any language/framework you want to learn from the internet. If you are following along and get stuck, google it. There are tons of links/forums/stackoverflow to help you out. Your own research to solve a problem would do a lot good in the long run