vba x 200

12,155 Topics

Member Avatar for
Member Avatar for hiz460

Hi, Im trying to add a code which adds a record for me and then saves it. I am also trying to add a code which deletes the record for me. So far, my "Add" button, clears the form, which is what I want. Then when I click on save, …

Member Avatar for hiz460
0
205
Member Avatar for akssps011

Hi all I have two questions: 1) I want to create a custom report in VB6. The report format consists of labels for name, designation etc against which data has to be populated by MS Access DB. Below this a table has to be printed consisting of data from some …

Member Avatar for akssps011
0
95
Member Avatar for seeker55

I'm just finishing up my project for school but I've seem to have hit a speed bump. Here's the code I'm working on : [CODE]Private Sub Command1_Click() cnt = 0 search = Val(Text1(1).Text) For cnt = 0 To 7 If search = memberarray(cnt, 0) Then memberLbl = "Member ID:" & …

Member Avatar for vb5prgrmr
0
102
Member Avatar for navaidstech

Just when I thought I was comfortable with SQL queries, another one popped up that I can't get around with.... I'm ALMOST there but not quite. Here is the situation... I'm dealing with two tables [B]PoolTeams[/B] and [B]PlayerStats[/B] The PoolTeams table has two columns: [B]PoolTeamID[/B] and [B]TeamName[/B] The PlayerStats table …

Member Avatar for navaidstech
0
227
Member Avatar for Mira Rangarajan

This is what i have done already.Anyhow thanks.Can't we draw a rectangle on both the sides of a range bar in which we can add some text? or Is there any way to draw a free text anywhere on MsChart?

Member Avatar for kvprajapati
0
44
Member Avatar for jonniebl

I am new to visual basic 2008 and am trying to navigate to a web site and automatically enter my username and password from within a visual basic program. Then I want to navigate to another page and fill data in various fields on the page. I can navigate using …

Member Avatar for kvprajapati
0
166
Member Avatar for technogeek17

Ok, I am relatively new to Vb.net, but I am getting along. I have an application that I wish to make an updater for. The updater needs to be able to read Visual Basic code files and insert the code into the application. Is there any way to do this? …

Member Avatar for kvprajapati
0
111
Member Avatar for niessen

I am trying to upgrade a number of older VB3 and VB4 projects to VB6. While there are no .dll calls in the form code, I assume that there are some associated with the old controls. I can get the projects to run in the VB6 development environment but when …

Member Avatar for niessen
0
264
Member Avatar for JdTSC

The msgbox widget is really useful. However the font limitations of the default msgbox can be brutal if your trying to deliver a message with considerable information. Has anyone coded an improved msgbox class that would take the same arguements + font?

Member Avatar for JdTSC
0
123
Member Avatar for vakhilesh

Hello,i am using VB6 in the development of my project which deals with sending sms messages if an intrusion in home/office is detected. However the application hangs whenever i try to run it.At sometimes even if it rarely runs it hangs after 2 or 3 minutes.Please help me with this …

0
56
Member Avatar for jeogs

i need code in VB6 of process scheduler priority and SJF where in the user will input the process, burst time, event time and the priority plsss help this is my ..Email Snipped.

Member Avatar for kinwang2009
-1
82
Member Avatar for P.manidas

Dear Sir/Madam, As I have seen VB 6.0 is supporting Icon files, Metafiles and BMP files for using in the PictureBox property of ImageBox, PictureBox, and CommandButton. I have tried ICON file to use on those Controls, but some ICON files are supported and some are not supported. So, I …

Member Avatar for kinwang2009
-1
3K
Member Avatar for cingo1

Dear friends, I have a VB6 app using MS Access2003 database ODBC connection in Windows Server 2008 my connection string is simple ODBC-- DSN=hotel -- using Microsoft Access Driver (.mdb) using admin user - i can run all forms on windows server 2003 successfully using other users - i get …

0
52
Member Avatar for arvin2006

good day everyone! is there any idea on how to set the picture property of the Data Report's Image Control based on the Form's Image Control? this code doesn't work: 'Me.Sections("Section2").Controls("imgEmployee").Picture = frmMain.imgPic.Picture Thank you very much for responses.

Member Avatar for shenba.akila
0
197
Member Avatar for Masterace

hi waltp the code i need is like (TK012001) and is to appear on the receipt and change whenever i make a transaction i.e TK012001, TK012002, TK012003.......... is that possible?

Member Avatar for WaltP
0
65
Member Avatar for sidhu51

Hi all, am working in vb6. I have a situation wherein i have to open many files together and keep it in a folder and then start runnin one by one continously without any break. i have the codes for opening a single file and runnin it... how can i …

Member Avatar for WaltP
0
113
Member Avatar for pankaj.garg

Hi, i am trying to create a report using VB6...the format of the report is attached as pdf file..the format of report is important for me.. i have my data in Access and finally would like to print report on a word document.. Please let me what should i use …

Member Avatar for akssps011
0
75
Member Avatar for Masterace

