Hi Eduardo, First of all .Thank you for these great tutorials. You have helped me a lot to understand Access and how to use it here at my work. I have a question about Tab Control. I have a continuous form (like the one in your video with the Hyperlink) and it opens a new form with detail information. I added some tabs because there are more information that needs to be displayed. but it doesn't open the specific record any more, it asks me to input the number I used as the hyperlink. Is there any coding I'm doing wrong that it doesn't open the correct Record? any advice would be highly appriciated
please how can I change the direction or the orientation of the Tab Control instead of (right to left) as in the video, To (left to right) thank you very much
ya, i was tried in entry data property sheet, but my navigation commands dont work. i want while i open a form, and the fields are empty as add new record, cause sometimes i forget to click new, whereas the form was filled and thats make my database is untidy. so please help@@EdcelleJohnGulfan
Sir edcelle suppose ung nsa menu mo sa left side ung mga command buttons dun ang i-assign ko sa bawat tab, pano po yun iaassign pra di naq magclick sa tab kundi sa command button sa left side ng form nlng
Pangmalakasan sir, sir ask po sana ako if paano po if around 5000 na po yung id at yung ibang tab po is ibang table na connected po via relationship sa employeeID at yung ibang tab ay many to many relationship po sa employeeID po. Patulong po sana sir.
@@EdcelleJohnGulfan thank you po sir. may video ka po ba for parent and child link? normalized nmn po yung tables with foreign key from employeeID table. at yung ibang table may foreign key din sa ibang table. if may video ka po sana para sa mga functions nato. 1. pwede po ba mag add ng search box at list box with view record functions para pwede po ma view lahat ng related records kasama sa tabs (katulad this video na instead employee id dropdown searchbox at list box po para sa result) 2. list box per tab para po sa records for add/edit delete/ na related po sa For. Ex. SalaryTable. . Please po. ito po kasi yung main functions na hinahanap ko sir edcelle
Apaka husay mo talaga Boss Edcelle!👏
Salamat sa panonood boss.
Thank you po Sir Gulfan. God Bless!!
Salamat din po.
Good evening, Your video have been helping me a lot. Thanks
Thanks for watching. It's highly appreciated.
Thank you very much
Welcome
Hi Eduardo, First of all .Thank you for these great tutorials. You have helped me a lot to understand Access and how to use it here at my work. I have a question about Tab Control. I have a continuous form (like the one in your video with the Hyperlink) and it opens a new form with detail information. I added some tabs because there are more information that needs to be displayed. but it doesn't open the specific record any more, it asks me to input the number I used as the hyperlink. Is there any coding I'm doing wrong that it doesn't open the correct Record? any advice would be highly appriciated
Thanks for watching this channel. It's highly appreciated. For your issues...
Do the same method. You should have Parent and Child link.
Thanks👍
Welcome
please how can I change the direction or the orientation of the Tab Control instead of (right to left) as in the video,
To (left to right) thank you very much
Great content. Eduardo can you please guide on how to create a table field in Ms access to accept specific age limit based on date of birth
Sorry for very late reply.
You mean, like it accepts only 30 years old below? if beyond it will show a message?
Can you explain please,how if we open the form for the first and its fields would be empty
You mean open as a new record?
ya, i was tried in entry data property sheet, but my navigation commands dont work. i want while i open a form, and the fields are empty as add new record, cause sometimes i forget to click new, whereas the form was filled and thats make my database is untidy. so please help@@EdcelleJohnGulfan
In your Form Property sheet, go to Event, then select On Load, an type the following.
Docmd.GoToRecord , , acNewRec
Sir edcelle suppose ung nsa menu mo sa left side ung mga command buttons dun ang i-assign ko sa bawat tab, pano po yun iaassign pra di naq magclick sa tab kundi sa command button sa left side ng form nlng
Baka ito ang ibig mong sabihin.
ruclips.net/video/rV1hgP3qBZM/видео.html
@@EdcelleJohnGulfan ok na sir edcelle marami salamat!😊😊
pano po mawawala yung mismong ms access na app kapag nagload yung main form mo sa na nakamaximize
Try this.
ruclips.net/video/1aWtJuhbcKE/видео.html
Pangmalakasan sir, sir ask po sana ako if paano po if around 5000 na po yung id at yung ibang tab po is ibang table na connected po via relationship sa employeeID at yung ibang tab ay many to many relationship po sa employeeID po. Patulong po sana sir.
Same concept parin sir. Dapat may common ground sila like ID number para sa parent and child link.
@@EdcelleJohnGulfan thank you po sir. may video ka po ba for parent and child link? normalized nmn po yung tables with foreign key from employeeID table. at yung ibang table may foreign key din sa ibang table. if may video ka po sana para sa mga functions nato. 1. pwede po ba mag add ng search box at list box with view record functions para pwede po ma view lahat ng related records kasama sa tabs (katulad this video na instead employee id dropdown searchbox at list box po para sa result) 2. list box per tab para po sa records for add/edit delete/ na related po sa For. Ex. SalaryTable. . Please po. ito po kasi yung main functions na hinahanap ko sir edcelle
Maybe this is what you want.
Creating a subform.
ruclips.net/video/lYD2YFM3Sk0/видео.html