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!
Search results for query: *
- Users: jwstockwell
- Content: Threads
- Order by date
-
use VBA function in WHERE clause
Can you use a VBA function in a WHERE clause - either in query designer and run it immed or using ado/dao in immed window ? I want to : UPDATE mytable SET field1 = "JANE" WHERE iseven(mytable.idnumber) TIA- jwstockwell
- Thread
- Replies: 4
- Forum: Microsoft: Access Tables and Relationships
-
Slow Defaults in New Record
ACCESS2000 I have a form with four pages and subforms on Pages2-4. Page1 has 5 controls bound to fields from a SQL query from one table. Pages2-4 have fields bound to other more complex queries. When a new record is added for Page1 only 1 of three default values show up in the controls...- jwstockwell
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
clustered resources
When setting up resources on an NT cluster, is it true that you have to set them up on each of the nodes (making sure they're identical of course), then 'register ' them for the cluster (virtual server). I watched one of our consultants do it this way last week and can't believe that MS would...- jwstockwell
- Thread
- Replies: 1
- Forum: Microsoft: Windows servers
