12,425 Topics

Member Avatar for
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
139
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
811
Member Avatar for redrum237

hey, i have made a game called zombie island. this is what needs to be included in the game: This is a simple turn based game. Set up a 2d grid. Onto the grid randomly position holes, zombies and a man (each represented by a simple character e.g. O Z …

Member Avatar for redrum237
0
147
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
35
Member Avatar for richwords

Well like i said i just joined this community and i,ve been working on vb6 applications and it has been giving me a lot of problems because i,m still new to programming. please i know i have some guru's out there who can help,so please post all necessary materials that …

Member Avatar for zandiago
0
341
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
233
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
80
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
46
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
Member Avatar for jtomacelli

I need to copy the data from the top row of a worksheet to all those empty rows underneath it UNTILL you get to a row that has data…then start over and copy that new data into the empty rows….and so on… I have the code that we've written so …

Member Avatar for vbCNEW
0
106
Member Avatar for ymidexterous

Hi Everyone! Need help in my new Project with Visual Basic 6.. I need to send a 5 volts signal from my pc using a VB6 program to the serial port where I could place a relay... Thanks :) Dexter A.

Member Avatar for ymidexterous
0
673
Member Avatar for deftones

Ok, I have this code as an ex.: [code] Private Sub Command1_Click() Dim L As Long, L1 L = Label1.UBound L1 = L + 1 Load Label1(L1) Label1(L1).Move Label1(L).Left + Label1(L).Width Label1(L1).Visible = True End Sub [/code] If I press the button two times, it will make two copies of …

Member Avatar for deftones
0
84
Member Avatar for drichird

Here is some old VBA code inside a Word 2003 document to open and then save a word document: [code] Documents.Open FileName:=docFileName, ConfirmConversions:=True, _ ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _ PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _ WritePasswordTemplate:="", Format:=wdOpenFormatAuto 'do stuff to the opened file here... ActiveDocument.SaveAs _ FileName:=docFileName, _ FileFormat:=wdFormatDocument, _ LockComments:=False, _ Password:="", …

0
103
Member Avatar for deftones

Hi everyone, I have a tiny problem here but just cant handle it, since I'm new to VB6.. I want to put a code into a module which contains a lot of lines with same objects. I have an idea of relating those objects with variables, so instead of, for …

Member Avatar for selvaganapathy
0
105
Member Avatar for ocw

hihi.. how can i upload a folder to the FTP Server instead of uploading file by file. ??? ocw

Member Avatar for inf4mi5
0
126
Member Avatar for veledrom
Member Avatar for veledrom
0
475
Member Avatar for lIGhT4umEnAll

Hi friends I need some help from VB and Oracle guru's. I am trying to create a dynamic table from VB 6.0 in Oracle (mean I want to create a table whose name is dynamic issue) For this purpose I code as follow and get error table name is not …

Member Avatar for manoshailu
0
151
Member Avatar for sddproject

Hi everyone! I want to have a coin toss on my program: i have two images (a heads and tails) and i want the user to click on a button which will generate one of these pictures randomly. There's all this code on how to create a random number generators, …

Member Avatar for Teropod
0
291

The End.