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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Attempting to access stopped site forwards to non-default
I'm running an IIS 6.0 webserver with about two dozen different customer websites, all on the same IP and TCP port, differentiated by host names. Some of these sites are discontinued and have been stopped in IIS. I would expect - from what the help file tells me - that attempting to access one...- peter0480
- Thread
- Replies: 0
- Forum: Microsoft: Windows servers
-
After update trigger
AfterUpdate will not trigger on the field being updated by code. You could, however, call the AfterUpdate directly yourself, or put its code in a procedure of your own which you call both from the AfterUpdate event procedure as well as after closing the search form.- peter0480
- Post #3
- Forum: Microsoft: Access Forms
-
ADO and SQL syntax
The column 'Size' may be the culprit. This is a reserved word, which can cause the query to fail depending on where it's run from. You could either change the column name or, whenever you refer to it in queries, enclose it in brackets like [Size].- peter0480
- Post #6
- Forum: Visual Basic (Classic)
-
How to requery after update/insert/delete
What is keeping you from calling the requery (I assume you get an error)? My most recent Access VBA app calls a sub doing a Me.Requery from the AfterUpdate event of dozens of controls of the form (due to customer's wish to instantly write a new record with every change made). It makes things a...- peter0480
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
