[visual-basic] Forum Topics

i need to use access to store my data in 2d array form.please explain me the procedure for that.or tell me, is there any way to create link to another table from a field item.

Hello everyone, I am using excel vba programming, in my application I always want to keep my first workbook.firstsheet active. I will be opening and closing some otherfiles in between the application. While running the application i don't want to show all flikkering in my application, what all the files …

Hi, I've just finished working on my little project and I've already compiled it. But when I run it and input necessary data, I get "out of memory" error. The program suppose to deal with a lot of information. How can I fix that problem?

Hi, i have a form in VB. iam using SQL Server as Back-end. And connection string and all works properly. the only one thing is i want to retrieve data from database into a combobox. i'am using this code.... [ dim i ] [ for i = 0 to Combo1.ListCount …

I have some bottons that are called cmdBananaSpider and cmdSydneyFunnelWeb that I am trying to link to [url]http://en.wikipedia.org/wiki/Banana_spider[/url] and [url]http://en.wikipedia.org/wiki/Australasian_funnel-web_spider[/url] I can't seem to get the right code in to link to the page, can anyone help me with the code? I would like it to open up in its …

S.O.S, help needed badly…the following macro: For Each Worksheet In ActiveWorkbook.Worksheets i = i + 1 If i < ActiveWorkbook.Worksheets.Count Then Worksheets(i).Range("M6").Copy Worksheets(ActiveWorkbook.Worksheets.Count).Cells(i, 1).PasteSpecial Paste=xlValues End If Next End Sub will pastes values the last worksheet in the workbook vertically. I am in severe need of a macro which will …

Dear Sir, Please tell me the way(code) of accessing another PC within LAN.

I have a tree structure containing nodes and child attributes. Each node has got a unique key as an attribute.I have got the the value of the key and I need to access its parent node using this key. Please suggest the way to solve this problem. Regards, Dinil

[ATTACH]6798[/ATTACH] i hv an interface sumthing like this. i/m using VB6 and i wanna find record in MS Access using find command button. firstly user will key in an employee number as a key to find that user record in MS Access. after that, the data will appear in the …

how can i access data that i have entered to the database in msflexgrid. like for example i have putting three categories the noofitem,scores, and totals. that was displayed on the top of msflexgrid horizontally..? is there anyone can help me... please...

Hi, I am using the acrobat com control on my form and setting the loadfile property to load the pdf file it is working fine here is my code to load pdf file and hiding the toolbar of acrobat control oPDF.setShowToolbar(false); oPDF.LoadFile(fileAddress); This is working fine now i want to …

Is it possible to view the vb code of an .ocx file w/o having the the activex vb file ? ... i mean i want to read the activex code written in the .ocx file ...

i using acsess 2003 or xp. but when i click in record source property to show the table a massage was shown. but when i use office 97 then there was no problem

Hi everybody, I need a little help. I have built a complex ms excel workbook that imports data from many single sheet ms excel workbooks. These workbooks are all located in one directory and are give a 7 digit name (ex. 1234567.xls). Note: the files are actually named by their …

Hi all Is it possible to trap the ESC key during the execution of an mdi form? I want the esc key to be trapped and when it is pressed I want the current form to be unloaded. Is it possible? Any help will be appreciated. Rajesh Khanna

Hello, I work with embedded systems and I need to use Visual basic to acquire some data through the serial port, store it etc. As I am just getting acquainted with VB6 I need some help. My Controller board (8 bit micro) sends out serial data 3 bytes at a …

I would like to create columns dynamically using VB in MS ACCESS. Help needed.

I have two internet connection. My Visual basic project run in one connection and other Connection can't connected my app. What is the solve in that problem? please help me.

I need help in VB.NET on how to read the entile file line by line which has about 500 lines, and then search line by line if search match found and then display it I have arrange them into an array but because the search need 2 matches on in …

How to get url images in picture box/image box using Visual Basic 6.0 dekstop application? Plz Help me.....

I am creating a form that will have numerous labels in it, enough so that it will go beyond the length of the form and screen size. How can I set a scroll bar to work with the form and also, I can't extend the form itself far enough to …

Hi All I am working on a Excel VBA proj. I ahve to insert some records in the Access Db. Right now I am forming the query as a string, creating a connection and executing the query Eg: "Insert into Table1 values ('A','B','Comments')" Now if the comments or any other …

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 …

Hi friends, Please tell me wherer i can get crystal report control Thank you

I would like to create columns dynamically using VB in MS ACCESS. Help needed.

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.

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

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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?

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 …

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 …

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 …

Dear Sir, I want a simple process for generating report using data environment

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

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 …

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 = "" ' …

[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 …

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

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..

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 …

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 …

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 …

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.

Hi Everyone, Is it possible to convert a .sh script to VBS? If so, how should I go about this pls? The issue is that i have found a script which does exactly what i need, but it is written as a .sh we are a pure windows shop and …