10,992 Topics

Member Avatar for
Member Avatar for NewVBguy

Hi Everyone, Please help me to solve this problem. I have an adodb.recordset that open eitheir an excel, dbf, mdb, or text file. What I want to do is to export this recordset into an acess table. Can vb6 do this. Please show me the how.... Thanks in advance Newvbguy

0
45
Member Avatar for shabina

is there a way to open attachments displayed in a textbox, separated by a semi-colon..like an email attachment that's underlined where u just click on the link(underlined filename) and it opens that particular attachment. i would just like to see an example...thanks!

Member Avatar for shabina
0
116
Member Avatar for fbdubai

am trying to read data from a RS232 cable which is connected to a machine. It displays CTS ON and nothing happens. I have tried downloading some simple help programs uwins MSComm in VB and it doesnt help. How can i get the data in and also send data out …

Member Avatar for Comatose
0
110
Member Avatar for fbdubai

I am trying to migrate my MS Access database to MS SQL. My coding pattern is simple. Like this '--------------------- Data1.Database.Close Data1.DatabaseName = App.Path & "\Status.mdb" Data1.RecordSource = "Performance" Data1.Refresh C1 = "SlNo = 1" Data1.Recordset.FindFirst C1 If Data1.Recordset.NoMatch = False Then Data1.Recordset.Edit Data1.Recordset.Fields("Amount") = Format(mamt, "##,##0.00") Data1.Recordset.Fields("Upd") = Now …

0
73
Member Avatar for duckforceone

Hiya all. I am currently working on a database of information about a card game. But i have a question. What i would like to do, is make a stand alone program, that can show the card information, and let users modify a bit of it. It would need to …

Member Avatar for Comatose
0
125
Member Avatar for tigrai

I like to start my project in cd with auto run but if the auto run fails in any case I like the cd to be ejected (remove cd) in vb6 thank you

Member Avatar for Comatose
0
205
Member Avatar for INI

Hi all, What code can I use whereby if the user times in anything other than a number an error message will prompt them. [code] [U]If NOT val(Textbox1.value) then[/U] Msgbox("Sorry you must only put numbers") else end if [/code] The line underlined, does not work. Please can someone tell me …

Member Avatar for Comatose
0
148
Member Avatar for Magna

Hi there, I just registered and see that u have solve many problems for many ppl .. and I get good and new info and codes from u.. I'm having problem with Datagrid bcoz for really I'm not advanced devoloper,I'm using DAO to show me the records from database to …

0
58
Member Avatar for BombAppetit

greetings citizens i have a question regarding OLE object. is it possible to display an OLE object in a list box? my table has a bunch of numbers and i plan to add a new column for "status" showing, err, the status of certain products. i pasted an image of …

0
77
Member Avatar for shabina
Member Avatar for shabina
0
187
Member Avatar for BillWebber

Hi to whoever has been good enough to read this. I am very new to Visual Basic 6 and are trying to build a small data base program as part of a tutorial i managed to get my hands on. I have been struggling with this problem in my code …

Member Avatar for BillWebber
0
187
Member Avatar for cyman73

Hello all, I am reading (get) and writing (put) values from multiple binary files. I first have to copy a binary file file1.bin to file2.bin and then I append 1 record to file2.bin. My problem is when I read the following code I am not getting the values I expect: …

Member Avatar for cyman73
0
195
Member Avatar for KyawGyi

Hi all of the developer Now I'd like to get the sample source code for Web streaming and capturing with VB both client site and server site software. KyawGyi:rolleyes:

0
41
Member Avatar for marlonism

hi sir/maam...i am new member here my name is marlon from batangas city philippines...and i wanna ask something about vb...if i have a lots of textbox in a form...and one button to clear it all textbox...is it possible to use a for loop...like for each textbox or something to make …

Member Avatar for nedwards
0
181
Member Avatar for Reid Grandle

I'm trying to figure out how to create a few handy macros for my job at work. I've done a little VBA programming before, but its been a few years since I've touched it, so I could really use some help. I'm looking to create a host of macros that …

Member Avatar for williamrojas78
0
146
Member Avatar for broznic

Hi everyone, I am having a problem with this code in VB6: [CODE] Public Function test() hOpen = InternetOpen("Example", _ INTERNET_OPEN_TYPE_PRECONFIG, _ vbNull, _ vbNull, _ 0) REM InternetOpen goes OK hConnectHandle = InternetConnect(hOpen, _ "google.com", _ INTERNET_DEFAULT_HTTP_PORT, _ vbNullString, _ vbNullString, _ INTERNET_SERVICE_HTTP, _ 0, _ 0) REM here …

0
57
Member Avatar for BarryX

