Search results

Hi everybody! I know that it is good rule not to have sums in a tbl, but How do I do then when I want a report to be ordered by a sum lbl on a form? In my case I have already two tbls: (tblmembers and tblpoints) and a form with a lbl that tells me how many points every member has ...

in a db I would like records from a tbl to be automatically deleted when they are older than 3 years. my records are stored by "Year((date))" #9999# any ideas? Thanks

can someone take a look this code? it is not working... : I mean all the simple codes work if I write one by one, but when I write all these "elseIf" I have problems. I understand I do no know how to write it and I need some information about how to use If, else if....then Anyone can suggest...

Hi everyone, I have tried to make this help I got from IIkhoutx work on my database but unsuccessfully.... The thing is that (It seems) I do not know how to use the "requery" so that everytime I give any member new points the txbox "Medlemstyp" will update according to the sum of given points...

I am still working on this... take a look at the help I previously got.... Now the question is: Is it possible to get a notice in form of message box everytime the value in Me!status changes? Please, in case you think that this is not possible can you let me know so I stop trying and I can go...

How do I make this happen? Could not find any help on the forum. Thanks to IIkhoutx previous help, I am now able to have the value of a combo uppdating automatically when the value in textbox changes (Cool!) I am now trying to make this happen but tried and tried without succeding: When the...

Is anyone willing to take a look at this sample?.. Any suggestion is appreciated, Thanks..

Please some help..... A form called "Members" based on tables: "Profile" and "Points registration" and "Bonus level") shows all information about my club members. I would like to have on the form the datas from the field "Level" in table "Bonus Level". This should uppdate automatically based on...

Hi guys, I just delivered to my company my first database of which I am very proud since I did not know what access was until one month ago. I got a big big book at the library and succesfully created My "Bonus System". Now The problem is: I created a report that shows to each club member how...