Search results

sir i more thing how can i auto refresh it... because every time i go to other record there's but when i press the refresh it will now show... thanks again....

thanx a lot my prob solve...

@kegz Just follow the instruction of sir booty

sir i attached the sample and i look in your links.. im sorry im not good in coding i can learn more on examples and understand it... but im trying now.. i dunno where to put it is it in EVENT After Update? can you look my sample and check for the error... thank you very much im preparing...

@ John Big Booty sir i attached the sample and i look in your links.. im sorry im not good in coding i can learn more on examples and understand it... but im trying now.. i dunno where to put it is it in EVENT After...

hi i would like to ask on how to link text box... here is my problem i have inserted a Tab consist of 4 tabs in my forms... in TAB 1 i have with a formula insidelike this (=[text18]+[text20]) now in TAB 2 i want to show the TOTAL came from TAB 1. i tried this already but it dont work error is...

o ic i have come up with this idea.. ill make 2 query 1 is all the check and 2 is the no check in the checkbox... and make 2 button to open it.. any other suggestion?

hi sir, i have a query with a yes/no check box in it.. in my criteria in yes/no i put it only shows the box with check when i generate the report... can anyone help me how to make a button that i can open the report if i select the box with check only in my report only the box with check will...

i look in your db i just change the formula in your unboundtextbox balance... =[Amount]-[Deposit]just put only this.. look the formula in you balance... hope it help... ps...dont put spaces in your field name... ^ ^

thank you for this, my database need a lot of revision.. i understand a lot sir.. thank you again...

try this create a report based on your query the in your criteria in your query put this Like [Forms]![searchform].[Name of combo box]& "*"the create a combo box based on your query field... it works very well for me... example.. you make a combobox based on Name field in your query Like...

Sir Beetle im having trouble in my report.. i added a table named tblpreschl which consist of the following field School ID, Male, Female i cant put it in enrolment table for the reason that pre-school is not included in the grand total... i notice when i put the pre-school data in tblenrol...

sir beetle im corrently working my own sample database based on your modified database... my data in secondary consist of 198 schools and 861 school in elementary.. i send you mail private here in this forum.. hope you read it and get some response... this forum help me a lot... thank you...

Actually i have 3 table connected them in Tabcontrols using relationally tblschooldata - first tab tblenrolment - secondtab tblagprofile - third tab my main focus is how can i add all the total to make the grand total appeared in my report thats why i only put the table enrolment in my sample...

im sorry im just a beginner in ACCESS my table objective is to get the total enrolment... that's why my fields are: Stdschool for example i have 3 school namely school 1, 2 & 3 StdfirstyrM StdfirstyrF StdsecndyrM StdsecondyrF StdthirdyrM StdthirdyrF StdfourthyrM StdfourthyrF sa you can see...

There is, in my table the fields are only Name of School, first yr male, first yr female, second yr male, etc.! there is no total fields of male and female and no grandtotal of the 3 schools.. any idead how to do this sir.... you thought me that total should not store in the table.... now im...

hi all, good day i have a problem in my data base getting the grandtotal of my subtotal... i dont have a TOTAL fields in my Table... my TOTAL in my form is Unbound in my form this is the code in my unboundtextbox total First Yr =[first yr male]+[first yr female]Second Yr =[second yr...

hi its my problem since from the beginning.. i split my database because i use it in Network... now i need to add a new table in my back_end datadase.. i did it! added it but when i try to connect it to my Front Database using Linked Table Manager The new table is not there... i try this method...

i found a way i use relationship... thanx

good day! i have a problem in my database i created 2 table namely tblrecord and tblenrol and in my form i created a TAB CONTROL page 1 is Record (source is tblrecord) page2 is Enrolment (source is tblenrol) i use FORM DESIGN MODE and click Add Existing Field i drag and drop the tblrecord...