vba x 200

12,155 Topics

Member Avatar for
Member Avatar for Olanrewaju_1

Hi everyone! i am currently working on a project that involves a mssql 2012 database. i have some table columns that i want to calculate and get the amount saved in the total column. And at the same time, i want to be able to display the table with datagridview …

Member Avatar for Santanu.Das
0
373
Member Avatar for SoftBa

Hi, I have started this project and come to the point where I can't figure out how to finish it. First Want to say that I'm noob for VB6 and programming in general, but I saw some examples and make it work this part of job I need. I will …

Member Avatar for dageci
0
2K
Member Avatar for dageci

Hello, I have a user control that consisting of UserControl, and one Form. When UserControl Initialize it opens that Form. In that form I would like to call an event that is fired from user control. Here is a example: 'Code In UserControl1 ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Option Explicit Public Event FormEvent(ByVal FormEventName …

0
118
Member Avatar for Gbtech

I have alot of text botton connected to adodc and i have alot of document in d database and i want to correct some mistake in some field pls i need the code to search for the name and pull the information in remaining text botton and change d mistake …

Member Avatar for Reverend Jim
0
152
Member Avatar for chinnasamyiITI
Member Avatar for Okere

pls fam,,, how can i access a webcam in vb6 and save its output in a picture box... pls i need it urgently cos am writing a project .. thanks

0
112
Member Avatar for cambalinho

i'm converting the VB6 DIB code to C\C++ from: http://www.tannerhelland.com/42/vb-graphics-programming-3/ **V – Using DIB Sections** but doing by steps... how can i convert: ReDim ImageData(0 To 2, 0 To bm.bmWidth - 1, 0 To bm.bmHeight - 1) to C\C++? for then use it on GetDIBits() function

Member Avatar for rproffitt
0
128
Member Avatar for Q2X5

Hi Every one >>> I'm doing visual basic program with sql server database I need to Export database to but it in my own server and connect to my prgram but i can't do it could you help me ...

Member Avatar for pritaeas
0
73
Member Avatar for Amar_4

I want to make info (email and password) entered previously in two text labels in a VB application to be put automatically in the Facebook page or any other social network in my default web browser and login automatically. (Of course after clicking AcceptButton in the VB program). -I'm using …

0
127
Member Avatar for rucel jhalia

Imports MySql.Data.MySqlClient Public Class EmployeeInfo Dim con As MySqlConnection = _ New MySqlConnection("server=127.0.0.1;user id=root;database=bsit3d") Dim cmd As New MySqlCommand Dim da As New MySqlDataAdapter Dim dt As New DataTable Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub Private Sub display_Click _ (ByVal sender As …

Member Avatar for rucel jhalia
0
272
Member Avatar for Hamed_3

hi . i have these codes : Private Sub Form_Load() WebBrowser1.Navigate "http://www.film-ha.com/wp-login.php" Do Until WebBrowser1.ReadyState = READYSTATE_COMPLETE DoEvents Loop If URL = "http://www.film-ha.com/wp-admin/" Then WebBrowser1.Navigate "http://film-ha.com/wp-admin/post-new.php" End If End Sub can anyone help me about how to add if webbrowser url is exact url that i want ? or maybe …

Member Avatar for Robin_6
0
318
Member Avatar for Monster99d

Hi, I'm trying to learn VBA for a personal project I am working on for excel. Right now I have in cell A2 - "2 years 1 month" and in cell B2 "1 year 2 months." I am trying to get it so it prints in C2, "3 years 3 …

Member Avatar for ddanbe
0
234
Member Avatar for CORKINSCS

I WOULD LIKE TO MAKE A NUMBER CREATED, WHEN USING COMMAND BUTTON, TO TRANSFER NUMBER FROM ONE CELL INTO THE ONE SELECTED. FOR EXAMPLE BELOW. Private Sub CommandButton1_Click() Range("D2 SHEET4").Value = Range("c21") End Sub IS THE EXAMPLE OF WHAT I AM TRYING TO ACCOMPLISH. I WOULD LIKE THE INFORMATION IN …

Member Avatar for Nutster
0
197
Member Avatar for Lance_1

im make program using vb6 n tried to get data from msaccess database ,display it in vb6 and save the data to oracle table database.. The table name in oracle is testcoba. Now i can save the data from vb6 to oracle table. But i want is the data will …

Member Avatar for Santanu.Das
0
1K
Member Avatar for MrTheMonium

Hello VB Masters, Firstly, apologize if my question is in the wrong place :) I would like to create a loop that will copy a data from rows in the first sheet to the columns in the second sheet. The data in the Sheet1 looks as follows: A B C …

Member Avatar for Slavi
0
268
Member Avatar for Lene_B

Hi I have data set where I find it easy to sort data by using pivot tables. BUT one essential cell is not a part of each sample ID. I have tried to make a macro to insert this data without luck. So in b column every time an empty …

0
135
Member Avatar for James778

