mstangeh

hi, I need to create or replace a permanent query in access (like a view in oracle, postgres...), but from vb6 using ADODB. i know that i can create and alter tables using a ADODB connection object with something like this dim obj as new adodb.connection ... ... obj.execute "create …

declare this in your bas: Public Declare Function ShellExecute Lib "shell32.dll" Alias _ "ShellExecuteA" (ByVal hWnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long and to execute a programas use this: Call ShellExecute(0&, vbNullString, …

I dont know if this would help you, but... Here is an example code for creating any object y execution time 'first create a new object dim chkbox as CheckBox Set chkbox = Controls.Add("VB.CheckBox", "chhboxname", "the container") 'the container could be a picturebox, frame.... 'now you can set all the …