Search results

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

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

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

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

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

Can you change the color of the command buttons on a form ??? :confused:

Have set up a few buttons on a form. Sometime when I do this they will stop working. "The expression on click you entered as the event property setting produced the folowing error. A problem occured while MS Access was communicating with the OLE server or Active X controls." Can anyone tell...

Have set up a few buttons on a form. Sometime when I do this they will stop working. "The expression on click you entered as the event property setting produced the folowing error. A problem occured while MS Access was communicating with the OLE server or Active X controls." Can anyone tell...

How do I add the cool pics to my profile..........

Anyone know of any Access 2000 Online training courses ?? Free ones of course ??? Thanks

I have used the [Enter Date Required] criteria format to select the dates for a query. This prompts the user to enter the date. How can I set an input mask on this method, or is there a better method of doing this ?? Thanks

This may sound overly simple.......But How do you resize a "Tick Box" in a form ??? Thanks

I know its not designed to happen, but is there a way to force a form to print on one page. My extensive form, I have now discovered, is about 10mm wider than an A4 page. Don't make me redesign it all please... I am learning to hate Access................ Thanking you

Is there any way of working around the maximum number of fields issue, without splitting into two reports ?? 255 is the limit.... I need 262 Thanks Guys..

Have created an option box. This enters 1,2,3,4..... as selected. Now I want to count in a report the number of 1's and 2's etc. Any ideas please...............

I am try to get a report to count how many entries of a certain type in a field. EG. How many blue items listed in the color field. The problem is I want how many Blue, Red, Purple, Black, and Orange all in the one field. email me on mickblackmore@telstra.com and I will give you an example of...