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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Winsock and VBA
Good idea! Unfortunately, it won't work in this case. The "other computer" is actually a robot, and can't recieve messages sent using Net Send. Thanks anyways! -Ivy- 8Ivy
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Use a variable in a query criteria
Set the query up to use a parameter, then use the QueryDef object to set the parameter. For example, if your query was stored as myQuery, and had a parameter TradeType: dim qDef as queryDef set qDef = currentdb.querydefs("myQuery") qDef.parameters("TradeType") = strTrade...- 8Ivy
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need to hide the input to an inputbox to use it as a password
In the form's properties list is an entry called Input Mask. Set the Input Mask to "Password". -Ivy- 8Ivy
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Winsock and VBA
Hi there, I have an existing Access 2000 application and I'm trying to convince it to send messages over Ethernet to another computer. The Winsock control should be able to do this, and it works fine when I try it in VB. However, in VBA, the connect and close methods don't seem to work...- 8Ivy
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
