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 Chriss Miller 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: *

  1. scottintexas

    Invalid use of null

    I am using Access 2007. I am taking field values from a form and putting them into the properties of a class object. Some values can be null, but I get the error "Invalid use of null..." because the property is expecting a value. How do I tell a property that null is ok? For example I have this...
  2. scottintexas

    DoCmd.Close not closing the form

    When the user clicks on "Cancel" the pop-up form is supposed to close itself. I am using Private Sub cmdCancelSurvey_Click() DoCmd.Close acForm, "frmNewSurvey" End Sub and I have also used the "Me" keyword for the form name. Yesterday this was working (or appeared to be working). No...
  3. scottintexas

    Using DoCmd.OpenForm causes error 2501

    I'm trying to open a pop up form. I have tried docmd.openform FormName:="frmCounty", WindowMode:=acDialog and DoCmd.OpenForm "frmNewCounty", , , , , acDialog Either one generates the error; "The OpenForm action was canceled" I just can't see what's wrong with this. ScottInTexas It's...
  4. scottintexas

    Addressing Content Controls in Word 2007

    This may be too new for any answers but since I am trying to make this work I might as well ask one of the masters here. I have placed a ContentControl (Text) on my document. The Tag is txtTractID. I want to grab the text the user puts in that control and put it in the second text control...
  5. scottintexas

    Split fuction in Access 97

    OK, so I have an old version. What I need is a split function. Has anyone built one from scratch? I did a few years ago , but I am oout of practice and I am being pressured. I need to split a comma delimited string of items. Thanks, Scott

Part and Inventory Search

Back
Top