Search results for query: *

Thanks was wanting to hear that though. Looks like I'v a lot of editing to do!!!!

Hi is there away to encryption all my stored procs in one operation, in other words a bulk encryption of all stored procs. Thanks

Is there any advantage of using a view over a non paramatised stored procedure?

Try the following Excell creation In VB this will creat a workbook and sheets without Excel on the machine Hope this helps

You could alos take a look at VB Smart this has some good free Xp stlye controls the menu control stands out!!! Hope this helps!!!!

You could also take a look at the followwing site SmartVB you will find some fee XP stlye controls the menu control is very good and takes a lot of the pain away associated with menu creation. Hopr this helps!!!

Try using the SSTab controle it makes the whole prossess painles as each tab gives you a new pain to laycontrols on so no need to send to front or change the visability state of controls. Hope this helps!!

The following link is for a FREE splitter control for use in VB6 it truely is a great control and better than the .Net version. MB Splitter Hope this helps !!!

I have a tutorial for this that i got of the web a hile back. Also there is a FREE third party control that can do it for you also MB TRAY

Try changing the code to this Set db = OpenDatabase("C:\test\orders.mdb") Set rs2 = db.OpenRecordset(cmbTables.Text, dbOpenDynaset) Hope this helps!!!

Try the following it should be what you are looking for! Option Explicit Private Sub Command1_Click() Dim a1 As String a1 = "as" MsgBox fac(a1) End Sub Public Function fac(letter As String) As Integer If Asc(LCase(letter)) <= 122 And Asc(LCase(letter)) >= 97 Then fac =...

Hi all I'm writitng a template that adds a combo box tothe standard controlbar. but when saving the document it also wants to save changes to the .dot file also. Private Sub Document_New() Dim cboNames As CommandBarComboBox Dim objToolbar As CommandBar Dim conTelList As...

What object are you using????

Or along the same lines this Select Case MsgBox("Please chose", vbYesNoCancel Or vbExclamation Or vbDefaultButton1, "") Case vbYes 'Do something Case vbNo 'Do something Case vbCancel 'Do something End Select Hope this helps!!!

You could also use this, it allows you to make as long a directory poath as you like. Private Declare Function SHCreateDirectoryEx Lib "shell32" Alias _ "SHCreateDirectoryExA" (ByVal hwnd As Long, ByVal pszPath As String, _ ByVal psa As Any) As Long Private Sub Form_Load()...

Not the mopst elegant solution but you could place both conection string within your code strating with the newest first cheching for an error if no erro then continu else open up the connection using the older version

The following link will help in the creation of stored procs in a VB project Stored Proc Wizard Hope this helps [2thumbsup] [2thumbsup]

You could also try PDFCreator this is freeware pdfcreator

This can only be achived via code and not wityh the menu editor. Option Explicit ' MenuBmp sample by Matt Hart - mhart@taascforce.com ' http://www.webczar.com/defcon/mh/vbhelp.html ' http://www.webczar.com/defcon/mh ' ' This sample shows you how to add bitmaps to your ' menu items. First...

Thanks mate but this sorted my problem out got it from another board but thanks anyway 'Loop Through the array placing in the address info For intLoop = 1 To UBound(vntAddress) 'See if the Array elemnt has a value If Len(vntAddress(intLoop)) Then...