10,991 Topics
 | |
| | My project needs to read records from a CSV file. The file contains 3 columns of data. Record is continuously being appended to the file by another application (about once every 6-8 seconds), and my application is to read the records and store the new ones. I am currently opening … |
| | Hello, I created a program which converts . xls to .csv. The problem is that the .csv file does not have similar formatting such as the column width is reduced causing dates to show up as ######. Does anyone know how I can solve this formatting issue. Thanks, Rahul |
| | Hi there. I am writing a program for work and for one of the parts I need to open up an outlook email account and parse through the new message bodies for specific information. After I get the information I need, I need to put it in a datbase. I … |
| | hi all:'( i am a newbie want to know how to get values from two tables in database. I have three tables one is the student information and the other table is the subject and grades .Both tables have id number which may join them together But what i need … |
| | Does anybody know of a way to rename the contents of a zip file when they're extracted? I have a program which grabs zipped files from an outlook account, gives them a unique name, saves them to a network repository, then extracts the contents to a sub folder in that … |
| | how can i save a data in listview1? i have a problem to my code heres my code [code] Dim objNewListItem As ListItem Set rs = New ADODB.Recordset rs.Open "Select * from Supplier", cn, adOpenKeyset, adLockPessimistic rs.MoveFirst Do While Not rs.EOF Set objNewListItem = lvwCustomer.ListItems.Add(, , rs.Fields("scode")) objNewListItem.SubItems(mlng_Supp_Name) = rs.Fields("sname") … |
| | hi programmers.. what is the exact code.. i want the excel cells equal to the rows or columns in my datagrid datagrid1.columns(1).rows(1)=[Sheet1$].cells(A,1) is this correct? thanks guys! |
 | How to test a string if it is separated with space or not? |
| | can anybody tell me .How should i store Requistion Nos In MaterialRequisitionorder table and Material Requistion Detail table. Here is the code what i have wriiten.Why it is breaking on the bold line. i am getting error item cannot be found in the collection corresponding to the requested name or … |
| | [QUOTE]this code is from another form before i get to the formload below xNum = 2 adminlec.show unload me [/QUOTE] [CODE]Private Sub Form_Load() lblLECNUM.Caption = xNUM '<----this is a public dim that i wrote on a module as integer Set cnn = New ADODB.connection Set rs = New ADODB.Recordset cnn.ConnectionString … |
| | how do i use update command in vb?? I need to make changes in the database from vb form,the changes made in the text box should be made in the database as well,this is the code i am using Con.BeginTrans Con.Execute "update Details set PS_No=" & Trim(txtPSNo.Text) & " and … |
| | Hallo to all, can anyone help me with my thesis? I need to filter space between character. Ex. If I input: "Jump and Go" a message box will appear saying "Space between character is not allowed." if I input: JumpAngGo or Jumpandgo is are accepted as long as there is … |
| | Hello I am upsizing a MS Access database to SQL. I am keeping the MS Access 2003 frontend and using a SQL Server for the Backend. All the MS Access VBA code seems to be working fine except for the code below. I have the same code using different tables … |
 | I make two table in ms access. both of two table has like 'student name' column. when I enter a name it save in table1. Now I want this name will save in table2 automatically. I mean I don't enter this name in table2, but it will store this name … |
| | Here's the scenario. I have a web server running with IIS 6 and website running written in ASP. The site and code has been working perfectly up until about 2 days ago when for no reason whatsoever the ASP has decided to partly work. and by this i mean as … |
| | i am trying to develop a program that would automatically translate languages. currently, i am using systran6 and google translate. but i still have to execute the translation manually. i am using vb6 and sql 2005. please help me on this. :-) |
| | in my application, i have created a data environment. Then i have connected a data grid to that data environment. Now my problem is when i add or delete one or more records, then the database updates itself...but the datagrid doesnt....it doesnt update until i run the application again... :( … |
| | I need to read the advance properties of audio file. E.g. Artist genre album etc. I am using VC++ 6.0 for application developement. Please let me know how to do this in vc++. |
| | hello to all programmers.. i want my datagrid to be saved in my database i am using excel as my database..i want to input my data in datagrid and i want to save it automatically in excel, plz help what's the exact code? and also when i input data in … |
| | hi everyone, can you please help me how the rigth syntax in filtering group, example I want to print 1st year 1st sem grades in the datareport.... any reply is my pleasure thnkz.... |
| | Can anyone tell me.How should i update. i am trying to to a new record if the Supplier_id Doesn't exist, Then i need to do a Select Statement.if that Supplier_id is in the database already,then i want to update method.i havewritten a code .Here is the code what i have …  |
| | how can i get the first name, the middle name and the last name in my textbox? what i mean is i have 1 textbox to input his full name the format is this sample: Nash, Steve B. then i have 3 label, the first label is Your first name … |
| | hello what is the exact code in saving visual basic using ms excel as database? i want to save my data in the form of visual basic into excel as database..what is the exact code in my cmdSave command button? thanks in advance... |
| | Hi All, I want to use the data grid as input interface. Can any one help how to start. i need 3 columns date, name, location the location field is drop down field user can select from the list only. the values entered by user should update in the database. … |
 | HI, I am Using VB 6, how do I sent data over the internet to an SQL DataBase |
| | Hi, I have a VB6 program that uses several ADO Recordsets to connect to an Access database. In one part of my program I have code for adding a new meeting (uses the meetingRst recordset). When the new meeting is added I requery the meetingRst and populate a ListBox detailing … |
| | 1. I work with a database project. Now I want to show all data (from a table like 'student name' column) in a combo box. how can I do this. I connect the database by system DSN and adodc control. plese any body help me. 2. If I select a …  |
| | I am looking for simple example to handle registry key like add new key,edit available key, delete availadle kay,search for key....... i search for examples but they are complicated to understand...... even simple functions also welcome (without full code) |
| | Hey guys please help me for VB proj([U]Topic[/U]=[B]Telephone Directory[/B])... my doubt When i select some area i want the particular pincode to be displayed in pincode textbox [U]note:[/U] the table name is area_name in which i hav 2 fields one is areas and another pincode. so please help me ...!! |
| | 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, … |
The End.