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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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?- waterj4
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
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?- waterj4
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- waterj4
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
