Visual Basic 4 / 5 / 6 Forum

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

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 am having problems formatting time in visual basic. I need it to be in 24 hour time without the AM or PM at the end. So if I wanted 1:29pm (12-hour) it would come to be 13:29 Thanks

how do i include union community-UCBioBSP SDK v3.00 type library in reference of visual basic in visual studio 2010 ultimate. I have trying several times but I just can't find it in my reference items. I look forward for your solution. Thanks. More >

I keep getting the following error: Compile error: Expected End Sub Can someone show me what I'm doing wrong & how to rewrite? Private Sub Exit_Click() DoCmd.GoToRecord , , acNewRec Function User_Form_macro() On Error GoTo User_Form_macro_Err

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

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

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?

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

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.

Public Function LinkFileNumericSplitter(strTextInput) As String On Error GoTo Err_LinkFileNumericSplitter Dim varResult As Variant Dim i As Long Dim strRowSource As String Dim strLinkFile As String Dim varSubTextInput As String If strTextInput = "Link File" Then

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

I want to make it super easy for my folks, a link in an email that will automatically create a bookmark, to take them to a specific location on our SharePoint site, in IE or Firefox... both would be nice. Can this be done? I imagine it would be a module of some sort... Thanks, Sophie

Hi. I found some code that does exactly what I want it to do except it stops if the length of a name in column A is more than 31 characters. I do not even see the error message in this code let alone where it is doing it. I hope someone can help me. thanks in advance. Option Explicit '<<<< Create a new sheet for every Unique value ...

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

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

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 new to programming and i have the source to my database but it is in access and i want to open in visual basic how do i convert it to VB? so i can start to edit my code?

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

Sir/Madam, I am using vb6. I had my project with MS-Acess DB & DAO. Now I convertedd it fully to ADODC in same vb6. Its upon execution, showing error "Unable to bind to field or DataMember (table name here)" ! (for most of the forms/tables.)! I have set all properties of adodc via Custom Property at design time. cmdType is 2-adCmdTable...

So I am writing a script to compare two excel files. I'm using a For loop in the first workbook to get the references I want to find in the second workbook (6450 rows long so that no For loop, way to slow) I have been looking for some way to use the VLOOKUP thing but i could not make it work Here is the code : For i = 7 to numLines...

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