Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Search doc on Google Drive
Rajashree Natarajan 
      
5 years ago
I have a medical DB for my office made from scratch. I am learned everything from this website and not a computer expert. I keep all the documents for my patients in their folder on a secure Google Drive. Is there a way I can search the folder containing all the documents from a click of button in their access form? Please give me simple steps I can follow. I am very new to VBA and have no knowledge of it.
Alex Hedley  @Reply  
           
5 years ago
If you have it sync'd to your machine you could just use the windows search api, otherwise you'll have to look into the Google API
Adam Schwanz  @Reply  
           
5 years ago
Could you explain what you are trying to do with the documents and access form? Are you trying to just add a document location to the form or are you trying to be able to open the document from inside of access?
Rajashree Natarajan OP  @Reply  
      
5 years ago
My access database is on a RDP and distributed to staff. When a patient comes in, we have to open the Google drive app and go thru many steps to get the actual patient folder. Each patient has a folder with all their papers in Google drive.. It would be nice to have a button in the access form which opens up that patient folder in Google drive and give access to all documents right away.... a virtual access to patient file with a click of a button... wondering if it can be done?
Richard Rost  @Reply  
          
5 years ago
Sure. Just set up Google Backup & Sync so that the GDrive shows up as an actual folder on your PC. Once you know that path, you can then just Shell to Explorer in that path.
Rajashree Natarajan OP  @Reply  
      
5 years ago
Thanks for the direction but i dont know what  "shell to explorer in that path" means. Do u have any video that can help me with it?
Richard Rost  @Reply  
          
5 years ago
I gave you a link to a Tip video on using the Shell Command.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 8/7/2026 10:04:17 PM. PLT: 1s