vba x 200

12,155 Topics

Member Avatar for
Member Avatar for kinyuadave

Hi there? I have this program that i need help with. I have created a program that by clicking a file menu an excel dbase is created and stored. Now the problem is i have many excel files and i want to enter data into them and this is done …

Member Avatar for Jishnu
0
121
Member Avatar for kinyuadave

Hi there? I have this program that i need help with. I have created a program that by clicking a file menu an excel dbase is created and stored. Now the problem is i have many excel files and i want to enter data into them and this is done …

Member Avatar for Jishnu
0
333
Member Avatar for abhidev

hi all, I am new to VB 6.0 . I have created an application, which generates a .kml file which is the format read by google earth at a particular location. I want to be able to open the .kml file by clicking a command button. I am right now …

Member Avatar for bushman_222
0
124
Member Avatar for dinilkarun

Hi, I have a large XML file about 70 MB.I would like to read data from it.I would like to read using SAX parser...as it is a event based parser. Regards DInil

0
70
Member Avatar for Shilpa Jain

Hi All, I am novice in VB 6.0. I have to search data from access table using Employee no field which is unique and populate it on the form. But, I am encountering an error whenever I try to run the source code. I am getting runtime error as "No …

Member Avatar for Shilpa Jain
0
184
Member Avatar for Shilpa Jain

Hi All, I am making a tool in VB using MS access database. When I run the query in access it returns me the data but in VB it shows 0 recordcount. Any idea what could be the reason for this? One nore thing to ask. As multiple people can …

Member Avatar for Shilpa Jain
0
175
Member Avatar for chanthung

i have developed a small software. its more or less bug free. i wanted to make a setup n c if it works fine. but after making the setup software, i tried running the software but halfway it stopped and showed this error. visual basic error msftqws.pwd\$(DLLselfregisterEX) cant figure out …

Member Avatar for QVeen72
0
160
Member Avatar for Shilpa Jain

Hi All, I am inserting data in access database using Vb6. Data is getting inserted but when I try to fetch it again, it returns an empty row.I have an idea that I have to use update/refresh statement but not getting where to use it. Please help!!! Below is the …

Member Avatar for Shilpa Jain
0
103
Member Avatar for realone

hi guys, pls can u help me with an algorithm that we compare record in a database one after the other.As in the first record compare to other records in the database,second record also compare compare with other records in the db,.....................untill all the records are compare. i want to …

Member Avatar for dadelsen
0
212
Member Avatar for shalli

1st lol..im new here, so hi every1 ;) ok my Question now..:-/ i have a problem to put an image on my MDI form which i also using an active skin in all forms including the MDI form.. can anyone tell me how can i show da Image on MDI …

Member Avatar for shalli
0
120
Member Avatar for Shilpa Jain

Hi All, I ahve to show the report on a vb form. I have written the code for exporting it to excel, but unable to get how to use it so that report is showed on vb form. I have an idea that I have to use datareport for this. …

0
69
Member Avatar for manickumar

hello sir i developed a small vb application and converted into an exe. i added this exe to right click menu options for file with extension .jpg what i want is if i select a jpg file and run the exe from rightclick menu the filename of selected jpg file …

Member Avatar for selvaganapathy
0
89
Member Avatar for sahilarora

I am trying to pass a whole recordset into a query. I have made a form, with a listbox that is linked to a table that has 2 columns: Country and CountryID. When I select the Country on the form, i need the Country and the CountryId to be passed …

Member Avatar for Jishnu
0
110
Member Avatar for mfahmy2008

I have a text file contains non delimited data (Each row consists from 16 fields and has a 131 byte) I used this code to load it's data into datagrid(I have visual basic 2005) The program work fine Now I want load this datagrid into access database I try to …

0
88
Member Avatar for madhanacdc

hi friends... can anyone tell me how to do this task. in a vb form i should input a sql query and should get the output. how to do this???? plz help me

Member Avatar for selvaganapathy
0
99
Member Avatar for Miruna

can someone send me the code for selecting the items listed in combobox on keypress. Like My combobox consists of following items: Bombay. Chennai. Delhi. Currently am able to select the item with the help of mouse. how can i select " Chennai " from typing 'c'? Thanks in Advance.

Member Avatar for selvaganapathy
0
87
Member Avatar for katididdy

I am trying to load an ini file into a list box. I am unable to get anything to display when I run in vb6. Does anyone have any snippets to assist me, or advice?

Member Avatar for selvaganapathy
0
41
Member Avatar for jaasaria

