10,989 Topics
| |
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. | |
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 … | |
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 … | |
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 … | |
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 … | |
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 | |
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 … | |
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 … | |
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 … | |
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. | |
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 … | |
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? | |
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 … | |
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 | |
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 … | |
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 … | |
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) … | |
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... | |
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 … | |
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 … | |
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 … | |
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. | |
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. … | |
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 … | |
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 … | |
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 … | |
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 … | |
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...... | |
I want to have a nested scrollable area (with buttons and controls) inside a dialog. Is this easy to do in Visual Basic? | |
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 … |
The End.