10,992 Topics

Member Avatar for
Member Avatar for newb2excelvba

Hi guys, Im not sure if this is the correct area to post my query. I was looking for excel vba thread but I was not able to look for it. anyway i am creating a break track program using excel with vba. My excel file contains the data for …

0
59
Member Avatar for pardeep3dec
Member Avatar for dinilkarun
Member Avatar for debasisdas
0
55
Member Avatar for el buen

Hello, I would like to know how I can modify a DataGrid , if I have a database with multiple tables. database = access , Using ADO with a select join multiple tables.

Member Avatar for debasisdas
0
35
Member Avatar for bprabhumdu

hello friends, how to separate all characters from a given string in vb6.0...For example if i give "welcome" in a text box ,in the same form it will print (w,e,l,c,o,m,e,).......... Thanks in advance ............... regards natraj

Member Avatar for bprabhumdu
0
146
Member Avatar for chern4ever

how do i edit the existing data in a txt files? example of text file "string1","string2","int3" string3 is an integer, i wan to edit it everytime i click a command button numppl is selected by user i wan the new int3 to be old int3 + numppl can sum1 help …

0
56
Member Avatar for army88m2

O.k. this is my first scripting class and I need someone's opinion on this code. I need to write a code for a modularized program that will: 1.) read each record from the inventory database 2.) print a price tag for each item in inventory 3.) count and print the …

Member Avatar for chid_
0
112
Member Avatar for praksk

I am relatively new to visual basic. I need to take two 8 bit byte values, join them to makea 16 bit binary value and then separate the 4 msb as a 4bit binary vale and the 12 lsb as a 12 bit binary value. Thanks in advance for helping …

Member Avatar for dmf1978
0
475
Member Avatar for sddproject

Hi! I'm trying to make a coin toss program using a random generator, but i'm not sure how to upload the image of the heads and tails from its file on my PC. Image names are Tails.gif and Heads.gif . Here's the code so far: [code]Public Class Form1 Dim headCount …

Member Avatar for sddproject
0
198
Member Avatar for puma8085

My project is to receive data from MRI machine, which has a com port can send serial signals. The data come thru pin3 of the com port and we want to save and read them on a pc. I've check the data with a spectrum analyzer and found the signal …

Member Avatar for puma8085
0
82
Member Avatar for Tekito

I'm new to class modules, and the compiler seems to be enforcing a correlation of the number of input vars for a Get and Let procedure of the same property. The Let property must always have exactly one more variable (the NewValue) than the Get procedure. So the code I've …

Member Avatar for Tekito
0
100
Member Avatar for dubey.pankaj

Hi.. I m using vb6. plz tell me how can i access data in sql table by vb coding like.....eg. In sql table i hard code the 20 question i want every time when we click the next button on vb form then display question no-2 & IInd time i …

0
52
Member Avatar for preethi_ga

Hi, Actually i try to use FlexGrid in VB. But i donno how to use that. Can anyone help me how to bind the database in MSFlexGrid?

Member Avatar for VIeditorlover
0
203
Member Avatar for osewa

i am writing program in vb 6.0 with msacesss as the database.what the program is about is hardware insurance management system.there is date registered in the entry form and date expir.i want explanation on how to use the date diff with code on to calculate the date difference.so that when …

Member Avatar for QVeen72
0
113
Member Avatar for kehar

Hi, I would like to pass on a parameter from VB6 for the date.value from datepicker. Pl help me how to convert date.value into string as the parameter I have created in Crystal Report is string type. The parameter name in Crystal Report is chdate. I wrote the code as …

Member Avatar for QVeen72
0
270
Member Avatar for hartoksi

I've searched all contents of Daiweb and found similar topics but not exactly good on me. I'm trying to build a activex DLL without any form. This DLL will be used by others as a function library about a specific purpose for "color matching". I wish to declare an array …

Member Avatar for Teropod
0
93
Member Avatar for pardeep3dec
Member Avatar for debasisdas
0
41
Member Avatar for veledrom

Hi, I want to create a form for retoprt section in my VB6 project. What do i add into my form and from where? Thanks

Member Avatar for debasisdas
0
73
Member Avatar for vbgirl

i have an question... this is my text file data [COLOR="Red"]1234567,08072008,2 8767768,08072008,4 9988776,08072008,6 7891234,09072008,8 4567891,10072008,1 5213789,11072008,2 7854123,11072008,3 4561237,14072008,1 7879145,15072008,2 5218510,16072008,8[/COLOR] i would like to separate it to 3 part. this code izit correct? [COLOR="Green"]Dim a(50) As String Dim c(50) As String Dim ProductID(50) As String Dim i As Integer i …

Member Avatar for QVeen72
0
152
Member Avatar for vbgirl

