Recent content by emanuele

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