11,868 Topics
 | |
| | 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? |
| | I need to create a table that will display different variables. Is there a canned table control I could use.  |
| | 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. |
| | hi guys i need your help! i have two date picker and a vsflexgrid in my form then i select datepicker1 month of january datepicker2 month of february i want to display all the records in both month ... example: january 9 records febraury 10 records my sample code: [code] … |
| | Our instructor told us to make a scientific calculator using visual basic... though he didn't yet discuss on how... what i made was just a simple calculator that can perform the four basic functions... here is my codes... [code]Dim val1 As Double Dim a As Double, s As Double, m … |
| | i cant load my data in listview this is my code [code]Private Sub LoadCustomerListView() Dim strSQL As String Dim objCurrLI As ListItem strSQL = "Select Lastname" _ & " , Firstname" _ & " , Address" _ & " , Idnumber" _ & " , Gender" _ & " From … |
The End.