10,992 Topics
 | |
| | this code is used to insert one record....how do i insert multiple records?? [code] Set connect = CreateObject ("ADODB.Connection") connect.open "DSN=OPTUMETL;Driver= Oracle in OraHome92;Server=urnts1.uhc.com;UID=OPTUMETL;PWD=OPTUMETL" Reporter.ReportEvent 0, "Database connection", "Successfully connected to URNTS1" Set objRecordset = CreateObject("ADODB.Recordset") ' Stmt to execute the code query="INSERT INTO STG_CARE.ASSESSMENTANSWER(ANSWERID, ANSWERGROUPID, ANSWERTEXT, DISPLAYSEQUENCE, ISEXCLUSIVENO, ISEXCLUSIVEYES, … |
| | Hello there, I have some codes with me to plot my graph that looks like [URL="http://www.vanth.org/vibes/images/normalECG2.PNG"]this[/URL], but I can't really understand what is going on in the codes below that is used to calculate the Y-coordinate in order to plot out the graph: [CODE]Function findY(ByVal index As Integer) As Long …  |
| | I have a thesis project in Visual Basic 6 using Bar Code Reader. This project is a convenient store that reads the bar code from the items or products in store. The cashier will point the bar code reader to the bar code of the items, then the barcode number … |
| | I need to delete the row in access database through vb6.0... I am using the search button to search the records,and then i need to delete those from the database,using the delete button. In the same way i need to upadate/edit the info in vb form and update it to … |
| | it is possible? may i know the code please? |
| | Dear reader (s), In my AccessDB, JanuaryDay(Table) having two columns JanDate & JanShift. JanDate contains all the dates of each month and JanShift contains text value for each date. Its like: Id JanDate JanShift 1 1/1/09 SM 2 1/2/09 M ……………………… ……………………… 31 1/31/09 M I Can retrieve the recordset … |
| | Hello , thank you all for reading my post i really appreciate your DaniWeb it helped me alot before and hope you guys and girls can help me again : i have a program that genrates a powerpoint slide file -it is name is "presentaion1"- now instead of go to … |
| | access events of form in UserControl i have 1)User control with one MSFlexGrid on it 2)Form to place user control 3)Some form's own control i dont know how many controls are there under form i have to place them in grid columns (eg. combobox in grid to provide its service) … |
| | hi, i've created a Form1 which contains a long running process. But i want an feature that will help the user to stop the running process in between, when i click a Button or some other control. How is it possible? |
| | I have created a Microsoft Tabbed Dialog Control (SSTAB) with 5 tabs using VB6 When I run my program and click on Tabs 0, 1, 3 & 4 the entire tab control is shown and correct, however, if I click on tab 2, the width of the control is automatically … |
| | Hello all... working on a queuing project for about 10 users, which is pretty simple in theory. I have the tables and forms done (or close) but am not sure exactly how I'm going to get the data from an FTP server into my table. The table was set up … |
| | Can anyone tell me why this codes are not working. here is the code What i have written.Simple i want to modify listview data using modify button.Kindly find the attachment also. [code] Private Sub Command2_Click() Dim con As ADODB.Connection Set con = New ADODB.Connection con.Open ("Provider=Mirosoft.Jet.OLEDB.4.0;Persist Security Info=False; Datasource=\\asfserver\itp$\product_tabletest.mdb") Set … |
| | In my AccessDB the column monthDate having data type: “date”. In VB6.0 label.caption is the value which I need to save in monthDate. Like: Label1.caption= 2/24/09. Problem is how will I convert the label.caption as date value so that i can save it in monthDate column. I don’t want to … |
| | Hi, I am generating the reports using vb 6 as front end and ms-access as DB and i am using data report to generate the reports everything is working fine but when i click export and save in word doc, everything will go and save in that doc, but unfortunately … |
| | good day to everyone! I just want to know regarding on how to connect to quickbooks using vb6.Ive worked on a company that uses quickbooks but i want to integrate vb to quickbooks. Please help Does anybody know.> God bless on this mother earth. |
| | Hello, I want to write a program using VBA that can make a new data sheet from an old one with specific columns in the new data sheet. After making this new data sheet i want to convert it to .csv. Any ideas how i can go about this. Thanks. |
 | I'm working on designing a game, the problem now is that while I have a code for randomizing a number, its the same series every time. This isn't good for random, to know what you're going to roll before you hit the button sucks. Is there anything to help with … |
