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 nicola1982

  1. nicola1982

    Check box default value

    Hi PHV, Yep, the field does allow null. Nicola
  2. nicola1982

    Check box default value

    Hi Zameer, Thank you for your reply. I tried the first option, but the triple state is already set to "No". I don't think that the second option would work, because I don't want the field to be permenantly false. I only want it to be be blank when the form is first opened. If a user changes...
  3. nicola1982

    Check box default value

    I have a database that is Access 97 front end and SQL Server back end. On one of my forms I have a check box that I cannot assign a default value to (I want it to be false). At the moment, when the form is opened, it is greyed out (though still "clickable"). However, setting the default value...
  4. nicola1982

    Graphs

    There is probably a really easy solution to this, but I just can't figure it out!!! I performed an investigation, which was to return a certain percentage of data (e.g. 1%, 2%, 5%, 10%, 25%, 50%, 75% or 100%) and time how long it took for the data to be displayed to the screen. I did each...
  5. nicola1982

    Grabbing and using IP addresses

    Hi Jeff, Thank you for your reply. The email option sounds like a better solution. If I do it this way, am I right in thinking that this can be done straight from Access rather than needing any Javascript? I will be running SQL server on NT server. Many thanks
  6. nicola1982

    Grabbing and using IP addresses

    I'm creating a form which will be posted on my company's Intranet. When users press "submit", I would like the IP address to be captured and stored in a cookie. The data on the form will be transferred into a database and once this has been done, I would like to send a copy of the form back to...
  7. nicola1982

    Visible/Not visible

    Hi Ken, The complete code now reads: Private Sub cboPrimaryDiagnosis_AfterUpdate() If Me.PrimaryDiagnosis = "Cancer/Malignant" Then Me.CboNonCancer.Visible = False Me.CboCancer.Visible = True Else Me.CboNonCancer.Visible = True Me.CboCancer.Visible = False End If End Sub Thanks Nicola
  8. nicola1982

    Visible/Not visible

    Hi Ken, Thank you for your reply. I've removed the two lines of code setting the focus but unfortunately, it still doesn't work. Many thanks Nicola
  9. nicola1982

    Visible/Not visible

    Hi Chris, Are you the same person who answered my question somewhere else? I've put the code on to the AfterUpdate event. All three combo boxes are there when I open the form, but regardless of the item I select from the primarydiagnosis combo, the cboCancer disappears and only the...
  10. nicola1982

    Visible/Not visible

    I have combo box (called PrimaryDiagnosis) on my form containing two values. If the first value is chosen, then I would like another combo box (called CboCancer) to show up, but if the second value is chosen, I would like a different combo box (called CboNonCancer) to show up. This is the code...
  11. nicola1982

    Autotext in Word 97

    At the moment all our users back up their "normal.dot" which stores their macros, etc. However, today I've noticed that any user-defined autotext isn't actually stored within "normal.dot" so even if they do back the template up, none of the autotext entries are saved. Does...
See more

Part and Inventory Search

Back
Top