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 dencom 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: gcrutch70
  • Content: Threads
  • Order by date
  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 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...
  4. 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...
  5. 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