10,987 Topics
 | |
 | Hi to all, here is my question:- i've declared an user defined type like this - [B]public type user str() as string end type[/B] where str() is an string array with empty elements. now i want to create the elements dynamically. for that i wrote these - [B]dim x as … |
| | rsYear1.Open "select count(ComplaintNo) from tblcomplaint where year(cDate) ='" + Year(DTPicker1.Value) + "'", ConSQL, adOpenDynamic, adLockOptimistic hi if u find any fault here reply me immediately rsYear1.Open "select ComplaintNo from tblcomplaint where cDate ='" + DTPicker1.Value+ "'", ConSQL, adOpenDynamic, adLockOptimistic i already try this also plzzzzzzzzzz |
| | Let, i have a rectangle drawn in autocad. Now i want my application to open the file on my command & read the length & width of the rec. Dimensions are given in the autocad drawing by 'dimension' command. How is it possible? Does vb6 work with autocad drawings? Let … |
| | |
| | I am building a device connected to the serial port of my PC. I need to chect the signal level of the RTS and DCD lines. How can I do that using MSCOMM? thanks tonino |
| | Hi, I have written some macro in VBA. It has 2 buttons one is SUBMIT and another is CANCEL. When i click on SUBMIT then it calls access and populate the data in another excel file and takes around 20-30 minutes to populate/complete the process. What I want is on …  |
| | Hi, can any one tell me how to create standalone variables during runtime. This is what we generally do in design mode when we need to create strings of fixed length like - [B]dim x as string * 5[/B] now i want to do such things dynamically. suppose i need … |
| | I am using the code:- [B]strCon = "Driver={Microsoft ODBC for Oracle}; " & "SERVER= abc; uid=abc;pwd=abc;" Dim oCon As Object Set oCon = New ADODB.Connection Dim oRs As Object Set oRs = New ADODB.Recordset oCon.Open strCon[/B] while connecting this with installed oracle client it works but without oracle client it … |
| | Good people, I need your assistance. I have a spreadsheet. My objective is to draw a line after writing each record. The purpose of this is for clarity - to denote the end of each record. Please see attachment for example of my spreadsheet and where I want the line … |
| | How can i detect the arrow key on the FlexGrid object, I had try using the KeyDown event, but this event doesn't respond with the arrow key pressed. |
| | <inlinecode> Good morning, I am using VB6 to create a form to collect data. I have a button(cmdSubmit) that will insert and update my MS Access database. </inlinecode> <code> Private Sub cmdSubmit_Click() Dim conn As New ADODB.Connection Set conn = New ADODB.Connection conn.Open "Mon_Mac" Dim rs0 As New ADODB.Recordset Set … |
| | Ok, yes this is an assignment. Yes It's due tomorrow, and yes I have spent countless hours trying to do this, my head is fried I start work in less than 6 hours and it's due in approximately 17hours time. Main problems: - I need to generate a Primary Key … |
| | OK, now this problem relates to the same one ive been having with the invoices, "Transfering records", that I posted. If i have a text filed, lets say activity, which contains the user activity on a form, (Eg user clicks "Send Report" button and "activity" changes to "Report Sent" - …  |
| | Hi, I am new to VB. I want to view my records from MS Access into my ListView control. Can you help me with this? Thanks in advance. I already connected my VB app to MS Access database using ADO OLEDB. I want this to be done using purely coding. … |
| | I am using frontend as visual basic 6.0 and back end as oracle 9i. Query is written for crystal report 8.5. In query select fields i used function to retrview data and grouping that fields. In Oracle Viewer Showing data is not same as Crystal report Viewer showing data. It … |
| | Hi,I am developing an inventory system and want it to be used in a networked environment.I have given it some thought but i am stuck.I have not done this before so i will greatly appreciate all the help.So is this possible- for the system to be used on multiple machines … |
| | okay so to install an add-in you simply go to Add-Ins...Add-In Manager...and select which add-in you want... I need to install the Resource Editor, but when I go to the Add-In Manager there is no VB 6 Resource Editor for me to select. How can I get that so I … |
| | Hi, Im busy using access to build a database, and Visual Basic to build the program code and automization in the database. Im looking for a feature simular to a notification box, where the if trigerred a msgbox or simular will appear. This is pretty simple and works perfectly. What … |
| | I'm trying to get a File watcher to update a que class and then process the files squentially without any luck. Private Sub FileSystemWatcher1_Changed(ByVal sender As System.Object, ByVal e As System.IO.FileSystemEventArgs) Handles QUEwatcher1.Created Dim i As String Dim myQ As System.Collections.Queue Dim Filename as string Filename = e.Name ' e.name …  |
| | Hello all, I have a question and hope someone can help me. I have 3 Java .exe/packages in which I want to make into one .exe so all can be installed one by one from the same .exe. Can I do that using VB? Thanks! Kudos! |
| | hey people.. i have to work out a software for a tours and travels company in vb6. can anyone please help me with the basic skeleton of the software. thank you. |
| | any problem here with the code coz am getting the error as unable to load the report error no:20525 and it shows the property read only can u clear it plzzzz CrystalReport1.ReportFileName = App.Path + "\REPORTS\Nature_Of_Complaint.rpt" CrystalReport1.ParameterFields(0) = "natureofcomplaint;" & cmbReport.Text & ";true" CrystalReport1.ParameterFields(1) = "fromdate;" & dtpFrom.Value & ";true" … |
| | I am trying to get the output of a string "A B C D E" etc to output to a label or a text box to have different colors for each character, for a kids learning program. I have just learned about the richtextbox, but I do not know how … |
| | I am using a data control with a simple SQL statement. I am accessing the [B]Data1.Recordset.RecordCount[/B] property right after I call [B]Data1.Refresh[/B] and I noticed it was giving me incorrect results (It would say there were 20 records, when there were actually 85). The weird part is, I put a …  |
| | [B]Hi to all, I am new to this field, working on VB6.0 and oracle 8i, I need help in combo box object, when the form loads I want combo box to show as “select” in “Text” property, rest I have loaded in “List” property. Thanks in advance please provide example … |
| | could some one plz help me with developing a VB application. i haven't developed any application yet, but now i have been given a task to develop a car rental system with VB as front end and MS access as back end. could some one plz tell me the best … |
| | Hello everybody, My objective is to split a record, write 90% of the record on one row and write the remaining 10% on the next row(right underneath the other half). The spreadsheet was formated exactly the way I want it. Now I am using similar code and technique to format … |
| | I have a 'do..while' section of code where it loops through lines in a text file, counts them, and when the line = "" the loop is supposed to stop and report the number of lines it counted. This all works fine in debugging mode... but when I compile it … |
| | Hello, I'm trying to use some data, generated by an executable file (.exe) in another program (that I'm developing). How do I do that using VB? Thanks |
| | Hi All! So the "project": In an Excel sheet I want to create a macro that jumps to a reference based on the value of a given cell. sg like this: Goto.Reference = "R" & [reference to the cell] & "C1" only the number of row changes, column number is … |
The End.