Hey, I am trying to write a section of code in VB that gives me the audio level of the output from a sound card. If I am using a Soundblaster card this is very easy as I can use the MIXERCONTROL_CONTROLTYPE_PEAKMETER. But not all sound cards have this. I …

0
58
Member Avatar for LocoBird

I made a simple chat program and file send (server/client) type. everything works fine when i run them in the IDE but after i make them EXE and test them when i do the file send the program that the file is being sent to just closes. the chat part …

0
67
Member Avatar for harish13

i have a array called arr() of type byte. one of my function returns an integer long value(val) 4 bytes. i want devide this value into bytes and assign to arr() that is arr(1)=first byte of val arr(2)=second byte of val arr(3)=third byte of val arr(4)=fourth byte of val thank …

Member Avatar for hollystyles
0
43
Member Avatar for Maria_19

Hey guyz Herez the prob, I got two dropdown list in EXCEL. to copy them to another excel doc is a peice a cake but the prob is I want to change the format while copying. List 1 has course curricullams and list two has course titles. now many courses …

0
42
Member Avatar for CoffeeDude

Hi, I am pretty new to Visual Basic 6 and I'm having a problem with a small program I'm writting for fun. Now when I do the following: [code]If ClockTime = #6:52:50 PM# Then [/code] The whole code works 100% find and dectect that the time has hit that time. …

Member Avatar for CoffeeDude
0
87
Member Avatar for Bernard Kane

Hi I am a new user of VB (or any prgramming for that matter) and keen to learn. A very simple example of what I was looking for was the code for a button to open another form. Does anyone know where I can access simple event proceedure codes - …

Member Avatar for Comatose
0
104
Member Avatar for lover99509

Hi guys, i have a problem in vb6 . lets say i have a command button named print in form1 then after clicking the print button it will transfer me to form2 which will control the number of copies,quantity and these things of printing options. The problem is how to …

Member Avatar for Comatose
0
169
Member Avatar for vhinehds

hi its me again... can someone please explain what a class can do? how to call a class? or if just give me a good link where i can refer to it. thanks a lot.

Member Avatar for Bharati Krishna
0
1K
Member Avatar for Maria_19

Hey guyz I got this search macro from the web for my excel project but as Iam a beginner i really dont know how to modify it. I need to use this search code to identify and retrieve documents for that its going to scan through a especified location. I …

Member Avatar for Comatose
0
153
Member Avatar for BombAppetit

greetings i'm currently working on my Form in VB6. it has a list box that i use to display table. How do i display table from a different database? i did it before by modifying row source property in VBA, but that only works if the form is part of …

Member Avatar for Comatose
0
137
Member Avatar for INI

I have a question, does anyone know why "Div/0" error comes up in VB? My program reads/writes to several files. On my computer and one of my friends computer, it works perfectly; though there are some desktops machines that I receive that error. When I step through the program to …

Member Avatar for INI
0
178
Member Avatar for rajesh.nich

hello sidekicks, I want a sample code for How to call Crystal report version 11 throubh Visual basic 6.0

Member Avatar for riffazra
0
77
Member Avatar for ykc

Hi, When I run an application written using VB6 and MS Access 2000 in Windows XP and Windows 2003 server,the system will prompt illegal operation (sslstbar.ocx, ssdw3a.ocx and ssdw3b.ocx) and the program will hang. Hope anyone can guide me to resolve this problem soonest possible. Your help are really appreciated. …

Member Avatar for nareshPenneti
0
138
Member Avatar for bang2711

