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 John Tel 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: waterj4
  • Content: Threads
  • Order by date
  1. waterj4

    docmd.runsql syntax

    I'm going over some old code that someone else wrote DoCmd.RunSQL "UPDATE tblAssetRecon_Exceptions SET LegalEntity = 0 WHERE LegalEntity Is Null;", -1 What does the -1 do?
  2. waterj4

    find text between two symbols.

    I have a text file that I want to get the data that is between two symbols. (":" and ",") example of Text field "Pet: Dog, Rover Black lab" "Pet: Fish, Moby Goldfish" "Pet: Bird, Tweety Canary" I just want to grab between ":" and "," to return " Dog" " Fish" " Bird" How do I do this?
  3. waterj4

    Problem with Dcount with date criteria

    I'm trying to check a table to see if it has any records that have been added today. In the table I have a [date created] field which is being createded with a default of now() and the format is set to short date. I'm trying to use DCOUNT to count the records that have a today date. I will...

Part and Inventory Search

Back
Top