[visual-basic] Forum Topics

pls help me i need this code to view my excel data in vb6 forms only.

Dear members, I am new to this site, I want to learn VB From the bigining. Kindly suggest me how to start. what is the basic requirements to learn VB. suggest me the best web site/books/links/material for me. Kindly do the needful.

hi can someone answer my problem , at first my vb6 is working with my windows 7 32bit but i need to create a project now , everytime i copy label , textbox , checkbox etc.. it always stopped from working.(Not Responding) .. any help please?

hi good day, i am having a problem about my program (VB 6.0) i want to save data from my program to the access database (mS Access 2003) the problem is that when i try to run the program, and click the button, theres an error about insert into syntax …

how we can use get setting and save setting in vb 6.0 with example.or any reallife program. thanks

I'm having trouble connecting to a database file on another PC. In this case, my PC is the client. Using: 1. Windows 7 32-bit on both PC's. * Same Workgroup * Connection verified using cmd (PING) * Connected using hub (straight through) * Workgroup status: Joined 2. MS Access 2007 …

how to make this print fit to page my listview data doesn't fit in the page help please Private Sub PrintDetails(ByRef e As System.Drawing.Printing.PrintPageEventArgs) Static LastIndex As Integer = 0 Static CurrentPage As Integer = 0 'Getting the current dpi so the textleftpad 'will be the same on a different …

Hello fellow earthlings. Using VB6, I want to write a MENU program that executes exe files, or executes dll files. The MENU file should have a function that sends a parameter to A.exe, or B.dll as an example. If A.exe or B.dll received the parameter from the MENU, then they …

Good Morning guys, Can someone please tell me how to insert a fileopen dialog in VB? What I want is when the user clicks on a button, the program takes them to a particular directory or folder, that way they will be able to select files on their own from …

Hey guys, i have been stuck for over two weeks now on a pos system that i am creating. My form is connected to an access database but cannot update records either on the form from Access or on Access from a VB form. Can someone please help me throuh, …

Hello, can somenone help me solve this problem? i try this code to insert my data into microssoft access 2013 database but when i insert, a new row is created with no data, someone can help me? this is my code for my save button, only date can insert. acsconn.Open() …

how to print report on Vb6 using Crystal Report

hi all, i am working on visual basic 6.. i am finding codes on how to ping url/ip address directly from vb6.Then, it will reply or response if there is succesfully ping or not.really needs someone help. I had try google and found codes but its provide error because it …

Private Sub pre() Dim cnview As New ADODB.connection Dim rsemployee As New ADODB.Recordset Call connection(cnview, App.Path & "\Commissions.mdb", "endromida") Call Recordset(rsemployee, cnview, "SELECT * FROM commi_cus WHERE sha_no ='" & txtShaha.Text & "'") If recexist("commi_cus", "sha_no", txtShaha.Text, cnview) = True Then Call hlfocus(txtPrt): Exit Sub With rsemployee txtPrt.Text = .Fields!funa …

Greetings! Anybody know how to insert marquee or scrolling text message in statusbar panels using Visual Basic 6. I want to put scrolling message in my status bar anybody could help me plz. Thank you in advance.

im making an airline reservation system, now my question is how to do the seat reservation with different flight schedule in one form only. I dont have any idea on how to make it but i already make a form which has a 36 seats. so confusing. do i need …

can you please help me on how to search multiple data and display it to my datagrid. im a newbie in vb6 and im having a hard time in coding.

hey..my name is marluke.. i want to know the code of Save, Edit and Delete using visual basic 6 and the database is Ms Access does any body wants to help me? please i really want to know and learn visual basic.. thanks for helping LuKeZ

hello dani, I am using shape sql for datareport without dataenvironment conncetion towards parent-child relation ship table. But doesn't work with error. Because parent fields only accepted in my project. I am attaching my vb 6 project to your kind attention please. Option Explicit Dim con As ADODB.Connection Dim rs …

Hye, I have problem with Auto Generate Slip No from Database.I wrote following code to get last record but it does not give me last record. Please help me? [CODE]Private Sub Command1_Click() Module1.Connect Dim rs As New ADODB.Recordset Dim str As String str = "SELECT Item_ID FROM Entry_Tab" rs.CursorLocation = …

hello I want a timer in my Access database form using Visual Basic I have the code dim i as integer=0 timer1= i label1.Text = "Remaining time:" + CStr(2500 - j) + "seconds" i = i + 1 If i > 5000 Then Timer1.Enabled = False commandbutton1.text=stop End If which …

Can someone help me?.How to alert data in Form automatically without clicking into the datagrid.I need to pop up the message box when the medicines expired without clicking in the datagrid. I have a table name inventory field names MedicineName, genericname, StockQuantity,"Expmonth", "Expday", "Expyear". here is my code Private Sub …

hi, can somebody help me? i am using visual basic 6.0 with microsoft access 2003 database i have a form that view the data from the database through the listview my problem is it says Compile Error: Method or data member not found heres my code Private Sub Form_Load() Dim …

hi, done some work is not finished yet but this two versions\stages are runable. and what is very helpfull, to read opinion, suggestion, critic, ideas, feelings about. here is the link: http://softwareconstructor.webs.com/ and i need to read what u think about two firsts: * tryout2 (10bm) * and tryout1 (190mb) …

hi there, can someone teach me how to insert combo box inside the column..

Can anyone help me, how to make a sectioning syntax in my enrollment system. I can't think of a way on how to do it. This is my current logic. The student will input his/her General Average if it is >= 98 Then he/she is section 1. But if section …