Hi Everyone, I have sheet with rows filled with text, and I copy each row and paste it in another sheet,(paste special transpose). I created a macor for this step. but how to add the loop code so it keep doing the same steps till empty. Thanks

Member Avatar for ddanbe
0
53
Member Avatar for crazy_neha

hello, i am neha currently and 2 nd year It student required to do a mini project using vb as frontend and sql as backend i liked the idea of student database project can someone help me with its coding and gui screens plz its urgent only 2 weeks to …

Member Avatar for vincent diobi
0
1K
Member Avatar for Mico_1

if i'm going to select the ID # from Stud Info View , i want automatically display the selected number in another form and display the number in Student ID in form of Add Subject , i need your presence please help me .. please..

0
108
Member Avatar for matoo

hi there everyone this sounds sily but i am trying to make a calendar which will show attendance on the calander what i want is to stop on the todays date txtbox txtboxes are arreys so the name is txtDay(0), txtDay(1), txtDay(2)........... txtDay(41) Dim strDate As String Dim strStartDate As …

Member Avatar for BitBlt
0
234
Member Avatar for meLiel

hi programming masters! i need your help..how can i SEARCH a record in a database and display the results?? example: if i type an ID number or a name on the text box and click the search button it will look for the records and display it.. i have a …

Member Avatar for Reverend Jim
0
12K
Member Avatar for jugnu

Hi, I am running vb6 forms in vb.net. My question is that is there any way to populate variable in VB6 Form through VB.net Form? Actually I have a single form of Voucher. I have multiple types of vouchers and I am separating them by their character code like CPV …

Member Avatar for Mr.M
0
136
Member Avatar for hwoarang69

I need some help created a google weather api using vb .net. I found the code online and there are no errors. Problem is that I can't seem to display wether information. Nothing shows up on screen and I am not sure what I did wrong. any ideas? Imports System.Net …

Member Avatar for tinstaafl
0
546
Member Avatar for SpeakerKeyboard

I'm currently have and excel speadsheet that has 3 rows. What I would like to do is create a macro that reads the last populated row, usually will be column A1, and then created a new column listing the current date and time. So for example, I have ColA ColB …

Member Avatar for SpeakerKeyboard
0
228
Member Avatar for matoo

Hi there Everyone I am writting a program POS in which i have employees database. they get a code or we can say employee ID numbers. 100001 100002 100003 now i want to keep the recourd attached with picture ID as well file names will be 100001.jpg 100002.jpg 100003.jpg as …

Member Avatar for matoo
0
281
Member Avatar for Sohail_4

Can any body tell me how can I detect Key press when my focus is not on the Form, Like I've Hidden The Form and I want to make it visible by pressing a single key or combination of keys I tried VBKEY case but that works fine unless I …

Member Avatar for Nutster
0
205
Member Avatar for Christian_4

can you please help me in my code MsgBox "Are you sure you want to Logout?", vbYesNo, "Confirmation" If vbYes Then Unload Me frmAuthentication.Show End If how can i have 2 choices example i want vb no and just stay with my form help me..

Member Avatar for Nutster
0
553
Member Avatar for lingam147

Hi, in VB8, I request your help to add the product field to a list box and when i start type a charactor of a sentence, the list box shows the relevant sentence to picked up from the list box.

Member Avatar for Reverend Jim
0
111
Member Avatar for Papa_Don

Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks …

Member Avatar for Papa_Don
0
318
Member Avatar for PinoyDev

Good day! I have a running code but I found it not very fast in terms of saving data. Is there a way to make it more faster? I am using msaccess as databse. Set RsTrandet = New ADODB.Recordset Sql = "SELECT TranDetail.AccountNo,cashflowcode, TranDetail.Narration, TranDetail.TranNature, " & _ "TranDetail.TranAmount, Acctmaster.Accountname …

Member Avatar for PinoyDev
0
291
Member Avatar for weekendrockstar

I am working with Visual Basic Studio 2013 and one of my forms requires the use of a web client component. I added Web Client to my toolbox and easily added it to my form. When VBStudio cooperates the form does everything as it should perfectly. However, when I loaded …

Member Avatar for djjeavons
0
284
Member Avatar for Papa_Don

Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks …

Member Avatar for Minimalist
0
339
Member Avatar for themathprof

I'm coding in VB6. I have pictures in Picture1 and Picture2. I would like to replace the picture in Picture1 with the picture in Picture2. What code will get this done? Thanks.

Member Avatar for Santanu.Das
0
2K
Member Avatar for xuexue

hi guys.. i always got this error in vb6.. here's my code [CODE] '########### Variable declaration ########### Dim conn As ADODB.Connection Dim rs As ADODB.Recordset '########### Variable initialization ########### Set conn = New ADODB.Connection Set rs = New ADODB.Recordset strUserName = txtUserName.Text strPassWord = txtPassWord.Text connStringSQL = "MySQL ODBC 5.1 …

