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 Chriss Miller 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 fossx
-
How to suspend code till Activex event is handled
Anyone know a better way to suspend execution of VB code until an activex control responds and the event is handled other than using a loop with a doevents statement in it. Such a loop seems to be slowing my application significantly. Thanks.- fossx
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
Code works in Excel VBA but not Access VBA?
Replaced code in my access module with: Excel.Application.DDERequest Everything worked fine. Thanks.- fossx
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Code works in Excel VBA but not Access VBA?
I am running Office 2003 which has VBA Retail 6.4.8869 running for both Excel and Access. The following code works just fine in Excel but gives a "Compile Error: Can't assign to array" error in Access. It is a DDE request that returns an array. Function doRequest(serverName, topic, request) As...- fossx
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
