Thanks so much for this video, it was very very helpful. I downloaded the file from Google drive link. I used the techniques to copy my backend db to another folder to server as taken backup.
Hi. I am currently learning MS Access on my own and so far I am learning a lot from your channel. I just want to ask how were you able to put a picture on upper right side of the screen. Currently, I am also doing it using using "We Browser Control" because I am fetching the image from our internal site. I did manage to place it, however I just could not remove the margins of the control, I could see the picture but the margins were also present. Also, how did you make it rounded and do mouse hover to it. Thank you.
I have managed to select the image, but if I change it, the form does not refresh the image, they only change when I advance the record or open the form again. What I can do, any idea?
Hi i have watched a few of your access videos and wondered if you could help. I have a form and what to attach files maybe 3 or 4 of them and store them on share-point not in the access file. when i save the form for this opportunity i want to be able to open the same opportunity again and have the form display the files name i have saved so i can click on them and open them. Each opportunity will have its own set of attachments. I want it to work exactly as it does in access but save location will be in sharepoint not access. The reason is i will need to attach a lot of files and do not want to make access very big and slow. Could you help with this?
Hi pal! Your source file works perfectly. But when I do the same in my database it tells me that "VtrselectItem" and "ext" are not defined. Any ideas please?
Thank you very much kind sir, but how can i store the picture in folder named by [id], i already managed to create the folder but don't know how to save it there?
@@EdcelleJohnGulfan I want to create a folder named based on emplyeeID and save the picture in it So I tried (Mkdir "c:\images\" & me. EMPLOYEEID) and it worked. BUT FOR THE FILE COPY I TRIED FILECOPY VTRSELECT, "c:\images\[ME. EMPLYEEID] " BUT ITS NOT WORKING HELP PLEASE
@@TechWithSally4D that didn't work it only renames the picture file usin the id value, what I want is to store the picture in the folder I created, so the picture for ID=1 will be stored in a folder named 1. Please help
Malaking tulong po itong tutorial mo sir. paano po ginawa sir. navigation sa loob ng basic employee information? hope masagot nyo po sir. maraming salamat po. God bless
The free template attached this video can be used to attach multiple files like pdf, excel, word and etc. Just do a little twist with the code. For .allowMultipleItem change to TRUE and add File Extension like .pdf; .xlsx or "*" for any type of files. just follow the sequence.
Sir, paano niyo po ginawa yang form na may navigation form? Kase yung nasa dashboard na employee, merong navigation form (personal info, in case of emergency, other info at attachments)
Oui bonjour monsieur vraiment merci et vous êtes tellement intelligent. Vraiment si vous pourriez m'envoyer le code pour faire défiler les textes sur le bas du formulaire. Merci
good day sir wala po kayo tutorial para po dun sa pag store ng image sa selected folder sir at sapag lagay ng file name po sa image maraming salamat po sana po makagawa po kayo ng tutorial God bless and advance merry christmas
Thank you for sharing the sample database file with the vba code. Very nice!
Thanks for watching
From where I can find the sample database with this interactive form?
Thanks so much for this video, it was very very helpful. I downloaded the file from Google drive link.
I used the techniques to copy my backend db to another folder to server as taken backup.
Tons of thanks for simple explanation with awesome work...🙏😇
You're welcome Elijah. Thanks for watching.
@@EdcelleJohnGulfan it says "User defined type not defined"
please help me to solve this issue
Thank you very much, Bro. It really helps me..
Glad to hear that. By the way, thanks also for watching.
Dim fd As FileDialog
generating error
User-defined type not defined
How to handle this sir
Ohh is this the video, thanks
Yup
Hi Sir Edcelle, I'm wondering if you can help me on how to pick an image file in ms access and then save it to the sharepoint document. Thanks
How did you make this profile design ? Do you have a video?
I have to create a video soon
@@EdcelleJohnGulfan okay waiting for it
Hi. I am currently learning MS Access on my own and so far I am learning a lot from your channel. I just want to ask how were you able to put a picture on upper right side of the screen. Currently, I am also doing it using using "We Browser Control" because I am fetching the image from our internal site. I did manage to place it, however I just could not remove the margins of the control, I could see the picture but the margins were also present. Also, how did you make it rounded and do mouse hover to it. Thank you.
I have managed to select the image, but if I change it, the form does not refresh the image, they only change when I advance the record or open the form again. What I can do, any idea?
Add this to your code
Docmd.requery
Nice Info
Thanks
Hi i have watched a few of your access videos and wondered if you could help. I have a form and what to attach files maybe 3 or 4 of them and store them on share-point not in the access file. when i save the form for this opportunity i want to be able to open the same opportunity again and have the form display the files name i have saved so i can click on them and open them. Each opportunity will have its own set of attachments. I want it to work exactly as it does in access but save location will be in sharepoint not access. The reason is i will need to attach a lot of files and do not want to make access very big and slow. Could you help with this?
Try this.
ruclips.net/video/OBhB4500Ka0/видео.html
great
it says "User defined type not defined"
please help me to solve this issue
can we store it on report?
thank you sir
Thanks for watching Mini.
Pls Sir how can it be done. Which VBA code does that
If you really need it now, you can email me at eduardogulfan@gmail.com
Sir ako rin. Na email na kita. Thanks
Hi pal! Your source file works perfectly. But when I do the same in my database it tells me that "VtrselectItem" and "ext" are not defined. Any ideas please?
Then you have to define it. Just follow or copy the code above my sample.
Thank you very much kind sir, but how can i store the picture in folder named by [id], i already managed to create the folder but don't know how to save it there?
Use File copy function. Just indicate the file location.
@@EdcelleJohnGulfan
I want to create a folder named based on emplyeeID and save the picture in it So I tried
(Mkdir "c:\images\" & me. EMPLOYEEID) and it worked.
BUT FOR THE FILE COPY I TRIED
FILECOPY VTRSELECT, "c:\images\[ME. EMPLYEEID] "
BUT ITS NOT WORKING
HELP PLEASE
@@samanmarewan7926 instead of "c:\images\[ME. EMPLYEEID] " use
"c:\images\" & me.EMPLYEEID
@@TechWithSally4D that didn't work it only renames the picture file usin the id value, what I want is to store the picture in the folder I created, so the picture for ID=1 will be stored in a folder named 1.
Please help
@@samanmarewan7926 sorry! My bad
Try this for making directory
"C:\images\" & me.employeeid.value & "\"
Malaking tulong po itong tutorial mo sir. paano po ginawa sir. navigation sa loob ng basic employee information? hope masagot nyo po sir. maraming salamat po. God bless
Sigi po gawan ko ng tutorial. Salamat pala sa panonood.
@@EdcelleJohnGulfan maraming salamat po sir.
Sir, is there any method to display a image from a folder on a form based on search results
Yes sure. I will upload soon.
Thanks
Welcome
sir, do have video like how to attached multiple file like pdf at create filename each folder. thank u and more power.
The free template attached this video can be used to attach multiple files like pdf, excel, word and etc.
Just do a little twist with the code.
For .allowMultipleItem change to TRUE
and add File Extension like .pdf; .xlsx or "*" for any type of files. just follow the sequence.
Thank you sir, i try tommorow❤️
Sir, paano niyo po ginawa yang form na may navigation form? Kase yung nasa dashboard na employee, merong navigation form (personal info, in case of emergency, other info at attachments)
Check this video.
ruclips.net/video/LuZdjnz-Q34/видео.html
Maraming salamat pala sa panonood.
good day po.meron po kayong video sa details on making this output po?
Soon po.
Oui bonjour monsieur vraiment merci et vous êtes tellement intelligent. Vraiment si vous pourriez m'envoyer le code pour faire défiler les textes sur le bas du formulaire. Merci
Pas si malin !
vous pouvez consulter mon fichier d'exercice gratuit à télécharger. Ouvrez simplement ma liste de lecture
en dessous de la description de cette vidéo, il suffit de la télécharger en cliquant sur le lien
Can you show the code 😢
You can download the file.
Le sous titrage embrouille vraiment !! Fait seulement en anglais on comprend
l'utilisation des sous-titres générés automatiquement est parfois déroutante.
caranya gimana bro?
good day sir wala po kayo tutorial para po dun sa pag store ng image sa selected folder sir at sapag lagay ng file name po sa image maraming salamat po sana po makagawa po kayo ng tutorial God bless and advance merry christmas
Gagawa ako soon. Maraming salamat sa panonood.
Sir ano po # ng backcolor sa dashboard nyo. Pangit kase ng blue na nakukuha ko
Update kita kung ok na computer ko. Pero pwede mo e.search sa internet. Type mo lang Rgb colors marami kang pagpipilian.
Comment faire celà vraiment vos vidéos m'aide beaucoup ! Merci
Merci d'avoir regardé
Sir hindi po ba pwd mahingi source code niyang asset tracking management?
maganda po ang mga content.. kaso hindi kayo ngrreply sa email
Wala po akong nareceived na email. From time to time ako nagche-check ng because of my work.
Sorry for that. What is your concern kabayan?
@@EdcelleJohnGulfan sir pa-double check po..
@@EdcelleJohnGulfan nagemail po ako ngaun.. hingi po sana ako copy.
Sir Pahingi din po ng vb code. Already we emailed you. Thanks po.
May attachment sa description. E download mo lang.
@@EdcelleJohnGulfan Thank you sir.. I hope sir you make a video "How to sync Ms Access on Web". More power.