Member Avatar for Kishore1982
0
1K
Member Avatar for Gabriel_6

Calculate the total parking charges based on the time of entry and time of departure of each vehicle. a. 1st half hour :0.20 b. 2nd half hour :0.50 c. subsequent half hour :0.80

Member Avatar for rubberman
0
50
Member Avatar for Papa_Don

Group, I've created some spreadsheets that others use. The headings of the spreadsheets are divided up with colors. However after I've created these and saved them formatted as I like, some of these cells are changing automatically after the other users open them up. I've read online there may have …

Member Avatar for hefaz
0
238
Member Avatar for Papa_Don

Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into the original workbook (where the macro's originate) and then closes the existing file. After the copy and paste is done, …

Member Avatar for hefaz
0
430
Member Avatar for hefaz

Hello all, I have created a pharmacy application in vb6, i packaged that, itselt has an access database. it works well in my pc, but when i want to send it to another computer, it installs there but dose'nt work there and says: C:// desktop/main/pharmacy.mdb is not a valid path, …

Member Avatar for hefaz
1
330
Member Avatar for Mike_25

Hi, I have two computers (Desktop and laptop), The desktop is my office computer and I have been using it for my application development(Visual basic). I have Visual studio 2013 and SQL Server 2014 installed on both computers. I exported the database from my desktop computer to the laptop and …

Member Avatar for Minimalist
0
234
Member Avatar for hefaz

in my vb6 application i face this error, Data Automation Error! No elements found, what is this belong to?

Member Avatar for hefaz
1
3K
Member Avatar for Jamie_7

When I try to recompile an OCX while in VB6 (run in Admin mode), I get "Permission Denied". I'm running Windows 7, 64 bit. I've already tried to set VB6.EXE to run in compatibility mode for XP SP3. I'm trying to create a new version of the OCX. I set …

Member Avatar for hefaz
0
281
Member Avatar for batoolhussain

hi everyone. I have written a program that convert from color image to gray image in asp.net with visual basic, but I have a problem am new in asp.net and I want to display the gray image but I don't know how. please help me. this is a code. If …

Member Avatar for madCoder
0
265
Member Avatar for Member #1123523

Hi, I've been given a task of printing from a grid in VB6 and came across the article shown below. https://www.daniweb.com/software-development/visual-basic-4-5-6/threads/431714/print-from-mshflexgrid-in-vb-6-0 I've implemented the code provided (re-typed, not copy/paste) and when I run it I get a run-time error 383 saying the printer properties are read only. For example, if …

Member Avatar for Member #1123523
0
485
Member Avatar for Mike_25

Hello everyone, This is Mike joing DANIWEB from Zambia. I have learnt a lot from this site and i have decided to join and learn more and more. I am new to visual basic programming. Looking forward to learn more from the experts in here.

Member Avatar for advent_geek
0
119
Member Avatar for goowee

Hi VB Wiz, I have a data that is currently displayed in row, but i need it to display in one column. this is how currently look like set1 [lastname/firstname] [lastname/firstname] [lastname/firstname] [lastname/firstname] set2 [lastname/firstname] [lastname/firstname] [lastname/firstname] [lastname/firstname][lastname/firstname] [lastname/firstname] [lastname/firstname] [lastname/firstname] set3 [lastname/firstname] [lastname/firstname][lastname/firstname] [lastname/firstname] [lastname/firstname] [lastname/firstname][lastname/firstname] [lastname/firstname] [lastname/firstname] [lastname/firstname] …

Member Avatar for BitBlt
0
169
Member Avatar for Franklin_1

I've got a problem on Visual Basic code. Never used it, and I'm supposed to edit this code below. I need to grey out the fields that have been transferred to the first page from pages (1,2,3) on pages 1,2,3. So after a field is transferred to page one, it …

Member Avatar for Mr.M
0
184
Member Avatar for vann_1

Can someone tell me how to connect combobox in vb6 to database (db2) I need to select from my combobox and the data should come from database.

Member Avatar for Minimalist
0
60
Member Avatar for lyca

Ive been installing a VB application on another computer, but wen im running the program an error occurs it says that my database is not valid(the path). my program has no app.path thats why i install it on Local disk D. Wat should i do now? is there any option …

Member Avatar for hefaz
0
231
Member Avatar for AndreRet

**Modifications Required for VB6 Applications to Work on Vista/7** Thanks to Hassan Basri in VBForums **Application Changes** - Remove SendKeys calls and replace them with API code. - Use the HKEY_CURRENT_USER in the registry for the settings of your application. - Do not write to HKEY_LOCAL_MACHINE. - If you are …

Member Avatar for hefaz
2
5K
Member Avatar for hkdani

Wouldn't it be nice to have a sizable command button in VB6? Face it. In the hidden recesses of your mind you have always wanted to be able to resize that command button in VB6--after the program is running that is. It's just that VB6 has not provided you with …

Member Avatar for hefaz
1
827

The End.