can everybody help me... [CODE]Public cnName As Connection Public rsId As Recordset Private Sub cmdImport_Click() Dim a(50) As String Dim c(50) As String Dim ProductID(50) As String Dim i As Integer i = 0 cdbOpenFile.Filter = "Text Files (*.txt)|*.txt| " 'Specify default file name to open cdbOpenFile.FileName = "" ' …

0
60
Member Avatar for vbgirl

[code][COLOR="Green"]Public cnName As Connection Public rsId As Recordset Private Sub cmdImport_Click() Dim a(50) As String Dim ProductID(50) As String Dim i As Integer i = 0 cdbOpenFile.Filter = "Text Files (*.txt)|*.txt| " 'Specify default file name to open cdbOpenFile.FileName = "" ' Specify default filter to *.txt cdbOpenFile.FilterIndex = 1 …

Member Avatar for vbgirl
0
138
Member Avatar for pardeep3dec

Hi, I would like to know about difference between Function and module and Procedure for making and use module in visual basic 6.0

Member Avatar for hartoksi
0
97
Member Avatar for vbgirl

i need a help how to printer Out the data which is store in list box then connect to printer server to print out?? thanks..

0
61
Member Avatar for abhinav.agarwal

Hi everyone, I am working on creating a VB 6.0 application which has excel as backend. Basically I have 3 sheets 1. A location sheet from where I need to pick values from particular range of cells ( say C2: F20). I have different excel sheets for a different locations …

0
43
Member Avatar for EddyLLC

The following Code is causing an error when I try to set the AdoConn = New Connection. I receive an "Invalid Use of New Keyword" error. Can I get some guidence as to why? Thanks. [code]Dim adoRecordset As Recordset Private Sub Form_Load() Dim adoConn As Connection Set adoConn = New …

Member Avatar for QVeen72
0
91
Member Avatar for nanawan

please help me.. i have 40 data to display at msflexgrid. but i cannot do that because it show too many continuations error... [code] Public Function show_msflex(SQL As String) MSFlexGrid1.Rows = 1 Set rekod = New ADODB.Recordset rekod.ActiveConnection = Con rekod.CursorLocation = adUseClient rekod.CursorType = adOpenDynamic rekod.LockType = adLockOptimistic rekod.Source …

Member Avatar for nanawan
0
269
Member Avatar for mandar2886

Iam doing a project on Voice Recognition System in VB 6.0 where in if I say "Open Windows Media Player" it should open the media player. This is my idea pls tell me if it is right and pls help me to proceed with it.

Member Avatar for selvaganapathy
0
810
Member Avatar for splitfinity

Hi guys. Im trying to get a wav file to play on a mouse over event. I want a wavefile to play when the mouse pointer moves over a label and stop wen it is moved off the label. I believe this can be done using the sndPlaySound, i have …

Member Avatar for splitfinity
0
167
Member Avatar for yasekwa

Hi, I'm Maya and I leave in Florida(South Africa), I am a bigginner on visual basic.net. I must say I am struggling and really need help on how to retrieve information on access tables using v.b (I already connected the databasess and vb.net...

Member Avatar for zandiago
0
28
Member Avatar for AUGXIS

hi guys, i get an error message "554 message is not rfc compliant" while i was trying to send an email. can you please help me with my code... [code] MAPISession1.SignOn With MAPIMessages1 .SessionID = MAPISession1.SessionID .Compose .RecipAddress = "myemail@email.com" .MsgSubject = "For Your Info" .MsgNoteText = "HELP" .Send End …

0
61
Member Avatar for dinilkarun

Hi All, Through Shell I am opening winxip32.exe in my vb 6.0 application. I want the application to wait until the shelled process has completed and then proceed with execution of the next line of code. How should I go about it. Please help. Regards, Dinil

Member Avatar for dinilkarun
0
76
Member Avatar for electrosoul456

I am using this query sql="select * from student" if rs.state=1 then rs.close rs.open sql,strcon,3,3 while not rs.eof datagrid1.datasource=sql datagrid1.refresh wend where as rs is a recordset variable and strcon defines the connection to the data base. please guide me for correction

Member Avatar for manoshailu
0
83
Member Avatar for deftones

Hey people, I have quite a big code and want it to be repeated until the conditions are met. The problem is that every time I try to use Do...Loop statement, my program becomes "hung". Or even when I try to replace that statement with other methods, the program still …

Member Avatar for deftones
0
96
Member Avatar for abu taher

I use data control to link access file by data properties not code. use simple code like move next etc. I use find next to find data. but when i want to find i write the criteria like Name = taher. But i want I write only taher in find …

Member Avatar for electrosoul456
0
232
Member Avatar for davidao

Hi, I am trying to find a solution for a problem.. I've got a string but I need to format it in a specific type.... #-0.6|141.443719976486|59.8780753410541|-0.6|140.736613195299|59.1709685598 #534359|59.1356132208082|-0.6|140.821466009042|59.1851106954913| #17|-2.03|141.39422501803|59.828577866371|-2.03|140.78611066998259.2204660345 #9042|59.1851106954913|-2.03|140.821466009042|59.1851106954913|#40.82146600902.03140.786110669982|59.2204660345506|-2.03|140.786110669982| #9042|59.1851106954913|-0.67|141.429577840862|59.7932225273117|-0.67|#140.821466009042|59.185110695491| I am trying to end each line with "|" and move the rest of the characters to the next line.... …

