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!

Search results for query: *

  1. gcrutch70

    Have a value show on a form based on a query

    I have a form it has several text boxes, fields and a subform. it has a parameter that prompts for a SerialNbr. The fields on the form are SerialNbr, cboCartStatus, CartDate, CartID, ServiceID Subform fields: cboCartEvent, CartID, CartEventSubType, CartEventDate The control source for the form...
  2. gcrutch70

    trying to update a record.

    I am simply trying to update a record. I have 2 forms. One form "Open Forms" and another form "Close Forms". When the user clicks the close form button they are prompted to enter the FileNo that they want to close. Once they enter the FileNo the "Close Forms" form opens up with prefilled text...
  3. gcrutch70

    How to test for zero length string or Null string

    I'm good how are you......I don't know what i would do without Forums like this! Well that fixed my problem!!!!!! now i have one other problem. Once the user selects a value and double clicks it. the form closes. I need the list box to be clear again when the user repeats the steps. As it is...
  4. gcrutch70

    How to test for zero length string or Null string

    I have some code that uses a table called "Carts" from an Address database. and some of the addresses have units (like Unit A, Unit B, etc) and some doesn't. I need to be able to tell it to go ahead and select it if it doesn't have a unit. I am selecting the address from a list box. And when i...
  5. gcrutch70

    take value from text box and populate list box

    i have a form that has one textbox called "Street_Name" and a list box called "lstAddresses". I want to be able to type a street name in the text box (and also filter it, eg. when i type in "Ro" or "Rose" it would bring up all streets with those letters like "Rosewood" and list all the streets...
  6. gcrutch70

    I need help writing code to tell me if a record exists

    well nope....thought I did. still getting the object variable error. Help intCountTag = DCount("[TagNumber]", "Tag", "[TagNumber]='" & Me.TagNumber & "'") If intCountTag > 0 Then MsgBox ("that Tag Number already exists, this will be a second warning! Go back and check Second Warning...
  7. gcrutch70

    I need help writing code to tell me if a record exists

    Thank you so much for your help. I think i've got it working now.
  8. gcrutch70

    I need help writing code to tell me if a record exists

    ok that works but after it runs and print the letter it gives an error: Object variable or with block variable not set. What is that about?
  9. gcrutch70

    I need help writing code to tell me if a record exists

    ok I'm sorry. I have a table called "Calls" this is where all the data is written once the user enters the info in the form. In this call table is a field called "Tag_ID" which is an auto number field and primary key in another table called "Tag". in this "Tag" table there is a field named...
  10. gcrutch70

    I need help writing code to tell me if a record exists

    i have a field Tag_ID which is the TagNumber from another table. So i wasn't sure if i need to use Tag_ID or TagNumber.
  11. gcrutch70

    I need help writing code to tell me if a record exists

    I have an access application with forms, tables, etc. I have a form that the user enters data. When the user enters a new record i need it to tell the user if that record already exist or not. if so, give message. if not, add it.

Part and Inventory Search

Back
Top