Search results for query: *

You can write the code in a vb application and have it do what you are looking for, but the question is do you want to write a vb application or do you want to automate the excel spreadsheet to do it itself. I can help you with writing the vb application, but I can't help you automate the excel...

Try using the common dialog control because this control has two properties which you might find useful. The "FileName" property and the "FileTitle". The "FileName" property will give you the path and name of the file, and the "FileTitle" property will...

Why don't you just put both values together in a string separated by a comma and then separate the values after the function has returned them using the "Instr" function.

I'm trying to specify a picture at run-time for a report image control. The following is the piece of code I'm using but it may not be the right function to be using for what I'm trying to acheive. rptDTour.Sections(2).Controls.Item(3).Picture = LoadPicture(App.Path & "\Angus Logo.bmp")

Just use a text file to store the string. So just use the following code (changing names accordingly) and it will work. Private Sub Form_load() Dim a As String Open App.Path & "\String.Text" For Input As #1 Input #1, a Close #1 Text1.Text = a End Sub...

I'm not entirely sure but don't you need to use the keypress/keydown of the actual control in question to have any impact on the control behaviour. If so here is a couple of pieces of code you can use if you have created a control array. private sub Text1_KeyPress(Index as integer,Keyascii as...

You know that there is enough difference between databases to cause problems. For example the "Access" database treats date fields differently from all other databases in that the date field in the query would be surrounded by number signs (#date#) and in other database programs its...

Just put a message at the beginning of the code stating that the document is printing and then at the end of the code put a message stating that the print job has been finished. Or you could bring up the printer dialog box and have the user print form there.

From what you are describing you should first set up the combo boxes so that there is a specific order in which the combo box selections are made. So you could disable all the combo boxes other than the first combo box. Then set up the combo box "Change" event to enable the next combo...

I may be wrong but numeric values that I know of aren't supposed to be surrounded by number signs. So if that's the case then the query should look like this: "SELECT * FROM saldoa WHERE mo = 1 AND (fecha BETWEEN " & DTPicker1.Value & " AND " & DTPicker2.Value & ")"

I just found a way to connect to a sybase database without using the ODBC. I don't entirely understand why this works but you could try the following piece of code to connect. You will still need a provider for this connection. Private Sub GetConnection() Dim cnGolf As ADODB.Connection...

You could do this a couple ways. First you could set up the initial form so that as soon as the text boxes lose focus to save the control text to a global variable, which can be seen from all forms in the project. Or if you just hide the form you can still reference all the controls on the form...

Sorry, I forgot to mention that you have to select the range of cells to be used in the chart before using the ChartWizard method. Example: xlsApp.Range("A3:A6", "B3:B6").Select

Have you tried using the ChartWizard method. Try using the following code after you enter the values in the excel spreadsheet. xlsApp.Charts.Add xlsApp.ActiveChart.ChartWizard xlsApp.ActiveChart.ChartType = xl3DPie

I have been trying to package up a system consisting of a Visual Basic 6 application for the front end and a Sybase database for the back end. I have read all the documentation I could find on packaging up the Sybase database with a front end application and it specified that it could be...

I was trying to do the same and I found a solution at the Microsoft site. Just go to the "Support Knowledge Base" and type in "Print a form that is too large for the screen or page" in the search text box and you should get a document with the text you just typed in for a...

If you are using "Adaptive Server Anywhere 8" then you could use the "Adaptive Server Anywhere 8" driver.

I have been trying to connect to a Sybase database using the OLE DB but despite what the documentation states an ODBC driver is needed to connect using this method. I was wondering if anyone has successfully connected to a sybase database without using an ODBC driver. The version of sybase I'm...

The "Shell" command runs the DOS commands from VB. You might want to look for more documentation on the command because I'm not entirely sure of the syntax.

I am using "SQL Anywhere Studio 8"(Sybase) and the ODBC driver I used is "Adaptive Server Anywhere 8" and if you are using the connectionstring the provider would be "ASAProv".