samuelmoneill

Can anyone tell me what is wrong with this code? [code] Dim current_date As String Dim filename As String Private Sub Form_Load() Dim path As String current_date = DateValue(Now) current_date = Format(DateValue(Now), "YYYYMMDD") Debug.Print current_date filename = "Daily SMS Backup " & current_date & " 200.sql" Debug.Print filename path = …

Hi, I am writing a vb6 application to take in SMS text messages from a modem, do some string maniplation on the messages and store them in a MySQL database. It also prints them to the main screen of the application. I am using a timer to check the SIM …

Hi, I have a relatively large application with multiple forms and a Module class. The problem I am having is that when I create a listbox on ANY form and try to use its 'Selected' function eg. List1.Selected vb automatically changes it to List1.selected Can anyone tell me why this …

Hi, I have a listbox(MultiSelect: 2 - Extended) in which I set ItemData index values for every item that goes into the box. I'll call this listbox myListBox. The ItemData index values match their respective ID's from a mysql database. What I need to be able to do is to: …

Hi, can anyone tell me ehy the following code doesn't work and how to correct it? <code> Dim v As Integer Dim alarm_type As String Dim alarm_type1 As String Dim alarm_type2 As String Dim alarm_type3 As String Dim alarm_type4 As String v = 0 If .... Then If v = …

Hi, Does anyone know how to send commands to a shell that is already opened? I know how to open the shell to run a command, but how do I send another command to it? Here is what I can do Shell("C:\Backup\mysqlbackup.bat") This command runs the mysqldump command. But the …

Hi, I have written an application in VB6 to take in SMS messages from a SIM card and store them as Alarms in a MYSQL database. Each Alarm is stored in the database with the date and time of the alarm. I need to add a function to the application …

Hi, I am writing an application in Vb6 to take in SMS text messages and store them in a database. I have 3 timers The first has an interval of 2 seconds In this time it checks the SIM card for messages and sorts them into a database and displays …