sir, question.. can i get the exact len of string when quering? because i have two format in my TransID. The one is the 10digit for the MSAccess and the another is the 11 Digits in my MySql. So if i update all in the MySql database the problm is …

Member Avatar for jaasaria
0
139
Member Avatar for dadelsen

The following script function "btnRunScript_onclick" works as long as it does not access the HTML control "txtMessage". If it does, "Page Error" is shown in the statusbar of Internet Explorer (6). Knows anybody why? Thank you. [code] <%@ Page Language="vb" AutoEventWireup="false" Codebehind="GuessingGame.aspx.vb" Inherits="Ch07Le04.GuessingGame"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> …

Member Avatar for dadelsen
0
413
Member Avatar for mfahmy2008

I have a text file contains non delimited data (Each row consists from 16 fields and has a 131 byte) I used this code to load it's data into datagrid(I have visual basic 2005) The program work fine Now I want load this datagrid into access database I try to …

0
94
Member Avatar for theybasis

[COLOR="Green"]hi there ...I am Debasish. New here and am wondering here and there thinking about what to do??? Is there any tech guru who can show me a way???[/COLOR]

Member Avatar for debasisdas
0
115
Member Avatar for kehar

Hi friends, Pl tell me the method to use Num2Str with a simple example. I am using VB6 and Crystal report 8.5 (K.S.)

Member Avatar for QVeen72
0
89
Member Avatar for mjuras

Does any one know if there are published standards for writing state to the hidden code in a VB6 form file. For example, below is how one ActiveX component writes its state. Are there any rules about how this relates to the COM interface or is it up to the …

0
69
Member Avatar for heamak

Hi, I am doing a project using vb which is related to generate a script and run it on a tool. I am invoking an tool(ex:media player) from the vb using shell command. Now i need to run a script in the invoked tool. instead of user going and manually …

0
48
Member Avatar for acecombat

