This is a Childs Play sir, try the bigger ones like in form settings, password recovery through gmail or anything else. But I have to Say 1 thing Whatever you do is too easy or simple ass compared to other youtubers, they present simple code in very much hard way. Don't know why? Maybe for length of video. But in this case you are awesome SHORT & SIMPLIFIED tutorials. I really love those
This is great - quick question (maybe addressed in another video you've done, that I'm missing)... Not all my 'products' have a complete set of information - so every row as a GUID. I don't want to display the GUID, so I was thinking about using an icon - but can't seem to find how to link an icon to a value, then make that a hyperlink. If I use TextBox, I can get the GUID value, but then no icon. if I use a Label, I can get the icon, but I can't get the hyperlink. If I use a button, I can get the icon and a link, but I can't get the GUID. I think you have an example where at the end of your row of the continuous form, you have a delete button ... it is red with a trash can, and I'm assuming it can sense the row it's on so it's able to delete that row. How did you get that to work?
Thanks for watching. I used Command button for the delete button (in the video). You may also use LABEL then apply OnClick Function. In Label, you can insert picture like a font.
Hi Sir Ed thank you for sharing your knowledge. may i ask if it is possible to hide specific row button in continous form depending on the status of the record. let say if the status of the record are still pending, then action button are still visible or enabled. if it is complete then action button become hidden or disabled. thank you.
Yes but it is complicated if you use command button. The simplest way is to use a text box then design it that looks like a command button. Then apply the IF function.
It happened to me as well. I use the code downloaded but it does not work. There is a command button 363 but does not find any code associated with that button? Strange.
Is there anyway to search a specific for the Form that displays no record when first opened? My DB is > 100,000 records. So when form first opened it is set to blank DoCmd.GoToRecord , , acNewRec. (display no records when first opened). Thanks a lot Edcelle for your valuable tutorials. All thumbs up
Hi sir pano po magsave ng single data papunta sa multiple fields? for example, magiinput ako ng name na alex then ise-save ko sya sa Vehicle 1, 2 and 3, paano po yun? Thank you
Hello Sir.. This tutorial is so awesome and i have learnt a lot.. but I have a problem...I have tried this method several times and tried to modify the codes but i still get errors and a blank form...Please help me on this..Please which other way can i do it to let is open the exact record..Thanks and awaiting your reply..
Thanks for the quick reply but for my PC * works on all my queries..the % sign does not work for me..all the same i tried it but still didnt work...I am not sure but is there something else am likely to be doing wrong?
This is a Childs Play sir, try the bigger ones like in form settings, password recovery through gmail or anything else.
But I have to Say 1 thing Whatever you do is too easy or simple ass compared to other youtubers, they present simple code in very much hard way. Don't know why? Maybe for length of video. But in this case you are awesome SHORT & SIMPLIFIED tutorials. I really love those
Thànk you so much. I really made the videos for beginners. That's why as much as possible I could deliver it in a simple way.
OMG it actually worked. Thank you so so so much. Have tried to find this for hours
Thank you.
This is great - quick question (maybe addressed in another video you've done, that I'm missing)...
Not all my 'products' have a complete set of information - so every row as a GUID. I don't want to display the GUID, so I was thinking about using an icon - but can't seem to find how to link an icon to a value, then make that a hyperlink. If I use TextBox, I can get the GUID value, but then no icon. if I use a Label, I can get the icon, but I can't get the hyperlink. If I use a button, I can get the icon and a link, but I can't get the GUID.
I think you have an example where at the end of your row of the continuous form, you have a delete button ... it is red with a trash can, and I'm assuming it can sense the row it's on so it's able to delete that row.
How did you get that to work?
Thanks for watching.
I used Command button for the delete button (in the video).
You may also use LABEL then apply OnClick Function. In Label, you can insert picture like a font.
Tutorial for using fonts like a picture:
ruclips.net/video/UTMlQQJ5R0Y/видео.html
Thank you for the good explanation and for the example file.
You're welcome Roberto.
im a fan bro! thank you for this. its never too late to learn. thanks a lot
Thanks for watching Jay.
Again, super nice and easy, thanks you!
Thanks for watching Tim.
thank you Sir Edcelle
You're welcome
Hi Sir Ed thank you for sharing your knowledge. may i ask if it is possible to hide specific row button in continous form depending on the status of the record. let say if the status of the record are still pending, then action button are still visible or enabled. if it is complete then action button become hidden or disabled. thank you.
Yes but it is complicated if you use command button. The simplest way is to use a text box then design it that looks like a command button. Then apply the IF function.
@@EdcelleJohnGulfan thanks for the info do you have video or demo for that sir?
As of now, no video.
Very Nice
Thanks for watching.
Great Trick...Thanks
Welcome po
If possible to explain how to make the item clicking
Thank you for this! I have a question
I've tried both methods and they both open blank forms. Is there another way it can open a specific record?
Use query as your Data source.
Try this: ruclips.net/video/0ENGX8MJTHY/видео.html
It happened to me as well. I use the code downloaded but it does not work. There is a command button 363 but does not find any code associated with that button? Strange.
thanks for uploded
Always welcome
Hi sir can we use 2 or more hyperlink in a continous form
In just 1 field? Yes you can.
@@EdcelleJohnGulfan say like name, ID,
How to add edit save option product information?
Hi Al, just add a command button. If you're really new, just watch this.
ruclips.net/video/0ENGX8MJTHY/видео.html
Good
Thanks for watching Chibenson.
Is there anyway to search a specific for the Form that displays no record when first opened? My DB is > 100,000 records. So when form first opened it is set to blank DoCmd.GoToRecord , , acNewRec. (display no records when first opened). Thanks a lot Edcelle for your valuable tutorials. All thumbs up
Sir, pwede na sa duha kacategory like name and date kay muopen siya ug one record?
Pwede sya sa Multi criteria mam. Sumpayan lang nimo ug AND function.
Hello Sir Edcelle CAn you make a playlist po tutorial ng Benninger's
Yes po. Yung ms access na playlist pang beginners yun. Pero gagawa akl ng specific. Thanks sa suggestions.
Hi sir pano po magsave ng single data papunta sa multiple fields? for example, magiinput ako ng name na alex then ise-save ko sya sa Vehicle 1, 2 and 3, paano po yun? Thank you
Append query po.
@@EdcelleJohnGulfan Tinry ko po magappend query, pero hindi nya nakukuha yung data doon sa form, sa form ko po ilalagay yung name na alex
Try this.
ruclips.net/video/pC7hoQe9nxs/видео.htmlsi=tXt47iCvBhtoqfCZ
thanks
Thanks for watching
Good day sir. pde ba magpagawa sa inyo?
Yes po. Chat me sa messenger. Ed Perez Matugas Gulfan.
Thank you
Thanks for watching Sam
Hello Sir.. This tutorial is so awesome and i have learnt a lot.. but I have a problem...I have tried this method several times and tried to modify the codes but i still get errors and a blank form...Please help me on this..Please which other way can i do it to let is open the exact record..Thanks and awaiting your reply..
If you are using * symbol in your query, replace it with %. It's because of the syntax of your Pc especially laptop.
Thanks for the quick reply but for my PC * works on all my queries..the % sign does not work for me..all the same i tried it but still didnt work...I am not sure but is there something else am likely to be doing wrong?