vba x 200

12,155 Topics

Member Avatar for
Member Avatar for t0kipot

hi, can u help me my Datagrid which connected to ADODC1 was updating evrytime i click my ADD command button, then i made another command button to CLEAR what data is in the grid, i used this codes to do that but always error like this "KEY COLUMN INFO IS …

Member Avatar for shahidpk
0
2K
Member Avatar for sss93

Hey so I have a customer form which has two buttons and displays contact data,containing a simple cancel and proceed. The main functionality is behind the proceed on_click handler.Becuase I want to determine whether the the entered details belong to a new person or just edit. I have got the …

0
110
Member Avatar for honeybee2090

i want to add items from webbrowser to listview i had use these codes to add in text1.text text1.text = WebBrowser1.Document.Body.InnerText now i want to use listview i try this LV.ListItems = WebBrowser1.Document.Body.InnerText but its wrong need lil Help with this code

Member Avatar for AndreRet
0
132
Member Avatar for t0kipot

hi, my command button sets its function to get the sum of my daily income. And when i click it again the sum will become double (EVERY CLICK) so i want to my command button to WORK by only 1 CLICK. example 10 + 10 = 20 when i click …

Member Avatar for AndreRet
0
190
Member Avatar for sriarjun2013

How to create flexgrid control with save & modify & deletaion & cancel button one example

Member Avatar for AndreRet
0
51
Member Avatar for t0kipot

Hi, help me please I have a project that gather the total cash of my customer. First when i click the 1st total button, the cash value will go to adodc1. Adodc1 is set for DAILY cash values inputs. After multiple cash value in the adodc1 i need to total …

Member Avatar for AndreRet
0
108
Member Avatar for ohwhatacuteanaconda

I need assistance with using Keypress to only allow a certain range of numbers (1-26) to be typed into the textbox. When ever I do it, it only allows me to press the numbers "1 and 2". I'm very new to VB so the help is much obliged. I know …

Member Avatar for ohwhatacuteanaconda
0
410
Member Avatar for Tekito

I am new to Visual Basic 6 Class Modules and am having difficulty constructing a certain class. First off, I created a simple class, which is basically an array with some basic properties (Sum, etc). Next off, I want to create another class, which has these arrays as properties. As …

Member Avatar for MrZerocaL
0
3K
Member Avatar for infantprgrmr

Hi, I am new into Visual Basic programming and I am using a VB2010 Express. I've been working on something and so far managed to achieve results by refering to different articles online. Now I am stuck at the serial communication part. Can anyone please help me describing how to …

0
52
Member Avatar for ben.sugden