I have the transparent frame control ([url]http://www.codeguru.com/forum/attachment.php?attachmentid=3108[/url]) and have added it as a reference in my application, however I am trying to replace all existing frames (That are bound with objects and are in code to be visable only at certain times) with these transparent frames without messing up the …

Member Avatar for selvaganapathy
0
99
Member Avatar for bpcslave

Good evening, all... Quick question, wonder if any light can be shed. I'm running a two-form program that reads from a database with three tables - first form has a filelist box that lists the available databases, the form takes that filename and uses it to set the source for …

0
76
Member Avatar for xxxviking

so considering i know nothing about programming, could this be done in vbscript? would it be like pages of typing or is it simple

Member Avatar for venomlash
0
110
Member Avatar for zawpai

Hi, Could anyone give me some suggestions? Now, I want to put the labels beside the list box to show the number of string lines, but i cant' do adjust all between string lines and labels although the size of text are same. You all will know the smallest size …

Member Avatar for selvaganapathy
0
138
Member Avatar for msantosh18

can any one help me how to create charts by connecting to database. my need is that i have to group by a column in database and represent it in a chart in visual basic. the values after groupby may have 10 values. how can i do it in pie …

Member Avatar for bushman_222
0
106
Member Avatar for preethi_ga

hi, when i update records in VB, only 0's are stored in database, can anyone halp me to solve this? send me appropriate code for this?

Member Avatar for preethi_ga
0
136
Member Avatar for Derice

i am trying to coonect ms access with vb6. The code is working but after i execute "SELECT * from table" it is showing the content for the last row in the ms access. I am wondering how i can change my code so it display all the content instead …

Member Avatar for Derice
0
130
Member Avatar for doaji

please i need help in gettin data interaction between forms, basically what i want to do is to create a questioniare of about three forms where data is requested from the user and the last (4th) form, displays an intepreted set of information based on the data that was enter …

Member Avatar for QVeen72
0
105
Member Avatar for mnafa

hi friends, pls tell how to take crystal report & how to use it? Thank you

0
49
Member Avatar for acecombat

I'm recoding an application for work to make it compatible with another application thats been upgraded, and as such I've added a bit more visual appeal with some backgrounds etc. The problem is that most of the forms have several frames in them and have multiple objects bound to each. …

0
49
Member Avatar for tbabe

<%@ LANGUAGE="VBSCRIPT" %> <% Dim objCon Dim objRS Dim str_DSN Dim strSQL Dim objCmd Dim myArray str_DSN = "filedsn=live.dsn" myArray = "" Set objCon = Server.CreateObject("ADODB.Connection") With objCon .ConnectionString = str_DSN .CursorLocation = 3 'adUseClient Cursor .Open End With myString = trim(Request.Form("SalesPart")) myArray=Split(myString,",") For i = LBound(myArray) TO UBound(myArray) 'Response.Write …

Member Avatar for tbabe
0
124
Member Avatar for acecombat

I'm trying to have VB open a basic 1 line settings text file but I want it (for first time users) to create the file if it doesn't exist, but I can't open the file without getting an error. How do I go about creating this file if it doesn't …

Member Avatar for selvaganapathy
0
1K
Member Avatar for chriscasaje
0
69
Member Avatar for Derice

Hi, there. I am looking links and sources for studying and understand way to navigate around windows directories. This can be easily seen especially during software installation where user is able to change the installation path. Is it related to the CommonDialogAttach.* ? Please give me a helping hand for …

Member Avatar for Derice
0
84
Member Avatar for ITKnight

does anyone know how to run any app that it write some vbscript or javascript or html from in vb???

Member Avatar for ITKnight
0
109
Member Avatar for RajeshVB6

Hi, I'm having problems with VB 6.0 data Environment. Is there a way to link two connections? Example, I have two vfp database files in different location; I created two connections with commands (query strings). In SQL, I'm trying to link these two by using union join. Is there a …

Member Avatar for QVeen72
0
121
Member Avatar for HelenLF

I am new to Visual Basic so this question may be a bit simple but it has me stumped. I have written some visual basic code where I reference 3 text files in the same directory. When I reference the files as /filename.txt the program works but when I reference …

Member Avatar for selvaganapathy
0
324
Member Avatar for Bomma9

Hi All, I have to develop an application that needs to send a sms to any cell/mobile using a CDMA connection. This application is for an voluntary organisation, which involves in free medical service. I appreciate if any one can help me in this regard. Thanks every one for your …

Member Avatar for Jishnu
0
236
Member Avatar for Jishnu

Hello, I'm using MAPI component to send email messages via VB6. Here's my code: [CODE] Option Explicit Private Sub cmdEnd_Click() Unload Me End Sub Private Sub cmdSend_Click() MAPISession1.SignOn MAPISession1.DownLoadMail = False DoEvents MAPIMessage1.SessionID = MAPISession1.SessionID MAPIMessage1.Compose MAPIMessage1.RecipAddress = txtSendTo.Text MAPIMessage1.ResolveName MAPIMessage1.MsgSubject = txtSubject.Text MAPIMessage1.MsgNoteText = txtMessage.Text MAPIMessage1.Send False MAPISession1.SignOff End …

0
410
Member Avatar for ahmbil

Can somebody help me to update my Database automatically using Data control(data1). I want to add 1 to all the value of one field so to automatically get the value of that field +1.

Member Avatar for selvaganapathy
0
77
Member Avatar for jem00

Hey guys, I need to find out the length of wav files so as to set a timer. How do I find the length of a wav file? Thanks, jem00

Member Avatar for selvaganapathy
0
112
Member Avatar for jem00

Hi guys, I'm pretty new to VB and am having a little bit of trouble with scroll bars. I have a text box and I want the user to input a value in there but I also want them to increase the value through a scroll bar or decrease the …

Member Avatar for jem00
0
266
Member Avatar for Arijit Manna

Hi :) Iam preparing a report on VB6. I wish to have my report printed in the DOS mode using a DotMatrix printer. How will I do it, since Iam not working on the command prompt. Is there any way to solve this issue? Are there any general rules irrespective …

Member Avatar for Arijit Manna
0
327
Member Avatar for Metabalistic

Hi, I'm new at DaniWeb. I hope I'm using the right protocol for this forum, but I was wondering: Does anyone know how to tell in VBA which button of a Microsoft Word custom toolbar has been activated? Is there something like an ActionSource property that provides the toolbar control's …

0
58
Member Avatar for Burret

I'm a beginner and trying to do some code for Excel I want to use String Tank_Level inside the method Sheet2.Tank1.Picture = LoadPicture(Load_Picture) for example like this Sheet2.(Tank_Level).Picture = LoadPicture(Load_Picture) is this possible ? Sub Run_Update_Tank() Dim Grader As Integer Dim Grader_String As String Dim Grader_up As Integer Dim Tank …

0
47
Member Avatar for eviocg

i am attempting to make a youtube video downloader based on the subject of the video. I have got as far as returning the video title and it wont work. It will return the html code of youtubes search API, but then it will not select the correct part of …

0
57

The End.