i need some help over here, as i`m quite new to this program. i have some problem over on how to create. i need 1 tab to be on the screen but inside the tag i got 2 button. the button is auto add on whenever i do update on …

Member Avatar for maheshsayani
0
197
Member Avatar for savi_karthika

Hello How to produce daily sales for each item in a month of a shop using dbgrid. It should give how much numbers sold for each item in every day of a month. Pls help

Member Avatar for maheshsayani
0
101
Member Avatar for russell214

I'm using VB6 as my frontend and MSACCESS as backend. I have a field in tblHistory named "payperiod". I have put text in this field. content of payperiod: JANUARY 1 - 15, 2006 JANUARY 16 - 31, 2006 FEBRUARY 1 - 15, 2006 FEBRUARY 16 - 28, 2006 and so …

Member Avatar for maheshsayani
0
262
Member Avatar for propricer

When I put a 'type' statement inside a procedure, it tells me invalid inside procedure. When I move it to the declarations section, it tells me invalid outside procedure. Help ... Where's the middle ???

Member Avatar for Comatose
0
110
Member Avatar for Embeza

Hi every body Can you please fix me errors. Here are my codes and errors incountered #Stage1 I want the user to type in the file path to txtpath.Text and a text input to be appended to that file be written in txtwrite.Text The error: Run Time error ->path not …

Member Avatar for Embeza
0
272
Member Avatar for vbmade2000

Hello All I have problem in database management in vb6 using access database. I have created small code library to store code snippets. When i add new code to database then size of database is increased.This is normal. But whenever i remove some code from my database then size of …

Member Avatar for maheshsayani
0
71
Member Avatar for Maria_19

Hi Every one I need some help with excel macros. I am a beginner so I dont know much about writing my own macros but what i need is a macro that can read a particular cell's contents from an excel sheet then search in the directory tree and retrieve …

Member Avatar for Maria_19
0
226
Member Avatar for s0312001

[CODE] Function CheckWord(ByVal Wrd As String) As String Dim i As Integer Dim Pos As Integer Dim Found As Integer Found = 0 For i = 1 To 26 Pos = InStr((Word(i).ToLower), Wrd.ToLower) If Pos <> 0 Then CheckWord = Word(i) Found = 1 End If Next If Found = …

Member Avatar for Comatose
0
283
Member Avatar for s0312001

Hello...:rolleyes: I know that you have done some work in the speech recognition field,do you know anything about testing for the presence of a sound. This would enable me to do extra processing when it was not recognised. are there facilities to manipulate the sensitivity of the word recognition? i …

Member Avatar for s0312001
0
107
Member Avatar for YASIR IRFAN

Dear All, I have an application witch get real time data and update itself like STOCK MARKET trading terminal. I want to capture real time data and store it in a text file. Please help me in this regard Thanks:sad:

Member Avatar for Comatose
0
270
Member Avatar for bobburney

My goal was to move the software from a Win98 machine to an XP Machine. I attached the 98 hard drive to my laptop and copied several folders over but I was unable to get it to work. When I restarted the 98 machine the dos program gets an error …

0
78
Member Avatar for DarkAlex

Hello. This is a very very basic question about variables in range names. I have quite a few ranges of varying lengths in multiple Excel documents. I want all the ranges standardized and set to the same length, but I don't know what that length will be yet, and it …

Member Avatar for DarkAlex
0
126
Member Avatar for haria_kishore

Hi everyone I have a table with 3 columns pk_itm_code name fk_code The pk_itm_code is taken from another master table. Now my requirement is automatic generation of fk_code fk_code = pk_itm_code + "PT" + random generated no. (startin from 1) If the user selects same pk_itm_code 2 times then the …

Member Avatar for Comatose
0
79
Member Avatar for maheshsayani

hi all i want to learn more about DLL and ActiveX control I Want the link of any site which offers learning about dll and active x in vb with Examples and demo to how to create then in step by step process Please Any one can help me in …

0
55
Member Avatar for maheshsayani

Hi All I Want To Create Semi Transparent Forms I Had done work on Transparent forms but i need semi transparent form which we can see background text/image through this form in vb please send me the solution for this

Member Avatar for maheshsayani
0
123
Member Avatar for INI

Good Morning All, I am having a major issue here; for some reason the line of code below works and sometimes does not work. When it desides not to work, it leaves a mess in my excel sheet. [code] Range("A1").Select ' This just goes to the upper left corner of …

Member Avatar for Comatose
0
190
Member Avatar for INI

Good Morning Guys, I am trying to copy a selected range from worksheet (or copying the whole worksheet) from file A, create a new workbook(name it and rename a worksheet in it). Then paste copied worksheet or range into new workbook. Please let me know what code to use, thanks. …

Member Avatar for INI
0
125
Member Avatar for BombAppetit

erm.. greetings again i have this database system using access and i need to look through another remote computer for files using Remote Administrator 2.2. how do i get started? as in to run the application and searching through folders in remote computer to get a certain txt file.. thats …

Member Avatar for BombAppetit
0
112
Member Avatar for purplegerbil

Hi, A program I am writing has the user entering values into textboxes then clicking an 'Add' button. Once clicked one of the textbox values appears in a list box. e.g Job Number, Data Filename, Unique Code The Unique code is displayed in a listbox. All three values are stored …

Member Avatar for Comatose
0
138
Member Avatar for agrothe

Would anyone know how, if it's possible, to pass a user defined type through a network connection say using winsock? For example: [CODE] type tExpl name as string address as string phone as string end type dim myExpl as tExpl winsock1.send myExpl [/CODE] As far as i know, winsock only …

Member Avatar for Comatose
0
105
Member Avatar for kthompsn

Have been asked to convert a set of programs from QBASIC to VB6. Any real pitfalls that i should watch out for? FWIW, my BASIC experience is mainly GW-BASIC and earlier. And yes, i WILL be RTFMing. tke

Member Avatar for Comatose
0
309

The End.