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 bkrike 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 caper64
-
How to Compare New Value Against Existing Table
I'm using Access 2000 and want to validate the entry of a new value against those values already in an existing table. One approach I was considering was to query the table (using DoCmd.RunSQL) and load the results into an array, then compare the new value by looping through the array looking...- caper64
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
DoCmd.SendObject Failure After Initial Success
I've tied the code below to a button on an Access (v. 2000) form that is used to send an email notification from Outlook (v. 2000). It works great; populates the subject field, pulls values from the various form text boxes just like it should, but it only works a few times and then it won't...- caper64
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
