10,989 Topics

Member Avatar for
Member Avatar for Robert06

hello all i m using VB 6 for automating excel. My data contains some blank rows, which i need to get rid of. can anyone tell me how to do it. help wud be appreciated. thanks.

Member Avatar for Robert06
0
101
Member Avatar for mallyajiggs

i want a common ADO control form which can be used to deal with multiple database (all with same tables and variables in MSACESS ) i there any way to achieve this using VB6 .. .. that is specifying the connection string dynamically or specify database at run time thank …

Member Avatar for Comatose
0
54
Member Avatar for Bomber686

Hi, I wish to run a vb app which queries the registry and returns a result. I then want to use that result to set a variable value which I can use in DOS. A batch file runs the vb app, when the vb app has finished a variable has …

Member Avatar for Bomber686
0
155
Member Avatar for Shefali

hii everyone i have a labview program that records and saves data in .lvm format. i need to open that file in excel using visualbasic 6. the problem is the file isnt in a correct format. so if i have to manually open the file, i have to delimit and …

0
58
Member Avatar for skalra63

there are two things i need to do to my program. 1) centre the form on the screen, then make it full screen. so thatthe form is always in the centre disgregarding the size. 2) centre list/combo items. currently they are justified left, i need it so they are in …

Member Avatar for skalra63
0
136
Member Avatar for softwarecaz

Hello I need to write my own mid function, have do I do that, just someone know, I know the mid function definition is mid(String, Start As Long, [Length]), if I wanted to create my own function, how do I do that, does someone have an example

Member Avatar for Comatose
0
129
Member Avatar for furjaw

Here is an example of the type of thing that I need to do using Visual Basic Express: Let's say that you are ordering a vehicle. First you pick the vehicle type: Sedan Sport Utility Mini Van Pickup Truck Then, depending on which you selected, you get a list of …

Member Avatar for Kegtapper
0
115
Member Avatar for robbie_j0

Hi there, I have a system built in VB_6 professional which reads from an access database. I need to search for a specific record using a word or short description entered by the user. This will link to the DESCRIPTION field in the database itself. Not being case sensitive would …

Member Avatar for Comatose
0
293
Member Avatar for Sul

Hi. I am working on a particular sql statemtent that looks like this, but I simplified it greatly. [CODE]x="INSERT INTO TableA (T1.Key,T1.Field1,T2.Field1,T2.Field2,T3.Field1,T3.Field2) FROM (T2 RIGHT JOIN T1 on T2.Key = T1.Key) LEFT JOIN T3 ON T1.Key = T3.Key"[/CODE] That is how Access created the statement. All 3 tables have the …

Member Avatar for Comatose
0
707
Member Avatar for Pim

Hello, I would just like to try VB. I've tried Python; too easy and C++: too difficult/abstract for a beginner. What I'd like to ask is: Do I need to buy VB? And if I don't, where can I find a good tutorial? Thank You.

Member Avatar for Pim
0
97
Member Avatar for Terminal-Access

Hi all just signed up to the forum basically for the past coupple of month's i have been working on an ActiveX chatroom Controll for use with IE browsers and the Mozilla / Netscape browsers, this once compleeted will be opencource for others to use at the moment its being …

Member Avatar for calcop
0
136
Member Avatar for ghaney1

I would like to dump a fairly long text file into a multiline textbox and have the end of the file showing without having to scroll down. Is there a chr string equivalent to the "END" key?

Member Avatar for ghaney1
0
72
Member Avatar for Nubbing

Hello all. Pretty much finished my project for school, everything works, you can add and delete files, can't crash the program e.t.c. but I can't find out how to list these in order of date. [img]http://img300.imageshack.us/img300/4570/visualbasichelp5ck.png[/img] Currently I have the sorted property of the list box equalling true. As you …

Member Avatar for Comatose
0
2K
Member Avatar for helloworld

can someplease please help me understand what the asc function and the mid function can do. does the asc function find the string and the mid function replace the string with a number. i have had a look in several books but none make sence please

Member Avatar for williamrojas78
0
85
Member Avatar for skalra63

