Visual Basic 4 / 5 / 6 Forum

Hi guys. The below code saves the video into specific folder and specific name. I would like to replace Dim destination As String = "C:\Users\Emily\Desktop\Video.mpg" to savefiledialog method so that the user can save the video into any folder and any file name they want. Can anyone please guide me, I'm new to this. Your help is much appreciated. ...

Am making a report generating project and have a field for grades from D1,D2,C3,C4,C5,C6,P7,P8 and F9, I have another field x where D1==1,D2==2, upto F9==9. I have another field named best eight and want it. to have the total of best eight grades using field x

Hi, I have a quite complex UserForm and using SQL queries I retrieve from and also save data to another workbook (unfortunately I cannot use Access db in this case). There are three particular textboxes in the form with linked checkboxes. Normally, users enter numbers to the fields and everything saves fine to the external workbook. But...

I have one command button that starts a procedure to fill out a couple different forms. One of those things is to print a page of a report that goes with the selected object. HOwever the report only applies to some of the objects, so when the command button is hit for ones that do not apply the 'Enter Parameter' button pops up. How do I get it to...

hi am currently develop enrollment system just have a major problem in displaying student rankings see the image attachment. With ListView1 .ListItems.clear End With Set rs = New Recordset rs.Open "select * from revieweegrades ORDER BY GENAVE DESC ", con, 1, 2 If rs.EOF Then Else With ListView1

excuse me, i need help to solve this. i have made simple hyperterminal program using vb 6 to read mscomm.input the input come from ultrasonic sensor and printed "160". i want to add name and save those two as database in excel.. what can i do to change that hypertminal input in to a text box so i can save it along with the name?? best...

Hi, I am running some calculations in 5 accounts. Once 1st account calculations are started, cursor will show busy symbol (In rotating mode). Once 1st account calculations done only it should go for 2nd Account. But issue here is, even 1st account calculations are in progress, 2nd Account calculations are calling. Due which my process is not...

I have a script to add taskbar icons on every new user icon. It works, except for the Microsoft Office icons. Here is the script: Option Explicit Const CSIDL_COMMON_PROGRAMS = &H17 Const CSIDL_PROGRAMS = &H2 Const CSIDL_STARTMENU = &HB Const CSIDL_CURRENT_USER_DESKTOP = &H10 Const CSIDL_PUBLIC_DESKTOP = &H19

I am getting Run time error 91 in below ** area.I couldn't figure it out where is the problem. What i try is, to avoid to enter duplicate pin number. Public Function Custom_PIN(ByVal TableName As String, _ ByRef EmployeeCode As String, ByVal FieldName As String, ByVal DataToCheck As String, _ Optional ByVal CodeFieldName As String =...

RsChild.Tables(0).Rows(0).Item("SpName").Value

I wrote a macro for opening an excel file in an existing excel. But i cant copying the formats. Can anyone help me, how can i copy the formats? i guess, it's easy, but i can't do it. It's really important:) Sub Megnyit() Dim mf1 As Workbook

Hi Can anyone help me please? I need to set up a simple listening port in VB5 and was wondering if the Winsock Component could be used. I want to collect some data from 4 machine which are connected to a server. I could take these out of the server and rout them direct into a PC if this is easier. I dont normally do networking or PC...

I have two combo boxes and both have many options.I want if i select one option in 1st combo so in 2nd combo i want to display only the options which i want.

Hi everyone I have bought an electronic device for our company which I need to communicate with through the USB port. Does anyone know how to do it in VB6. Thanks

This is for search command button: The codes are Private Sub Command2_Click() Adodc1.RecordSource = "SELECT * FROM Payroll where EmployeeName = '" & txtSearch.Text & "'" Adodc1.Recordset.Requery Adodc1.Refresh Adodc1.Caption = Adodc1.Recordset.RecordCount End Sub I dont see what's wrong with it. Anyone?

Hello, I am very new to VBA and need help ! I have VB macro in Excel that grabs the data from a Word document and imports it into Excel worksheet. The code in macro has expression that clears the active worksheet and places the new records. However, I need only to update active sheet with new records, or add new records. So, trying to figure...

I have a batch file to start Access macro like this: "C:\Program Files\Microsoft Office\OFFICE14\MSACCESS.EXE" "C:\users\sus.ACEELAC\Desktop\DailyRun\DailyRun.accdb" /Excl /X macNewfall I want to change to Vbscript to run the macro because I have other code in my VBscript. Sorry if I post to the wrong category as I cannot find VBscript...

i want to create a simple system by combining Microsoft access and visual studio..should i make the access database first?and how should i link the two please assist..its urgent

I have an old payroll program written in VB3. The payroll reports are Cyrstal reports 4/5/6/8. My current problem is how to add a code so as to email employee payslips directly?

I'm writing a code for a board game. To play the game, a player generates two random numbers and colours in an area on the grid indicated by the numbers. For example if the generated number is a 2 and a 3 the player clicks in the 2x3 square which results in the colour of the square being changed. A player should only be able to click and...

I using visual basic 2010 and I want to extract the data I had insert in the exe.file to excel without overwrite the data or design of it. Below is the code I use Dim oExcel As Object Dim oBook As Object Dim oSheet As Object Dim sNWind As String Dim conn As New ADODB.Connection ...

Hello to all! My name is Jana, I began with Visual Basic not so long time ago, without a lot of basics - just immediately. I've found this site while googling about my question/problem. I am stuck :) I have a MultiPage. Inside of this I have pages. Inside of one of this Pages there is a TabStrip... When User presses "Empty fields" - all...

I have came up with a class called example that is referencing another class to pull the information called smc3. i have an existing project that i want to pull both of those into and make them work. is there any way that i could do that, and if so, then how would i do that? If there are any more details that are needed to help understand,...

I need to import Java based tables from websites in excel. More specifically I need the following http://www.batsoptions.com/market_data/ I need the most active table to show up in excel. Any ideas ?

access.Open("Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source = '" & Application.StartupPath & "\test.mdb'" ) value = TextBox2.Text query.CommandText = "insert" query.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc query.Parameters.Append(query.CreateParameter("RID",...