Visual Basic 4 / 5 / 6 Forum

I have a messagebox that asks if I want to delete a specific ebook from my listbox. The message says, "“Do you want to remove the x eBook?” the x needs to be the title of the book selected. This is what I have: Private Sub btnRemove_Click(sender As Object, e As EventArgs) Handles btnRemove.Click ' removes the selected line from...

I am using vb6 and crystal report 10 for making reports. Now i am making a report , the report works fine just i want that the page number of the report start from the number which i give him. For example i have a report with 10 pages , when i click on show report the report pages from 1-10 are displayed with number 1,2.3.....10 Now i...

Hi, I have a spreadsheet filled with an employees' checking times. I want to remove the bottom and top ten percent of checking times per day. However, there are hundreds on days within the spreadsheet and all the days are in the Date Column. I'm assuming a if - percentile function would be the best way to isolate these bottom and top times but...

hi guys, i want to add attempt onto my password so that the person login in only has a limited amount of attempt they can try to enter the corret password but I have no idea how to do it can someone guide me on how to do it. this code works fine if the person makes a mistake. (It does not let the person log in but it does not give the person...

I am trying to complete an assignment and I am stuck on correctly keeping a running sum of items as I add them to a ListBox control. Can anyone show me a code snippet that would do this? Each time I add a new item the previous total (sum) should be added to the new item to keep a running total. thanks.

I AM VERY NEW TO THIS VBA/MACROS. I GOT NEW JOB AS VBA PROGRAMMER. HERE IS MY QUESTION I HAVE ONE MAIN FOLDER IN THAT I HAVE 10 SUB FOLDERS, IN EACH SUB FOLDER I HAVE 10 WORKBOOKS. NOW I NEED TO COMBINE ALL WORKBOOKS INTO SINGLE WORKSHEET. I WROTE A CODE WHICH WORKS FINE BUT IT ALSO OPENS SOME XML DOCUMENT ALSO, NOT SURE WHY IT OPENS...

I want to stop a program running in VB6 to check code. What is the ascii keycode to do this?? (CTRL-BREAK DOES NOT WORK) Advance programming one line at a time while debugging (VB6). What ascii keycode does this??

How to change system date in VB6.0

This is my code: sourcePath="C:\Users\DANI\Desktop\source\*.*" pastePath="C:\Users\DANI\Desktop\dest\" set FSO=CreateObject("Scripting.FileSystemObject") FSO.CopyFile sourcePath, pastePath FSO.CopyFolder sourcePath, pastePath

Hi everbody, I'm new in Visual Basic and using 2010 Express. I'm trying to develope a small analize program and having a problem with it. I have a database, datagridview1 and data in its cells. I want to calculate the first 20 cells "average" in " DataGridView1.Rows(20).Cells(1).Value and continue successively. I added a picture of an excel...

I have a datagridview like at the attachment. How can I find the ten biggest and ten smallest numbers in column 1, and write them in column 2. (from the first cell) Thanks a lot.

Can someone give some hints??? Id like to know if someone have a code for visual basic/ excel to calculate the the product of a sequence of numbers in VBA, i'm using windowns 7/vista.The definition of the product of n numbers is https://es.wikipedia.org/wiki/Productorio What i already tried: Function mo( j, n) Dim x As Double, j As...

This is the code I am working with and I am very confused on how to insert this into an averaging Formula. I am new to using VB, What I am trying to achieve is each data sheet it is ran on, the data might shift several rows, but I need to pull the same series out for each sheet ex: 22.5 hours +3,-3 hours for 7 data points. I need the 7 data...

I am only trying to add fields that don't exist in the table already from another table list. It works if all the fields are missing but when i already have that field in my table, i get an error. How can i limit the Add column to only the fields that are missing? Any help will be greatly appreciated. Function AddField() Dim db As...

How to use Sum in a column data with visual basic 6.0

I am trying to get this code to work so that the MySheet = "XXXXXX" is locked from view unless a password is entered. It works fine when I have only one MySheet listed, but when I enter another MySheet only the one date 05.14.17 is now password protected. What am I missing? Thanks!! Private Sub Workbook_SheetActivate(ByVal Sh As Object) '...

Hello all. I am creating a access database that goes out to all of our databases, open them and select the backup button. I can open the database and get to the right form but I haven't been able to figure out the button. I receive a run-time error '438': Object doesn't support this property or method I appreciate everything that anyone...

Imports System.Speech.Synthesis Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ComboBox1.Items.Add("Male") ComboBox1.Items.Add("Female") End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)...

vb6 data report how can make sum(total) function to temp variable

invoice total 123.44 so grand total 123 and round off colom -44 also invoice total 123.55 round 124 and roundup +45

I have been wrapping my head around formatting texts in a .txt file to a new desired format in a new text file. Please can anyone assist with my issue?

Dears I am trying to do a small program on VB 6.0 to find the records in database and print it in text box based on combo box selection but i failed to find a code which allow me to do this. Any help please.

Running a macro to format tables in a Word document - setting colors and Bolding labels work fine. I get a 'syntax' error when trying to FormatTables. Here is the part of the code that troubles me. Sub FormatTables() BoldLabels

Can someone give some hints??? Id like to know if someone have a code for visual basic/ excel to calculate the SUM OF the product of a sequence of numbers in VBA, i'm using windowns 7/vista. In other words I want to calculate the value of https://upload.wikimedia.org/wikipedia/commons/thumb/e/e7/Greek_uc_sigma.svg/59px-Greek_uc_sigma.svg.png of...

Hello, I am trying to do something that sounds simple, but it seems impossible to me after trying for many hours. I want to iterate thru a table, grab the ID field, and run a series of queries based on the ID. Desired steps: Grab the ID from record 1 Run query 1 run an add-in to do percentile analysis (this works just fine)