Search results

i guess ur subform is null with no records, try to fill something then view

you said something right, i dont want to delete the EmployeeName, but i asked the question generally since when i get the code i can use it for good purpose. i have put other command in this Unbound form to open a Form for new record entry, and lets say the user clicked it wrongly and a new...

hi, I have in an unbound form a List box with Row SOurce of EmployeeName from a table, im selecting one of the names of the employee and loading form of specified Employee name using filters I want to create a command button to delete the selected EMployee Name from the list Box (which in its...

maybe i was not clear enough, i have something like 7 subforms in my Report, its data is taken from a Form input, they both have the same Source table. when some subforms are not filled with record in the form, they are not appearing in the Report, but just their Caption is appearing which is...

i have many sub forms in my form, but not all subforms are filled with records on my form, so the ones not filled with record is leaving the report blank and displaying only its captions (my subforms are viewed as Datasheet in the report), Can i do something so that those Captions that i am...

hi, i have a formula where i want to calculate it each time im doing next with the data navigation button... i tried to put the code in "on change data", "on after update" of the form and its not calculating... the formula is correct and its working in other fields. where i shall put the code...

Thank You Sir, this is it:)

i have a form of Employee Info, where with navigation button i move to the next employee. i have put a Command button to Preview Report on Single Employee Info that i am reading currently. So i want to Filter the Report with Single Employee Name and records so im coding on click even of the...

hi, i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent can i assign in One Form's Record Source 2 Queries? not at the same time for sure...let me give the correct figure i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent when i click cmdOld i will load a...

hi, i was worked on Access with my screen resolution 768x1024, and i took it to run in another PC of display 600x800, and as a result form sizes where changed and many many things to edit again, is there a coding so that when i run the access it checks the display size of the system screen...

hi, Check the attached File, i have a form with 2 text box, one is entry of Date Employed and after update the second text box calculating the current system date will subtract both years to display how many years Employee worked i've put =Date()-[DateStartedJob] After update of first text box...

thanks :)

check the attached file...its a stupid thing...but in all cases u know my name hehe

yes sir, i am surprised why

hi i have created subforms and set the Default View to Datasheet Now i have a form where i am adding command buttons on it to load those subforms but They are not Loading it as DATASHEET VIEW. Any Clue? Thanks

sorry to bother again, but i guess after checking and realizing that we are using 3 command buttons and playing with the visibility properties, it will be so hard for me to reach what i want to accomplish. since i will use somehow 8 command buttons under each other, and when i click one subform...

what i will have is a form with maybe 10 command buttons under each other to make subforms visible and invisible, and maybe it will reach a place where the form will be bigger than the screen and there must be stretching of form so that the user scrolls down...thats why i asked from u to make ur...

Thanks alot, this is it :D i wanna ask for one more thing, can u try to make ur form smaller then run the form and click the command button to open the subform, and u will notice that the second command button is not appearing, so something to be done also with the main form to strech (showing...

Command button i am using shows and hides so it has 2 actions, so similarly they are sorted down each other, the example u gave is opening the subform in other area which i can do that, but i want to know if the same example u gave can open the subform in the middle of those 2 command buttons...

Hi, I have 2 command Buttons under each other in a Form, I will click the Top Command Button and it will open a subForm between the Command Buttons and Stretch the Form Down, and when i hide the subform, i want to see the 2 command buttons on top of each other again. Can anyone tell me what...