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 ...

still intressed? Buon giorno Sentient, I thougth you might want to have a look at this filter... just place a button on the database to open the separate form with a filter (the code is basically the one you got from Wayne) Just have a look at the codes, since you might find it difficoult to...

Grazie. (means thank you in italian)

one more inch? Hi Phile, thanks for your reply. I just need one more little advice: How do I make a Delete Query? Sorry for being such a beginner :confused:

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

one last advice one last advice... trow away the access for dummies, it does not really help at all. Get I better book, like a developer´s handbook or similar, there you can find what you need, as well as use the search function on this forum and have a look at all the old topics. good luck.

try this one too .. its in english. this works are not mine but I´ve used the codes as well for my databases.. I am also one of those who just started with access, but I promise you can do a lot if you just put some effort in it and try without giving up. Besides the "gurus" here are always very...

try this. try this... designed in italian but just check how it works by reading the codes..

:confused: no one could give me any suggestion?...... :(

password http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46271&highlight=password http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36910&highlight=logon+password have a look at these, otherwise there are many other threads to check. just go on...

a look at this sample? If you have time and feel like you want to take a look at this sample I would be grateful. I explain in it what my problem is.. thank you for all the support.

thanks for the help thanks for your help Mark, I will try it now and hope it will work. just one question... do you know where on the web I can get informations about how to write codes using if ... else if, as well as information on how to customize msgboxes, I might need it in the future...

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...

thanks for quick reply the range is : Chrome: >= 0 <=9 Silver: >=10 and <30 Platinum: >=30 I already have this in form current in the form "Medlemmar" Private Sub Form_Current() If Me![given points] >= 30 Then Me!Medlemstypnr = 3 ElseIf Me![given points] >= 10 Then...

shortcut... http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=41472 the shortcut....

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...

Thank you.. Once again I´ve got some useful help. Everytime this happen It makes me feel so happy and this is not only for the help itself, which also is helpful for writing simila future codes, but for knowing that you all people are so kind to dedicate so much effort in helping others... I...

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...

Would love to... Hi ! I would love to see your database, maybe I will learn something new.... e-mail to emfedele@yahoo.com Thanks

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...