Visual Basic 4 / 5 / 6 Forum

Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge. I would be using layman's...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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

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

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 & "_"