hi need codes for displaying a negative value eg ($-1000) in the balance txt when a person pays more cash here are my codes Private Sub CmdCalc_Click() 'to declare variables Dim Nam As String Dim Unit As String Dim Amt As Currency Dim Bal As Currency Dim Tot As Currency …

Member Avatar for vb5prgrmr
0
89
Member Avatar for stabatron5000

I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x …

0
130
Member Avatar for HelloMe

Hello everybody... I did a project in c++ about factorials. Now i will do it on VB6. But my problem is somehow my output is always 1. So i think my funktion i made take no action at all. Would be greate if someone can spott my error...Thank you [code] …

Member Avatar for HelloMe
0
119
Member Avatar for BillWebber

Hi, and thanks for reading, I only hope you have a chance of helping me out, whoever you may be i thank you in advance. Here is the problem I am up against. My program is random number selector like a lottery number picker. I made it so it picks …

Member Avatar for Kelbow-Mendes
0
2K
Member Avatar for lightner86

hello.. can someone help me on my problem with regards to VB... my problem is that i want to change the value of a cell in a flex grid for example if Item no:112 is already in the flex grid and its quantity is 26...and then the next time the …

Member Avatar for omoridi
0
107
Member Avatar for RassKass

Hi, I would like to perform a validation check on a field (Employee/Staff Number) there should not be duplicate entries in this field so i would like for a check to be performed when the next field is clicked then a msg displayed saying "Staff Number already exists" Any sample …

Member Avatar for omoridi
0
114
Member Avatar for P.manidas

Dear Sir/Madam I have a program where I have used a small form as Input / Message Box in place of VB’s InputBox / MsgBox in a click event procedure i.e CmdSave_Click(). Though the code lines are executing in that procedure at a time, the global variable GblBox is not …

Member Avatar for P.manidas
0
325
Member Avatar for lloydi12345

hi, i have created a program but don't know what to do. The condition is when text1.text = empty or it has no value then there would be a msgbox popping out. and for the else, there would be no msgbox popping out. i really don't know what's the code, …

Member Avatar for gms_019
0
203
Member Avatar for akssps011

I am using VB6 and MS Access for my project. I have to make a printable page to print slips(8 on 1 page) with attributes name, id etc to be retrieved from the database for each slip. how should I approach for this? Is there any tool in vb for …

Member Avatar for vb5prgrmr
0
80
Member Avatar for papamutz

EXAMPLE if i input like this " int a; " or " a+b-c=d " then the output must? OUTPUT : int = CHARACTERS a to z = VARIABLES ; = TERMINATOR 1 - 0 = NUMBERS + - * / ( ) = OPERATORS = = EQUAL

Member Avatar for vb5prgrmr
0
91
Member Avatar for cabsjonel

gud evening to all of u folks folks im so stessed right now cause i have only two days to pass my project in vb6 which is a lending system my big problem is i dont know how to link my customers in formation table and payment table can you …

Member Avatar for kinwang2009
0
100
Member Avatar for xXxWiredxXx

im newbie on MySql... im trying to migrate my DB(MsAccess) to MySql.. i have this sql statement on my MsAccess [QUOTE]SELECT MI.MIDate, MI.WIStockNo, Month(MI.MIDate) & ", " & Year(MI.MIDate) AS Period, MI.MIStockName, MI.MIUnitM, MI.MIRequired, MI.MIUpdated, MI.MIBCQ, MI.MITo, MI.MISection, MI.MIPurpose, MI.MIJobNo, MI.MIItemNo, MI.MIEncoder, MI.MIRequisition, MI.MIStockman, ([MI.MIRequired]*[WItems.WIAmountUnit]) AS TotalReqAmt FROM WItems INNER …

Member Avatar for xXxWiredxXx
0
84
Member Avatar for KiltedScot

This seems to be a common error, but I can't quite get it fixed in my case. The basic operation of my database / form is: Get search value Retrieve record Display record The form has two combo boxes and several text fields. Each of the combo boxes allows the …

Member Avatar for KiltedScot
0
265
Member Avatar for david1987

Hi, I am creating an application in vb linked with a access database and i am having problems searching records. For the team screen I have the following database query that I wish to call: [CODE] SELECT TeamName, [Section] FROM Team WHERE (TeamName LIKE ''' & TeamNameSearchTextbox.Text & ''') [/CODE] …

Member Avatar for vb5prgrmr
0
122
Member Avatar for student02

hi guys, is this possible [CODE]Private Sub Command1_Click() Adodc1.Refresh Adodc1.Recordset.Update Adodc1.Recordset.Fields("Balance") = Val(Text1.Text) - Val(Text2.Text) Adodc1.Recordset.Fields("Amount_Paid") = Val(Text2.Text) + Val(Text3.Text) Adodc1.Recordset.Update Adodc1.RecordSource = "SELECT * FROM Tuition_Fee WHERE Tuition_Fee_ID_PK = " & Form2.Label16.Caption Adodc1.Refresh Text4.Text = Adodc1.Recordset.Fields("Total_Tuition") Text3.Text = Adodc1.Recordset.Fields("Amount_Paid") Text1.Text = Adodc1.Recordset.Fields("Balance") MsgBox "Tuition Updated" Printer.Print " Official Reciept" …

