Visual Basic 4 / 5 / 6 Forum

Dear experts! I need a help. I had made a small Bill format and i need it to be exported and save it in an excel sheet. Please help me anybody. I will put here my codes.... Option Explicit Private Sub Command1_Click() Text11.Text = Val(T1) * Val(T7) Text12.Text = Val(T2) * Val(T8) Text13.Text = Val(T3) * Val(T9) Text14.Text = Val(T4) *...

Hello, I need a query to solve the below problem. The table rows are given below Stock Details ------------------------------------------------------- ID Product Color Rate Stock 1 AD.GOLD White 5250 100 2 SM White 5318 100 3 LOGU - II White 5357 100

I am working on a complex decision tree in excel, and each time I add a question the number of lines doubles. For this reason I am trying to write a macro to insert the new lines, copy data from existing lines, and pasting it into the new lines. I wrote some psuedo code that I think works logically, but am not familiar with the syntax of...

I am trying to use vba to import a tab delimited txt file where both the file name and the content varies. I have a form with a button linked to the code, it will import the tab delimited file, update some column data in the table based on a query and then export it back out to the same tab delimited txt file. The issue is when the tab...

Hey people...am doing a system development for my school exams. I was wondering whether you could help me find a way of putting a setting that allows one to change the theme i.e. change colors of the buttons,font and background with one button click and stuff...

Hello Everyone please help me. I am new to VB and i want to know how to compare the current date with the date stored in the database table?

I have a master form with 4 subforms. The subforms all contain editable controls. When a user updates a control, an audit trail sub is activated which records the change, the user, etc. This audit trail sub is actived "before update" on each subform. What I'd like to do is delay the update of the subforms until the user specifies. This means,...

Hello! My monitor's resolution is 1600 x 900 pixels. I've made full screenmode like this: Me.WindowState = FormWindowState.Maximized Me.FormBorderStyle = Windows.Forms.FormBorderStyle.None If I then get the dimensions of screen's working area like this...

Hi ppl. How do i make a combo box have its fields defined by the value of another combo box? For exemple if in the first combo box the chosen field is "Soccer" then the values of the other combo box will be "Referee, Player, Ball". If the first combo box chosen field is "Money" then the other combo box values will be "Coin, Payment". ...

Hello, I'm coding a program that shows pictures. I have Settings-menu that has option to show pictures in fullscreen. The fullscreen item of the menu has submenu "Fit on fullscreen" If I don't have this submenu and I have Me.MenuStrip1.Hide()

hi, i have Office 2013. i don't have this items. i have Microsoft Office 15.0 Object Library in the References list. i tick this but dose not work this codes . please help me !

I tried to run a batch file using shell command. my code is as below. it throws an error run time error:5, invalid procedure call and on debut it points out the shell command line. pl clarify and solve the problem. My code to run the batch file. Dim path As String path = ActiveWorkbook.path Dim retVal, A, fs Dim coln As String coln =...

I have the code that is calling a function named Get_Reg: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMsg As String Dim strResult As String strMsg = "O Registo mudou." & vbCrLf & vbCrLf strMsg = strMsg & "Pretende gravar?" & vbCrLf strMsg = strMsg & "Sim para gravar e Não para cancelar." & vbCrLf If...

Hello, I have a main Case form, that when I click a button, a new Client form opens. On the Client form, I have 3 text boxes that users use to create a new client, first name, last name, and date of birth. I also have 2 invisible text boxes named Client name and ID that I ended up creating due to one of the problems I am encountering. All text...

HI, I WORK WITH PRINTDOCUMENT CONTROL AND I WANT TO PRINT MORE THAN 1 PAGES. I PUT IN PrintDocument1_PrintPage CODE : Private Sub PrintDocument1_PrintPage(ByVal sender As System.Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs) Handles PrintDocument1.PrintPage Dim Lm As Integer Dim Rm, dgvRows As Integer ...

Hi all i am searching this from a long time but didn't find any answer for this, as i am new to programming i m unable to modify codes also. What i want is to copy datestamp folder from one location to another, everyday we are getting datestamp folder i want to move the whole folder to some other location..

i built a language translator... and i used a text file as database. I need to know how to code the buttons so i can switch back and forth between english and apache. this is for translating from enlish to apache. i know i can switch the separate to "\" to indicate how to find the apache to english...but how to combine them Private Sub...

Hi. I cant fix it :( any ideas PLZ? :( Public Class Form1 Dim sqlConn As SqlConnection Dim COMMAND As SqlCommand Dim Query As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load sqlConn = New SqlConnection sqlConn.ConnectionString = "data source =...

This code is meant to iterate over all of my sheets, but it is skipping some. Can anyone help me figure out why? Sub BuildIntegration() 'Setup Variables Dim NextRow As Integer Dim intSheet As Integer Dim WkshCount As Integer

I have developed a program in VB6 to view PDF File. I also make a setup file for the program. In my PC the program runs well without error but when I installed it another computer and click the button to open the PDF file it just disappear/ terminate without showing any message and I have to start the program again. For your information the...

Hello Guys...... I've two project in one solution project1 and project2. I've fit the panel1 in project1 so i want to show on prj2 any data just like TextBox or level on project1(panel1). How to show and what will be write code....Please help me....

This is the button that I am trying to click on a webpage. All is does is open and menu with more buttons. <a id="ctl00_ContentPlaceHolder1_TnBActivityList1_lbAddNew" class="actNewHyperlink" href="javascript:__doPostBack('ctl00$ContentPlaceHolder1$TnBActivityList1$lbAddNew','')">Add New</a> I have tried a number of things and I cannot figure...

hi. i am new to the visual basics i want to upload and download the data from the ms access database to the handheld billing machine by using the ado controller through the ms comm component connection.i want code to this my question. and i want to add the customer.xlsx and product.xslx file to the set up file how can we add those files.

I am using the below code to display all the record based on a condition, but it is displaying the last record. Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As Outlook.Attachment ...

Forgive me in advance, but I have a word.dot that inserts a unique receipt number sequentially into the header of the document on open, trouble is when ever someone else opens the doc it runs again and overwrites the originally created number with a new one, I’ll need the syntax version, I thought of using the system date and time but the...