I am responsible for developing and maintaining a widescale CRM platform written with Visual FoxPro 9.0 (sp2 SEDNA). Alongside a SQL 2008 back end, I make extensive use of the Microsoft Common Control libraries for the purposes of providing TreeViews, ListViews and the like (the kindof theing that VFP does …

Member Avatar for ben.sugden
0
239
Member Avatar for ronb

i wrote and compiled an vb 6 program on a windows xp sp2 box i am trying to run the program via a batch file from an nt box i get this error: runtime error 91: object variable or With block variable not set the program runs under the scheduler …

Member Avatar for aronhugos
0
5K
Member Avatar for asrith001
Member Avatar for AndreRet
0
170
Member Avatar for killerSmile

can anyone help me to make a program for multiple choice test using visual basic and ms access???pls ..

Member Avatar for deceptikon
0
120
Member Avatar for newbie26

hey..can someone help me?? i have a html/php file with a command button and when i clicked it, it will run the exe file of a vb6 application. how can i do this?can i have sample code?? thanks in advance.

Member Avatar for newbie26
0
504
Member Avatar for savedlema

Hi friends, I'm developing an application for HR. I have two tables so far.One is tblDetails and the other is Academic. I have created a relationship (ID to AcademicID), I have been able to pull data to a form by this SELECT statement: sqlSearch = "SELECT tblDetails.ID, tblDetails.FirstName, tblDetails.Surname, Academic.AcademicID, …

Member Avatar for savedlema
0
228
Member Avatar for honeybee2090

http://www.warriors-rules.com/socks.txt i want to creat login application for this application have 2 textbox 1 webbrowser 1 button login text1.text username text2.text password i am useing htaccess for this AuthUserFile /.htpasswds/.htpasswd AuthName "Sockz-5 Login" AuthType Basic require valid-user

Member Avatar for honeybee2090
0
88
Member Avatar for honeybee2090

my text box have multi lines i want to count those lines and show it in form caption. spoz i have 12 lines in text1.text i want show it like this Sockz-12

Member Avatar for honeybee2090
0
583
Member Avatar for ms061210

Please help me debug about datetimepicker. I think, the code is written correctly but its not. The program kee[s prompting **ORA-01858: a non-numeric character was found where a numeric was expected** Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cmd As New OleDb.OleDbCommand 'cnn.ConnectionString = …

Member Avatar for mikeybware
0
336
Member Avatar for Divinedar

The attached excel worksheet can explain better of what I need. I need to calculate the attached based on fiscal year starting with August and ending in July for the next 5 years. If you have any other questions for better understanding please let me know.

Member Avatar for peter_budo
0
276
Member Avatar for ponnu

vb6 code to check if record doesnt exist,then insert new record.server is ms access 2010.So when i used the Dlookup function If IsNull(DLookup("[empid]", "[employee]", "[empid]= & txtemplid.text")) Then I got error like "function or subfunction not defined .is it due to issues with referencs .how can i fix this error …

Member Avatar for ponnu
0
2K
Member Avatar for lianpiau

my record got OrderFormNo and CashBillNo.(one to one insert) if 1st record OrderFormNo is 123 and CashBillNo is ABC, if 2nd record also same OrderFormNo, the CashBill must be same. As a result, I want detect if got same OrderFormNo in database but different CashBillNo, will not insert to database.

Member Avatar for debasisdas
0
246
Member Avatar for myliene

roll no. name 2/12/2012 14/12/2012 23/12/2012 12 james 56 90 88 23 philip n/a 99 76 45 rosy 55 n/a 85 6 peter 59 74 45 13 sam 69 73 n/a this data i have in excel sheet,i want to write a vba code that depicts individual student's performance in …

Member Avatar for ChrisPadgham
0
117
Member Avatar for ms061210

**PLEASE HELP ME. THIS CODE WILL RETRIEVE THE SEQUENCE YOU MADE. AND WILL OUTPUT IN THE TEXBOX IN THE NEXT FORM. BUT MY PROBLEM IS THAT IT DOES NOT RETRIEVE/GIVE THE GENERATED SEQUENCE. FOR SHORT NO OUTPUT T__T . PLEASE HELP.** Public Sub getJO() Dim oradb As String = "Provider=OraOLEDB.Oracle; …

Member Avatar for Begginnerdev
0
191
Member Avatar for amitash

Hi, I want to store today value in a string in VBA Word, e.g. today is Oct 04 2012, the string will be = "04102012". Any simple code can achieve that? Thanks!

Member Avatar for AndreRet
0
315
Member Avatar for jontennyeah

i was adding a windows form namely form3. but when i set it in the startup form there was an error "The custom tool ' MyApplication.generator' failed" what can i do to fix it? i cannot debug my program with that error. can you help me ? thank you

0
88
Member Avatar for myliene

i have data in excel file from which i want to generate report card for students based on their performances in test held on certain dates.for it i need to write a vba program to depict it in a chart and the dates on which students did not aapear for …

Member Avatar for BitBlt
0
106
Member Avatar for angel06

Guys kindly check this code of mine. Supposed to be Text3.text once inserted into Table1 should give the total work hours but instead, it gives a date, not time. Private Sub Command1_Click() Dim Str1$, Str2$, Str3$, Str4$ Text2.Text = DateTime.DateDiff("n", Text1.Text, Label1.Text) Str1 = Text2.Text \ 60 Str2 = Text2.Text …

Member Avatar for BitBlt
0
135
Member Avatar for compulove

I am writing a program that is a multi-form inventory program for a bookstore with data saved in a textbox. Here is what I need to do: * Write a menu-driven multiform inventory program for a bookstore with data saved in a text file. 1. Each record of the text …

Member Avatar for AndreRet
0
220
Member Avatar for angel06

Hello! I'm currently working with my monitoring system now, is there a code to append records from table 1 to table 2? Please help me guys! Thanks.

Member Avatar for BitBlt
0
253
Member Avatar for guru_iyer

I've a DataGrid Control in my application and a button. When i click a button it should display the contents of the Logins table in the DataGrid. For this I've coded the following, but its giving me an error "Rowset is not bookmarkable.". I've searched a lot, many suggestions include …

Member Avatar for AndreRet
0
1K
Member Avatar for mahela

I have a vb programme.there I link it to a access database.In the database I have a table with 3 fields code,description,amount.I used primary indexing for code field.so codes are as 1,2,3,4,...when I enter the code number in vb program I can extract related description and amount.but what I want …

Member Avatar for mahela
0
122
Member Avatar for HibaPro

the procedure entry part 1stractI could not be located in the dynamic link library MSDART.dll ??? how i can fix this ??

Member Avatar for AndreRet
0
155
Member Avatar for HibaPro

after i add all the reference on my vb6 project and everything loaded successfully when i press on report button to view the report i face this error msg: Logon failed Details: ADO error code ox80004005 Source: Microsoft OLEDB Provider for SQL Server Description: [DBNETLIB][Connectionopen] sql server doesnt exist or …

Member Avatar for AndreRet
0
148
Member Avatar for silversurf

Hello everyone, I am trying to build a inventory and pos system with Ms-Access as database and VB 6.0 programming. I got stuck in one place again. What I want to do is trying to print out the codes and price of the products. In this form, I have a …

Member Avatar for AndreRet
0
480
Member Avatar for HibaPro

Private Sub Cmd9_Click() 'On Error GoTo Error_Handler Dim Report As New Blank_rShopDrawing 4 Set Report = New Blank_rShopDrawing Report.RecordSelectionFormula = "false" Form1.CRViewer1.ReportSource = Report Form1.CRViewer1.ViewReport Form1.Show 1 Exit_Error_Handler: Set rs = Nothing Exit Sub Error_Handler: MsgBox Err.Number & " : " & Err.Description Resume Exit_Error_Handler End Sub the error in …

Member Avatar for AndreRet
0
339
Member Avatar for maverick420

**While executing the following code and when clicking the clear button it gives me error "Error Input String in not correct" line --> workedHour = Decimal.Parse(HourWorkedTextBox.Text) Any help will be highly appreciated** Public Class Payroll Dim fullName As String Dim pay_Rate, workedHour, grossPay, netPay, taxRate As Decimal Dim taxAmount As …

Member Avatar for AndreRet
0
253
Member Avatar for jamescv7

Hi its my first time to join on this community, could anyone help me out to figure out? Actually I want to figure out how this picture would work http://i49.tinypic.com/5bd1tt.png using loop. Basically its like this on a elaborated details: > Write a program like the one to the right. …

Member Avatar for AndreRet
0
482
Member Avatar for HibaPro

when i want to add a component or Referrence to vb6 Project it give me this error msg : error accessing the system registry how i can fix that ??? sry again

Member Avatar for AndreRet
0
6K
Member Avatar for Doogledude123

Whats wrong with this, doesnt make sense that it wont create the folder or files. If PathRead() = 0 Then MsgBox("Error Reading Path Info: One or more Paths do not exist.", MsgBoxStyle.Critical, "Path Read Error") MsgBox("Would you like to create these files?", MsgBoxStyle.YesNo, "Create?") If MsgBoxResult.Yes Then MkDir("/Paths/") System.IO.File.Create("/Paths/aPath.txt") System.IO.File.Create("/Paths/mPath.txt") …

Member Avatar for TnTinMN
0
197
Member Avatar for jd2369

i'm creating an application that will automatically launch a website and click a button on that website. div class="levelwrap level1" style="display: block;"> <ul> <li class="first"> <li> <li> <a id="ctl00_ContentPlaceHolder_TabStrip_Tab3" href="javascript:__doPostBack('ctl00$ContentPlaceHolder$TabStrip','ctl00$ContentPlaceHolder$TabStrip$Tab3')" style="z-index: 8;"> <span class="wrap"> <span class="innerWrap">Network</span> can anyone assist? I'm trying to click the button above. screens a screeshot of …

Member Avatar for geniusvishal
0
137
Member Avatar for america9

Hi, I am trying to develop a windows batch file /vbscript, where the script automatically opens an .exe (like for ex: notepad.exe) and selects the file menu and scroll to a particular file menu subitem . This is the code i have so far : Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run …

0
67
Member Avatar for Dr.Lipe
Member Avatar for debasisdas
0
35
Member Avatar for moonfang9909

where i can download a visualbasic 6.0 and vb.net i NEED it foR my thesis. . i hoping for your reply. ..tnx

Member Avatar for brylle
0
122
Member Avatar for ms061210

**PLEASE HELP ME, MY CODE IS FOR SEARCHING. YOU WILL FIN THE NAME IN THE COMBO BOX, THEN WHEN YOU PRESS SEARCH ALL THE DATA ABOUT THE TENANT WILL BE RETRIEVED. BUT MY PROBLEM IS, EVEN THOUGH THE TENANT IS IN THE LIST, THE CODE ALWAYS RETURN NOT FOUND. PLEASE …

Member Avatar for ms061210
0
164
Member Avatar for HibaPro

Private Sub Cmd_Print_Click() 'On Error GoTo Error_Handler If newflag <> 0 Then MsgBox "Inserting New Record Mode, Press EXIT Button To Return To Normal Mode", vbCritical, "Attention" Exit Sub End If If RepNo.Text = "" Then Exit Sub Dim Report As New rstoreinmaterial Report.RecordSelectionFormula = "{DetailsStore_InOut_Material.RepNo}= " & Val(RepNo.Text) & …

Member Avatar for AndreRet
0
530
Member Avatar for ralph.s.bernardo.1

hey guys i need help for adding values of two or more fiels using ms access, adodc, and datagrid in vb6.0 . example of these is book quantity field with book title field with different titles. i need help ASAP for my library system project. help me please. help for …

Member Avatar for AndreRet
0
199
Member Avatar for jayrbete

Hello Everyone, Can you help me about importing Maya 2011 in visual basic? or converting maya binary to exe files..? thanks a lot for helping me.

Member Avatar for Begginnerdev
0
140
Member Avatar for Tintso
Member Avatar for webseller

Hi All,, I want to add new leave type which its respective purple color to the already existing template by microsoft office available at "http://office.microsoft.com/en-us/templates/results.aspx?qu=employee%20attendance&queryid=194963f8-3883-4599-b317-3dbd92b705c5#ai:TC102780235". Anyone could help me how to add new add new leave type and its color to the year column. Thanks in advance Jos

Member Avatar for ChrisPadgham
0
199
Member Avatar for ss123456

i have a table employee. it has various attributes.(e_id,e_name,e_addr..) i have a data grid that displays all d values of employee..i need to now select multiple rows from the datagrid of employee such that only e_id gets inserted into another table. is there an sql or vb code that can …

Member Avatar for ChrisPadgham
0
898

The End.