Do you have any tutorial for transfering all the physical files from one to the other? Ex: we are working for clinic that has patient's files that need to be reassigned to the other worker once the person left the job. Also, the report of the transfer log of the total numbers of files that are transfered, the transfer date, from whom to whom. Thtanks a lot for your help
Thank you for a such valuable tutorial 😊😊😊 I have a further question on this, what if I enter product ID which doesn't exist and would like a program to add as a new record, what code should be written?
I want to enter the monthly performance of the personnel in Access every month, of course, by uploading the Excel file, but I want the performance of each month to be in exactly one column and by using the personnel code, the performance of each person should be placed in front of him. Please use the combo box to select the month of performance. Thankful
Maybe lots of ms access users will be faced to this problem screen flickering on forms I searched alot but I can't find a specific solution for this issue maybe if you can make a video on it.
wow, you always answer the comment. gret! so, please...i was follow your step but why, its still not working. just show pop up runtime error 0375... i dont know why, please help
field issues. Try to fix by doing like this. sample: "Your Field" Change to [Your Field] or use the On Error. Video: Debug th-cam.com/video/BxGLZMguJVA/w-d-xo.htmlsi=i4WI9NBNlvFgYeOA
If I import or paste countries would the field cboCountry work, and populate the RaceGroup? Example: I have cboCountry, and populates the RaceGroup textbox. example: if it's typed or paste or select from cboCountry Phillipines, the RaceGroup would populate Filipino and so forth. So instead I click, select from the dropdown cbo, if I import several data where individuals have the Country, would work? Sometimes I receive hundreds of rows to import where it has the countries and individuals, and the blaml RaceGroup field needs to be populated. I have to use excel to use the vlookup or xlookup to populate the RaceGroup in Excel then I import everything ready to Access. But I want to do this in Access. It's ridiculous we have to use Excel to help Access. This happens to other people too.
Sir naa Koy Isa.ka.program.,pautang gihapon,,which is Ang tubo Niya is daily,1% daily,, akong gihumoan og program.,everyday mag update ja sa iyang balance.,every mag change og date Ang computer,Ang problema is.,even na fully paid na ciya,magcompute gihapon ciya sa iyang interest.,example,karon cya nagfully paid.,ugma naa pod ciyay mosulod na tubo,Kay magchane namn og date Ang computer.,og naa Kay sulotion Ani sir.pwd patabang.,og himoan nimo og vedio.
Sorry for late reply. Question... 1. Is the Me.ProdName has a source? it should be unbound or blank source. 2. Is your criteria (EmpId ) is a number or integer? try to add a single quote or Apostrophe like EmpId ='" & me.ProdId & "'"
nice vedio sir,salamt sa knowledge
Salamat pod
I've been trying to get this to work for hours... you're a life saver!!! Just subscribed
Thanks. it's highly appreciated.
Thanks. it's highly appreciated.
مرسی
Welcome
V good👍
Thanks for watching
thumbs up to the BEST TEACHER. Thanks a lot for your powerful tutorial
I'm so flattered with your comment 😃😃
New subscriber here.
Thanks sa tulong
Walang anuman. Salamat sa panonood.
Thanks, teşekkürler abim
You are welcome.
nice video
Thanks for watching Edith.
👍
Saya sangat tertarik dengan tutorial ms access.
So stay tuned in this channel.
Boss Edcelle pde dn palang prang search box yan anu, pra lahat ng details e lumabas at kung di mo kailngan ng listbox:)
Yes po sir Ryan.
@@EdcelleJohnGulfan mahusay ka tlga boss! ngaun nggwa q na ung gngwa q DIY lng na database pro di pa tapos mdami pa kulang hehe
Keep it up lang Sir!
Can I do it for a tabular form
Do you have any tutorial for transfering all the physical files from one to the other? Ex: we are working for clinic that has patient's files that need to be reassigned to the other worker once the person left the job. Also, the report of the transfer log of the total numbers of files that are transfered, the transfer date, from whom to whom. Thtanks a lot for your help
I don't have a tutorial as of now.
thanks for your quick reply Edcelle@@EdcelleJohnGulfan
Thank you for a such valuable tutorial 😊😊😊 I have a further question on this, what if I enter product ID which doesn't exist and would like a program to add as a new record, what code should be written?
Nice question. I'll create a video for that.
Here's the link for the tutorial.
th-cam.com/video/7IMBbpLZ6Zs/w-d-xo.html
how if product ID use combination format like CB1001 etc?
Same process.
Thank You So much sir ,how to manage database size in MS Access.
just use external backend.
th-cam.com/video/6T1TvSoD_UE/w-d-xo.html
Can I use "OR" condition while using DSum function. For example " Fieldvalue= (DSum("FName", "TableName", "Ref=1" OR " Ref=10")). Regards.
Salamat sir sa mga video nyo about ms access.., can u help me with my simple database like data entry of PDS File..TIA sir..
Pwede naman.
@@EdcelleJohnGulfan how can i reach u sir..i have some questions. ☺️
Email me at eduardogulfan@gmail.com
my pm po ako sir.
pano naman po sa attachment field? possible po ba gumana gamit yung method nayan?
😍😍😍😍😍😍😍😍😍😍😍
I want to enter the monthly performance of the personnel in Access every month, of course, by uploading the Excel file, but I want the performance of each month to be in exactly one column and by using the personnel code, the performance of each person should be placed in front of him. Please use the combo box to select the month of performance. Thankful
Maybe lots of ms access users will be faced to this problem screen flickering on forms I searched alot but I can't find a specific solution for this issue maybe if you can make a video on it.
wow, you always answer the comment. gret! so, please...i was follow your step but why, its still not working. just show pop up runtime error 0375... i dont know why, please help
field issues. Try to fix by doing like this.
sample: "Your Field" Change to [Your Field] or use the On Error.
Video: Debug th-cam.com/video/BxGLZMguJVA/w-d-xo.htmlsi=i4WI9NBNlvFgYeOA
If I import or paste countries would the field cboCountry work, and populate the RaceGroup? Example: I have cboCountry, and populates the RaceGroup textbox. example: if it's typed or paste or select from cboCountry Phillipines, the RaceGroup would populate Filipino and so forth. So instead I click, select from the dropdown cbo, if I import several data where individuals have the Country, would work? Sometimes I receive hundreds of rows to import where it has the countries and individuals, and the blaml RaceGroup field needs to be populated. I have to use excel to use the vlookup or xlookup to populate the RaceGroup in Excel then I import everything ready to Access. But I want to do this in Access. It's ridiculous we have to use Excel to help Access. This happens to other people too.
Maybe this video can help you.
AUTO FILL IN : th-cam.com/video/8UxBf9Ysa84/w-d-xo.html
Cascading Combo box: th-cam.com/video/-IE-aXR3olM/w-d-xo.html
Sir naa Koy Isa.ka.program.,pautang gihapon,,which is Ang tubo Niya is daily,1% daily,, akong gihumoan og program.,everyday mag update ja sa iyang balance.,every mag change og date Ang computer,Ang problema is.,even na fully paid na ciya,magcompute gihapon ciya sa iyang interest.,example,karon cya nagfully paid.,ugma naa pod ciyay mosulod na tubo,Kay magchane namn og date Ang computer.,og naa Kay sulotion Ani sir.pwd patabang.,og himoan nimo og vedio.
Maglisod kog hatag sa solution kay wa ko kakita sa imo structure .
🌹🌹🌹
🇧🇩🇧🇩🇧🇩
Thanks for watching.
this code is not worked.
I tried this code in all version of ms access and it works well.
Try to check it or else send me your coding.
I dont know why mine is not working Me.ProdName = DLookup("FirstName", "Employees_List", "EmpID =" & Me.ProdId)
Sorry for late reply.
Question...
1. Is the Me.ProdName has a source? it should be unbound or blank source.
2. Is your criteria (EmpId ) is a number or integer? try to add a single quote or Apostrophe like EmpId ='" & me.ProdId & "'"