Recent content by Phredd

I really only need something basic. High security is not a concern. What ever is easiest for a new player to setup. Ideally the same code can be used on every installation for the 12 month period. Once expired there would need to be a single new code applied to each installation. For this...

I have designed a database and would like to restrict access based on a subscription. If they have entered a validation code, then the database opens. If not it drops to an error message. Code then keeps working until the specified time (12 months) then will require a new validation code. There...

Sorry. If I am understanding you correctly I cant see how that would work.

Hi Guys, I have setup a very basic form which includes several yes/no boxes to indicate requested logons for local software programs. I need the related report to be sent to specific emails depending on the yes/no boxes selected. IE if some selects tick boxes 1, 5 & 9 in the form then the...

Hi Guys, I am trying to determine which user currently has a database open in my company to allow me to ask them to close it for maintenance. I am a little (Lot) out of my depth with this level of coding, but have stolen this code from another site on recommendation. While I have no errors, I...

The "Error" handle ?? Not sure what "Hitting" it will do. Nothing seems to has changed regarding the error. Remove all error handling or leave as is. Either way it errors 2501 ever time I cancel the print.

I know this has been covered to death, and I think I have read every post. My issue is although I think I am following all the advise, it appears my line "On Error GoTo Errorhandler" is not being recognized. I have put this line in many locations, and every time it just seems to skip or...

Yah............Thanks Many thanks. It is now doing what I wanted. Now i can see it working, I can debug and modify... Thanks again.

Differant type of Random Hopefully it is acceptable to upload a small file... I need to randomly sort each team on the attachment every time the report is run... It sounds so simple... I am sure someone could look at this and do it in 30 sec, but its loosing me. Sorry if I am asking too...

:confused: I have teams for example , Red, Blue, Green and Black. (Except there are 20 or more.) Each week they need to be in a differant order. I tried =rnd() in a Query this gives them all the same number, and if done in a report won't sort. It needs to change every time the report is...

Little more help :confused: Sorry to jump in on someone elses thread. But I have the same issue trying to generate a random Team draw, and need a little more direction than the one provided. I have teams for example , Red, Blue, Green and Black. (Except there are 20 or more.) Each week they...

Got it ...thanks I have said it before..... This is the best place anywhere for getting quick and accurate responses to question. Well done guys, and thanks

Thanks Mile-O-Phiile.... What was the trick to get the button to "Become Active". I drew the shape etc, and started playing with "ON" events, but my button still thinks its a label. Thanks guys, I think once I get this bit going I should be right.

Guys, Is there any simple way to change the BACKGROUND color of a button in a form from the standard grey to anything else. Thanks

Graham, Humour me............. Which link do I go to next ??