Recent content by AndyDuke

Hi Modex, Use the Click event of the combo box to get the Text property e.g. Private Sub combo1_Click() if (combo1.Text = "windword") then Dim ad as string ad = Shell(c:\Program Files\MSoffice\winword.exe,vbMaximizedFocus) End Sub

Are you declaring the Winsock object as: - private object as Winsock or private withevents object as Winsock The second declaration will allow you to trap and respond to events generated by the object. Andy.

Nora, Depends on your budget at the end of teh day. I use grids by DataDynamics, menus by Sheridan (as was - not sure what they are called now) and a range of home produced controls for IO. If you don't hae money to spend, then you will be limited to freeware or shareware tools (see...

Looks good to me. AndyD

I wouldn't try to force the move. If someone else is accessing the folder then you will cause them to crash by moving the folder. Just handle the error that you get. Andy.

Nick, The problem will be caused by the differeing security regimes used on the two databases. You could try putting an ADO data control onto a form and use that to build a connection string which can be cut and pasted into your code. Andy.

Check out thread222-61203. This gives two methods, one using API calls and a VB code method. Andy

Hi, I'm assuming that you are using ADO and SQL or similar here. If the stored procedure has no arguments then you can just use the .Execute method of the ADO connection, Connection.Execute "sp_StoredProcedure" If the stored procedure has arguments then you can either use the...

ChopStik, Should the function GetProperty read: - Public Function GetProperty(PropertyID As String, Page As String) As String Dim rs As ADODB.Recordset Set rs = GetPropertyData(PropertyID) If (rs Is Nothing) Then GetProperty = "This record does not exist" Else...

ChopStik, I simply check for (rs.EOF = True) after executing the SQL command. If the recordset has returned a record then EOF will be false. Andy.

mhm, Sorry for the delay, I've just returned from holiday. I don't think you can use a progress bar with teh FSO object because there is no feedback from the copy method in the FSO object. In applications like Windows Explorer they use a form with an AVI (animation) to show that the copy is in...

Hi, I've done a lot of programming with the MapPoint 2002 object library, using it to create an application for managing customer advisors and sales territories. If you want to drop me a line at andyd@hec.org.uk then I'll be happy to answer your questions. I'll be away from 28/07 to 12/09...

Mail me and I will send you a VB Class that does all this. Andy. andyd@hec.org.uk

I suspect that this is a constraint put on the Visual Basic language by Microsoft. I assume that VB is written in C++ which may not have the same restrictions. You could get round this by declaring a class call Constants and returning the constant values as properties. Andy.

Don't think you can do it (without some complicated API functionality). If you want to program an application so that DLL's contain user interface components (i.e. forms) then you end up with an SDI (Single document interface) application like Word 2000 as opposed to an MDI application like...