11,868 Topics
 | |
| | I am started a new with VB6 Access project. I am connected database with ADODB, DSN Method that Code Given below. '======================In module ============== '=================== Connection With Database =============== '====================================================== Public CNN As New ADODB.Connection Public RS As New ADODB.Recordset Public cString As String Public Sub Main() Set CNN = … |
| | I have a problem for some reason with Vbhide on one XP computer. I have some code running on 30 XP machines and it runs fine, but one XP machine doesn’t want to hide the window when executed. The below code is an example of the line of code that … |
| | i think it is not possible to print vertical lines along with text data in vb6..so i thot of transferring the whole contents from vb form to a word document. but now i dont know how to do that. i want to transfer the data in a specific tabular format. … |
| | Hi, I have a subroutine(callMe) in Module1. I want to call "callMe" in other subroutine in Form1. I cant do it. I cant call subroutine in other subroutine. How do i do it. Thanks  |
| | hi i would like to know the functions of webbrowser1.busy,STATE_COMPLETE and all other properties of web browser. pls also let me know how to make the process sleep until web browser gets loaded. thank u |
| | Hi everyone. I'm new here, and I'm also starting to make reports using Crystal Report. Can you give me some tips (or any tutorial sites) for me to familiarize CR? Anyway, I installed Crystal Report 9.2 Many Thanks :) |
| | Hi, Code below retrieves some of the enum values, not all. Why? Thanks [code] Dim RST As New ADODB.RecordSet Combo1.Clear RST.Open "Select Distinct Title From MyTable",Conn If Not RST.EOF Then RST.MoveFirst Do While Not RST.EOF Combo1.AddItem RST(0) & "" RST.MoveNext Loop End If [/code] |
| | Hello, How to copy an item selected in a Listbox present in Form1 into a Combobox present in another form-Form2. Here the combobox contains a list of customers while the listbox contains only the selected few. For eg in the cbox i type "r" the i get a list of …  |
| | Hello, I have a login form in Access which has a combobox and ac ommand button. The combobox has a list of customernames. On selected the customer in the CBox or specifying a part of the customername, when i click the commbuton i should get another form having a list …  |
| | hi guys can someone pls help me... Im copying data from different files (all excel), how can I count the last row then the second data that im copied will placed under it. It's somehow like insert a record.. Thanks... :) |
| | hi everyone; can somebody help me with my project. I have different files in one folder (Budget Folder) then I will import that in a single excel file (destibook.xls). This is the code. [ICODE] Dim DestBook As Workbook, SrcBook As Workbook Application.ScreenUpdating = False Set SrcBook = Workbooks.Open("C:\Documents and Settings\cbanato\My … |
| | Hello.. I want to make a macro to create a chart from a table in different sheet. What i try to do is copy the information into a new sheet. Next i use the information copied to make a column clustered chart. The problem is the chart does not appead … |
| | So far i have managed to butcher some code i found around 12mth ago to allow me to read the relevant node but i'm struggling to find out how to edit this node value and save the xml file. I cant find where i got this from or anything similar. … |
| | I ask for simple help. I'm at a part of my application where I need it to open a text file, and search for id numbers within the text. There will be several instances of "id=######"s that I will need to grab from the text file, and put them line … |
| | hi how to make the process sleep until my webbrowser gets loaded. this is my code [B]webbrowser1.navigate("www.google.co.in") text=webbrowser1.document.body.innertext[/B] pls send me the code |
| | I have a form has to (maskedbox1) and (maskedbox2) if maskedbox1 I put date of today, I want ([COLOR="Red"]maskedbox2[/COLOR]) show date after 30 days as defult I will be thank you if you help me to do this I use vb6 |
| | Hey guys I am a VB noob and need some help, basically this is what I want to do please look at the following picture [URL="http://www.bus.ucf.edu/llinden/courses/ISM3253/assignments/marketing_study.PNG"]CLICK FOR PICTURE [/URL] The app should basically pull up the data contained within this CSV file : [URL="http://www.bus.ucf.edu/llinden/courses/ISM3253/assignments/survey_data.csv"]CLICK FOR CVS FILE[/URL] and display it … |
| | i am working on a vb project in which need has arised to print an invoice. however the problem is that the contents of the invoice is accompanied by horizontal and vertical lines. Also the so-formed rows and columns are not regular. My question is how can i print such … |
| | When I Enter The First Data enters as null in the database. while record count shows me there is one record in the database. i have uploaded the whole project. can anybody figure out the error in the code. if yes please assist me!!! please note about the project : … |
| | [ICODE]Private Sub Form_Load() Dim tmp() As String Dim i As Integer Open App.Path & "\links.txt" For Input As #1 tmp() = Split(Input(LOF(1), 1), vbCrLf) Close #1 For i = 0 To UBound(tmp) DL.Download tmp(i), App.Path & "\" & ExtractFileName(tmp(i)), "k" & i Label2.Caption = "Connecting..." Next i End Sub Private … |
| | i am working in developing a package for reading data from a com port and then display its interpretation. i am getting data in a text box. i have a database to compare eachline and give results. Now my problem is data is coming in the text box, i have … |
| | Hi all, I am generating a report in flexgrid. I need to copy this data in excel and attach the excel sheet in the outlook so that the mail can be send. Outlook will be opened on a button click. I am able to open the outlook but unable to … |
| | In the code below I use the Form_Load to connect to a Access database and load a form and combo box. I then use the cboComp_Click to look for a record in the tblToDo table, If found I load it into the form using the FillFields If not found I …  |
| | Private Sub btnedit_Click() Dim a As Variant Set conn = New ADODB.Connection strConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SPUM;Data Source=(LOCAL)" conn.ConnectionString = strConn conn.CursorLocation = adUseClient conn.Open 'lblindexid.Caption = rs!Indexid strsql = " Select * from ES_otherSchools where Indexid = '" & lblindexid.Caption & "' " Set rs = conn.Execute(strsql) … |
| | hi everyone, I am not a software kid that much but after getting fail from all books, im here for help. I am trying to read data from a device like monitor with a screen like calculator. It is connected with its main unit with 15 pin serial port like … |
| | Hi, How do i select a particular value of a combobox? Example [code] combo1.selectvalue(rset.field("id"))[/code] I believe you understand what i mean. I bring data from database and want select it in combo. Thanks |
| | Can anybody help me. I want to store data from a textbox to a word document and viceversa. mt second query i have developed a package using Vb and access which involves mscomm com control. i am not able to make an exe file or make a package using package … |
| | hello Frends, i m creating a new project of vb to access conncetivity in 5 PC small LAN. I don't Know What is the code,connection string use in project. And I am biginar for that type of programming. I want to store data in server, access database tables. Please give … |
| | hi i used the following code to read data from web. this is my code Private Sub Command1_Click() Dim Text As Variant WebBrowser1.Navigate ("www.google.co.in") [U]Text = WebBrowser1.Document.Body.Innertext[/U] MsgBox Text For i = 1 To 1000 If Mid$(Text, i, 8) = "google" Then MsgBox ("String Found") End If Next i End …  |
| | I am working on a project that uses VB to control the application, DWGeditor. Basically, I am starting with a template .dwg file and then inserting others as blocks; essentially layering the files to create a final product. VB has allowed me to create an interface so that I can … |
The End.