28. (Advanced Programming In Access 2013) Using The File System Object
Вставка
- Опубліковано 19 вер 2024
- Using The File System Object (Scripting.FileSystemObject) video in the "Advanced Programming in Microsoft Access 2013" series hosted by Steve Bishop. In this free advanced video tutorial series Steve will be going over Microsoft SQL Server installation, Database Migration, creating a better User Interface, using external data sources, complex Visual Basic For Applications (VBA) concepts and distributing your application.
Click here for the full playlist of "Advanced Programming in Access 2013":
• 1. (Advanced Programmi...
Click here for the Work Files of this series:
github.com/Xip...
Thank you Steve. Your work has inspired me in many ways. Remain great in 2019 and beyond!
Hi Steve
Excellent Tutorials, Thanks a lot Steve for uploading this videos, it’s really helpful, never
found such good videos.
Thanks a lot Steve for your remarkable support, what is the code adjustment required in order to send a series of emails instead of and individual email?
Thank you again for these excellents videos
I would like to know if this code can be used for outlook office 365
or gmail
Hi Steve. I'm trying to add a button to execute macro using "AddContactFromOutlook", but when trying to execute I get a "the command or action 'addFromOutlook" isn't available now. Do you know if this is a reference problem? If so, which reference should I select? Many Thanks!
Another great example, many thanks.
If I wanted to send a report as a PDF without needing it saved can I use the sendObject command in the code instead of a file path?
+Stuart Wise Yes, the DoCmd.SendObject command is designed to send a file as an attachment in an email.
+Programming Damn that was fast.
And thanks for the info, I have used before when jumping into outlook but never doing it with outlook in the background
Thanks again
Hi Steve. i have a database in which i put file path and file name to store the files and it is working ok but now i want to save those file to another location please can you help me for that and it is possible to send you this data base so that you can look it and reply me
Hi Steve - I have been following your Access (basic & advanced) videos from start to finish and able to replicate the same results as shown in the videos. Excellent videos' well explained and taught. I am however, unable to create the "attachments" folder on my local drive. No error message is shown and the attachment is emailed successfully.
When I use the ?folderpath in the immediate window, the result is a blank line!
Thank you for sharing these videos. I am new to access/vba/sql and I have learn't so much so far and coding is a lot fun. Will you be preparing a video series in Javascript in the near future?
I would say perhaps your are trying to create the attachments folder from a location you do not have full permission on, or perhaps it is the programs files folder which can cause some goofy things like this.
As for Javascript, I likely will be doing a class on JS in the future. It is very similar to C# so if you learn the basics of C#, you will have a leg up. Additionally, C# has a few extra features that JS does not have, so you'll start to understand the differences in languages and how they tackle certain problems.
Thanks Steve. I manually created the folder 'attachments' on my local hard drive without any permission error. I will re-watch this video again in case I missed something.
Thanks for your tip, I will start on your C# video's too (after I finish Access Adv)
I like your video series they are very well made, and straight-forward to follow. I particularly like how you've created bite-sized learning material 10-20 minute video segments which works really well for me.
Thanks mate!