Sooo...I was told to start a new thread about this. So I'm trying to make a link between TextBox1.Text on Form1 to TextBox2.Text on Form 2. What I currently have is a line of code underneath my TextBox2_Change code reading: TextBox2 = Form1.TextBox1.Text This ALMOST does what I want it …

I am doing my final year project in college admission with vb6.0. i have completed 60% of the project.I have created several register forms for ug, pg, mphil and so on. And then i have admission register form.I have also created database for all those forms in oracle 10g. i …

Use visual basic 2008 Form1 with a text box (ScanArtikelBarcode.txt )on it barcode scanner I use now this code to read a barcode Private Sub ScanArtikelBarcode_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles ScanArtikelBarcode.KeyDown ' This way I collected the scanned barcode and process it against my table and …

i have a serial id, and i should fix that only 100 entries are allowed.How can i do this by code? and also how can i automatically generate consecutive numbers i.e from 1 to 100.Please help me frnds.I have to complete my project soon.

I want to put the path and name of a spreadsheet, the page and number of pages and the date and time into the footer(s) and display it in Times New Roman 6 pts. I made the following macro: Range("A1").Select ActiveWindow.View = xlPageLayoutView` Application.PrintCommunication = False With ActiveSheet.PageSetup .LeftFooter = …

Hi All, I have just completed my project in VB 2008 express edition. Now I want the project to be converted to .EXE so that I can deploy it on other computer / laptop. Could any one please help.... Regards, Ashwin

When I format the date so that a field gets the value as year-month-day-hour-minute-second, I omly see the date-portion, the rest is filled with zeros. I use: strDT = Format(Date, "yyyymmddhhmmss") I get '20140226000000' What goes wrong, or how can I get the desired result?

How do you pass the data in a field on one form to a field in another form?

i want to run this Query with **ADODC control** and show result in **Datagird View** Private Sub Command1_Click() Dim Sell_tbl, Stock_Bottle, res As String Sell_tbl = "SELECT Sum((Quantity)*12) FROM Sell_Detail Where Cateogry='Large'" Stock_Bottle = "Select Sum(No_Of_Bottle) FROM Add_Bottle Where Cateogry='Large'" res = ((Sell_tbl) - (Stock_Bottle)) Adodc1.RecordSource = Sell_tbl Adodc1.Refresh Adodc1.Caption …

Hello, how to get id of selected row or clicked cell row in datagrid in vb6.0? Thanks

for save I write this........ With rs .Open "Select * from Dad", con, adOpenDynamic, adLockOptimistic .AddNew !SrNo = cmbbillno '!SrNo = GetNewNo("Dad") !DadItems = cmbIName !DadSize = cmbISize !Dad = txtDadIQty !Dadby = cmbOrTkBy.Text !DadDate = DadDate !deliverydate = deldate !partyname = cmbPartyName !amount = txtamount.Text !due = txtdue.Text !Receive …

I am working on a homework assignment and have been hashing it out for days. Hopefully my novice status with this wears off soon. I am supposed to create an ISP calculator with checked radio buttons and the user enters the hours. Package A = $9.95 for 10 hours each …

how to search data from 2 different table using dtpicker?? it is connected to mysql wampserver . please help

Hi in my project for printing faxes they connected server remotely now i want to change the servere lo local.Please suggest me on this.

how to make registration system only inserting image i need to know please help to my thesis

I am very new to visual basic 2010 and am really struggling with it. My assignment is a fat gram calculator and the example is there are 200 calories in the food and there are 8 grams of fat in the food. The calculator gives the percentage of calories that …

function fact(n) if n=0 and n=1 then fact=1 else fact=fact*fact(n-1) end fuction

I am trying to convert access2.0 database to access2010. 2 days trying to recode this to run in access 2010 but no success. Global Const CONNECT_SQL = "ODBC;DSN=PCGINV;DATABASE=pcginv;UID=;PWD=" Global gqdfTemp As QueryDef Global grecSQL As Recordset Sub GetSQL(strSQL As String) On Error GoTo Err_GetSQL Dim db As Database Set db …

Hello, I need to create password protected PDF file in VB6.0. How can i do this? any reference link, suggestion or source code? Thanks.

hi I want to make a query that first find the sum of two columns of different table then subtract it Example it is a visual basic program Dim large_tbl As String Dim sell_large As String large_tbl = "SELECT Sum(No_Of_Bottle) FROM add_cotton where Cateogry='Large'" sell_large = "SELECT Sum(Quantity) FROM Sell_Detail …

Every single time I try to use a control from components on vb6, I put the code, I run the program, then when I try to open the same program in another day, its not working, its giving me the error : Line 13: Class MSAdodcLib.Adodc of control Adodc1 was …

Friends again problem with date function In my form there is a text field -txtDod- of Date type formated like "dd-MMM-yyyy" My input is also formated like "dd-MMM-yyyy" Now see my code Private Sub TxtDod_KeyPress(KeyAscii As Integer) Select Case KeyAscii Case vbKeyReturn If Not IsDate(TxtDod) Then LblMsg = "Enter Date …

Need Help.. I have two tables tblRecieve and tblReleased tblReceived --ID-RcvdPcs --1 5 tblReleased --ID-RlsdPCS --1- 2 as you can see i have received 5pcs and i already released 2pcs in same id so the remaining pcs is 3. how do i code this to prevent user to released more …