Member Avatar for vb5prgrmr
0
178
Member Avatar for princeutoy

HELLO PLEASE HELP to do a CODE PLEASE.. it give the meaning of each input.... if i input in a textbox this int a; then the output in listbox must int = characters a = variable ; = terminators

Member Avatar for vb5prgrmr
0
101
Member Avatar for firoz.raj

<<split from [URL="http://www.daniweb.com/forums/post452669.html#post452669"]here[/URL]>> [QUOTE=QVeen72;1120857]Hi, First Check Which Form is giving the error, and also check what all components (ocx) you have used in that form.... SP2 seems very old.. What I recommend is Download and Install Visual Studio latest service pack (SP6 ) on your machine and Complie and Create …

Member Avatar for vb5prgrmr
0
100
Member Avatar for vince21121

could someone help me compute the EOQ (Economic Order Quantity) in vb..? i really find it hard computing it.. i tried so many times, but i just can't get the logic out of it.. tnx

Member Avatar for redratear
0
52
Member Avatar for maylim26

HI! Anyone here got idea to add shortcut in DEsktop automatically run( using Package and Deploy Wizard)?Izzt it is possible to to?

Member Avatar for kinwang2009
0
568
Member Avatar for jemz

hi, please help me on how to use the textfield_change can you give me an example on this so that i will know how to use this..thanks in advance...hoping for your positive responds....

Member Avatar for abu taher
0
161
Member Avatar for drewpee

I have a test table where I'm using the Last() function but it seems to not work, it always return the 2nd record when i have 10 records.. [CODE]SELECT LAST(Date_Received) FROM serviceRS; [/CODE] returns the 2nd record [CODE]SELECT FIRST(Date_Received) FROM serviceRS;[/CODE] returns the 3rd record X_X

Member Avatar for drewpee
0
112
Member Avatar for PinoyDev

Hi guys Good day. I just want to ask help on how to hide the start menu and prohibit access to it as well as the task manager and the date and time when the form loads, and restore it back when the form terminate without restarting the computer. Thank …

Member Avatar for PinoyDev
0
152
Member Avatar for jeevsmyd

I have been doing TC++ programing for the last 2 years.. This evening all of a sudden I made the switch to vc++.. here is the code.. my first ever Visual C++ programme.. it is compiling without errors but the console window poped and disappeared quickly.. what is wrong? something …

Member Avatar for WaltP
0
110
Member Avatar for eddan

Yeah I was stupid and pressed (X) on all of the bars to the left you know the "Solution Explorer" I think and alot of more, how do I re-enable them?

Member Avatar for mitrmkar
0
111
Member Avatar for student02

Guys. can you help me with my project again? hehe.. sorry for flooding forum with my threads.. I have a table that have a field name Amount_Paid, Date, and Transaction_Number.. i want to add all the data that has been saved on Amount_Paid that has same that, for example, today …

Member Avatar for kinwang2009
0
128
Member Avatar for lloydi12345

hello,i think this is just a simple question but im not really familiar with the basics of VB6.0 so i am asking it, can i ask how can i set integer value on text1.text without making the value visible on the textbox when i run the program? thanks like text1.text …

Member Avatar for student02
0
269
Member Avatar for renierose

My problem are if you log in to the attendance system there is a 30 minutes interval before you can log - out to the system. then if you log- out to the system you can log -in again, until you complete the 8hours of working for one day.

Member Avatar for WaltP
0
150
Member Avatar for kavya_nayak7

Hiii...Iwant to retrieve the month part from dtppicker(like i want to display the monthwise reports or display a paricular month's entries from database) ..can anybody provide a solution for this?

Member Avatar for vb5prgrmr
0
67
Member Avatar for Bananat

I am trying to generate a mouse click based on x, y position and not using a hwnd. I've tried several examples but none seem to work for me. I'm using VB6. Any ideas?

0
47
Member Avatar for timmmy

ey, im looking some code that will open up the browse window so i can open a file for my database i have created thanks :)

Member Avatar for SCBWV
0
105
Member Avatar for lomyuk
Member Avatar for purplegerbil
0
116
Member Avatar for Comatose

Another Small And Simple Function To Take Each Character of a string, and put it into an Array, This helps significantly when you need to sift through a string. This Function Uses The spush (String Push) Function, Also In Code Snippits.

Member Avatar for jfc2k4
-2
963
Member Avatar for drewpee

Ok so i have a couple of [B]Strings[/B] and [B]Dates[/B] I'd like to use in making my reports. I can't seem to make it work. any help? This was my latest failure. [CODE]SELECTCCIF_No, Date_Recieved, FROM serviceRS WHERE Date_Recieved >= '" & DateFrom & "' AND Date_Recieved <= '" & DateTo …

Member Avatar for vb5prgrmr
0
128

The End.