Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,195,744 members, 7,959,301 topics. Date: Thursday, 26 September 2024 at 02:00 PM |
Nairaland Forum / Science/Technology / Programming / Post Ur Vb 6.0 Questions Here (40905 Views)
A Comprehensive Tutorial On Vb 6.0 / My Board Games In Vb 6.0 / Vb 6.0/vb .NET & Intranet/internet Application Development (2) (3) (4)
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) ... (16) (Reply) (Go Down)
Re: Post Ur Vb 6.0 Questions Here by hart: 3:55pm On Oct 08, 2007 |
luckyco i will like to programme in microsoft access. pls help me out with some material to enable me be acquianted with the stuff. my email. faradelucky@yahoo.com one love. |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 12:24pm On Oct 17, 2007 |
U mean u want to program in vb using microsoft access as your backend? |
Re: Post Ur Vb 6.0 Questions Here by DevDel(m): 2:51pm On Oct 23, 2007 |
with VB 6 applications that I created, How can I solve the problems of installation of varying operating systems? All those DLL files you know, |
Re: Post Ur Vb 6.0 Questions Here by ELIJAHLOVE: 11:17am On Oct 25, 2007 |
please i need a b code that would help me link my vb form to my access page. the problem is that am working on a databasesoftware. so i designed a form in vb to fill in certain information into my access table. but the two are not communcating. i used db for connection string and rs for Recordset i.e DIM DB AS CONNECTION DIM RS AS RECORDSET SOME OF THE FIELDS I USED ARE NAME AGE SEX STATUS. PLEASE USE THIS TO HINT ME. TANKS SO MUCH |
Re: Post Ur Vb 6.0 Questions Here by ELIJAHLOVE: 11:38am On Oct 25, 2007 |
I NEED A VB6 CODE THAT HELP ME LINK MY VB FORM TO MY ACCESS PAGE. I AM WORKING A SIMPLE DATABASE PROGRAM THAT WOULD TAKE INPUT FROM USER AND SAVE IT IN AN ACCESS DATABASE. MY FIELDS ARE AGE NAME SEX STATUS PLEASE KINDLY USE THESE FIELDS AS THEY APPEAR ON BOTH THE VB INTERFACE AND THE ACCESS TABLE. THANK YOU SO MUCH |
Re: Post Ur Vb 6.0 Questions Here by ELIJAHLOVE: 11:42am On Oct 25, 2007 |
I NEED A VB6 CODE THAT WILL HELP ME LINK MY VB FORM TO MY ACCESS PAGE. I AM WORKING A SIMPLE DATABASE PROGRAM THAT WOULD TAKE INPUT FROM USER AND SAVE IT IN AN ACCESS DATABASE. MY FIELDS ARE AGE NAME SEX STATUS PLEASE KINDLY USE THESE FIELDS AS THEY APPEAR ON BOTH THE VB INTERFACE AND THE ACCESS TABLE. THANK YOU SO MUCH MY EMAIL ADDRESS IS gbenga89@yahoo.com |
Re: Post Ur Vb 6.0 Questions Here by ELIJAHLOVE: 2:43pm On Oct 26, 2007 |
PLEASE KINDLY HELP OUT . I NEED YOU TO HELP ME, AM HAVING PROBLEMS LINKING MY VB FORM TO AN ACCESS PAGE USING ADODB CONNECTION AND RCORDET. MY ACCESS FIELDS: ARE AGE, SEX,LEVEL. THESE FIELDS ALSO APPEAR ON MY VB 6 FORM. WHAT I NEED IS TO DESIGN A DABASE PROJECT WHICH WILL HAVE A VB6 INTERFACE, SUCH THAT WHATEVER THING IS FILLED GOES INTO AN ACCESS TABLE CALLED "DATA" PLEASE SAVE MY SOUL. I VE BEEN BATTLING WITH THIS FOR LONG |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 10:30pm On Oct 26, 2007 |
ELIJAHLOVE Am sorry am out of net because of out internet is down. To connect ot MS Access database do the following dim db as new adodb.connection dim rs as new adodb.recordset db.connectionstring=<"your connection"> db.open set rs=db.execute("Select * from datatable") 'to insert data do the follwoing rs.addnew rs.fields("name")="Elija" rs.fileds("Age")=27 rs.fields("Address")="Abuja" rs.update 'to update do the following rs.update "name","Elija" rs.update "Age",27 rs.update "Address","Abuja" ' to delete rs.delete at the end rs.close let me know if you have any problem Plz reduce how you program in access use either MySql or SQLserver,Oracle |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 10:33pm On Oct 26, 2007 |
DevDel VB is only used on Windows Operating system. If you want to interoperable program consider Java. |
Re: Post Ur Vb 6.0 Questions Here by scientist(m): 2:05pm On Oct 27, 2007 |
I am currently developing an account system [savings account] prototype using vb 6.0, although the scope is limited to only making deposits, withdrawals i have a slight problem with the account statement form How can previous updates on any given particular account be saved, such that when I want it to generate a statement of account for any given account number, all previous transactions that were carried out by the client or customer would be shown on the form or report? THANKS FOR YOUR HELP. |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 11:59am On Oct 31, 2007 |
Issue and execute this sql statment and Select * from <ur Table name> where ClintID=<ClientID> It will provide that to u |
Re: Post Ur Vb 6.0 Questions Here by scientist(m): 5:19pm On Oct 31, 2007 |
luckyCO:Thanks so much for the help I will implement this ASAP |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 5:57pm On Oct 31, 2007 |
Ok try it and see but if it doesnt help u out dont hestitate to let me know. |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 5:34pm On Nov 13, 2007 |
No more Questions? |
Re: Post Ur Vb 6.0 Questions Here by Eskay2020: 2:05pm On Nov 19, 2007 |
Hello,i'just learning Vb 6 .please can anyone tell me how to design forms and write code for database in vb.Saving,retrieving,deleting,and modifying the content of a database and the like.My email address is eskay2u@gmail.com. |
Re: Post Ur Vb 6.0 Questions Here by Hayorbahmy(m): 2:04pm On Nov 22, 2007 |
Hey N'landers, How would I search for a record in a database from the run time in VB 6.0 The database I used was Access. I would type one of the fields of the record in a text box and it would return the full details of the record. I'll be expectin the reply |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 1:24pm On Nov 28, 2007 |
I reply you in no distant time. Please bear with me. You have to use SQL statemen of rs.find otpion in ADO object. I will sent full cope to you. Better stop programming in access use MYSQL,SQL server or oracle to start learning such that you wont start all over a again. Remain blessed. |
Re: Post Ur Vb 6.0 Questions Here by ELIJAHLOVE: 2:39pm On Nov 29, 2007 |
PLEASE KINDLY HELP ME WITH HOW TO DESIGN A VB FORM THAT WILL TAKE IN PICTURE AND KEEP IN A DATABASE FOR NOW AN ACCESS DATABASE WILL DO. PLEASE I WILL APPRECIATE IT IF YOU CAN BE DETAILED. TANKX SO MUCH I REALLY APPRECIATE THE WORK U GUYS ARE DOING. U R GOING PLACES FOR SUREE.TANKS SO MUCH PLS ONCE AGAIN BE EXPLICIT AS I AM JUST COMING UP IN VB PROGRAMMING. |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 11:31am On Dec 19, 2007 |
Am sorry that I have not had chance to reply you. Our internet connection is becoming something else. please bear with I will make out time and write the codes and send to you as soon as our internet is steady. Thanks |
Re: Post Ur Vb 6.0 Questions Here by Dynast(m): 4:57pm On Jan 08, 2008 |
Great programmers! Need help on how to impliment a Computer Draw. I will enter say texts or numbers into Vb object say combo on clicking a button the data entered shld be randomised and one picked out from the rest. On clicking a button another one will be picked out Any one picked out leaves the column so that it will not be picked again Hoping to hear 4m u thanks and Happy New Year(Bon Anee) |
Re: Post Ur Vb 6.0 Questions Here by chukz4real(m): 11:47am On Jan 11, 2008 |
@contributors good one! I admire it all @Lucky I want to go into programmin fully. Though I had little knowledge on Object Oriented Programmin but can code conventionally a little. I've once tried VBA. Please do put me through on VB. This could be online I suppose cos I blive u reside in Lagos while am in Ph. Thankx Regards. chukz4rea@yahoo.com 08038443905 |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 5:58pm On Jan 14, 2008 |
chukz4real since you are on internet you can conveniently download materials which will be of use to you. If you want to fully utilize OPP do use C# or VB.Net. How do be a good programmer to choose any program and start developing it. You may start writing non-database program to enable you master Keywords and syntaxes later you start by writing Database program. Choose any topic on the process you will learn. Stop procastinating or feeling that it is not too needed in your profession nor it is too hard and you must get somebody to train you before you learn. That is best way not to be a good programmer. The best programmers dont learn in class room, they concentrate and discover most by themselves. Remember there is no magic in computer and everything in computer has sequence otherwise syntax error. You can learn easily when you have a problem say a class that will enable you print report. After geting that, the whole lot of problems about printing is solved then you proceed to another one. Join forums where you can download codes, modify and plug them into your programs. Am not in Lagos neither PH but we can meet online as you said. Do let me know that particular keyword you want to use or you need which refuses you and what you want to achieve with that keyword I could be of help. cheers! |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 2:14pm On Feb 12, 2008 |
No more question on vb? |
Re: Post Ur Vb 6.0 Questions Here by krap(m): 6:38pm On Mar 31, 2008 |
i really want to commend you,luckyco on how to try to profer solutions to questions.More power to your elbow. I am trying to develop a program using vb6 in which i would create a table(more of a data table) on a form in which computations could be made in the table along rows to give a final result and the table will be linked exactly to an excel table which could be printed.If it is not possible,you could tell me how i could achieve this possibly with another program. Thanks. |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 5:03pm On Apr 01, 2008 |
You can achieve what you just said using Vb6.0. Let me get your question correct, you said you are designing a program that uses database afterwhich there will be some computations which will be exported to excel maybe for printing? If that is what you need, I will send you a code which you would use to export entire database,grid to MSexcel by using CreateObject command. Thank, clearify your question such that I will understand. |
Re: Post Ur Vb 6.0 Questions Here by yaro248(m): 12:05pm On Apr 02, 2008 |
Great Job LuckyCO: Ever tried FireBird for DB? if not why not give it a try as I think it's an easier database than other referrences given. http://firebirdsql.org/ You really are doing a great JOB. Kudos to you, keep the good work. |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 12:24pm On Apr 12, 2008 |
krap you have not cleared me yet. Please try give me details of what you want to write that I will help you. |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 12:32pm On Apr 12, 2008 |
I have sent this file because you have taken so much time in letting me know what you need. Call this sub program and assign Mhs with MSHFlexgrid and KIM is optional representing row where you want to start exporting the file. Thanks Help it will help you. [b]Public Sub PrintMsh(Mhs As Control, Optional KIM As Integer) If MsgBox("Are you sure you want to export the data to excel", vbQuestion + vbYesNo, "Choose either yes or no" = vbNo Then Exit Sub On Error GoTo errh Dim D As Object, k As Long, J As Long Set D = CreateObject("Excel.Application" D.Visible = True D.WORKBOOKS.Add Dim II As Long Dim i9 As Long Dim i8 As Integer i8 = CInt(Mhs.Rows / 65536) - 3 For k = 1 To i8 D.WORKSHEETS.Add Next k i8 = 1 i9 = 65536 II = 1 Dim M As Long M = 1 Dim DF0 As Integer If KIM <> 0 Then DF0 = KIM + 1 If KIM = 0 Then DF0 = KIM + 1 For k = 0 To Mhs.Rows - 1 If k = i9 Then II = II + 1: i9 = i9 + 65536: M = 1 If II = i8 Then i8 = i8 + 1: D.WORKSHEETS(II).Columns.Font.Size = 8 D.WORKSHEETS(II).Rows(1).Font.Bold = True D.WORKSHEETS(II).Rows.AutoFit D.WORKSHEETS(II).Columns.AutoFit End If For J = 1 To Mhs.Cols - DF0 D.WORKSHEETS(II).CELLS(M, J + 1) = Trim(Mhs.TextMatrix(k, J)) Next J D.WORKSHEETS(II).CELLS(M, 1) = M - 1 M = M + 1 Next k D.WORKSHEETS(II).CELLS(1, 1) = "S/N" D.WORKSHEETS(II).Columns.Font.Size = 8 D.WORKSHEETS(II).Rows(1).Font.Bold = True D.WORKSHEETS(II).Rows.AutoFit D.WORKSHEETS(II).Columns.AutoFit Exit Sub errh: End Sub [/b] |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 11:44am On Apr 19, 2008 |
Have u used the code? Let me know if it served you. Thanks |
Re: Post Ur Vb 6.0 Questions Here by ifkunlethe: 3:46pm On Apr 23, 2008 |
I AM A VB6 PROGRAMMER. IF U NEED ANY HELP JUST CONTACT ME. kunlee22ng@yahoo.com, if_shittle_then@yahoo.com,08032578656 I WANT TO KNOW WHERE I CAN DOWNLOAD VB6 SOFWARE. |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 2:52pm On May 03, 2008 |
Dynast: I think you should use this code below if this is only what u need. Draw Combox Box and command Box and paste the code below Private Sub Command1_Click() Dim K As Integer, M As Integer Dim NF As String K = Combo1.ListCount - 1 M = Int(Rnd * K) + 1 If M < 0 Then Exit Sub Combo1.ListIndex = M NF = Combo1.List(M) Combo1.RemoveItem M Combo1.Text = NF End Sub Private Sub Form_Load() ' You can replace this since you have something else you want inside combo box. Dim J As Integer For J = 1 To 600 Combo1.AddItem J Next J End Sub |
Re: Post Ur Vb 6.0 Questions Here by luckyCO(m): 11:27am On May 13, 2008 |
Hope we don have much problem? Anyway, if I have not answered your questions due to the time my Internet was down can still repost them such that I will answer them. Thanks |
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) ... (16) (Reply)
Java Programming For Dummies / Artificial Intelligence And Machine Learning Group / Facebook Is Suing Me For This
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 52 |