Search results for query: *

I clicked on FAQ219-2884 and FAQ222-2244. Both displasy errors. Can you send me what each says? Thanks

How can I enable or disable the print button on my form depending on the CurrentUser that is logged on? Some Users will be authorized to print out the record, others won't. The print button will print out the current record if clicked. Thanks

I created a Main Form in Access 2000. I also created a subform where I can enter different addresses. The data is stored in SQL 2000. When I enter two different addresses and save, the second address writes over the first address so I end up with duplicate addresses. How can I prevent this? Is...

How would I check to make sure that the user enters the correct number of chararacters in a field? This is a Access database. Say that the field is 4 characters long and the user enters 3 chararacters and then hits the tab key to exit out of the field. I would like to display an error that says...

I created a 'Find Record' Command Button on my form. I would like to have the button, once I click on it, prefilled in the 'LookIn Area' with a certain field name. The user 99 percent of the time searches on Social Security Number. The Social Security Number is the fourth field on the form. I...

Thank You Gazonice. It Works.

How would I cause a field in my Access form to always be entered and displayed as lowercase. I've tried putting a '<' in the format property but if I use the CAPS key, the results are Uppercase. Can you also help me in wrting a query as I need to convert this same field in my table to lower...

Using a query as input to my report, I want to print out out a value that looks like this -Example: 133.82258. I want to print only the 133 value, nothing after the decimal point. The number may vary, I'm calculating averages, and it could also be something like 27.478930. Is there something I...

I forgot to mention in my earlier question that when I set up Access in production, I remove the toolbars. The user has only the 'BUTTONS' I provide. One of the toolbars contains 'FILE' so therefore I cannot get to 'SEND'.

When I used Access97 version 8 I was able to right click on a report and a menu would display that would allow me to send e-mail to one of my users. The menu has the 'SEND' option. Now using Access 2002 version 10 when trying to send out an e-mail after right clicking on a report, the menu does...

I've used the formula next31-60 days in Crystal Reports. Besides creating a date parameter, does anyone know how to get the date range of 0-90 days?