Recent content by 100watt

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...