Thanks When pop form is open so MS Access Page is also seen in back... How to close these Options. I mean when user use this project only saw the hole Popup App
Hello Sean, please, after filtering a bd through several combo boxes, how do we apply DCount function to count the visible rows which appears at a time in MS Access.
Maybe the form area you designed is really big? You can tell when you look in design. Make sure the light grey canvas is only as big as you need for the pop up. If it is too big, it will fill your screen. That doesn't look like a pop up!
In the Form table, if the document is N, the title is HOA DON NHAP SACH, if the document is X, the title is HOA DON XUAT SACH. So what should I do in the design part?
You can do this using the On Current event of the pop-up form. th-cam.com/video/KdR1LVt3VJc/w-d-xo.html In the On Current event, just put something like: If (your document field) = 'N' then strTitle = "HOA DON NHAP SACH" Else strTitle = "HOA DON XUAT SACH" Me.Caption = strTitle
Good question! You can use expressions. You can make a button with an On Click event, or use the After Update event of a text box, where you put the code: Forms!frmMyReceivingForm!txtValueToSet = Me!txtValueToSend Something like that. This works for active or inactive controls.
Excellent Video.... Thank you so much I am searching since long time for video like this. thanks lot... please can you guide me how to design tables for a employee hiring and transfer maintenance DB in various branches of a company for employees. In MS Access please. 1. DB should allow to assign employees to vacant posts, if already assigned it should show it is already assigned. 2.Once employee is assigned to a Post then status of post should change to filled from the date of appointment to till the date of removal/resignation/transfer of employee. 3.If employee resigned and transferred, then the status of post should become Vacant and then it should allow us to assign other employees to that post from the date of vacant 4.DB should record various employees worked in a post for different periods. 5.DB should show us no of posts filled and no of post vacant at any time. please guide or make video on this please... I am desperately needed this please.
Thanks and glad you enjoyed it! That's a pretty nice database you're designing. You're going to need some tables for each of the things as they exist in the real world, then some junction or transaction tables to accommodate several many-to-many scenarios. Something like: Tables; employee, job, employee_job_posting. #3 will be a function, answered by simply looking at the data and comparing dates to see if the job is currently filled. #4 will be recorded in employee_job_posting, which will have start and end dates which occur when those event happen. #5 you can simply query for these and present them in a report. The table employee_job_posting will have foreign keys for employee and job, plus start and end dates.
![[Gegagedigedagedago] NEW Help Gegagedigedagedago Nugget escape from Nikocado Avocado Challenge](http://i.ytimg.com/vi/hJWnwRC2Fz8/mqdefault.jpg)
Thanks
When pop form is open so MS Access Page is also seen in back... How to close these Options.
I mean when user use this project only saw the hole Popup App
Good question.. I remember I saw that before. I'll have to remember how I did it!
@@seanmackenziedataengineering Thanks your reply sir
Hello Sean, please, after filtering a bd through several combo boxes, how do we apply DCount function to count the visible rows which appears at a time in MS Access.
Try adding one text box to the form. Set the control source to:
=Count(*)
Is it possible to add/show another mini form on MouseOver... If posible please show us how to do it.. Thanks
Great idea for a video, thanks!
It’s still confusing, mine isn’t popping up, it just fits my screen and doesn’t move around
Maybe the form area you designed is really big? You can tell when you look in design. Make sure the light grey canvas is only as big as you need for the pop up. If it is too big, it will fill your screen. That doesn't look like a pop up!
In the Form table, if the document is N, the title is HOA DON NHAP SACH, if the document is X, the title is HOA DON XUAT SACH. So what should I do in the design part?
You can do this using the On Current event of the pop-up form.
th-cam.com/video/KdR1LVt3VJc/w-d-xo.html
In the On Current event, just put something like:
If (your document field) = 'N' then strTitle = "HOA DON NHAP SACH" Else strTitle = "HOA DON XUAT SACH"
Me.Caption = strTitle
How to pass a value from unbound pop up form to another forms active control please?
Good question! You can use expressions. You can make a button with an On Click event, or use the After Update event of a text box, where you put the code:
Forms!frmMyReceivingForm!txtValueToSet = Me!txtValueToSend
Something like that. This works for active or inactive controls.
you are the best
Thanks for watching!
Thanks!
No problem!
Excellent Video.... Thank you so much I am searching since long time for video like this. thanks lot...
please can you guide me how to design tables for a employee hiring and transfer maintenance DB in various branches of a company for employees. In MS Access please.
1. DB should allow to assign employees to vacant posts, if already assigned it should show it is already assigned.
2.Once employee is assigned to a Post then status of post should change to filled from the date of appointment to till the date of removal/resignation/transfer of employee.
3.If employee resigned and transferred, then the status of post should become Vacant and then it should allow us to assign other employees to that post from the date of vacant
4.DB should record various employees worked in a post for different periods.
5.DB should show us no of posts filled and no of post vacant at any time.
please guide or make video on this please... I am desperately needed this please.
Thanks and glad you enjoyed it! That's a pretty nice database you're designing. You're going to need some tables for each of the things as they exist in the real world, then some junction or transaction tables to accommodate several many-to-many scenarios. Something like: Tables; employee, job, employee_job_posting. #3 will be a function, answered by simply looking at the data and comparing dates to see if the job is currently filled. #4 will be recorded in employee_job_posting, which will have start and end dates which occur when those event happen. #5 you can simply query for these and present them in a report.
The table employee_job_posting will have foreign keys for employee and job, plus start and end dates.