currently, i have a form where a user can manipulate data. however, because i only want them to change "Supplier" of a product to a known one, i have created a second form. which they click (next to the supplier entry field.) this displays a list box ( with supplier …

Member Avatar for skalra63
0
119
Member Avatar for laifa

Hi, As far as encryption goes, I am a newbie. Right now when I login, it will compare the user and password stored in my database. If both match, I will be able to login, otherwise I will be refused. The user and password are now stored in plaintext. How …

Member Avatar for laifa
0
1K
Member Avatar for helloworld

Hello can anyone please help me with some code, as you may be aware ASC means: Function Asc(String As String) As Integer Public Function Zeichen_OUT(Zeichen As String, wheelNr As Integer) As String 'go left, direction reflector (Umkehrwalze) Dim Z As Integer Dim offsetZ As Integer offsetZ = RotorOffset(wheelNr) - RingOffset(wheelNr) …

Member Avatar for helloworld
0
234
Member Avatar for mahda

hi... would you help me... i can't understand about connection database from access. i will using this db in my project.. help me pls... thx...

Member Avatar for Comatose
0
36
Member Avatar for Comatose

There seems to be a serious number of posts regarding the use of VB with an Access Database... Due To The High Volume of questions about access, I'm posting this link. Please, Go through the tutorial, and if you have questions regarding access with VB still (after reading through the …

5
1K
Member Avatar for HellRazor

Hello, im having problems with using a RAF in my project. i have 5 fields on my form three of wich hold integers and the other two hold strings, i want the data to then be sent via a "send button" to the random access file. here is the code …

Member Avatar for Comatose
0
76
Member Avatar for chan karan

Would any one help me to solve the problem??? for example: 12345/abc123 I want to divide the above string into two value, - 12345 - abc123 I want to know how can the program recognize the value in each digit??? And how can the program recognize the "/" to divide …

Member Avatar for Comatose
0
151
Member Avatar for benyam_dessu

I am write a payroll grogram. Is it possible to make this program run in the network? I mean, how could I make it for users at different workstations access it simaltaniously. regards, ben.

Member Avatar for Comatose
0
113
Member Avatar for infmas

Hi, sorry my last post that was too short. When I try to compile a project in VB6 in my computer and another one in my company, VB6 stop to compile in the middle, and freeze. I looked in task manager and the C2.exe is pending in the process list. …

0
84
Member Avatar for ChriRi

I'm working on a MS-SQL-Server-DB with MS-Access. There are some dozens of forms. I'd like to translate the forms by button-click into another language. I've made a procedure (sub) called by button-click which walks over the complete "Controls" and changes the captions. So far, so good. But this procedure (in …

Member Avatar for ChriRi
0
80
Member Avatar for Luket00

Hello, I am new here and would appreciate any help! I work for a company who has a Access mdb with about 20 or so forms in it. The management usually has full access to the database to enter data to specific forms on a daily basis. I have been …

0
66
Member Avatar for Indigo238

I'm a relative new comer to development and need some assistance in writing a function. Here are the requirements: Return the 5th element from the end in a singly linked list of integers, in one pass, and then provide a set of test cases against that function. Any ideas? Thanks …

Member Avatar for Indigo238
0
97
Member Avatar for vishalsomani

Hello, I have attached a database which will be in use for the question i am about to ask. The question is ... Write queries to retrieve the following sets of information. a) An annual report showing the number of orders and the value of the orders placed by each …

Member Avatar for Yomet
0
252
Member Avatar for sleepless

i want to collect data and show in OLE or Excel for every 1 minute. and every data i collect i wan save in a folder. every time i wan update the data. how i should write my program.. Thx for helping me......

Member Avatar for Yomet
0
180
Member Avatar for complete
Member Avatar for Comatose
0
35
Member Avatar for skalra63

i wondered if anyone could help me with this. i have a button on a form (frmUpdateProduct). this button opens up another form (frmSelectSupplier). i have a listbox which gets all the supplier names from the access database, and assigns then with the Supplier ID (also from the database). here …

Member Avatar for aparnesh
0
155

The End.