Member Avatar for selvaganapathy
0
79
Member Avatar for andy_aphale

hello all, my self anil i am doing some timepass work in VB for practice. i am creating a webbrowser and i need some help i am creating it by using some components like microsoft internet controls. now i have created stop,refresh,back,forward,home buttons succsessfuly but i want some help from …

Member Avatar for selvaganapathy
0
188
Member Avatar for matt_wroe

Hello, I have written a program in visual basic 6 for controlling pumps on an addressed rs232 or rs485 network. Currently the names and addresses of these pumps are stored in an excel file which can then be edited by the software at runtime to add/remove pumps from the network. …

0
40
Member Avatar for hell_tej

Hi Frends, I m creating an access to VB6 connectivity Project. I ahve problem that VB6 Gives not me permition to leave any field NULL so when i save my record it genrate ERROR 94 That is invalid use of null value In my project it is not necessary to …

Member Avatar for manoshailu
0
133
Member Avatar for Teropod

Is there any way how i could compare arrays like pattern matching or should i write my own code? Thanks.

Member Avatar for manoshailu
0
379
Member Avatar for AUGXIS

hi guys, i was trying to sum up all the balances of clients to know which of them has reach their credit limit but my codes are not working. It shows an error and highlights on this code [code] rsArmaster.Open "select sum(balance) as credit from ArMaster where shippercode= '" & …

Member Avatar for AUGXIS
0
92
Member Avatar for kmacker

Ok. Need some help with a project at my work. Wanting to create a useful map of the windfarm where I work. (Once completed, will be the largest windfarm in Europe :-)) Anyway have created a map of the site showing the locations of each turbine. Using this map as …

Member Avatar for kmacker
0
173
Member Avatar for mode17

hi i'm creating a program with the same effect as the green screen used in the movies and i'm having problem in getting the right value of green colors, but when i uses black or white as a color to be mask it works but not with the green, can …

Member Avatar for selvaganapathy
0
89
Member Avatar for arun_kumar112

Hi All, I am new programmer, I have to create list of item which are selected from list box . It should be displayed like " a,b,c,d,e,f " How can I do ? it can be in a string or numeric . only selected Item is required to display displayed" …

Member Avatar for selvaganapathy
0
102
Member Avatar for Djali

Hi Guys, I want to ask about dat file. How can I create a code for read and write dat file with VB ?, eg : string string 0.5000, 40 0.7699, 60 0.8431, 70 1.6754, 50 string string For above example,The code read string value in line 1 and 2 …

Member Avatar for selvaganapathy
0
104
Member Avatar for orion_nsk

Hello Everyone, I'm Uploading this Project for the ones who need Help regarding VB's MSCHART CONTROL!!! This Sample Shows : [B]1) How to Show Data from an Access2003 Database on Chart. 2) How to Print Data from MSChart Control. 3) How to "Save As..." the Chart, as .Bmp file.[/B] Hope …

Member Avatar for Djali
0
334
Member Avatar for prasethavm

What is the difference between crystal report and data report in vb. how to create crystal report and data report in vb.

Member Avatar for debasisdas
0
45
Member Avatar for hell_tej

Hi, I m inserting Record in Access using VB6 SQL statement as follows [code]Dim str As String On Error GoTo solve str = "INSERT INTO [compinfo]([cID],[cname],[address],[add2],[city],[Postno],[mob],[phno],[faxno],[email],[workday],[offtime],[saldate],[duedate],[amount],[paytyp],[web],[type],[expdat],[charge]) values (" & "'" & txtcomid.Text & "'" & _ "," & "'" & txtcomnam.Text & "'" & "," & "'" & txtcomadd.Text & …

Member Avatar for debasisdas
0
249
Member Avatar for apuamy

i have developed an application which uses TRIM command and MSCOMM command. When i am running the exe file in any other computer, error shows in TRIM command.Error shows some component missing. Then i loaded VB 6.0 in the new computer still error continues. Then i tried my software in …

Member Avatar for apuamy
0
83
Member Avatar for mstrauss

I have created some subroutines and User Defined functions in Excel's VBA. Internal to them, I have created arrays. I would like to use Excel functions on these arrays, but can not seem to. For example I would like to use the determinant function, which is mdeterm in excel. If …

Member Avatar for vbCNEW
0
156
Member Avatar for bytigma

Hi guys, Hope you will be able to help me with this problem. The problem that I have is that I have two .xsl files that are uploaded to the same specified folder at 4pm everyday. The file names are the same apart from the end digits specifying the date …

Member Avatar for vbCNEW
0
99

The End.