Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by FredSB

  1. FredSB

    Button in Access

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

    Button in Access

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

    I duplicating my input data in an Access subform

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

    Field Length Edit

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

    'Find Record' Command Button

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

    Always LowerCase

    Thank You Gazonice. It Works.
  7. FredSB

    Always LowerCase

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

    MS Access Print Question

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

    Sending E-mail Problem

    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'.
  10. FredSB

    Sending E-mail Problem

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

    Next 31-60 days

    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?
See more

Part and Inventory Search

Back
Top