10,987 Topics
 | |
| | Hi, I am using the following syntax in VB 6.0 to copy distinct values from strTableName to TableName strOpen = "Select distinct * into" & " " & strDupTableName & " from " & strTableName rst.Open strOpen, db, adOpenDynamic, adLockOptimistic But I am getting a runtime error "-2147217833". I have … |
| | Hi All, I am using VB6 with mysql database recently. But I am having problem with showing the text type of mysql field value in a Msflexgrid. Msflexgrid1.TextMatrix(i, 3) = "" & rdoRS.rdoColumns("products_publisher").Value This line gives error message. Anybody could help me? Many thanks. Tomii |
| | Is there a substring code to find out only the first letter of a word? I know that sr.ReadLine.ToUpper will read all the letters capital, but can it read just the first letter?  |
 | I make a project with a access file with back up. But I want to create same file from my project. I mean when I need i make the same file from my project. help me |
 | Hi everyone, Is it possible to create a Microsoft Word macro that will open up a VB GUI that will have a number of form fields. Once you fill out the forms, then the macro will use that information to query an Oracle database and then return the formatted results … |
| | hi, I want to upload one photo at a time in picture box.... I would like to take input from user.. i have taken one button...by clicking on that button it should open the drives and files window.........after selection that link is stored in textbox.... how that link i can …  |
| |  |
| | make a simple calculator involving the following operations addition, subtraction, multiplication, division, square-root and percentage!!thanks....:) |
| | Hi!! I am EXTREMELY knew to Visual Basic. (You will be able to tell shortly!) I needed a computer programming class for school and my advisors put me into a class that uses Visual Basic! Ive been struggling!! My latest assignment is........ -Write a program to request positive numbers one … |
| | Hi I have a form where a user can enter a path name into a text box and I want to be able to check if the path name is valid. By valid I mean contains the right syntax. Is there a way to accomplish this in vb6. Thanks in … |
| | can any 1 help me...my problem is : i hav a text box named text3 and a picturebox named as picture1 if any thing is typed in text3 then picture1 should display the picture which is stored in "c:\" with the name of the value that is typed in text3. … |
| | Hey there, I have the following problem driving me nuts! I have 2 check boxes and each one is assigned a message (for check 1 say Hi, for check 2 say food). If I click on one of them, it displays its message in a text box, and pressing the … |
| | Hello i need a help for my barcode scanner project. i want to create a code save it in a DB and be able to read it and decode it with the barcode scanner.  |
| | I have made a program that you can add your contacts but i need to get a way to edit the persons details.... The details are kept in a txt file(because i don't know how to make this using a db) I have a list box showing the name and … |
| | Hi all I have created an application which automates the Preparation of Question Papers for Various Exams. This software uses a DSN connection to a ACCESS database. While I was developing software I created this connection manually but while I distribute my application this connection will have to be created … |
| | Hi, Can anyone help me with this.. I have a vb program that produce a pdf file. I have installed the exe file in citrix metaframe server so all user can access. The problem that i've encountered is the printing from the user's pc was slow because it need to … |
| | Hello, I have a program that runs another application and grabs one of the data in the textbox. However, I need to change this program so that it can determine whether the caption of one of the command buttons in that other application is in bold or not. Does anyone … |
| | VBA so that each click generates a random character between A and Z in cell A1, and the number is displayed with a random font size in the range of 16 to 24 points. can anyone help me out??  |
| | Hey there, I'm still a newbie to VB and here's my question. I have say 3 check boxes and each of them is assigned a message. If I click on one of them, it displays its message (say Hello) in a text box. Now if i press on the 2nd … |
| | If any body help me, I shall be very greatful: How shall we write Code using VB so that the value of the product of two variable should be rounded to the nearest Integer number which is divisible by 5. Is there any way to check whether the given number …  |
| | i have a completed project want to comply an run succefully on system that have vb but i want to know the setup to comply so that i can install it and run in a computer without vb or refer me to a site that fully elaborate it Thank your … |
 | Hi my friends. I write a program that show sended and recieved bytes in dialup connection. i use below api function's for get Sended and Recieved bytes: RasGetConnectionStatistics RasGetLinkStatistics RasEnumConnections RasGetConnectStatus it work correctly. now i want write this program for dsl(adsl) connection. but previous program not work in adsl … |
| | This involves an Excel file that is being controlled by another program. I have written my own excel file with vba that works with this Excel file. So basically, the program opens up an excel file, then the user opens up my excel file in the same instance of the … |
| | Is there any way to display more than ten thousand list of Record using FlexGrid- all at once. If not, what will be the solution of this problem. |
| | Hi, I have a access 2007 database which makes use of attachments. I cannot seem to find a way to sent the attachments by e-mail. My table structure is simular to: ID: Autonumber Att: Attachment Send: Yes/No Eg: ID Attachment Send 1 xyz Yes 2 xyz No 3 xyz Yes … |
| | [B]Hi all, Is it possible to programatically "Compact and Repair" an mdb file as can be done manually from MSACCESS menu "Tools"-> "Database Utilities" -> "Compact and Repair Database..." Any help will be appreciated... Rajesh Khanna [/B] |
| | hi, Through VB i would like to delete duplicate rows in MS ACCESS. Note: There are no PKEY in Database also the DB allows duplicate records. Please help Regards, DINIL |
| | Hi, I want to write VB code so that the any First letter of any Word entered in the textbox will be automatically converted to Capital. Whether there is one or more than one word in the text box, any first letter of the word should be converted to Capital … |
| | Is there any way to display more than ten thousand list of Record using FlexGrid- all at once. If not, what will be the solution of this problem. |
| | Dear Sir/Madam Please tell me how can i remove "Invalid use of null" problem . Coding given below There is no value in rc1.fields(6) [code]db1.Open "Provider='Microsoft.Jet.OLEDB.4.0';Data Source='" & App.Path & "\tmgmt.mdb';" st1 = "select * from travel where sno = " & frmtorf.tserial.Text & ";" rc1.Open st1, db1, adOpenDynamic, adLockBatchOptimistic … |
The End.