Visual Basic 4 / 5 / 6 Forum

With the below code, I could able to save the excel file as Text file. But in the text file so generated, there will be "#####" marks after each row. Please let me know how to get rid of this.. Private Sub cmdtxt_Click() Dim wb As Workbook If txt1.Value = "" Then MsgBox "Please browse the file first!", vbOKOnly, "Error" cmdbrowse.SetFocus...

I am not very good with VBA but I will try to get all the details in here. I am trying to use 5 combo boxes and 2 text boxes to look up and generate a report based off of those selections. I want it to generate a report as well once I click on the command button. I have the 2 text boxes setup as from and to date boxes that I pulled off of...

I want to upload a file named "maxinum.txt" to a FTP server.But there is already a file called "maxinum.txt" on the FTP server. Share my project:https://hupiyingwu.github.io/FrameChain/

How to export Data from MSExcel to MSAccess using vb6.0

I'm running Logon Script and it is in VBScript. when I'm calling Sub function it givving me this error If InStr(strGroups, ADFS1_GROUP) Then MapDrive "G:", "\\xxx-xxx-ADFS-1\GROUP" Else MapDrive "H:", "\\xxx-xx-ADFS\HOME"

Hey everyone i need help, i am trying to make a log in form where a user keys in their username and password and they are checked from the database then log in access or restriction follows after. My problem is that my program only reads from the first record if there are other usernames and passwords they are not acknowledged. Please help me fix...

i have a query (qryNotesTextSearch with the fields "StationID", "DateEntered" and "Notes")that lists the various notes taken at various dates for a company selected in a combo box (cboStationName). I wish to programme a command button, say (cmdToWord),to allow the user to have a word document that displays the results of the query for further...

hi, I have been stuck with this part here for days... basically I have been trying to use VBA in excel to "export" a value as a criteria to an update query in Access. I have googled part of the solution but I got stuck with this "error 3265, item not found in this collection" Sub importTblCurrent() Dim tsSH As Worksheet Dim cn As...

How to make a reference to the database mdb. On clicking on definition it says there is not a reference to the mdb database

how to sperate numbers, letters and special characters

hi all i have one comboBox which has some values and i want to display in the textBox a value once selected..

I found code here (thank you) to get my email to load query results to specific emails. I just need to add a CC email and the signature at the bottom of the email. I have tried several things and it all results in either I get the query data without signature or I get the signature. So I'm asking for help. I am not a programmer. Here is...

Sorry for my bad english:-) i need to read txt file line by line with best fsted method... my txt file is 142 Mb and contain approx 1.370.000 lines... all lines have a fixed lenght 132 characters. How to?

I have my App in Visual Basic 6.0 and I need to rotate the print out to fit the label. Thanks in advance for your suggestions. I am attaching the screen capture.

Does any one know how to print a Dymo label with Visual Basic 6.0? I already designed the label with the Dymo Software and saved the file as mylabel.label. I need to print that label in Visual Basic 6. I have the form with the following fields: Recipient, Invoice and Barcode. Thanks.

Hello, I used to be able to write small programs in Basica long time ago !! I never catchup with VBA. Maybe it is still time! I just would like to interrogate a dosimeter on regular base every 10 seconds, or every so many minute, for testing it for current leak. My PC run Windows 10 Pro and I use Office 365, and Excel for VBA.

Hello, I've created a simple batch file (as listed below) for renaming multiple files in the same directory: @echo off SETLOCAL ENABLEDELAYEDEXPANSION SET old=EN SET new=_ENG

I want use vb6 to connect, show live video, capture image from camera hikvision. hikvision support all function connect,.. but i can't show live video. please help me!

Hello all, I'm very new to visual basic and would like to have your help. I have a two dimensional table with the values representing the mass. Each row representing a speed and each column represents a temperature. So that for a particular speed and temperature, you have a unique mass value. The speed and temperature values are entered...

I have created a navigation form which contains a few nested sub forms. They are like this. frmNavigation is the main form which has navigation buttons and a sub form named NavigationSubForm. NavigationSubForm: Its source object is a form named sfrmNavigation. sfrmNavigation has a sub form named subAddNewStudent. subAddNewStudent: Its...

i have developed my own project in vb 6.0 where it was running without any errors now suddenly it is not running all the forms in the project it is running only one form i just stuck there please help me what to do......

Hi all... I have got a problem about passing data parameter in data report VB6 my problem: x= "admin" how to send value of x variabel to data report Thanks for your advabced

Hello All, Please guide me VBA code to insert the image from access to excel file. Thanks

I am trying to run a exe with parameters from a VB script. I tried writing it using a bat file but it does not close the dos prompt window so I am trying to rewrite it using VB script. It works if I do not specify any parameters for the exe to run. But i need it to run with the parameters. Not sure how to get it to run with the parameters. I need...

Public Sub Sub_serialNo() Dim rs_tmp12 As New ADODB.Recordset Dim STR_PVNO As String Set rs_tmp12 = Nothing rs_tmp12.Open "Select prefix from VoucherTypeMst where Name='JOURNAL VOUCHER'", conn, adOpenDynamic, adLockOptimistic If Not rs_tmp12.EOF Then STR_PVNO = BRANCHCODE & rs_tmp12(0) & Format(MONTH(Date), "00") & Format(Day(Date), "00")...