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 John Tel 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 psatyendra
-
Recordset Performance issue
Sorry. This solution doesn't work for me. Because i need to call RValue function more then 4000 times. So every time, if we call database is not a fair idea. I tried this solution, But i found bitter performance issue. Can anyone help me to solve this. I think, is there any solution to use pivot...- psatyendra
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
MsgBox in VBA; font size
Hi I think better way to achive your requirment is, add a frame to your window and custimze it as you want. Add a close button and in onclick event hide that frame. In page load hide that frame and when ever you require it, show it. Satyendra- psatyendra
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Recordset Performance issue
Hi I am working on VBA macro's coding for Excel from last 3 months. I did a small reporting project and delivered it to client. I query data from SQL recordsets and displaying it. But it was slow while looping recordset. So copied complete data into variant variable and i loop that variant...- psatyendra
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
