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!

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

Search results for query: *

  • Users: 1no7
  • Order by date
  1. 1no7

    Hiding Database Window from User

    Is there anyway in which I can permenently hide the database window, so the user can't recover it using the F11 key? Also, is it possible to prevent the user from opening the database whilst holding down the 'SHIFT' key and again gaining access to the database window? I'm using Access 97 if...
  2. 1no7

    Access/VB Color Behind Fields

    I've had a similar problem with continuos forms and the only way I could get round this was to create four text fields with a different colour format for each one. You then use an IIF statement in the control source to select the data you need it too. If you overlap the fields (i.e. so it...
  3. 1no7

    'Object Required' Error using IF statement

    Hi I keep getting an 'Object Required' error when I use an IF statement to check if a field has a null value. e.g. If strText.value is null then etc.... I'm using Access97 any ideas?
  4. 1no7

    Changing font color based on another variable

    Thanks zevw This works fine when the form has a default view property set to single form, however I'm using a tabular form that has a default view of continuous, so the code suggested only manages to change all the relevant fields to the same color. Is there anyway around this? By the way i'm...
  5. 1no7

    Changing font color based on another variable

    Does anyone know how I can change the font color in a field based on a value in another field. I need to use a different colour for each value (5 in total). I've tried using an IF...Then statement but so far i've only managed to change the font colour in the fields to the same colour. It...

Part and Inventory Search

Back
Top