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 Wanet Telecoms Ltd 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: rgatrell
  • Content: Threads
  • Order by date
  1. rgatrell

    Extract string from between brackets

    Hi, I need to extract a value from a dynamically changing string but only the bit between a set of brackets, e.g. var exampleString1 = "some text (I need this bit)" var exampleString2 = "some more text (value to store)" Output: exampleString1 = I need this bit exampleString2 = value to store...
  2. rgatrell

    Assign NULL to all parameters containing empty string

    I'd like to create a function (or perhaps it should be a stored procedure?) that I can call from any stored procedure. It needs to loop through the values of all parameters, checking to see if any of them contain an empty string and if so, assign NULL to each. I'm aware that you can assign...
  3. rgatrell

    One-To-One relationship design issue

    I’m creating an Asset Inventory (using MS Access for now) and have settled on the following design (please note there are other tables and fields involved but I’ve omitted them for readability): Assets Table: ------------ AssetID (PK) AssetType Tag Make Model Serial etc. Computers Table...
  4. rgatrell

    code / query to update field in second table

    I hope this makes sense: 2 tables - "tblVehicles", "tblJobs" The table "tblJobs" has a field named "JobIsMOT" (yes/no field) and a field named "JobDateCompleted" (date field) The table "tblVehicles" a field named "VehicleMOT" (date field) The idea is to have the jobs form (which is bound to...
  5. rgatrell

    Textbox entry history

    Hi, Does anyone know if it's possible to store the last 5 items you typed into a textbox - similar to the search history in Windows XP etc. I have a textbox that users input a word to search for, and I would like to have some sort of search history. Thanks

Part and Inventory Search

Back
Top