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 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. SeanWcisel

    Using the macro builder to search for a record

    Hey guys! I need to search for a record based on the text in a text box when the user presses enter. I'm completely new to building expressions this way, could anyone tell me what syntax to use? specifically, say I want to use SearchBox to find the record with key value "293" in the UserID...
  2. SeanWcisel

    using AfterUpdate to search and update several fields

    Thanks guys, Once again, I need to actually navigate to a record. It looks like the macro builder is the way to go. I'm still not sure about the syntax for the expression though. What would I put in the "find what" field to search for something? Let's say I'm looking for customer 199 using field...
  3. SeanWcisel

    using AfterUpdate to search and update several fields

    And then just have those fields update when I select an option? That might work, I guess I'm not quite sure how that'll help me actually jump to that record though. The other problem is that this code needs to hold up when there are 10,000+ database entries. I'm trying to avoid using trees if at...
  4. SeanWcisel

    Auto increment a number in code

    How about this: Store the max record number used (assign new ones as max+1) use a while loop like this: Dim currentRecord (VB uses Dim, right?) Dim previousRecord Dim nextRecord If (currentRecord.Index != previousRecord.Index + 1) { currentRecord.Index--; } Else {...
  5. SeanWcisel

    using AfterUpdate to search and update several fields

    Yeah, they're all in the same table (well, they're from different sources, but I've compiled them in one table). I was just reading a post that describes something similar. It was only a few posts down, so I apologize for that. The problem is, I also have next/previous buttons, so I'd like to...
  6. SeanWcisel

    using AfterUpdate to search and update several fields

    Hi guys! I've got a form with about thirty text boxes on it. I need the user to be able to type a value in one of them (always the same box), press enter, and have the other values populate depending on the values associated with the user input. I have that field linked to the appropriate...

Part and Inventory Search

Back
Top