| | Hi, I am generating the reports using vb 6 as front end and ms-access as DB and i am using data report to generate the reports everything is working fine but when i click export and save in word doc, everything will go and save in that doc, but unfortunately … |
| | im using textmatrix in my mshflexgrid my problem everytime e delete all the record the table did not update. . please help. . |
| | Hi! Please help me .. urgent How do i using a Query in crystal report?... I tried using the select expert but I dont know how to go abt it... from srao |
| | hi all, new here and doing my best with a bit of FTP code but have got stuck so would appreciate some help, thanks in advance... I have the following bit of code [ICODE] '------------------------------------------ 'Command format : [PUTFILES] = <local directory> ; <remote directory> 'Example : [PUTFILES] = C:\TEMP\ …  |
| | Can anybody tell me why i am getting error in the bold line. Application uses a value of the wrong type for the current Operation .? [Code] Private Sub Command2_Click() If (CheckInput) Then End If Y = MsgBox("do you add this record", vbYesNo + vbQuestion, "message") If Y = vbYes … |
| | Hi, I am developing an Inventory Management System using VB 6.0, and MS Access Database. I am getting an error: "data type mismatch in criteria expression" which sounds like a variable type mismatch. But i have checked and double checked my datatypes and they seem to match up. Here is … |
| | help how can i know if the user is not an admin i have combo box in my combo box have a user or admin additem if he choose admin then all i want is to validate if the username and password is for admin user this is my code … |
| | hi can anyone help me i have a billing system, how can i save the data to another table? using sql? may 1 table name is transac and all i want is if what the record have been save to my transac then it will save to another table name … |
| | Hi, I have problem to change table design in access. I have imported data and table is like: Product; Name1; Name2; Name3...etc And i should change it be like: Product; Name; qty ..and all data.. Any good ideas how i will change this ir right shape..? |
| | Ok, Ive got a program that Im working on, where it is supposed to calculate some formulas that I have based on some user inputted data and display the data in the form of a table on the same screen, and then optionally show a graph of the data plotted … |
| | Hello friends,i want a know who to rename the start in windows through the Application developed by VB 6.0.If u know means pls help...... |
| | how can i update my table please help. . [code] MSHFlexGrid1.Clear MSHFlexGrid1.Rows = 2 MSHFlexGrid1.FormatString = "|Product Description | Unit | Price Per Unit | Quantity" Set rs = New ADODB.Recordset rs.Open "select * from temp", cn, 3, 3 Counter = 1 Do While Not rs.EOF MSHFlexGrid1.TextMatrix(Counter, 1) = rs!pcode … |
| | Can any one please help me?? Using VB 6.0 and Access DB. [code] ssql2 = "INSERT INTO JanuaryDay (JanRm_id) SELECT rmd_id FROM RmIdIndex WHERE rm_id= " & CLng(txtrostermid.Text) rsName.Open ssql2, conName, adOpenDynamic, adLockOptimistic rsmnth.Open "select * from JanuaryDay", conName, adOpenDynamic, adLockOptimistic rsmnth.MoveFirst Do While Not rsmnth.EOF ‘here is the problem. …  |
| | hi everyone, i just want to ask if it is possible for the SQL INSERT INTO to LOOP? for example, insert new records in TABLE ten times with the same values (colum1,column2,column3,etc..) is there an alternative way instead of typing (INSERT INTO.. 10x) statement repeatedly. thanks. |
| | I would please like to know the purpose of each of the following visual basic project file types. 1) FRM 2) BAS 3) FRX 4) OCX 5) CLS 6) VBP It will also be helpful if you may list the site where i may get this information. |
| | wsup guys.I hav managed to split a string into indivudual words usin the split function. i have displayed the indivudual words in three textboxes.However since am developin a swahili english language translator, how do i perform a search in my database, to look out for this indivudual wordss and there … |
| | Hi I'm new to this site and I hope I'm posting this in the correct forum. I'm after a macro that when clicked will open the "save as" diadlog box with the filename consisting of entries made into 2 "text Form Fields" which appear in the document itself. One would …  |
| | I was able to install Visual Basic 6.0 in Vista Ultimate without problems... However, when I try to activate the ADO Data Control Component, it displays an error message (something concerning with the registry entries or some sort)... Then I tried reinstalling VB 6. The same thing happens again.. Can … |
| | hi guys?i need some help.i am developing a swahili, english language translator.i have an access database,which has 2 columns.namely(English word, Swahili word).which function in vb6 or vb.net can i use to break down an entire sentence into tokens, then translate the individual words directly from the database? thanks |
| | hi i have a problem puting a column header to my listview did not affair to my listview here's my code [code] Private mobjConn As ADODB.Connection Private mobjCmd As ADODB.Command Private mobjRst As ADODB.Recordset Private Sub Form_Load() Call SetupCustLVCols Set mobjConn = New ADODB.Connection If mobjConn.State = 1 Then con.Close …  |
| | I am wrking on a VB6 project,and I m new to this,I need to save the inputs values from the text boxes from the VB form,and using the command button,i need to save the data into the access database which i had created named Dtldb.mdb How do I use Data … |
| | hi guyzz... i have more than 1000 datas in my tables i loaded it in the listview using function.. but i have problem in loading it.. it consume almost 9 second to load all in the listview... i think it is in my coding.. i would like to minimize it. …  |
| | I am developin a project in VB6,i need to save the data inputs in form to the Access Database,using the save button......... Plz help me Thnks in advance:) |
| | hello my problem is simple but i cant solve it. i have textbox in form1 and i want the value in the textbox equeal to the value in label in form2..how can i do it.. my code sample is: form1.Text1.Text=form2.Label1.Caption its not working... anyone can help? |
| | Hi! This problem is probably simple to solve but I can't find the answer. I neet to read the sheets that are on an excel file and put the names of them in an array. Can somebody please tell me how to do it? Thanks! |
| | Hi all I need help. I have written 3 different exe files. What I would like to know is how do I link them to run from one package . Thank you very much. Nicky |
| | i am a newbie to the vb timer control..can any one give me few samples of vb timer usage and yeah one more thing how to make a progress bar using timer..:| |
| | Hi, I am a very old chemical engineer who just put away my slide rule. In a program I am writing, I have: Dim VV(30) As Double, SHR(30) As Double, SGR(30) As Double . . I = 1 Call PHYSPROP(VV(), SHR(), SGR(), TF(), 1, 0, 0, 0, 0, I) The … |
 | Hey all, I have this problem that I can't work out why it is doing it. I've got a client - server program. The client sends an request to the Server, which in returns it queries an access database and save the output as a file. Which it will then … |
| | Hello reader(s), In table1 i have 3 columns named: emp_id, month, year. First i'm inserting emp_id from a recordset with validation from a text box. Problem is: In the same row i need to insert data of month and year column from individual text box. Code should like: insert into … |
| | Hello reader(s), Here is my code: [code] Private Sub Combo1_Click() Dim r conName.Provider = "Microsoft.Jet.OLEDB.4.0" conName.ConnectionString = App.Path & "\rosterdb.mdb" conName.CursorLocation = adUseClient conName.Open rsid.Open "select * from DayWiseRoster", conName, adOpenDynamic, adLockOptimistic ' in below loop i got the problem. it prompts "loop without do" Do While Not rsid.EOF If … |
| | Hello All. Can someone please help me? I have been at this code for two weeks. I am a newbie at creating the following code in VB6. I want to open a database (SQL), read from the data tables, and write the data into an existing excel spreadsheet cell by … |
| | Hi, can everyone help me to install VB 6.0 because I have encountered a problem as I install VB 6.0 Installer only reboot the system, because of updating the Microsoft Virtual Machine for Java. any response are my pleasure. thank you. |
The End.