Visual Basic 4 / 5 / 6 Forum

What is meaning for . If you set If like this If RsData.RecordCount Then Combo1.Tag = RsData.AbsolutePosition Else Exit Sub If RsData.RecordCount what ??? <> < > = >= <= ?

<area href="build.php?id=16" coords="184,319,28" shape="circle" alt="Clay Pit Level 0"> in vesual basic

in vb 6.0, form, i have a command button that can add informations such as - name, age, address, contact number. another command button that can save the infos that already added. command button that can cancel adding, clear the infos that have typed. and a data control that is connected to a ms access. i want to a list view that displays the...

i'm creating assets tracking data base, i have to set asset depreciation every year of asset life, i am using datediff() but it count total duration of asset, i want that starting date and ending date and computer count integer number until the ending date for example purchased asset date 12-Aug-2010 useful life of Asset is 12-Aug-2014, between...

I'm getting this error for the last line of this code: Dim ComKey Dim ComCode, SubComCode Dim SelectedCompanys ComCode = rpt.Sections("Detail").Controls("COM_CompanyCode12").DataValue SubComCode = rpt.Sections("Detail").Controls("SUBCOM_SubsidiaryCode12").DataValue ComKey = ComCode & "_"

Can anyone help me? if I have 50 labels in a userform called Label1, Label2, .... ,Label50 and I want to fill them with the names of 50 people found in the first 50 rows of column A in an excel spreadsheet (assume the sheet is the active sheet) then I could simply do this? with userform1 .label1.caption = cells(1,1).value .label2.caption...

Hi I have an access table containing two fields named arr_date and dep_date, both date/time format i.e 'dd/mm/yyyy hh:mm:ss' Using VB6 I am trying to select the records from the a table named data_2014 with dates/times where a date/time variable is between the arr_date and dep_date. However it is not returning any results or is showing...

I am using VB to create a code that will save a copy, send it via outlook then delete the copy it saved. I want this to be via command button but am not picky as long as it's as easy as the comman button. The code I have is Sub Mail_workbook_Outlook_2() ' Works in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Outlook 2000, Outlook...

Sorry,i'm still a newbie but i'ld like to know how i can run a programme that can display random texts in one label or textbox every 3seconds, that is; i want a different text to display after 3seconds in which another text will display and so..... in runtime. Example, the first text is 'i love you' and after 3seconds it'll display ' i'll do...

I have a command button (SlurryBatchTicketCorrectionForm) in excel. On click, I would like it to print the first tab of an external file (N:\QCGRP\SOP\FORMS\SPD\(SPD-219) Slurry Adjustment Sheet.xls) to the default printer. I'm not sure where to even start, so any assistance would be appreciated. Thank you!

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

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

I have 3 text box textbox1, textbox2,textbox3 and a datareport1 i want val of text1,2,3 display in datareport1 section1 textbox1,2,3 my code is : Datareport1.section("section1").controls("text1").text-text1.text Datareport1.show But error help me.

Hello, I am working on MBAL (PETEX package); and to build the MBAL model and import raw data I've used OpenServer. As the created model is untitled at the beginning (attached Fig1), I have to Save it As somewhere with a specific name I know if the file had a certain name, I can simply change the directory and also the name by the bellow...

I have a table set up for employee training where the record's primary key is employee number, and each field is a training course. In the data field is the date in which they were trained. The database is set up to add fields when a new training is added. I want to be able to run a report to show the last time an employee was trained in a...

can anybody help me to convert vedio to flv extention by using vb6. thanx

Hello, A simple request I am sure, but I am unclear of the procedure. I have limited experience with VB, so here goes: I am trying to create a simple VB application that will bring up a form box with a TextInput for an email address and a SEND (caption) button only. The function of this application will, when the SEND button is...

My old VB 6 .frm files are not opening as FRm files now. They are included under Modules Folder in the Project Explorer. My Visual Studio is working fine , I am able to create new projects and new Forms. Only problem is that all my old forms are not opening up. Pls help

Hi guys, I am wondering how to plot a stairstep-like graph in VBA automatically. In MATLAB, I got some function called 'stairs' that could help me with it. But I dont know if there exists any similar function in VBA as well. For example, I got a function like: num = 10*cos(t).*(t).*(t) + 1; denom = (t.^4 + 5*t.^2 + t.^3 + t + 3); x =...

Hi all, I am stuck in a bin packing problem. Basically, I have different sizes of items with different weights. I am trying to put those items into the bins with a maximum number of full and empty bins and minimum number of half-filled bins. I try to use hybrid grouping genetic algorithm instead of traditional one. So in this case,...

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

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?

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