About Experts Sitemap - Group 54 - Page 16 2014-07-22

Visual Basic: hi, matching number, question id
matching number, question id, random number: Hi, when you have that random number, you need to pick the question from the DB whose ID is equal to that random number. If such an id does not exist, you need to generate another random number until you get a matching number for the question id. HTH...

Visual Basic: Mandatory field question, message boxes, program exit
message boxes, program exit, 599cd: Then set a variable once the warning has popped up, and if it s triggered a second time, just ignore it. If X 1 then Msgbox warning!!! X=1 Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page...

Visual Basic: mscomm1, 599cd, allexperts
599cd, allexperts, vb6: You might just be sending the data too fast to the COM port. Try inserting a delay between each line - half a second or so should be fine. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at...

Visual Basic: Need help regarding Data report in vb 6, parameter entry, text1
parameter entry, text1, prints: in the dataenvironment command1 enter under sql statement. see that command name and connection are selected Select * from testable where rate ? change to your table name and field this gives a parameter entry as usual drag the fields on to...

Visual Basic: passing variable to the procedure, combo boxes, previous question
combo boxes, previous question, dear mr: i dont remember your previous question(i get a huge no of them daily) what has Public, static to do with what you want to achieve? no connection at all and pray what is Bon? and what do you want this procedure to achieve? passing values to procedure...

Visual Basic: Query on MS Access, improper entry, improper data
improper entry, improper data, query design: ok, this cannot be done automatically from vb you need to change the value by code or manually if field 2 is based on the value of field 1 then this can be done using a query instead of having field2 in the table, delete it there and have in query...

Visual Basic: Query output update on VB6.0+MS-Access, math operations, query fields
math operations, query fields, query table: It sounds to me like you just need to learn how to properly create CALCULATED QUERY FIELDS. You can make a query that will perform math operations for you automatically. Please see the following FREE video tutorial on my web site for step-by-step instructions...

Visual Basic: How to run a query made in access from VB6, google search, 599cd
google search, 599cd, command button: Use DAO or ADO recordsets. It s too much code to go into here, but if you do a Google search, I m sure you ll find code. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts...

Visual Basic: VB 6.0 If statements, x time, 599cd
x time, 599cd, allexperts: VB6 lacks a CONTINUE statement which would take care of this (they added it in VB.NET). In the code you have there, you don t need to do ANYTHING. There s no code after your IF block, so the loop would just continue. I personally just use a variable...

Visual Basic: VB 6 & Access Connection for multiuser, dynamic connection, typical microsoft
dynamic connection, typical microsoft, microsoft jet: the problem here is with access. though it allows multiuser operation, trouble starts with updating records. you can split the database into many with linking of tables so that the data is updated. means a copy of db is split into each machine and linked....

Visual Basic: VB 6 & Access for multiuser not multiusing, vb 6, 599cd
vb 6, 599cd, free tutorials: That makes sense. Without seeing all of your code, I wouldn t have guessed that. I assumed your RS was setup correctly. Glad it s working. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at...

Visual Basic: VB.NET Menu program, VB6 to VB.NET
VB6 to VB.NET: Why don t you use VB.NET like I do for 9 years now? And the Express edition is even free and makes real executables! MS has stopped updating VB6 in 2001... So, for a small project like that, give yourself a push and use VB.NET. In both versions you...

Visual Basic: VB Query, access2003, access developer
access2003, access developer, 599cd: Not really. The best you can do is purchase the Access Developer Extensions and convert your project so that it s distributable. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts...

Visual Basic: Visual Basic 6, dim arr, code option
dim arr, code option, adu: here s the sample code: Option Explicit Dim arr() As Integer Private Sub Command1_Click() Dim adu As Integer adu = Val(Text1) ReDim arr(Text1) arr(adu) = 15 debug.Print arr(adu) instead of debug you could use label1.caption or other method...

Visual Basic: vb6+excel-- beginner to VB6, excel application, excel sheet
excel application, excel sheet, project references: this is a sample code: you can modify areas to suit your needs: Option Explicit under project_references check Microsoft Excel 11 library Private Sub Command1_Click() Dim xl As Excel.Application Dim rowVal As Integer, colVal As Integer Set...

Visual Basic: visual basic 6, microsoft data access, microsoft data access components
microsoft data access, microsoft data access components, jet oledb: uninstall vb6 and reinstall the same. while installing, you should not run any other programme. if error persists, then you need a different vb6 CD. once you have VB6 running, you could use ADODC control or ADODB code, to connect to Msaccess. sample...

Visual Basic: Access VBA Array - How to load results of a Query/Table, steve jameson, 599cd
steve jameson, 599cd, correct tool: Greg, I wouldn t bother with an array if all you re doing is sending an email. I would just use a text string variable. You will, however, need something like a recordset to loop through the records in that query to read the individual names. Something like:...

Visual Basic: Compile Error: Procedure Too Large, b7, orientation
b7, orientation: for a beginner you have tried things beyond your depth. for god s sake where did you pick up such junk code? have never seen such meaningless lines. still i do not know what you want to achieve. i can help you out only if i know the full details of what...

Visual Basic: Can we Create Tubular Form like in access in vb, math operation, msflexgrid
math operation, msflexgrid, mathematical operation: you mean Tabular form? whatever you can do in access, you can do in VB. you can take a value from record and do math operation in msflexgrid or label. how can i tell the code without knowing what the records are , how you get them from access and...

Visual Basic: converting text file into data file, import wizard, separator character
import wizard, separator character, 599cd: There is an import wizard in Access you can use and specify the separator character. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts Cordially,...

Visual Basic: Dear sir, datareport, listview
datareport, listview, queries: datareport needs dataenvironment. first where did the listview get the data? listview is for display. better to get the report from tables or queries. you can sort the data by labNo or any other field. in dataenvirnoment you need to use the properties...

Visual Basic: Dynamic Arrays, egg cartons, egg carton
egg cartons, egg carton, dynamic arrays: An ARRAY is when you have a fixed number of variables all called the same thing. Like a[12] which is a variable a that can hold 12 items. Think of this like an egg carton. A VARIABLE array is one that can be redimensioned (usually with the ReDim command)...

Visual Basic: datagrid in VB, adodc, datagrid
adodc, datagrid, switchover: datagrid requires use of ADODC. if you are using ADODB switchover to Msflexgrid coding is like dim ravi as string esql = select * from tablename rec.open(esql),connection,adopenstatic,adlockreadonly do while not rec.eof Sample code msflexgrid1.rows=msflexgrid1.rows...

Visual Basic: Formatting a Cell, vb question, valus
vb question, valus, 599cd: You re talking about cells… is this an EXCEL question or a VB question? VB doesn t use cells. It has controls called text boxes. I need more information in order to help you. Let me know if you have any other questions or comments. Also, be sure...

Visual Basic: include? inheritence, visual studio, list box
visual studio, list box: in form2 add this code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Form1.ListBox1.Items.Add(TextBox1.Text) Form1.Show() Me.Hide() End Sub and in Form1...

Visual Basic: Listbox in VB 6.5, vb 6, vba
vb 6, vba, boxes: first are you referring to VBA (which is very much different from VB) or just VB. there is nothing like VB 6.5. i assume that you are in excel (that means VBA and not VB). your using 12 boxes with the same range does not make sense to me. and the...

Visual Basic: how to link VB6and MS access, activex dataobjects, jet oledb
activex dataobjects, jet oledb, microsoft activex: put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn As ADODB.Connection, rec As ADODB.Recordset Private Sub Form_Load() Set cn = New ADODB.Connection Set rec = New ADODB.Recordset cn.Open ( Provider=Microsoft.Jet.OLEDB.4.0;Data...

Visual Basic: Need assistance for VB6.0, 599cd, allexperts
599cd, allexperts, textboxes: I do NOT use Crystal Reports. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts Cordially, Richard Rost 599CD Computer Training http://www.599cd.com...

Visual Basic: retriving data adodc, adodc, esql
adodc, esql, recordsource: 1)better move to ADODB because if the same project is loaded in another computer the ADODC has to be manually placed on the form. in adodc for specific record: use Private Sub Command1_Click() Dim esql As String esql = Select * from YourTable where...

Visual Basic: Search Data B/W 2 dates urgent plz help!!!!, tips access, 599cd
tips access, 599cd, allexperts: You can specify criteria for running your queries, such as limiting between two dates, checking for specific names, etc. by specifying PARAMETERS in your queries. This free tutorial on my web site explains how to use parameters in queries: http://599cd.com/tips/access/parameter-queries/?key=AllExperts...

Visual Basic: Sql Query, adodc, 599cd
adodc, 599cd, allexperts: First, NEVER use the Field name NAME. It s a reserved word. Your problem is PROBABLY because you need quotes around your text string… …WHERE NAME= & Text1.text & AND… Notice the extra single quotes. Let me know if you have any other questions...

Visual Basic: How to select multiple records from a table in Access, strsql, recordcount
strsql, recordcount, currentdb: thank you for your response. pl send the full details with your table,required display etc to mgravi2005@dataone.in in zipped format.Mention in sub: Allexperts contd. normally i charge a high rate for my time but in your case let me know your budget as...

Visual Basic: How to select multiple rows from a table in VB, strsql, openrecordset
strsql, openrecordset, lrs: You have to LOOP through the records with a WHILE loop. While Not LRS.EOF get your record LRS.MoveNext Wend I cover Recordsets in detail in my tutorials… Recordsets are basically objects you can use in VBA code to edit, add, and delete records....

Visual Basic: VB 6 option button query, msgbox, answer button
msgbox, answer button, option button: what is ans(0) ? how can the user be responsible for Label6, label7 and label8 caption? if ans(0) is an array where is the declaration? this part you need to change secondly with one button click if you are evaluating 1 answer of the 3...

Visual Basic: VB+Access, dataenvironment, datareport
dataenvironment, datareport, code option: you can use the dataenvironment even for conditional filter put a dataenvironment on form and point it to your database add a command it its sql properties in the textbox enter Select * from testable where item=? where testable is your table...

Visual Basic: VB6.0 Multi-User Problem(Auto-Number), current company, ms access
current company, ms access, increment: first of all autonumber is inadvisable. change it to Number. you will have the freedom to alter it, delete it etc. but if it is zero then it will produce an error. to overcome that you use this method: conn is the connection function to your database...

Visual Basic: VBA Code, 599cd, daily basis
599cd, daily basis, allexperts: Instead of deleting the table, just run a DELETE QUERY in your macro. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts Cordially, Richard Rost...

Visual Basic: VBA modeless userform, excel code, custom images
excel code, custom images, logo image: in the excel code window (alt +F11), choose Insert and select User Form. put an image Box on the form and point it to your logo image file. in caption ..enter the Caption you want have a label on theform and its caption as Please wait till the programme...

Visual Basic: vb, adodc, esql
adodc, esql, computer switch: Option Explicit Private Sub Command1_Click() Dim esql As String esql = select * from testable where RollNo= & val(Text1) Adodc1.RecordSource = esql If Adodc1.Recordset.RecordCount 0 Then Adodc1.Refresh label1= Adodc1.Recordset.Fields(0) label2=adodc1.recordset.fields(1)...

Visual Basic: vb6.0+ ms access, adodc, picturebox
adodc, picturebox, vb6: in acces you can use one method: in the table, have a field with OleObject type make a form based on this table. in the form which shows the oleobject, copy and paste the image. the form s add new property is to be true. thats it in vb you the...

Visual Basic: Access VBA 2003 - dynamically Creating controls, access vba, 599cd
access vba, 599cd, allexperts: Yes, it is possible, but if you don t have that many controls it might be easier for you to just make them all and then set them visible or not when the conditions you need arise. Let me know if you have any other questions or comments. Also, be sure...

Visual Basic: Capture End Sub/Function Event?, looking for a new job, 599cd
looking for a new job, 599cd, allexperts: Sure… if you want to do what I think you want to do, you could just use a variable or even a form field to indicate when something is DONE and then move on to another function / sub. Sub1 do some stuff if Field1=TRUE then run Sub2 end...

Visual Basic: Check Box and Datagrid control in VB 6.0, jet oledb, source master
jet oledb, source master, strsql: the datagrid configures well only with ADODC. add adodc and point it to the table create a query with only checked fields and use the sample code: Private Sub Command2_Click() Adodc1.RecordSource = select * from testable where rate 100 adodc1.RecordSource...

Visual Basic: Crystal IX formula, 599cd, allexperts
599cd, allexperts, computer job: As it says right in my question instructions… I do not use Crystal Reports! Sorry. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts Cordially,...

Visual Basic: colorize partial cell in rowset of listview... based percentage, rowset, cells
rowset, cells, labels: i dont think the same cell can have two colours. what you can do is have labels on these rows of the same length as listview cell and have their backcolor as say red then you can make their length property based on the percentage of the figure. this would...

Visual Basic: Drawing a Line on the form using timer control, timer interval, timer control
timer interval, timer control, vb 6: sample programme i have incremented only one axis but you can do the same for both x and y axis , 2 textboxes.. timer interval 1000 you can change the tim2 =5 to more or less depending on delay Option Explicit Dim tim2 As Integer Private Sub Timer1_Timer()...

Visual Basic: VB 6.0 and MS Access (Datepicker), microsoft windows common controls, windows common controls
microsoft windows common controls, windows common controls, datagrid control: you are the person starting with ADODC; you are supposed to know its properties and not toss back the question. set the property End of action to adDoaddnew msflexgrid does not take datasource=rs you need to programme it like msflexgrid(rowval,colval)=...

Visual Basic: LISTVIEW, jet oledb, adodb connection
jet oledb, adodb connection, adodb recordset: Private Sub Form_Load() Set conn = New ADODB.Connection Set rec = New ADODB.Recordset conn.Open ( Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:Hotelhotel.mdb; Jet OLEDB:Database Password=saroj ) rec.Open testable , conn, adOpenDynamic, adLockOptimistic...

Visual Basic: LOGO, project menu, unwanted items
project menu, unwanted items, splash screen: in your project add a form using the Project Menu_ Add Form choose Splash screen. make this the startup form. put your logo here removing unwanted items. you can put a timer on this so that it closes itself after some interval and opens your main for...

Visual Basic: need help with vs2005 for printing, submission button, printing format
submission button, printing format, prc files: vb 2005 is a bit more advanced for a beginner. it is easier using VB6. ( it can be done but needs a bit more experience) this requires professional approach and as such cannot be give free. i can design the form which gets the files. these prc files...

Visual Basic: need of vb codes, field queries, jet oledb
field queries, jet oledb, esql: under general declarations Dim esql As String, conn as ADODB.connection, rec as ADODB.recordset Private Sub form_load() Set conn = New ADODB.Connection Set rec = New ADODB.Recordset put the filename you want here conn.Open Provider=Microsoft.Jet.OLEDB.4.0;Data...

Visual Basic: how to retrieves data from table by using two combo box, esql, combo boxes
esql, combo boxes, combo box: Private Sub command1_Click() Dim adu As String, esql As String, ravi As String esql = select * from testable where item where Field1= & & combo1 & esql=esql & And field2= & val(combo2) here field1 is a string and field2 is integer.if field2...

Visual Basic: simple exercise and examples, simple exercise, joe matt
simple exercise, joe matt, visualbasic: there is no single site which completely answers all your topics free. i also help out in vb 2005 and 2008 for a fee. here are some links www.startvbdotnet.com/ www.imt.net/~joe/matt/program/vb/Tutorials/ www.vbdotnetheaven.com/ http://visualbasic.about.com/od/learnvbnet/a/LVBE_L1.htm...

Visual Basic: VB .net query, code timing, profiler
code timing, profiler: If you use the Visual Studio Enterprise Developer Edition, you will find that it includes some very powerful profilers which let you do exactly that. However, the Enterprise Developer Edition is really expensive so I m not sure if this option is viable for...

Visual Basic: VB & SQL related question, esql, combo boxes
esql, combo boxes, datagrid: the sql can be done in this way Dim esql As String esql = select * from testable where RunnerNo= & & Combo1 & the above code is if RunnerNo is a string if it is an integer then esql= select * from testable where RunnerNo= & val(combo1)...

Visual Basic: Word macro Save As file name but as a html type at the root of H: drive, word macro, 599cd
word macro, 599cd, html type: The SaveFileName is where you specify the name of the file… you can make that whatever you want. This code will save your data as a normal TEXT file, and all an HTML file is, is just a plain text file with the HTML extension. It should work OK. Let me...

Visual Basic: Access database filtering combo box, pit project, material code
pit project, material code, combo box: Just use a WHERE clause in the SELECT statement for the combo box rowsource - OR make a query that filters your results. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts...

Visual Basic: Microsoft Access, query fields, math operations
query fields, math operations, format material: Just include the FORMAT function with your calculated field: BlockID = Format([Material_Code], 000 ) & _ & … Here s a tutorial covering calculated query fields… It sounds to me like you just need to learn how to properly create CALCULATED QUERY...

Visual Basic: Programming Help, using visual basic 6, string x
using visual basic 6, string x, 599cd: You can t do that. You d have to have different conditions for each operator type. If MyType= then if A B then whatever elseif MyType= then if A B then whatever etc. Let me know if you have any other questions or comments. Also, be...

Visual Basic: Programming Help, arithmetic operators, using visual basic 6
arithmetic operators, using visual basic 6, string x: you cannot assign the arithmetic operators to a string you need to write a function based on the choice of operator select case Combo.text case do this case do something else else do third thing etc i do not follow the logic in...

Visual Basic: question, activex dataobjects, ms access database
activex dataobjects, ms access database, jet oledb: change the first textbox into a combobox and add this code making changes as needed: better to have the runners nos in a combobox rather than a textbox. put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim...

Visual Basic: Reading/Writing INI, google search, scripting runtime
google search, scripting runtime, text boxes: Sounds like you just need to use basic FILE I/O to write/read a text file. I cover this in my VB201 and 202 tutorials. Sorry, it s a bit too much to go into here, but if you don t want to pick up the tutorials, I m sure you can find some code with a Google...

Visual Basic: Saving a color to a datafile, google search, color dialog
google search, color dialog, program loads: I would just use a simple text file. Write out the information, then read it back in next time the program loads. I m sure you can find info on basic text file I/O with a Google search (or on my web site with my tutorials). You could also use registry...

Visual Basic: specific question, tips access, 599cd
tips access, 599cd, video tutorial: Recordsets are basically objects you can use in VBA code to edit, add, and delete records. They give you the power to do pretty much anything you want to your data using VBA code. Here s a FREE video tutorial on how to use Recordsets: http://599cd.com/tips/access/recordsets?key=AllExperts...

Visual Basic: Urgent Help!!!!!!!!!!!! VB6 Saving, open filename, random access
open filename, random access, input data: your code makes my head spin. why add comments when you dont know what is to be written. normally i dont read lengthy codes:it wastes my time. at one look, i fail to understand what is listitem, gridClick etc are doing. Also your line open filename .......

Visual Basic: VB Query, ms access database, recordsource
ms access database, recordsource, adodc: to a button click add for such an event follow these steps: for ADODC recordsource initially you would have pointed the adodc1 to the table named testable and add this code: Private Sub Command1_Click() ravi = Chr(34) esql = Select * from testable...

Visual Basic: VB6.0, package and deployment wizard, mydo
package and deployment wizard, mydo, runit: save the project. in menu File _ make poject exe .runit. if there are errors correct then and make the again to have the files in the project you need to have paths of any file as app.pathmydo.doc then use package and deployment wizard..available instart_programmes_...

Visual Basic: VB6 installation, package and deployment wizard, s system
package and deployment wizard, s system, registry settings: *which values of the Registry are you changing in client s system? * are you expert enough to know the effect of the changes and handle problems if they arise? *have you made changes in your system s registry using Regedit efficiently? all these questions...

Visual Basic: Visual Basic 6.0, adodb connection, adodb recordset
adodb connection, adodb recordset, adopenstatic: first make a DSN in control panel admin tools data sources. start the sql server in vb use the connection object Private Function connect() Set conn = New ADODB.Connection Set rec = New ADODB.Recordset Set rec1 = New ADODB.Recordset esql =...

Visual Basic: vb connectivity, activex dataobjects, jet oledb
activex dataobjects, jet oledb, microsoft activex: put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn As ADODB.Connection, rec As ADODB.Recordset Private Sub Form_Load() Set cn = New ADODB.Connection Set rec = New ADODB.Recordset cn.Open ( Provider=Microsoft.Jet.OLEDB.4.0;Data...

Visual Basic: adjusting a listbox within Visual basic, 599cd, allexperts
599cd, allexperts, tamale: I don t understand. Where is your output going? Are you adding this all to a textbox? If so, how? Without seeing your program, I really can t tell you anything more. Let me know if you have any other questions or comments. Also, be sure to visit...

Visual Basic: automatic update jpg in excel, option link, path check
option link, path check, check option: first, it is NOT vb but what is called VBA which is a completely different language and Usage. the way to do it is to insret an Object in excel sheet and choose create from file and point it to your picture s path. check option Link to file. each time...

Visual Basic: to display data in a listbox after updating a database, jet oledb, rec1
jet oledb, rec1, adopenstatic: 1) it is not a good idea to use Table as the Name of table. it is a Keyword. Again the word Key is wrongly used. change the name to Id or some such 2) before adding items to listbox you need to list1.clear to remove previous items instead of If rec1.Fields(0)...

Visual Basic: About Flexgrid Control, loading data, combobox
loading data, combobox, combo box: camt understand what you are trying to achieve. there is no sense to me loading data from a combobox to flexgrid. why duplicate data? again and you say transfer all data ... makes no sense to me/ the alternative is to plan exactly what you want and why...

Visual Basic: MS Excel VBA, Mailing Address Question, rich text document, excel vba
rich text document, excel vba, blank cells: Yes, Ross, you could certainly do this, but it s probably going to involve some serious programming. Since you can t tell what data is where (line 2 could be an address, or a company name - who knows) you re probably STILL going to have to go down and review...

Visual Basic: mysqk and dsn from client to other, adopenstatic, hi friend
adopenstatic, hi friend, 599cd: You won t be able to use a DSN named on the server from a remote workstation. See: http://support.microsoft.com/kb/168336 Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts...

Visual Basic: Path vs. File, 599cd, allexperts
599cd, allexperts, free tutorials: You would just say: X = Dir( C:Bluecow.jpg ,vbDirectory) If X = then DirectoryFound = FALSE Easy enough? Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts...

Visual Basic: prevent the data table form duplicate Entry with vb 6 application, adlockoptimistic, gotfocus
adlockoptimistic, gotfocus, vb 6: you have too many mistakes in the code: 1) what is Bool here and where is the value. 2) there is no End Select and other values for Case 3)you do not update the Emp No. it is automatically added as you have used the Primary Key. if you remove the...

Visual Basic: prevent the data table form duplicate Entry with vb 6 application, gotfocus, vb 6
gotfocus, vb 6, primary key: you should not enter the Primary Key. it is automatically updated. anyway the description you have given is too cumbersome to read. to avoid duplicates, you can create a loop which will check all the records with the entered no and sees that it is not...

Visual Basic: How to read specific integer in the line of text file, line answer, question thanks
line answer, question thanks, string 1: from VB you cant directly read a particular line. you need to loop thro all the lines and check for a particular character, say 2 and what is the idea of such a procedure? cant you change the textfile?change the zeros, have line nos. then you can directly...

Visual Basic: Search or Find Codes, ms access database, esql
ms access database, esql, satellite provider: 1 which isthis country satellite provider? 2 you need use a recordet using dim esql as string esql= select * from YOurTableName where FieldName1= & &text1 & rec.opem(esql),conn,adstatic...readonly if rec.recordcount 0 then display it...

Visual Basic: Search method(VBA-Excel), radio buttons, spread sheet
radio buttons, spread sheet, search method: your statement I have an application in VBA and MYsql as database does not make sense to me. where is Excel here? VBA is a language used in excel /access and there is no application here. you have mysql database, userform, excel, ... does not sound...

Visual Basic: String handling, vba code, zahl 60
vba code, zahl 60, result string: If you re working with Excel, why not just use the HOUR and MINUTE functions in a cell? =HOUR(A1)*60+MINUTE(A1) You don t need complex VBA code to figure out the number of minutes past midnight a time is. There are many different techniques in Excel...

Visual Basic: VB6 Combo Box, combo boxes, database programs
combo boxes, database programs, 599cd: Database programs like Microsoft Access have this behavior, but VB6 combo boxes do NOT. You d have to program your own special control or look for a 3rd-party ActiveX control that has this. Let me know if you have any other questions or comments. Also,...

Visual Basic: VB8 february dates, date check
date check: There are several useful functions in VB .NET to help you with date computation. If you look up the date variable class in the help system, you will get a long list of things to help you. In the meantime, there is the IsDate function which can help you right...

Visual Basic: vb6 & ms access - run time error 13 type mismatch, run time error 13 type mismatch, run time error
run time error 13 type mismatch, run time error, run time error 13: 1) how many records are there in the db? 2) where is the data now from which you are entering? 3) i shall do the job if you are willing to pay me a fee.(dont ask me how much. tell me how much you are willing to pay. My rates come high) if you are ok with...

Visual Basic: World time clock, world time clock, google search
world time clock, google search, webbrowser control: Well, if your time clock doesn t need to be EXACT (to the second) then you could just insert a WebBrowser control in your form and then read one of the public Web-based time servers. That s not too hard to do, but unfortunately it would take me far too long...

Visual Basic: Auto update chart, interest types, that would allow users
interest types, that would allow users, auto updates: yes even without password you can copy the range as follows.by mistake i thought Access instead excel. to copy and paste the range from another WB use these code : Sub Macro1() Open Source protected workbook Workbooks.Open Filename:= C:Book1.xls...

Visual Basic: ado connectivity, field queries, sql server
field queries, sql server, text2: let your sql server be running open control panel_Admin Tools-ODBC create a user DSN give it a name say Test. point it to your database.save and exit in adodb --- Option Explicit Dim cn As ADODB.Connection, rec As ADODB.Recordset Private Sub Command1_Click()...

Visual Basic: How to append another text entries to the existing .txt file?, call loggers, text entries
call loggers, text entries, textboxes: change this line i.e. For Output to Append Open c:Call_Loggers.txt For Output As #nFile to Open c:Call_Loggers.txt For Append As #nFile and after MsgBox Settings Saved paste these lines Me.txtSN = Empty Me.txtName = Empty...

Visual Basic: Calendar in Excel, question sign, 599cd
question sign, 599cd, allexperts: This tutorial isn t exactly what you want, but it does cover changing cell colors and should get you started: http://599cd.com/tips/excel/extend-conditional-formatting/?key=AllExperts Let me know if you have any other questions or comments. Also,...

Visual Basic: Changing criteria by combobox., query parameters, old dogs
query parameters, old dogs, field column: Peter, I only ask for brevity because some people type in their entire life story before getting to the question. I assure you if you ve asked a question of me in the past, I always respond - even if the response is I can t help you. Anyhow, I need to...

Visual Basic: Compact and repair access 2003, newname, compacts
newname, compacts, pwd: use the following code ====================== Dim OldName Dim NewName DBEngine.CompactDatabase App.Path & urOlddb.mdb , App.Path & urNewdb.mdb , , , ;pwd=urpassword Kill App.Path & urolddb.mdb OldName = App.Path & urnewdb.mdb : NewName...

Visual Basic: Creat relativity., record source, load time
record source, load time, relativity: you can not create relation between forms.you need tables to create relations between them. for example if you have table named as tblEmployee and another table named as tblActivity with the following fields tblEmployee tblActivity...

Visual Basic: Creating interactive AVI program in VB, AVI
AVI: Yes, but you need a control to play the AVI for you (writing one for oneself would require CODEC programming, not an easy thing to do), and the only one I know of is included in a suite of controls costing more than 1000 USD. If you are interested of spending...

Visual Basic: confusion in a program s algo, pine apple, frame area
pine apple, frame area, check boxes: Make a form from the tool box Click Frame (just below label displayed as A) and place it on the form Next : from toolbox click Check box and place within the frame area as many check boxes as you want. say for example : Mango/Orange/Pine Apple Down...

Visual Basic: data report based on query, datareport, code option
datareport, code option, dataenvironment: put a dataenvironment on form and point it to your database add a command it its sql properties in the textbox enter Select * from testable where item=? where testable is your table and item is the fieldname add a datareport and drag all...

Visual Basic: datacombo in vb, datacombo, mdi form
datacombo, mdi form, connectionstring: your connection string is wrong and you need to open the connection which you have not done. also you need to call the fillcombo from a commandbutton click the code is incomplete also. and with all that it will not auto load into combo box, after opening...

Visual Basic: datareport in vb6.0, datareport in vb6, jet oledb
datareport in vb6, jet oledb, dim rs: for datareport use a Dataenvironment control. add this to the form and for dataenvironment you add the select .. no dynamic no adodb nothing then your string select .. is wrong select ... where Debit = & val(txtNo.txt) you drag the fields from...

Visual Basic: delete records from the selected in list, jet oledb, open recordset
jet oledb, open recordset, adlockoptimistic: what is the code you used for Conndb. you have not used open recordset object as I mentioned in this code rs.Open SELECT * FROM tblProduct ORDER By ProductId , dbs, adOpenDynamic, adLockPessimistic, adAsyncFetch need full code to check at my end...

Visual Basic: entering data in a form, command buttons, dbs
command buttons, dbs, access database: Paste this code in any module To open databse --------------- Public rs As DAO.Recordset Public dbs As DAO.Database ______________________________________________________________________________________________ Public Sub ConnectAccessDb() ...

Visual Basic: error 13, jet oledb, type mismatch
jet oledb, type mismatch, int datatype: I don t know what is your table. However below is the connection details and update commands. I hope this should solve your problem. In Module ************* Option Explicit Public gstrUserName As String Public rs As ADODB.Recordset Public dbs As...

Visual Basic: export, adodc, export option
adodc, export option, ms access: 1)the datagrid gets the data from ADODC which gets the data from access table. that is the purpose of the datagrid. if you have got some other data you need to use createobject(filename) and pass the data using a loop. it is cumbersome but can be done. ...

Visual Basic: export, excel application, ms access
excel application, ms access, cells: 1 Try with the following codes: Private Sub cmdExport_Click() Dim oExcel As Object Set oExcel = CreateObject( Excel.Application ) Dim oWorkBook As Object Dim oWorkSheet As Object Dim i As Integer, k As Integer Dim lRow As Long Dim LastRow As Long...

Visual Basic: flexgrid, activex dataobjects, jet oledb
activex dataobjects, jet oledb, microsoft activex: to display all records you can use flexigrid or datagrid or dbgrid. depends on your coding check mark on Projects_References_ Microsoft ActiveX dataobjects Libray 2.0 to display in msflexgrid Option Explicit Dim conn As ADODB.Connection, rec As ADODB.Recordset...

Visual Basic: Hide block Textbox, option boxes, wife name
option boxes, wife name, checkbox: You need to check the value of checkbox. for example if chkbox1 is for single and chkbox2 is for married then check as follows : If chkbox1=true then Me.txtboxWifename.enabled=false else Me.txtboxWifename.enabled=True endif hope this will...

Visual Basic: Hiding columns if blank to update chart, graph data, index line
graph data, index line, access vba: Christina I am sorry for the delay. I was working on a databse mailed to me by Michael. I would look up your question on saturday if it suits you, I have taken vacation for this purpose. On sat I will work on your problem. It would be appreciated if you could...

Visual Basic: listview, listview
listview: I m afraid there is no way to do that - the control does not support that. However, there are some listview controls by 3rd party manufacturers that can do that, but they are not cheap. If you want the names of the manufacturers, get back to me. Yours,...

Visual Basic: How to lock the particular rows in DATAGRID, ms access database, jet oledb
ms access database, jet oledb, retrieving records: In any module add these code and variables ---------Variables for Adodb connection Public rs As ADODB.Recordset Public dbs As ADODB.Connection -------------Code------------ Public Sub AccessConnectADO() Set dbs = New ADODB.Connection Set...

Visual Basic: Magnification, optical glasses, angular size
optical glasses, angular size, eyepieces: actually this is not vb question. However I am trying to explain a little bit if you want to know the meaning and use formula in vb6 Magnification is the process of enlarging something only in appearance, not in physical size. like used in optical glasses.in...

Visual Basic: message box: sum of cells must be less than 100%, input cells, oh my goodness
input cells, oh my goodness, f77: In F78 use formula instead manually input by user i.e. Sum(F75:F77) and paste the following codes . Private Sub Worksheet_Calculate() If ActiveCell.Address = $F75$ Then Exit Sub If Cells(75, 6).Value + Cells(76, 6).Value 100 Then MsgBox...

Visual Basic: datagrid, ms access database, database path
ms access database, database path, cursortype: have you placed the adodc control and named it adodc1. when message box flashes message for invalid and unqualified reference click Debug instead End.This will take you to the line having problem in coding. if possible send me your project file at aziz_abroad...

Visual Basic: Propertybag, string str1, avail
string str1, avail, programmer: To test the property write and read method just paste this code to form load event. Dim objBag As New PropertyBag _____________________________________________________________________________________ Private Sub Form_Load() Dim Str As String, str1...

Visual Basic: Public Variables in VB 6, public variables, form1
public variables, form1, adu: what is the hangup about using a module as that is the proper method. however you can call the variable from another form using this method let us say there is label1 in form 2 In Form1 to a command1 click add Option Explicit Public adu As Integer...

Visual Basic: Require SQL Query, date1, format date
date1, format date, yy: this is a concatenation problem. vb gets confused about the character. use this way out: Dim GOOD As String GOOD = Chr(35) date1 = Format(#10/3/2000#, MM-DD-yy ) date2 = Format(#10/4/2000#, MM-DD-YY ) here you can put any other date like...

Visual Basic: if and statements in vb, range target, target address
range target, target address, address value: Place Stop after this line to break the code If Target.Address = $G$59 OR Target.Address = $G$61 Then now from the View menu click immediate window in immediate window paste this code and check the value Range(Target.Address).Value = no ...

Visual Basic: Transfer Data, access databse, import dialog
access databse, import dialog, option2: I can sure help you if you provide me with complete details like: Which option you choose to import excel file Option1 Or Option2 If option2 then there should not be any problem.To avoid delay send me your excel file and access databse to check at my...

Visual Basic: VB 6......., karens replicator, development wizard
karens replicator, development wizard, vbrun: it does the same job as the package. it is meant for persons who dont have vb installed in their computer. it gets the same vbrun dll files, along with installer files (large size) also try it a few times and then you will see the problems i dont see your...

Visual Basic: VB 6.......PRINT out, open paint, datasource property
open paint, datasource property, key print: do you wish to print Form Image this can be done by double clicking form. Then File--- Print---- Form Image alternatively, After double clicking form from Project explorer,press Alt Key + Print Screen. Now open paint and paste the image. In paint remove...

Visual Basic: VB menu error, array element, control array
array element, control array, menu name: I assume you have same menuname for 2 menus. Try Like this File caption : &File menu Name : mnuFile ...New caption : &New menu Name : mnuNew ...Open caption : &Open menu Name : mnuOpen hope this will not flash any error...

Visual Basic: validation, focus event, gotfocus
focus event, gotfocus, data input: check with Isnumeric function as follows : Private Sub txtPrdDesc_GotFocus() If Not IsNumeric(Me.txtPrdId) Then Me.txtPrdId = Empty Me.txtPrdId.SetFocus End If End Sub you will notice from the above code that...

Visual Basic: vb6, correct reply, timer control
correct reply, timer control, mdi form: your question is not fully clear. how have you displayed time using time function or a timer? are you using a MDI form with child forms or series of forms? you can close all forms with unload me when the time = 0 or 2 mts + or whatever (the current...

Visual Basic: vb6 database, package wizard, application folder
package wizard, application folder, program database: if using package wizard you have added your databse file then uninstallation will all the files you have added. and if you have manually copied data file then it should be in application folder. database removed by uninstallation is not recoverable using...

Visual Basic: visual basic, rowheight, commandbutton
rowheight, commandbutton, ht: as far as i know, the button is not part of msflexgrid, but you can place commandbuttons on rows by this sample code after you place a commandbutton of 255 ht and width and adding code: Private Sub Form_load() Command1.Height = MSFlexGrid1.RowHeight(1)...

Visual Basic: visual basic 6.0, adodb connection, jet oledb
adodb connection, jet oledb, adopendynamic: this is not the way to get balances into the account. your table needs to be redesigned.create a new query which has a calculated field. no need to calculate balances; it should be done automatically. i can show you the query if you are willing to pay...

Visual Basic: word conversion from one language to another, dictionary program, vb program
dictionary program, vb program, word conversion: you can use office file object to search with the following codes Dim objFSO, objFileStream, sFileName as string, sFileBuffer as string, sSearchValue as string, bValueExists as boolean sFileName = c:file.txt Path to file sSearchValue = textbox1.value...

Visual Basic: this is actually a follow-up of the last question, follow ups, secure network
follow ups, secure network, last question: i agree it is too many follow ups. here s how it goes split the string using left and right functions. use day and month functions to get month and date using Public Function getMonthName(date) get the month name concatenate them store it to a variable...

Visual Basic: coding, userinterface, null values
userinterface, null values, combobox: create a form as follows : Place a combobox for user name , 1 textbox for password and 2 commandbuttons (Login and Change Password) The users and their password should be stored in tables. when user clicks Login button first check for null values in...

Visual Basic: How to connect Visual Basic 6.0 with Microsoft Excel. I want to know the code., excel application, project references
excel application, project references, documents and settings: under project References, check Microsoft Excel object Library and add this code: Dim xl As Excel.Application Dim strFileName As String Private Sub Command1_Click() Set xl = CreateObject( excel.Application ) xl.Workbooks.Open ( C:Documents and...

Visual Basic: converting string to date (vba in excel), case 2, vba
case 2, vba, nyu: i presently do not remember the function which i used some years before but here is a way in a module create a public function Public Function GetMonthName(olage As Integer) Select Case olage Case 1 GetMonthName = Jan Case 2 Case 7 GetMonthName...

Visual Basic: excel - VB, worksheet menu bar, macro security
worksheet menu bar, macro security, code windows: use the following vb code in excel vb window i.e Tools--- Macro--- Visual Basic Editor In vb editor click Project Explorer in View menu. From Project Explorer double click This Workbook and in code windows paste the code : ________________________________________________________________...

Visual Basic: VB Web Broswer Address Bar - how to show the current address?, system windows
Visual Basic: VB Web Broswer Address Bar - how to show the current address?, system windows

Visual Basic: Get file path, file selection
file selection: Among the controls provided with VB.NEt is one called OpenFileDialog. Drop that on your form, select it and press F1 key to call up the help. You will find detailed instructions on how to operate it there. The control will display the standard Windows fils...

Visual Basic: hi, store receipts, rst
store receipts, rst, wizard: cmdNewRecord (Add new Record) ------------------------ Private Sub cmdNewRecord_Click() DoCmd.GoToRecord acDataForm, Store Receipts , acNewRec End Sub cmdDelete (Delete Current Record) ---------------------------------- Private Sub cmdDelete_Click()...

Visual Basic: output access data to word, odoc, orange text
odoc, orange text, word range: use ado or dao recordset DAO ---- Dim dbs As DAO.Database Dim rs as DAO.Recordset Dim StrOrder as String Set dbs = OpenDatabase(App.Path & AccessTableName.mdb , False, False) Set rs = dbs.OpenRecordset( SELECT * FROM tblScore , dbOpenDynaset)...

Visual Basic: output to word doc, report wizard, report layout
report wizard, report layout, info thanks: In a nutshell, set up the report that you want to export to Word. Use minimal formatting because most of it won t copy through well to Word. Now, if you want to be able to select a specific customer, then on your customer form, make a button that opens...

Visual Basic: Printer Orientation, printer orientation, smsg
printer orientation, smsg, app title: Default Printer --------------- on a form place a listbox named as LisBox1 and a command button as Command1. In the form code window paste the following codes : Option Explicit Private cSetPrinter As New cSetDfltPrinter Private Sub Command1_Click()...

Visual Basic: Printing in VB6, paper orientation, datareport
paper orientation, datareport, intermediate knowledge: it is not a vb problem. sometimes the pagedefaults or printer default gets locked at Landscape. to eliminate printer s faults, create a new printer from start_Settings_Printers choose add printer and see if its drivers are automatically installed. set this...

Visual Basic: getting run-time error 94, run time error, adopenstatic
run time error, adopenstatic, adopendynamic: the execute method gives this problem if you use recordset property then you can check if rec.recordcount 0 then ..it produces no error but in the above code you can add dim v as variant esql = select * from .... and so on rec.Open (esql),...

Visual Basic: Save command button, command button, access connection
command button, access connection, addnew: you didn t specify how you are connecting to your database. For DAO Access connection ------------------------ Set dbs = OpenDatabase(App.Path & urdb.mdb , False, False, ;Pwd= urpassword ) Set rs = dbs.OpenRecordset( SELECT * FROM urtblname , dbOpenDynaset)...

Visual Basic: Sendkeys & Different Focused Windows, clip art window, 599cd
clip art window, 599cd, question sign: You need code to switch to another open program application. I have done this before, and I know it s possible, but I don t have code handy. There is a Windows API call you can use. Try searching Google for VB switch to window and I m sure you ll find it....

Visual Basic: Snyconize the boxes, three boxes, parameter query
three boxes, parameter query, ref name: one doesn t need to have VBA, it is part of Office suite for excel, word etc. the trouble in this case, the second table is not necessry. you could use a function to check the grade or whatever and store the progress. it is not just coding but redesign...

Visual Basic: SQL SCRIPT, sql table, column name
sql table, column name, form1: Use the following code instead: kata = SELECT * FROM tbmasuk WHERE Tanggal_masuk Between & Format(Me.DTPicker1, mm/dd/yyyy ) & And & Format(Me.DTPicker2, mm/dd/yyyy ) & ORDER By Tanggal_masuk you have only 2 records in your sql table...

Visual Basic: SQL SCRIPT, sql server 2000, listview
sql server 2000, listview, sql2000: check with the following : SELECT *, Tanggal_masuk AS Expr1, tbmasuk.* FROM tbmasuk WHERE (Tanggal_masuk BETWEEN CONVERT(DATETIME, dtpicker1, 102) AND CONVERT(DATETIME, dtpicker2, 102)) **********Revised Solution******* use the following...

Visual Basic: Microsoft Outline control Menu, outline control, control menu
outline control, control menu, tree menu: I have uploaded the Project with 2 forms. The form opens when you click Product master it opens product master form and when user clicks supplier master from treeview,the Supplier form loads and show on the screen. Outline control I am unable to understand....

Visual Basic: treeview vb6, ms access database, tree structure
ms access database, tree structure, mail: send me your database : aziz_abroad at yahoo.com if needed I will add fields to your database.Also explain how would you like to display the Tree. for example Treeview structure should be as follows Parent1 SubChild11 SubChild12 ... and...

Visual Basic: VB 6.0 Web Browser, system32 directory, plug ins
system32 directory, plug ins, system32 folder: lloks like a problem with your registry. first check if there are 2 ieframe.dll s in the system32 directory. check the filename then you need to check for this item in the registry and remove the entry 1. this could be a problem with your vb installation...

Visual Basic: VB code for ms access, activex dataobjects, jet oledb
activex dataobjects, jet oledb, microsoft activex: better to have the runners nos in a combobox rather than a textbox. put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn As ADODB.Connection, rec As ADODB.Recordset Private Sub Form_Load() Set cn =...

Visual Basic: VB pdf reader, web browser control, vb oracle
web browser control, vb oracle, reply thanks: method 1: use a web browser control on the vb form Option Explicit in the dialogbox uncheck always ask Private Sub Command1_Click() Dim adu As String adu = E:current arpana.pdf WebBrowser1.Navigate adu method 2 using pdf reader ( you can use...

Visual Basic: VB Web Broswer Address Bar - how to show the current address?, URL, webbrowser
URL, webbrowser: This will work, however, the user is required to enter a fully qualified URL into TextBox1 (i.e. http://www.microsoft.com): Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged ...

Visual Basic: VB6 Programme Install File, dos shell command, package and deployment wizard
dos shell command, package and deployment wizard, visual studio 6: Use the PACKAGE AND DEPLOYMENT WIZARD that comes with Visual Studio 6. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts Cordially, Richard...

Visual Basic: Visual Basic, datagrid, connection string
datagrid, connection string, textboxes: you can use adodc control to display data in datagrid. make several buttons on the form that contains datagrid control (like Save/Edit/delete) and several textboxes same as the count of datagrid columns. For save use connection string to save the contents...

Visual Basic: Visual Basic Program, datareport, code option
datareport, code option, commandbutton: datareport requires dataenvironment(available in your project) you could filter the command for dataenvironment with a? put a dataenvironment on form and point it to your database add a command it its sql properties in the textbox enter Select...

Visual Basic: vb 6.0 question, best solution, insertion
best solution, insertion: this lockoptimistic etc does not prevent any insertion or update. If 2 persons are using this at the same time the latest updated data is not avilable to the second user until the procedure ends in the first user. there os no best solution but only suitable...

Visual Basic: vb6+access, microsoft data access, data access objects
microsoft data access, data access objects, predefined database: dynamic table creation is not advisable. anyway here is one method: put a command button, text box on a form and enter this code Dim db As Database, rec As Recordset, tabname As String, esql As String check Microsoft Data Access Objects under Project...

Visual Basic: visual basic 6, Intermediate, microsoft access data base, jet oledb
microsoft access data base, jet oledb, esql: add an imagelist and add 2 images, 1 command button add this code T is the name of Treeview Option Explicit Dim conn As ADODB.Connection Dim rec As ADODB.Recordset, esql As String Dim nodX As Node, nodY As Node Private Sub Command1_Click() Do While...

Visual Basic: Autonumber, mail id, yahoo
mail id, yahoo: send me your project so that i can find out where you have the problem. at present i do not have the sample project for the question i answered. it is in another computer so i can upload it tommorrow only. my mail id : aziz_abroad at yahoo dot com ...

Visual Basic: access2007-VB programing, transport database, shot image
transport database, shot image, proper advice: i shall help you build the project but the codes and forms will be in access 2003. if you want it only in 2007 it will take more time as i am moving to a different location on project work for 2 months. for access 2003 i shall help you for the whole project...

Visual Basic: ask for vb, doing projects, management field
doing projects, management field, word of mouth: most of the Companies do not see your CDs, etc showing your projects. the idea in doing projects is only to increase your confidence to tackle any given project. the way to get into a job is thro ads in naukri.com and various other sites. follow these...

Visual Basic: DataBase, hightlights, parameters
hightlights, parameters, store text: if idproducto store text data then ================================== Data2.RecordSource = SELECT Cantidad1 FROM 1Cantidad where IdProducto = & txt_c1.text & otherwise ========= Data2.RecordSource = SELECT Cantidad1 FROM 1Cantidad where IdProducto...

Visual Basic: Dirlistbox, testd, filelistbox
testd, filelistbox, mr aziz: save it to temp table. suppose make an access table say tblPath with field pathId,fldDetails I assume you need to store only 1 record and update this record as and when user select drive and path. ********Additional Comments********* I think helping...

Visual Basic: datareport, datareport, dataenvironment
datareport, dataenvironment, sql: there is no code for datareport. have a dataenvironment in the project and point it to your table in access. then create a command1 and set its property by having an sql like select * from your tablename you need to set the datareport s property by pointing...

Visual Basic: find data, combo box, student database
combo box, student database, sample database: I have uploaded a sample database at http://rapidshare.com/files/343697378/StatusFilter.zip.html in this database you will see a table(tblStatus with total 25 records having status a=7 records,status b=8 records and status c=10 records). double...

Visual Basic: form design, temperature measurement, smoke detection
temperature measurement, smoke detection, colour background: aspect ratio Certain sizes of rectangle are more pleasing to the human eye e.g. where the ratio of width to height is 1:1, √2:1, 5:4, 4:3 or 16:9. Either landscape or portrait, if you get your layouts to work around these sizes of panel they will look...

Visual Basic: help me please vb, visual basic 3, names project
visual basic 3, names project, project group: .vbp = visual basic 6 project file .mak = visual basic 3 project file .vbg = Visual Basic Project Group File The following description tells window to display only vb file names : Project Files{*.vbp;*.mak;*.vbg}|*.vbp;*.mak;*.vbg The first...

Visual Basic: image saving in local system using vb6.0 coding, common dialog control, drive path
common dialog control, drive path, environment project: You can use FileCopy Command as follows : Private Sub Command1_Click() FileCopy H:FolderNameFilename.jpg , D:FolderNameFilename.jpg MsgBox Completed End Sub H: is the mapped drive (Server Shared folder) on your local machine....

Visual Basic: Modal panel, modal panel, modal form
modal panel, modal form, mousemove event: It would rather involved then because you d have to find every control (other than those inside the panel) and program the MouseMove event for them to set a flag when the panel is visible and the mouse is outside the X/Y coordinates of the Panel. You d have...

Visual Basic: Msflexgrid, customer appointment manager, appointment management
customer appointment manager, appointment management, string 11: send me project at aziz_abroad at yahoo dot com **************Code************ Private Sub cmdByEmp_Click() Dim j As Integer j = 1 Call connectdatabase DRs.Open select * from Tbl_emp_Appointments , cn, 1, 3 Do While Not DRs.EOF ...

Visual Basic: making data entry form, activex dataobjects, jet oledb
activex dataobjects, jet oledb, microsoft activex: if you are willing to pay a nominal fee i can do it for you. if you want just the tip here it is: to addnew use this: put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn As ADODB.Connection, rec As...

Visual Basic: need your help please,thanks, visual basic 3, vbg
visual basic 3, vbg, names project: .vbp = visual basic 6 project file .mak = visual basic 3 project file .vbg = Visual Basic Project Group File The following description tells window to display only vb file names : Project Files{*.vbp;*.mak;*.vbg}|*.vbp;*.mak;*.vbg The first...

Visual Basic: PDF Reader in VB 6, resource folder, shell command
resource folder, shell command, adobe reader: you can use Shell command ... check the code below : Private Sub Command1_Click() Dim varPdfReader, varPdfFile As String Change the path to the location of adobe reader i.e. AcroRd32.exe varPdfReader = C:Program FilesAdobeReader 9.0ReaderAcroRd32.exe...

Visual Basic: please give me help, microsoft data access, microsoft data access components
microsoft data access, microsoft data access components, jet oledb: first, better change to ADODB as it gives a better grip on your code. this is the method: this needs some knowledge of ADO, suggest reading a book or goto garybeene.com for a free tutorial on ADO. It is also a new chapter for you and you cannot just get...

Visual Basic: please help,visual basic, visual basic 3, vbg
visual basic 3, vbg, names project: .vbp = visual basic 6 project file .mak = visual basic 3 project file .vbg = Visual Basic Project Group File The following description tells window to display only vb file names : Project Files{*.vbp;*.mak;*.vbg}|*.vbp;*.mak;*.vbg The first...

Visual Basic: please please help me with these,thanks, population, quotes
population, quotes: select * from tblState where fldPopulation 10000000 is correct select * from tblState where fldCapital like S% is correct see single quotes or you should enclose as select * from tblState where fldCapital like & S% select *...

Visual Basic: Question visual basic, adodc, date1
adodc, date1, format date: first you need to filter it using the dates between as in code below Dim GOOD As String GOOD = Chr(35) date1 = Format(#10/3/2000#, MM-DD-yy ) date2 = Format(#10/4/2000#, MM-DD-YY ) here you can put any other date like format(date, mm-DD-YY...

Visual Basic: repetition my Question, aziz ahmad, ahmad 1
aziz ahmad, ahmad 1, adodb recordset: I am unable to understand you question. you first wrote now i would when text1= aziz and text2= ahamad then text3 Automatic write 1 so i gave you code to automatically get the code. now in new case for testing duplicate entry use the below...

Visual Basic: repetition structure, repetition structure, value defaults
repetition structure, value defaults, loop value: a) If you omit the STEP stepValue clause, then incremental value defaults to 1 =========== for example =========== For i = 1 to 100 Step 1 x= x+i Next In the above loop value of x will icrease by 1...

Visual Basic: SYSDES, timer interval, vely
timer interval, vely, cury: normally a picturebox on form with animated gif will do or you could have an image and add a red ball ico or gif , and a timer(interval 200) or it and add this code Option Explicit Dim curx As Integer, cury As Integer, velx As Integer, vely As...

Visual Basic: search and show result in datareport, mail id, adodc
mail id, adodc, database database: place a button on form3 and name it cmdReport create command2 under connection1 in dataenvironment1 right click command2 and click properties under SQL Statement paste the following code : SELECT * FROM paigah now create a report say datareport2...

Visual Basic: treeview, rapel, bunga
rapel, bunga, rst: Use the following codes: ========================= Private Sub cmdAddNode_Click() Dim nd As Node, strChild As String, strParent As String, FoldType As Integer If Me.txtParent = Or Me.txtChild = Then If...

Visual Basic: VB, windows notepad, appactivate
windows notepad, appactivate, type string: egs: String sendkeys type string here SendKeys + {INSERT} SendKeys %FN sendkeys string,wait ( wait is boolen, default being false, determines whether the calling...

Visual Basic: VB+Excel, excel application, excel workbook
excel application, excel workbook, command button: Option Explicit Dim xl As Excel.Application Private Sub Command1_Click() Set xl = CreateObject( excel.Application ) Dim adu As String xl.Workbooks.Open ( E:currentMike3December09.xls ) substitute your file here xl.Visible = False adu...

Visual Basic: VB6.0, microsoft data access, microsoft data access components
microsoft data access, microsoft data access components, jet oledb: again you have asked more than one question here. first you must know how to connect to a database: here is how: this needs some knowledge of ADO, suggest reading a book or goto garybeene.com for a free tutorial on ADO. It is also a new chapter for you...

Visual Basic: VB6 could not lock etc (access db), open sessions, blank value
open sessions, blank value, stock system: this is probably due to some settings of the particular computer logged on OR the properties for allow addnew etc in the tables. it could also be due to code which opens dynamic or otherwise. Maybe someone is entering wrong type of data or your conversion...

Visual Basic: VB6 + MS Word 2007, microsoft word object, check microsoft
microsoft word object, check microsoft, explicit check: it is not MIDI but MDI form here is the way to run a word document from your vb form: Option Explicit check microsoft word object library under References. Dim appWord As Word.Application Dim wrdDoc As Word.Document Dim strFileName As...

Visual Basic: VBA script to vlookup from external file, mail id, paste application
mail id, paste application, desktop folder: send me your both xls workbooks i.e workbook running vba code and workbook(file1.xls) also tell me the error description. my mail id : aziz_abroad at yahoo dot com ***********on 09/01/2010******************** use the following code instead your existing...

Visual Basic: Vb database, ms access database, dim rs
ms access database, dim rs, header section: Pretty easy. I don t know how your month is in your database (if it s in a date field or separate field), but I ll assume a separate field for this example. - Create a text field on your Access form in the Header section labelled Month Lookup . - Create...

Visual Basic: Vb database, ms access database, jet oledb
ms access database, jet oledb, esql: you need to filter the records.if you have a date field then month(dateField). this will be a no between 1 and 12 then you could use for a recordset an sql: select * from tablename where Datefield= & 2 for that you need to use adodb. under general...

Visual Basic: Visual basic, manual selection, adu
manual selection, adu, visual basic 6: selecting all items in a listbox does not make sense to me. then why are options given in the first place. anyway this is one method: Private Sub Command1_Click() Dim adu As Integer, i As Integer adu = List1.ListCount For i = 0 To adu - 1 List1.Selected(i)...

Visual Basic: variable contains string, homework question, substring function
homework question, substring function, happy new year: This sounds like a homework question. I ll answer, but you really should experiment with it to understand it. If you don t have access to a VB, just thinking it through logically would work. Your answers are: 1) Input string: Welcome home . So, Mid(strMsg,...

Visual Basic: vb adodc filter method, data base access, sri lank
data base access, sri lank, filter method: Thanks for the new year wishes. here s wishing you the same. it is always better to have names of databases, tables, fields which do not occur in the value as the computer gets confused sometimes as to which is under reference. but an sql like select...

Visual Basic: vb6, microcontroller 8051, minor alterations
microcontroller 8051, minor alterations, mschart control: one such method. add a mschart, adodc to the form and this code: for this the datagrid must be fully visible on the form else you need to alter the code. put mschart1.columncount as 1 and add this code: Private Sub Command2_Click() Dim i As Integer...

Visual Basic: vb6, repetition structures, match
repetition structures, match: question not framed clearly. there must be a condition to check in the loop or match something to stop the loop or it will go endless. for next is wrong, if then will check for a conditon but will not loop . do until is ok if some condtion is given ...

Visual Basic: vb6, do loop, expression
do loop, expression: c. Do Until The expression is evaluated at the bottom of the loop after the statements in the DO Until loop have been executed. If the expression is true, the DO loop does not iterate again. For example Dim n As Integer Do n = n + 1 Loop...

Visual Basic: vb6, crsales, day1
crsales, day1, day2: a. curTotal = curTotal + curSales because at start curtotal would be 0 suppose cursales for day 1 is $500 then curtotal for day1 in loop would be 0+500 but for day2 if crsales is 650 then curtotal would be = 500(day1 sales)+650(day2sales) and so on....

Visual Basic: visual basic, database in access, table database
database in access, table database, d test: no that is not the way. you need to create a database in access or other first manually. Unless you are a master where you can create a table and database dynamically. or are you referring to a backup of an existing table/database. it may be ok but not...

Visual Basic: i want to get an answer to the quetion bellow, microsoft data access, microsoft data access components
microsoft data access, microsoft data access components, datasource property: method1 easy but not comperehensive: put a ADODC control on form (available from rt click on tools panel on left. choose components and choose Microsoft ActiveX Data control. put a check mark) also select a datagrid control. place both on form connect...

Visual Basic: arithmetic operation connecting vb6.0 and ms access, arithmetic operation, sql view
arithmetic operation, sql view, airline reservation: in access, you can develop a query on the seats booked table and get the count of the seats.(using view totals and select count) this field gives the no of tickets booked. the same SQL used in this query (from the sql view of menu) you can copy the sql and...

Visual Basic: Clarify, microsoft visualbasic, word 2
microsoft visualbasic, word 2, text word: Dear Bruce, Let s first make a plan. First step of the plan would be to have a fixed list of calegories, let s say Dogs, Cars, Flags and Cats. Each time user ordering something from particular category we need to know which category it is. To accomplish...

Visual Basic: combo box, listindex, combo box
listindex, combo box, file txt: Dear Chris, The answer to question 1 is yes, you can. As to the number 2 please check this link: http://rhondatipton.net/2006/10/30/reading-data-from-a-text-file-using-net/ It has general explanation how to read data from text file as long as a...

Visual Basic: files search program, program question, command buttons
program question, command buttons, vitaly: Dear Shameem, My job is to help you in solving your problems with code, i.e find errors, suggest the way to solve etc. If you need somebody to write code for you then you are at wrong place: here at AllExperts we are answering questions. Sincerely,...

Visual Basic: Hmm, vb class, text boxes
vb class, text boxes, 599cd: You want to add the VALUE of the text in the box, not the text itself. =VAL(box1)+VAL(box2) I cover this in my introductory VB class. Let me know if you have any other questions or comments. Also, be sure to visit my FREE Tips & Tricks Page at...

Visual Basic: Uppercase, microsoft visualbasic, class answer
microsoft visualbasic, class answer, word string: Dear Bruce, You can use this code: Dim s1 As String If txtWord.Text Then s1 = Microsoft.VisualBasic.Left(txtWord.Text, 1) If s1 Then If s1 Like ( [A-Z] ) Or _ ...

Visual Basic: Using VB for Excel Dialog, excel sheet, data changes
excel sheet, data changes, textboxes: Dear Andy, As far as I can understand, you need to create a form level variables to hold info you entered 1st time. Let say you have 3 textboxes on your form so you will need 3 form level variables sBox1, sBox2, sBox3. If you are using vb.net you ll...

Visual Basic: VB.Net 2010 deploy windows application question, deployment project, application question
deployment project, application question, exe type: vb does not automatically allow upgradation from previous versions. you could try in the build menu of the project and select the publish option it would result in an .exe type which can run without installation. am no too sure it would work on all...

Visual Basic: VBA script for Outlook, excel spreadsheet, vitaly
excel spreadsheet, vitaly, email: Dear Jeff, Can you, please, explain in details what steps are you taking now that you have to do manually now ? I mean, you open an email and then what are you doing EXACTLY? It would also be helpful if you can give me an idea what your standardized...

Visual Basic: Visual Basic, quarters dimes nickels, change application
quarters dimes nickels, change application, mod 10: Dear Vy, Change your processing code: ‘Processing IntMoney = Val(txtShow) Debug.Print (“Money = ” & Ctype(intMoney, String)) intQuarters = intMoney Mod 25 If intQuarters 0 Then Debug.Print (“Quarters = ” & Ctype(intQuarters, String)) intMoney...

Visual Basic: Visual Basic, quarters dimes nickels, change application
quarters dimes nickels, change application, dimes: Dim Q As Integer, D As Integer, N As Integer, P As Integer Dim yeshtu As Integer, temp As Integer Private Sub Command1_Click() If Text1 = Then Exit Sub yeshtu = Val(Text1) Q = yeshtu 25 If Q 1 Then Print Q & Quaters Else Print Q; Quarter...

Visual Basic: Visual Basic: Date changing format when code run, visual basic date, format cells
visual basic date, format cells, yyy: Dear Gareth, So the problem is in Excel sheet itself. Go to Excel sheet, select cell which has date and go Format - Cells. Make sure the cell formatted as Date and choose appropriate format string. If there is no suitable format string(s) try to find...

Visual Basic: vb connectivity with oracle using dsn, adodb connection, jet oledb
adodb connection, jet oledb, oracle table: You can use this code as a sample and update it according to your needs: Private Sub GetConnection() Dim sqlString As String Set conn = New ADODB.Connection conn.ConnectionString = Provider=Microsoft.jet.OLEDB.4.0;Data Source=X:Documents...

Visual Basic: vb connectivity with oracle using dsn, adodb connection, jet oledb
adodb connection, jet oledb, oracle table: You can use this code as a sample and update it according to your needs: Private Sub GetConnection() Dim sqlString As String Set conn = New ADODB.Connection conn.ConnectionString = Provider=Microsoft.jet.OLEDB.4.0;Data Source=X:Documents...

Visual Basic: vb connectivity with oracle using dsn, adodb connection, jet oledb
adodb connection, jet oledb, microsoft jet: Dear Pooja, You can use this code as a sample and update it according to your needs. You ll need special connection string to connect to Oracle. Private Sub GetConnection() Dim sqlString As String Set conn = New ADODB.Connection ...

Visual Basic: Code, elseif
elseif: Dear B.P., First let s ad form level variable dCost for running total; second, let s fill out the source listboxes in Form_load event: Public Class Form1 Private dCost As Decimal Private Sub Form1_Load(ByVal sender As System.Object, ByVal...

Visual Basic: Command Button 1 plus Command Button 2 triggers this event., command button, command buttons
command button, command buttons, command2: How about check boxes for each of your command buttons. In the event for command1 set the checkbox to YES. Same for command2. Then when command3 is checked, look and see if the checkboxes for 1 and 2 are yes. If so, run your event. Let me know if you have...

Visual Basic: delete deduction record, strsql, vbyesno
strsql, vbyesno, transaction form: Private Sub Command1_Click() Dim adu As Integer adu = MsgBox( Want to delete? , vbOKCancel) If adu = 1 Then call Run_query Else MsgBox ( not deleted ) End If End Sub Private Sub RUN_Query Dim SQL_Text as String SQL_Text = Delete...

Visual Basic: Fill in Form Fields in Word 2003 in Visualbasic, text boxes, necessary details
text boxes, necessary details, database table: Dear Donna, I believe it is possible if the numerous documents you mention are the forms themselves. If yes then after you ve got all necessary info on your main form, you create all those numerous documents in you code one by one and fill them out one...

Visual Basic: Listbox looping question, 599cd, allexperts
599cd, allexperts, computer job: You can use the ListCount property of the listbox to determine how many items are in it. I cover this in my VB105 class: http://www.599cd.com/site/courselist/vb/vb105?key=AllExperts Let me know if you have any other questions or comments. Also, be...

Visual Basic: Loops, inputbox, correct input
inputbox, correct input, word value: Dear Bruce, First, add one more form level variable to make sure the new code is not running when form is loading: Public Class Form1 Private bLoading As Boolean = True and at the end of Form1_Load event set it to False: bLoading = False...

Visual Basic: Pass a table field Name to VBA from a form, contract id, dim rs
contract id, dim rs, database table: Dear John, Your code is using this statement: Set db = CurrentDb and CurrentDb is set somewhere else - that s why I need to worn you that this code will not work at all unless variable CurrentDb is representing open database containing your table...

Visual Basic: Program not enabling and disabling buttons, dear ryan, vitaly
dear ryan, vitaly, guess: Dear Ryan, Try to change your code to: evaluates user s guess and displays accordingly If guessTextBox.Text = number Then newGameButton.Enabled = True enterButton.Enabled = False output.Text = Correct! End If ...

Visual Basic: Just a question regarding if then else in VB, case statement, case 2
case statement, case 2, vitaly: Dear Zach, Looks like you should use Select Case statement, something like this: Select Case intSomeIntegerVariable Case 0 Dogs you put here your code for the case...

Visual Basic: Reading a column from a tab delimited text file using vb.net, system entries, visual basics
system entries, visual basics, line input: This can be done without much hassle. I would ask you to look up two commands in the help system, namely Line Input and Split The first will read single lines from a text file and put them into a string, the second will take that string and split...

Visual Basic: Subprogram, usdollars, subprogram
usdollars, subprogram, japanese yen: Dear Vy, From: http://www.terry.uga.edu/~cpiercy/mist4600/lectures/subsfunctions.htm Subprograms Structured programming is a set of standard practices for making program design and maintenance easier and more organized regardless of the language...

Visual Basic: search for a word in a textbox in visual basic, integer index, text1
integer index, text1, office today: Private Sub Command1_Click() Dim Total As Integer Dim Index As Integer Index = InStr(Index + 1, Text1.Text, How ) If Index = 0 Then Print 0 Exit Sub End If ...

Visual Basic: Timer, picturebox, appro
picturebox, appro, increment: Hm, not sure If I understood this correctly, but why dont you use 2 timers? There is no limit on how many timers you can have, so have timer1 start timer2 at the appropiate point. If this is not the answer, please get back to me. Yours, Fran...

Visual Basic: VB Instance Variable, instance variable, dear ryan
instance variable, dear ryan, vitaly: Dear Ryan, Define form level variable: Public Class Form1 Dim GTotal As Integer if user is entering info in Textbox1, then you can use this code for Click event: Gtotal = Gtotal + CType(Textbox1.Text, Integer) Sincerely, Vital...

Visual Basic: VB / MS Acess, document and settings, docmd
document and settings, docmd, excel application: Dear Arif, Run your code once, then check the database: is there still tempQuery existing? If yes, that means you are not deleting it correctly: 1) you do not have rights to Delete, or 2) code to delete Query object is not correct. If this is not...

Visual Basic: VB6, activex data object, jet oledb
activex data object, jet oledb, microsoft activex: the wqm_print is a function to which 3 variables stenicl, optname,opticon are to be passed. the insert statement inserts into a recordset. your code does not do anything. here are 3 samples of insert: Option Explicit put a check mark on Project_References_...

Visual Basic: Visual Bsic, visual bsic, exceptions
visual bsic, exceptions, variables: Private Sub Command1_Click() Dim intNumber As Integer intNumber = Val(txtShow.Text) Select Case intNumber Case 100 To 199 lblShow.Caption = Basement Case 200 To 500, Is 900 lblShow.Caption...

Visual Basic: Visual basic, leap year, georgian calendar
leap year, georgian calendar, leap years: Private Sub Command1_Click() Dim intYear As Integer Dim intOne As Integer, intTwo As Integer, intThree As Integer intYear = Val(Text1.Text) intOne = intYear Mod 4 intTwo = intYear Mod 100 intThree = intYear Mod 400 If intOne =...

Visual Basic: vb6.0, code displays, text boxes
code displays, text boxes, box1: Hi Sneha, When you say it goes to textbox2 on form2, what is that you do actually do to make the itemcode to go from textbox1 to textbox2 ? Is it something like, you are copying textbox1 to a public variable say mitemcode and then you copy it to itembox2...

Visual Basic: Error compiling / debugging, program logic, column headings
program logic, column headings, investment book: Dear Mac, First of all, we need to comment out this statement: On Error GoTo ProgramExit It will look like this: On Error GoTo ProgramExit Run this program again and send me a FULL DESCRIPTION of the error you are receiving It would really...

Visual Basic: POPULATING LISTVIEW WITH FILE CREATION DATE AND TIME, listview control, himadri
listview control, himadri, vitaly: Dear Himadri, To populate listview, please, check this link: http://www.visualwebgui.com/Developers/KB/tabid/654/article/how_to_populate_a_listview_control/Default.aspx To find all files in a specific folder, use For...Each loop for every file in...

Visual Basic: Report generation, sql querry, access databse
sql querry, access databse, dynamic queries: ok, send full details in plain language of what you want. what is the Comb_nameoftheelement etc what is the structure of your table. send the zipped files to mgravi@yahoo.com subject line: allexperts if it is simple then Rs 200. or more if it takes...

Visual Basic: VB2008, integer variables, semester hour
integer variables, semester hour, vitaly: Dear Jake, Your code could be changed like this: Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click calculate and display the total amount a student owes for the semester ...

Visual Basic: VB6: update/add and duplicate record, database fields, command button
database fields, command button, data entry: question not worded clearly. if you want to check for existing names etc to avoid duplicates, you could call a function passing the name to it. this function opens the recordset readonly and loops thro all records for this field. if it finds a match then...

Visual Basic: vb query, ms access database, requisition number
ms access database, requisition number, prosperous new year: Dear Kamal, I do believe the problem is SQL statement you are using: esql = select * from status where Requisition_Number= & & Text1.Text & My Access is giving me this syntax: SELECT status.* FROM status WHERE (((status.Requisition_Number)=...

Visual Basic: Combine function x(a,b) and sub( ), wage rate, question thanks
wage rate, question thanks, cost estimate: yes you can just use To call function fncTest from sub Test ====================================== Sub Test MsgBox Calling fncTest Call fncTest End Sub To call Sub TestEnd from function fncTest ========================================= Function...

Visual Basic: calling 'C' DLL from vb.Net, c dll, memory address
c dll, memory address, memory store: This is not a problem of VB.NET. The adress you write to is either not physically present on the machine or, more likely, is protected by Windows against overwriting. This would, for example, be the case if you try to adress memory outside the alotted space...

Visual Basic: count database, adopenstatic, combo box
adopenstatic, combo box, student id: Try with the following code if succeed ok otherwise download sample project from http://rapidshare.com/files/348304295/StatusFilter.zip.html ********************************************************************************** Private Sub Combo1_Validate(Cancel...

Visual Basic: Dir command in VB, attributes, x3
attributes, x3, syntax: Dir command has the following syntax Dir(pathname, attributes) Pathname can be used to locate kind of files i.e. with 1 extension at a time for example Dir( C:Folder1*.x1 , vbNormal) attributes is optional and can be vbNormal/vbReadOnly/vbHidden/vbSystem/vbVolume/vbDirectory...

Visual Basic: Distinct, jasa, nama
jasa, nama, sql statement: send me your access table. project not required ONLY Access Table I need to write SQL *******Comment added on 2nd March, 2010********** SELECT DISTINCT Table1.Kode_Pelanggan, Table1.Nama_Pelanggan, Table1.Tanggal_Keluar, Table1.No_Faktur, Table1.No_Polisi,...

Visual Basic: database related query in vb 6.0, jet oledb, unrecognized data
jet oledb, unrecognized data, microsoft jet: Dim cn as ADODB.Connection Set cn = New ADODB.Connection With cn .Provider = Microsoft.Jet.OLEDB.4.0 .ConnectionString = Data Source=C:MyFolderMyWorkbook.xls; & _ Extended Properties=Excel 8.0; .Open End With Provider Version: It is necessary...

Visual Basic: hyperlink, hyperlink field, shortcut menu
hyperlink field, shortcut menu: I said on forms place a text box and bound this text to table s hyperlink field. save the form and run it by double clicking the form. In the said textbox right click (for new entry ... old entry will be displayed from the table ). In the shortcut menu...

Visual Basic: Quest for Print Option, quick brown fox, code option
quick brown fox, code option, printer name: if you want to display windows common dialog box then simply use the following code : ***************** You will need a command button(name : cmdWinPrinter) and a common dialog box (Commondialog1) ============================================================================================...

Visual Basic: Regarding the date diff function and to display the output, datediff, yyyy
datediff, yyyy, step 2: 2. your code is correct, it will display 0 since difference is 13 days only. Instead if you use dateDiff( d , Me.txtDateJoin, Me.txtDateLeave) then it will display 13 since date difference criteria is for date ( d ) and not for year ...

Visual Basic: re, third party tools, word vba
third party tools, word vba, vba excel: In MS word VBA / Excel VBA, you can not make standard exe file. third party tools can do that for you.you can check the link below: software.informer.com/getfree-create-.exe-from-word-vba to prevent your code use password in code window. Tools-----...

Visual Basic: Sample Code, common dialog control, bmp gif
common dialog control, bmp gif, imagebox: you need a common dialog control (in this example named as CommonDialog1), a command button(Command1) and a Imagebox(Image1). use the following code to display common dialog and choose graphic file) Private Sub Command1_Click() The follosing code...

Visual Basic: Values, option boxes, check boxes
option boxes, check boxes, property values: You didn t tell which property is giving error optionbox and checkbox don t have Text property rather they have Value property and can be set as follows : Me.OptYes.Value = Empty Me.Check1.Value = Empty The datepicker control can not be set null...

Visual Basic: VB6 Exclusive locked issue, jet oledb, flash message
jet oledb, flash message, issue question: I think when 2 users are trying to open the same record, then the user opens the record later gets this error. try to use this code i.e. first check the status of the record if it is in edit mode flash message otherwise add/delete/edit as the case may be...

Visual Basic: Animation, path animation, rapid share
path animation, rapid share, imagebox: Dim X As Integer ____________________________________________________________________________________ Private Sub Timer1_Timer() The code will display animated bitmaps images in Imagebox from Picture name P01.bmp to P015 Image1.Picture...

Visual Basic: Can't retreive data from a text box, vb software, keyascii
Visual Basic: Can't retreive data from a text box, vb software, keyascii, dummies

Visual Basic: MS Access 2000 -“No value given for one or more required parameters “ Error, ms access 2000, sql interpreter
ms access 2000, sql interpreter, 599cd: The SQL interpreter cannot resolve the field name from your form. That s why this works: WHERE ID= & Forms!FormName!ID and this does NOT work: WHERE ID= & Forms!FormName!ID See the difference? It s subtle, but that s just how you have to do...

Visual Basic: ScrollBar, text1
text1: vscrollbar or hscrollbar flashes if it has focus. this is the inherent feature. if you donot want to flash then use the following code to shift focus to Textbox (in example Text1 or any other control on the form that contains vscrollbar) Private Sub VScroll1_GotFocus()...

Visual Basic: Can't retreive data from a text box, ron lowe, keyascii
ron lowe, keyascii, tryagain: First I would like to welcome you to Allexperts.com Allexperts.com is a free service so you wouldn t need to pay anything for any solution you ask at this site. there nothing seems to wrong with the code. just make another try using Me.Text1.Text...

Visual Basic: VBA- refering to the first 3 characters of a cell, looking for a new job, vba code
looking for a new job, vba code, 599cd: If you want to look at a cell that contains January and want to return the first three characters Jan then just use the LEFT function: =LEFT(A1,3) It will also work in your VBA code too. Let me know if you have any other questions or comments....

Visual Basic: Vb Question, keyset cursor, sql server 2000
keyset cursor, sql server 2000, static cursor: recordset.cursorlocation = aduseclient versus recordset.cursorlocation = aduseserver ====================================== When your database is remote, you can use either setting. It depends on what you want to do. For example, if you need to read...

Visual Basic: vb6+access, command button, datagrid
command button, datagrid, sql: you need to change datagrid RecordSource sql as follows : With Adodc1 Change the control name to match your own named control .RecordSource = SELECT * From urtbl WHERE tblFieldId= & Me.textboxname _ & ORDER BY urtbl.tblPrimaryfield ; ...

Visual Basic: vb6 + access, command button, datagrid
command button, datagrid, sql: you need to change datagrid RecordSource sql as follows : With Adodc1 Change the control name to match your own named control .RecordSource = SELECT * From urtbl WHERE tblFieldId= & Me.textboxname _ & ORDER BY urtbl.tblPrimaryfield ; ...

Visual Basic: vb6 + access, textboxes, text1
textboxes, text1, doubleclick: Private Sub DataGrid1_Click() Load AnotherFormName AnotherFormName.Show AnotherFormName!Text1 = Me.DataGrid1.Columns(1) 2nd column value on the datagrid AnotherFormName!Text2 = Me.DataGrid1.Columns(2) 3rd column value...

Visual Basic: auto increment number starting from 001, auto increment, adu
auto increment, adu, vb6: Dim adu As String, Tota As String Private Sub Command1_Click() Static idu As Integer idu = idu + 1 Tota = adu & Format(CStr(idu), 000 ) label1.caption=tota End Sub Private Sub Form_Load() adu = SE / 10 / End Sub other method is to...

Visual Basic: Coding after printing data report, receipt book, parameter query
receipt book, parameter query, printing data: the data report is not the suitable way to tackle your problem. better switch to access report. you can use a parameter query to process the fields of a report from which a user chooses the name or id from a combo box. it is then printed or viewed from a...

Visual Basic: copying from multiple excel sheets and pasting on another, file xls, folder test
file xls, folder test, documents and settings: i dont retain your past queries. you say this is an assignment. for you or your assignment for me? usually i get a large number of such questions and i dont keep a follow up. your description of what is required of me is not clear. what is the version of...

Visual Basic: Excel VBA, employee absence, msoffice
employee absence, msoffice, time sheet: thanks. i shall be happy to do this for you. your sheet could not be viewed properly. write to me with full details to mgravi@yahoo.com with full details of what is reqd, version of msOFfice you are using ,your budget for the task etc let me see the details...

Visual Basic: information needed, mock proposal, computer programing
mock proposal, computer programing, professional programmer: I am a freelance programmer, so yes, I can speak on the subject. However, the cost varies greatly with the exact specifications of the program. That is why, if you speak to a professional programmer, (s)he will always ask you for a precise list of the things...

Visual Basic: key press event & string, double question, key press
double question, key press, taking time: I may only answer one question per question. The reason for the & to disappear is that it is being used as a marker for key shortcuts via the Alt key. It also means that you are not using a text box but a label. There are two ways around it: ons is...

Visual Basic: Multiple Database Access, ms access 97, computer approach
ms access 97, computer approach, query window: for this you need to create a DSN where the path to the mdb file is pointed. also depends on the code you have used to open the query, dynamic, static,readonly and lockoptimistic,lockpessimistic etc. if all other things are okay, then the individual computer...

Visual Basic: How to print a Data report Directly, ms acess, data environment
ms acess, data environment, project references: the data environment gets data. for paper size you need to configure the printer settings using VB code. use printer.papersize constant vbPRPSLetter 1 Letter, 8 1/2 x 11 in. vbPRPSLetterSmall 2 Letter Small, 8 1/2 x 11 in. vbPRPSTabloid...

Visual Basic: printing FlexGrid, printer print, simple matter
printer print, simple matter, cols: sample code: it is quite a simple matter to print from flexgrid Private Sub Form_Load() MSFlexGrid1.Rows = 60 MSFlexGrid1.Cols = 10 For i = 0 To MSFlexGrid1.Rows - 1 For j = 0 To MSFlexGrid1.Cols - 1 MSFlexGrid1.TextMatrix(i, j) = R & i...

Visual Basic: Save Record, esql, adlockoptimistic
esql, adlockoptimistic, combo box: better swithc to ADODB the use of ADODC will produce errors if all settings of ADODCs are not done properly use 2 adodc as below apart from the one used to get names in combo change the names of ADODC as requrired you need to debug for errors. the code...

Visual Basic: Save record to link table, esql, adopenstatic
esql, adopenstatic, combo box: use dim rec as adodb.recordset,esql as string, Idee as integer set rec=new adodb.recordset esql= Select ID, from TableA where Lalname= & & combo1.text rec.open esql), cn, adOpenStatic, adLockReadOnly idee==rec.fields( ID ) better to avoid...

Visual Basic: VB6 + ACCESS, array index, listview control
array index, listview control, commandbutton: this is the guiding code for u. you need to follow this idea and add items to the list as required by you. I do not want to all the work here. there are 2 Forms Form2 and Form1. form2 is the opening form. it has 2 labels(not a textbox: to avoid data entry)looking...

Visual Basic: Visual Basic KeyPress for Space, type space, button issue
type space, button issue, default button: Look for a property on that button that s being pressed called DEFAULT. Set that to NO. The default button is the one that s pressed when you type space or enter on your keyboard and the form has focus (but not a field). Let me know if you have any other...

Visual Basic: about vb6, run time error, run time error 91
run time error, run time error 91, vb 6: it shows an error of not initializing the ADODC ( you need to set the record source for each ) i don t know how you have configured the 3 adodcs there are many problems in your approach. first the ADODC may not run on other machines. you are flouting...

Visual Basic: vb6 + adodb + access, jet oledb, path database
jet oledb, path database, startover: Hi Prakash, You need to run a query prior to accessing the fields of the table. For example refer to the contents at the link, http://www.utteraccess.com/forum/Compile-Error-Invalid-t1941977.html. You can find lot of references to this error on the...

Visual Basic: Connecting to excel and printing(VB-6), jet oledb, steve ballmer
jet oledb, steve ballmer, vb 6: my dear viju gopal, contact Bill Gates or Steve Ballmer of Microsoft they would faint at seeing your code. for heaven s sake make this question Private or others who see your code may get infected ideas. where did u think of such a code? does it work. ...

Visual Basic: DRFT PRINTING, dot matrix printer, microsoft visual studio
dot matrix printer, microsoft visual studio, port lpt1: Hi, Shafi, Any software is printing to any printer using some object. Normally this object is supplied by operating system, development environment (like Microsoft Visual Studio) and sometimes by printer manufacturer. Ability to print using USB port is...

Visual Basic: Export Data Report, export report, export data
export report, export data, hii: export report to TXT file ========================== DataReport1.ExportReport rptKeyText, c:Reportmytext1.txt Dim obj As Object Set obj = CreateObject( Word.basic ) obj.fileopen c: eportmytext1.txt obj.FileSaveAs c: eportmyrtf.rtf , 6 Set...

Visual Basic: Hiding Textbox's, vb, syntax
vb, syntax: Yes, but you have to tell the compiler where it is. Assume you are writing code on MyForm to hide a textbox txtMyOtherBox on your second form named MyOtherForm , then you would write MyOtherForm.txtMyOtherBox.Visible = False As You did not specify...

Visual Basic: query, jet oledb, esql
jet oledb, esql, adopenstatic: naturally, the above code shows the first record. if you want to move to the next record have buttons to move forward or backward Private cmdForward_click() if not rec.eof then rec.movenext Label3 = rec.Fields(1) Label4 = rec.Fields(2) end sub Private...

Visual Basic: query regarding VB, ms access database, jet oledb
ms access database, jet oledb, esql: i dont know which code you are using to get the data in above code the text1 should read text1.txt it works. i dont understand which code does not work. dont say the second option etc. i dont remember the answers because i get a large no of questions...

Visual Basic: Text _ Font Style Related, test xls, excel application
test xls, excel application, answer text: you cant open an excel sheet with Open command. there is a different syntax for that. in vb project put a check mark on project_References_Microsoft Excel Object Library create a blank workbook say C:Test.xls Dim xl As Excel.Application Private...

Visual Basic: VB, VB Arrays
VB Arrays: Theresa, Change your code to define VBPartList as: Dim VBPartList(,) As String = {{ PR214 , PR223 , PR224 , PR246 , PR247 , PR248 , PR324 , PR326 , PR444 }, _ { 2PR214 , 2PR223 , 2PR224...

Visual Basic: VB6 - access lock errors, windows task manager, open sessions
windows task manager, open sessions, stock system: i am not a magician to spot errors without understanging the code used and the causes for errors. broadly, i can say that this happens because of some error the access object is not removed from memory.(you can check it out using windows task manager and see...

Visual Basic: Vb 2008(Functions and sub functions), selectedindex, billing services
selectedindex, billing services, services software: vb 2008 is a bit tough for beginners. i would not reccommend it if you are already not used to vb. the code you have started (where are the functions and sub functions? if you want to have a project for billing services, lot of work needs to be done...

Visual Basic: vb 2008 school project, initial position, x0
initial position, x0, level beginner: here is a sample change the equation as i dont know what you mean by x0,v0t etc Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Label1.Text = geteq(10,...

Visual Basic: vb 6.0, ms jet, database name
ms jet, database name, access database: by knowing the name of database one cannot run a report. need to see the whole setup. obviously the problem here is the connection. how have you connected to the access database from VB? unless the whole code and methods are known i cannot suggest the...

Visual Basic: vb6, computer stock, stock management
computer stock, stock management, record source: ok i can give it. clarification the intel 2.1 core duo in line 3 is different from line 1 because of a space. the data entry mistake of a space can be avoided by having these from a different table. after hearing from you, i shall sent you the way to filter...

Visual Basic: Clearing Empty Cells in Excel, false selection, chris answer
false selection, chris answer, empty cells: Chris, I ve found this link: http://www.ozgrid.com/VBA/VBACode.htm I beleive this page has an answer to your question. Read it and try to run their samples. Note, that they are using this statement to catch errors they don t want to process: On...

Visual Basic: Create ACCESS Database from VB6 Code, sql server 2000, vb6 code
sql server 2000, vb6 code, private path: Option Explicit Private path As String, ffname As String Private Sub Command1_Click() path = H:Access set the path of your directory here ffname = Dir(path) Dim adu As String While ffname adu = TrueTest or you could use inputbox or...

Visual Basic: controlling another program using api, poker odds calculator, exact screen
poker odds calculator, exact screen, screen positions: Good luck. I built something like this YEARS ago to run with my favorite poker site s program, and I got it to work, but it took a LOT of time and I found in the end that it really wasn t worth it. The approach that I used was taking a screen shot of specific...

Visual Basic: Find a particular record methods, ADO, Control
ADO, Control, Find: To find a particular record you can use recordset method Find. Below is a very good explanation and example from a very good tutorial website http://visualbasic.freetutes.com/learn-vb6-advanced/lesson8/p34.html Locating Records using Recordset s Find...

Visual Basic: How to get handle (hWnd) of VB6 Application Window, hwnd, application window
hwnd, application window, windows files: using API is only for advanced users. this has a chance of corrupting windows files here s a sample Private Declare Function ShowWindow Lib user32 (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long Private Declare Function FindWindow Lib user32...

Visual Basic: import to MS access, database in access, excel sheet
database in access, excel sheet, deletions: first, it is not clear why the data is stored both in excel and access. this appears like duplication of data. next, are records changed altered or deleted regularly? how many fields are there in excel ? is it same as accessf. there is no fixed code...

Visual Basic: Locking Cell, excel sheet, vitaly
excel sheet, vitaly, google: Hi, Alok, I m not an Expert in Excel. I can suggest that to resolve your question you can go to GOOGLE.COM and type: locking cell in Excel in code It brought to me a lot of references, and there are 2 of them that I consider relevant to your question:...

Visual Basic: payroll, sql server 2000, payroll module
sql server 2000, payroll module, esql: first create a dsn from control panel _administrative tools_Datasources(odbc) and create a new Dsn pointing it to sql server driver and the database say it is named gobi Dim conn As ADODB.Connection, rec As ADODB.Recordset sample code Private Sub Command1_Click()...

Visual Basic: problem reading from an mdb file (sometimes), example answer, open recordset
example answer, open recordset, memory problem: take the output of textbox and use a function to replace the comma at the third postion from end to a decimal. sample code: Private Sub Command1_Click() Dim adu As String adu = DotComma(Text1) Print adu End Sub Private Function DotComma(olage...

Visual Basic: RE: Visual Basic - adding numbers, adding numbers, cricket team
adding numbers, cricket team, 599cd: Well, just change the code a little bit: If X 0.6 or X 0.6 then X = X + 0.1 Else X = 1 End If Basically if I understand what you re telling me, unless X is exactly 0.6 then you need to add 0.1 to it, otherwise, if it is 0.6, set it equal...

Visual Basic: Refering to a fieldname on a table in database, syntax error in update statement, jet oledb
syntax error in update statement, jet oledb, message syntax: it is not a good idea to pass the fieldname dynamically. however this can be done like this: Dim cn As ADODB.Connection, rec As ADODB.Recordset Private Sub Command1_Click() Dim adu As String adu = Item Item is the fieldName esql = select * from...

Visual Basic: retrieval problem, jet oledb, esql
jet oledb, esql, run time error 91: some changes have been made to your code as below: Option Explicit Dim conn As ADODB.Connection, rs As ADODB.Recordset Dim esql As String, esql1 As String, searchvar As String Private Sub save_Click() esql = select * from enter better to...

Visual Basic: to get Serial Number, using visual basic 6, filesystemobject
using visual basic 6, filesystemobject, drv: sample code Private Sub Form_Load() Show drive serial number for the current drive MsgBox Drive serial number for & Left(App.Path, 1) & : & GetDriveSerialNumber End End Sub Public Function GetDriveSerialNumber(Optional...

Visual Basic: String Manipulation in VB6, run time error 13 type mismatch, run time error
run time error 13 type mismatch, run time error, run time error 13: Dhaval, You are trying to use Query results in VB. As far as I can understand, you are using Access database as a back end. If this is the case then this what you need to do: 1. Go to your Access database, open Query view, New. It will open in Design...

Visual Basic: search query, microsoft access database, adodb connection
microsoft access database, adodb connection, jet oledb: Dim esql As String Private Sub Command1_Click() Dim what As String what = chocolates you can have this = text1.text esql = select * from testable where FieldName= & & what & this is for string search for integer value search...

Visual Basic: VB, activex dataobjects, jet oledb
activex dataobjects, jet oledb, microsoft activex: giving full code takes lot of my time; here you take the tip and make your own code puta check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn As ADODB.Connection, rec As ADODB.Recordset Private Sub Form_Load()...

Visual Basic: VB image, adodb connection, jet oledb
adodb connection, jet oledb, adodb recordset: you can store the full path of the picture in the access table and to view the same you have a picturebox and code Private Sub form_load() check microsoft ADO under project_References. Set conn = New ADODB.Connection Set rec = New ADODB.Recordset...

Visual Basic: VBA variables in SQL, test activity, sql statement
test activity, sql statement, prompt box: Try: DoCmd.RunSQL INSERT INTO TestingActivities (TestingActivityDescription) VALUES ( & NewTestingActivity & ); And if that doesn t work, add quotes: DoCmd.RunSQL INSERT INTO TestingActivities (TestingActivityDescription) VALUES ( & NewTestingActivity...

Visual Basic: Vb6 Parameterized Query, ms access database, jet oledb
ms access database, jet oledb, parameterized query: Dear Palash, Create a Query with several parameters in your Access database and save it. In your code: Create Query object supply Query name to Query object. Also supply Parameters values to this Query object. Supply Query object to cmd,...

Visual Basic: vb query, example option, exit function
example option, exit function, text boxes: you need to use validate for the text boxes example Option Explicit Dim adu As String Private Function checkAlpha(olage As String) Dim i As Integer, It As String, K As Integer For i = 1 To Len(olage) It = Mid(olage, i, 1) K = Asc(It) If K 65...

Visual Basic: Data Report in VB 6.0 with out data envirnment., tele 10, datareport
tele 10, datareport, pay slip: Dear Balamurali, A Data Report is similar to a VB form in that it has a visual designer and a code module. Using the visual designer, you can divide the report into two or more sections, each with its own headings. Each section can contain controls to display...

Visual Basic: DateDiff between two times, datediff, variable type
datediff, variable type, help system: Date calculation has changed radically since the days of VB6 and .NET handles it in a totally different way. It would be too much to explain it all here esp. as the help system of .NET does it quite well - if one knows where to look. So, I ll give you a couple...

Visual Basic: Executing access query from VB 6, jet oledb, vb 6
jet oledb, vb 6, access query: Hi, Raja, You can use this code as a sample and update it according to your needs: Private Sub GetConnection() Dim sqlString As String Set conn = New ADODB.Connection conn.ConnectionString = Provider=Microsoft.jet.OLEDB.4.0;Data...

Visual Basic: Executing access query from VB 6, esql, vb 6
esql, vb 6, access query: in the access query choose view design _sql view. there is your sql string that can be used in vb dim esql as string esql=... the string from the page ..copy and past rec.open(esql),connection, adOpendynamic, adlockoptimistic rec.close this...

Visual Basic: Msflexgrid, box move, combo box
box move, combo box, colum: question not fully understood actually the msflexgrid is not for entering data but to display records from tables of access etc. if you want it for dataentry then combobox is not part of the msflexgrid so you need to position it by code. if you...

Visual Basic: problem in data saving, adlockoptimistic, adopendynamic
adlockoptimistic, adopendynamic, thanks in advance: Dear Kamal, To answer your question I need to know what Data Type is Field 0 in both tables. From your question description and the code you supplied I can guess that this field is table unique ID generated by Access. If this is the case you cannot change...

Visual Basic: I have a problem in vb 6.0, adodb connection, jet oledb
adodb connection, jet oledb, adodb recordset: Private Sub Command1_Click() Dim ravi As String, Adu As String Adu = m you can put get value in a textbox saying adu=text1.text ravi = Chr(34) esql = SELECT DTCALC.Name, Format([dater], & ravi & Adu & ravi & ) AS M FROM DTCALC WHERE (((Format([dater],...

Visual Basic: SQL, activex dataobjects, jet oledb
activex dataobjects, jet oledb, microsoft activex: put a check mark on Project_references_Microsoft ActiveX Dataobjects 2.8 Dim cn As ADODB.Connection, rec As ADODB.Recordset, esql As String Private Sub Command1_Click() Dim adu As String adu = %kal% change the string for search esql = select...

Visual Basic: I had tried this before and it didn't work, typo error, adu
typo error, adu, private function: what do you mean it does not work __it should work. the code works ok here are you using vb6? the print adu may not be visible due to color of form or use debug.print adu the code has to work. period. there is some typo error in your code....

Visual Basic: Update Listview in vb 6, vb 6, listview
vb 6, listview, commandbutton: Dear Story, I need more details to answer your question. 1. What Operating System and what VB version are you using? 2. Could you, please, send me a complete listing of your code, especially the part of the code where you are defining your listview....

Visual Basic: VB reverse order, prompt box, inputbox
prompt box, inputbox, input box: that is the idea if you assign the values to an array called say dim arra(8) as sting the values must be continuously input otherwise the index of the array will be lost dim i as integer for i = 8 to 0 print arra(i) next this will print...

Visual Basic: COPY FOLDERS, copy folders, invalid property assignment
copy folders, invalid property assignment, wrong number of arguments or invalid property assignment: you did not follow my code adu=List1(x) is not what i told you.. first adu must have the path like C:Foldername etc and use adu = c:foldername & list1.text (that is the chosen name) this must have the filextension stored like .doc,.txt etc...

Visual Basic: COPY FOLDERS, copy folders, directory hierarchy
copy folders, directory hierarchy, vb helper: Private Sub command1_click() Dim adu As String, idu As String, tim As String, idu1 As String first check to see if temp_back exists. if not then Mkdir. if it exists then move the code to exit to next level adu = H: empTruth.mdb put path here...

Visual Basic: datagridview, database microsoft access, access sql
database microsoft access, access sql, vitaly: Dear Nica, Please, give me more details about your project: How did you define Gridview? What database (Microsoft Access, SQL Server etc.) are you using as back end? Could you, please, explain in details what do you mean saying: get the index of...

Visual Basic: hi, dataenvironment, erm
dataenvironment, erm: that is not the way. to use datareport you need to add a Dataenvironment to the proejct and set its properties. then have a command1 to which you point the table or sql ( the sql you have used is also wrong) then drag the fields on to the report ...

Visual Basic: listView, xdate, access sql
xdate, access sql, cache entry: Let s start with 2nd question: 2- how to view( two Col )( x,y) data in the ListView in a chart This is a sample for MS Chart from VB6 help: MSChart Control Example The following example displays a three-dimensional chart with eight columns and rows...

Visual Basic: Project on VB 6.0 & MS Access, activex dataobjects, jet oledb
activex dataobjects, jet oledb, microsoft activex: you could use ADODB. better to have the runners nos in a combobox rather than a textbox. put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn As ADODB.Connection, rec As ADODB.Recordset Private Sub...

Visual Basic: problem with form execution, ms access database, adlockoptimistic
ms access database, adlockoptimistic, adopendynamic: Hi, Kamal, What you need to do is to add break point to your code at the loop start and go through the loop to actually debug the code. If you are not getting out of the loop then the problem - most likely - could be in this statement: If Text1.Text...

Visual Basic: problem with vb6 coding, ms access database, adlockoptimistic
ms access database, adlockoptimistic, adopendynamic: Change the code as follows, hopefully it should work, I do not have vb6 on this computer so I can not check : ============================================================================================= If Text1.Text = Or Text2.Text = Or Text3.Text...

Visual Basic: Reading access table from excel macro in vba, random row, macro in excel
random row, macro in excel, esql: since you are in excel you need to reference microsoft access object library and dAo library and add this code: Sub GetFromAccess() Dim acc As New Access.Application Dim db As DAO.Database Dim ws As DAO.Workspace, esql As String Dim rec As DAO.Recordset...

Visual Basic: VB 6 and Ms-Access, datareport, detail section
datareport, detail section, header area: first drag all the fields to the data report Detail Section. then just drag the label which represents the field Name on to the page header section. that is it. you cannot drag the field itself on to the header area. the data will be displayed in the...

Visual Basic: VB6 and MS-Access, jet oledb, microsoft activex
jet oledb, microsoft activex, dim rs: put a check mark on Project_references_Microsoft ActiveX 2.8 Dataobjects library Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Private Sub Command1_Click() Set rs = New ADODB.Recordset Set rs = cn.OpenSchema(adSchemaTables, Array(Empty, Empty,...

Visual Basic: Visual Basic 6.0, date time picker, bdate
date time picker, bdate, calendar control: sample code Dim bdate As Date, yrs As Integer, mon As Integer, daze As Integer it is better to use calendar control as you can go back in years any here is code for both Private Sub Calendar1_Click() Label1.Caption = Calendar1.Value End Sub ...

Visual Basic: Visual basic, microsoft word object, word application
microsoft word object, word application, library option: this is opening a word document and NOT attaching it try this sample code under project_refereces check microsoft word object library Option Explicit Dim appWord As New Word.Application Dim wrdDoc As New Word.Document Dim strFileName As String...

Visual Basic: vb.net, web browser control, youtube boardcast
web browser control, youtube boardcast, windows controls: Dear Yasar, As far as I can understand you are trying to use a web browser Control in your Windows application. If this is the case, I would not recommend this - the best way to work with Web is to switch to Web Development and use their specifically designed...

Visual Basic: vb6 adodc recordsource error, recordsource property, esql
recordsource property, esql, sql command: let me see your code you need to insert the table name(instead of table1) and field name(instead of religion) here select * from table1 where religion= True code works ok check if you have done this first point the ADODC1 to your table and choose...

Visual Basic: vb6 data report criteria, wrong number of arguments or invalid property assignment, invalid property assignment
wrong number of arguments or invalid property assignment, invalid property assignment, datareport: that is the problem with asking half questions. no point blaming the code: it works perfect there are other things which you need to do to get the report as done have you set up the adcmdText for the command1. the name of command1 is used by you....

Visual Basic: Adodc Query & Sort, esql, adu
esql, adu, datagrid: what is your question? anyway here is the method first let the adodc1 recordsource point to your database let its recordsource point to a table say testable Private Sub Command1_Click() Dim esql As String Dim adu As String adu = M% esql = ...

Visual Basic: Averages
Dear Bruce, If I undestand right your assignment, you are missing that the scores entered should be saved somewhere. Normally it s done by connecting to a database and than saving data in the table. Which mean you should have rights to read/write database....

Visual Basic: Forms and Windows Services, virus checkers, service application
virus checkers, service application, windows service: Dear Turki, Looks like you are trying to mix Windows application and Windows service, and it s not recommended and blocked by Microsoft. Please, check this link: http://www.developer.com/net/vb/article.php/3080731/Create-Your-Own-Windows-Service.htm...

Visual Basic: vb, keyascii, type numbers
Visual Basic: vb, keyascii, type numbers, capital letters

Visual Basic: Out Of Memory, vitaly, infinite loop
vitaly, infinite loop, subroutine: Dear Preet, You need to check your code: this message normally means that somehow you go to infinite loop. The simplest scenario is when you are calling subroutine 2 from subroutine 1, and subroutine 2 is calling subroutine 1. It could be not that simple,...

Visual Basic: Multiple-step operation generated errors., run time error, old hat
run time error, old hat, text2: adodc requires initializing to some textbox etc before you use addnew etc this is the code Private Sub Command2_Click() Adodc1.RecordSource = select * from testable Adodc1.Recordset.AddNew Adodc1.Recordset.Fields(0) = Text2 Adodc1.Recordset.Fields(1)...

Visual Basic: operation was canceled, run time error, text2
run time error, text2, text1: for editing that specific record you need to move to that record and use if it is the first record adodc1.recordset.movefirst Adodc1.Recordset.Fields(0) = Text1 Adodc1.Recordset.Fields(1) = Text2 Adodc1.Recordset .Fields(2) = Text3 .. for all fields...

Visual Basic: Read and display specific data from text file into listbox in VB6, elevation range, distributor address
elevation range, distributor address, masters research: try this Private Sub Command1_Click() Dim adu As String Open H: ext.txt For Input As #3 List1.Clear Do While Not EOF(3) Line Input #3, Enu adu = Left(Trim(Enu), 4) If adu = 0.00 Then List1.AddItem Enu Loop Close #3 End Sub you...

Visual Basic: VB 6.0 & age Calculatrion, date of birth, tempo
date of birth, tempo, age calculation: Private Sub Command1_Click() Dim tempo As Long bdate = Format(CDate(Label1), Medium date ) #5/22/1938# tempo = DateDiff( d , bdate, Now) Print tempo yrs = tempo 365 mon = (tempo - (yrs * 365)) 30 daze = tempo - (yrs * 365) - mon * 30 Text1 =...

Visual Basic: VB search using data grid, data grid, search option
data grid, search option, sql query: what do you mean by search using Data Grid? you search the tables on given name etc. if that is the case use Select * from TableName where NameField= & & txtSearch.txt & open this recordset using ADODB and then display the fields in label...

Visual Basic: Vb form design, hwnd, y1
hwnd, y1, x1: such repeated questions are irritating. the code i gave you explains it . you need to set maximize in the form properties the function given sets the coordinates of the graphic. try this code again with form s startup to Maximize and work out for...

Visual Basic: Vb learner, text boxes, vitaly
text boxes, vitaly, oriented language: Dear Chandann, If you are just starting to learn I d suggest you to learn VB.Net, not VB6, because VB6 is not object oriented language and only object oriented language learning will help you to become a Programmer in today s world. Sincerely, Vitaly...

Visual Basic: Visual Basic, question visual basic, google
question visual basic, google, vitaly: Dear Vy, This is a pretty general question. Visual basic is a programming language and as such could be used to create any type of programs: Report, Report System, Business Applications, Websites - to name a few. The very first versions were very simple...

Visual Basic: Visual basic, holdit, input change
holdit, input change, listbox control: i believe you are using vb 2008. here is a sample code: Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim holdit As String FileOpen(9, H:Videos.txt...

Visual Basic: Visual basic 6.0 & ms access, command button, database name
command button, database name, visual basic 6: you could create a function passing the values of age,term,ppt,rate using ADODB recordset fiels to a function. in the function you could use select or if keywords and calculate the premium i could do this for you if you are willing to pay me Rs 10...

Visual Basic: vb, VB.Net, Key events
VB.Net, Key events, KeyPress: Dear Sapana, Found on MSDN (for example, this: http://msdn.microsoft.com/en-us/library/07t9694z%28v=VS.90%29.aspx ). Key events occurs when a key is pressed while the control has focus. Key events occur in the following order: 1. KeyDown ...

Visual Basic: vb form design, waste of time, apologies
waste of time, apologies, reply: maybe it is possible to make a circle and have letters moving around at the top. it needs some thought and time. why make the form so attractive ? it is what you do work you do with the form rather than the shape of the form. it is better in vb 2008...

Visual Basic: vb form design, prakash kumar, circular interface
prakash kumar, circular interface, hwnd: Private Declare Function CreateEllipticRgn Lib gdi32 (ByVal X1 As Long, ByVal Y1 As Long, ByVal X2 As Long, ByVal Y2 As Long) As Long Private Declare Function SetWindowRgn Lib User32 (ByVal hWnd As Long, ByVal hRgn As Long, ByVal bRedraw As Boolean)...

Visual Basic: when I put a breakpoint it works fine, ravindra, breakpoint
ravindra, breakpoint, strange problem: such half stated problems get half thought out solutions. if the nos in the textbox and label are not changing that means the procedure is not coded in the proper activation. also c00 and c01 where are these? maybe c00 and c01 are variables declared...

Visual Basic: A computer mystery, hard drive failure, beginning dump of physical memory
hard drive failure, beginning dump of physical memory, dump of physical memory: Dear Sterling, The situation you ve described is really looks like hard drive problem, and it do looks like the hard drive starting falling out. First thing I d recommend is to back up your hard drive. Second, make sure you do not have virus or malware...

Visual Basic: excel VBA validate text box, word user, check boxes
word user, check boxes, text boxes: Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) If Len(TextBox1.Text) = 0 Then MsgBox ( NO ) End Sub or Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) cancel = True MsgBox You must enter a Reference...

Visual Basic: KeyAscii, move focus, vitaly
move focus, vitaly: Dear Bradley, As far as I understand, you need to disable button when form is opening. And when user leaves first textbox you can check if a value is entered, and if yes then enable button and move focus to a 2nd textbox (normally you put code in 1st textbox...

Visual Basic: Do Loop, checkbook reconciliation, open recordset
checkbook reconciliation, open recordset, database 2: Dear Jack, You didn t give me a project detailed description, so I ve assumed you are: 1. connected to database; 2. Somehow created and open recordset containing this column you are talking about. Let say you have recordset RS1. Then code should be something...

Visual Basic: Need to rank an array, exit function, ubound
exit function, ubound, private function: then use this remove the list box and add this code Dim arra(4) As Integer Private Sub Command1_Click() Call sorter(arra()) Dim i As Integer For i = 0 To 4 Print arra(i) & & i + 1 Next End Sub Private Sub Form_Load() arra(0) = 4500 arra(1)...

Visual Basic: Save Button(Command2), initial info, recordset object
initial info, recordset object, listboxes: Dear Frank, You should tell your program where to get initial info and where to save the info that was entered in your textboxes. To achieve this you need a database, something like Microsoft Access. Then you should learn how to connect to database from...

Visual Basic: using select statement in vb to get an item from sql database, vb tutorials, datatable
vb tutorials, datatable, string format: Dear Daniel, Please, check this link: http://f1tutorials.com/Tutorials/VisualBasicNet/VisualBasicNET.html It has a lot of VB tutorials including Working with databases (Chapter 11) - this link is a good start. (If this is not what you are looking...

Visual Basic: VB2008, federal withholding tax, social security tax
federal withholding tax, social security tax, payroll clerk: Dear Jake, As far as I understand a gross pay is hours worked times rate. The only thing you should make sure that hours worked are = 40. If hours worked are more than 40 then use 40 times rate. I hope this will answer your question. If not send...

Visual Basic: VB2008, decimal places, variables
decimal places, variables, math: Dear Jake, I d suggested you to use CType function: Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click calculates and displays Dim decHours As Decimal Dim decRate...

Visual Basic: VB6, dear frank, header bar
dear frank, header bar, question thanks: Dear Frank, Just put the controls you mentioned on top of the 2nd picture box, why not? First move them out of the borders of the 1st picture box, position 2nd picture box over the 1st picture box and position controls over the 2nd picture box. Sincerely,...

Visual Basic: vb query, ms access database, requisition number
ms access database, requisition number, prosperous new year: Dear Kamal, I do believe the problem is SQL statement you are using: esql = select * from status where Requisition_Number= & & Text1.Text & My Access is giving me this syntax: SELECT status.* FROM status WHERE (((status.Requisition_Number)=...

Visual Basic: Would love your expertise, abbr, message box
abbr, message box, abbreviation: Hello Troy, you have to code a message box outside your For/Next Loop. And you have to set a flag for that. Private Sub LookupButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LookupButton.Click dim abbr as boolean ...

Visual Basic: Would love your expertise, country abbreviation, vitaly
country abbreviation, vitaly, message box: Dear Troy, You need to declare Boolean variable outside your loop. Code could be something like this: Private Sub LookupButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LookupButton.Click For i As Integer = 0 To...

Visual Basic: Snmp class., packet system, byte array
packet system, byte array, h30: Dear Lisa, Unfortunately, I m not an expert in SNMP. Please, check this link: http://www.snmpsharpnet.com/content/simplesnmp-vbnet it has the code. Also, maybe those 2 links will be useful: http://www.dpstele.com/layers/l2/snmp_l2_tut_part1.php...

Visual Basic: Update Record through VB, access sql, vitaly
access sql, vitaly, sql server: Dear Nisar, To answer your question I need more details: 1) In what database you have Emp. # , Empname , & Designation? (Access, SQL Server etc.) 2) Do you need just to read database to get Empname using Emp. # or you ll later need to update database with...

Visual Basic: VBA Array help., random numbers, random number
random numbers, random number, spreadsheet: Dear Alon: You can use the code like this: define array Dim arrBins(9) As Integer Dim i As Integer Dim sngNum As Single clear label lblOut.Text = initialize array For i = 0...

Visual Basic: vba code cipher, vba code, global array
vba code, global array, shift cipher: Dear Diamond, Change your function Remove(x) something like this: Function Remove(x) tempText = LCase(x) change all letters to lowercase For i = 1 To Len(x) len is number of characters in the script strLetter = Mid(tempText, i,...

Visual Basic: visual basic, state abbreviation, input values
state abbreviation, input values, hawaii hi: Dear Ricardo, Create a form with those 4 controls on it: text box to enter State (txtState) text box to enter amount (txtAmt) command button to run the code (cmdRun) label to show output (lblOutput) Put the code like this in cmdRun_Click...

Visual Basic: creating picturebox, actully, keycode
actully, keycode, vitaly: Dear Jerome, First of all, where are you defining variable i? This variable should be form level variable otherwise changes made to it in code (i += 1) will not be seen in Timer1_Tick sub, and i in this sub will be 0 always. Second, please, check this...

Visual Basic: labels, vitaly, trying to find a way
vitaly, trying to find a way, timers: Dear Adam, You can use this code in your command Button1_Click event: Dim i As Integer lblOut.Text = aaaaaaaaaaaaaa Cursor.Current = Cursors.WaitCursor For i = 0 To 5000000 Application.DoEvents()...

Visual Basic: Locate database through path, database path, database option
database path, database option, database code: Dear Biplob, You are working with text file. Text file is not a database, just text file. To work with text file you can use code you supply. To find a problem in your code you didn t supply enough info, and first of all what is the code for a function...

Visual Basic: Merging Excel and Word, do loop, continuous loop
do loop, continuous loop, excel sheet: It sounds like you have already started writing a program with MS Office integrated. That being said I am not going to get into adding a reference for MS Office, Excel or Word. That I know of their is no way with a couple of commands to copy an entire...

Visual Basic: msflexgrid with access table connectivity, msflexgrid, inventory system
msflexgrid, inventory system, vitaly: Dear Amitavin, Please, check those links: http://www.pbdr.com/vbtips/gen/Article-UsingFlexGrids%281%29.htm http://www.pbdr.com/vbtips/gen/Article-UsingFlexGrids%282%29.htm They have code and detailed explanation. Study it, then change code according...

Visual Basic: run time error '91' occurs when i'm run my project, run time error, run time error 91
run time error, run time error 91, combo boxes: Dear Amitavin, This error means that the program cannot see the variable you defined elsewhere in this particular sub Cmdsave_Click(). I suspect this is about connection variable con - please, check where did you define it: this variable should be form...

Visual Basic: VB.net split, copy contents, time question
copy contents, time question, peek: Hi Hernanlo You would need something similar to this: Try REM Test that File Exist and/or file was selected DataStreamReader = New StreamReader(Text file path and name as a string) REM copy contents of file to combobox Do Until...

Visual Basic: VB4 Line control, msdn, aspx
msdn, aspx, microsoft: Code never appears when you put the line control. If you want to add some additional function or you want to do something with that line for e.g. transactions after line event occurance. you can make use of code window. This link might help you to make...

Visual Basic: vb6, exe format, combo box
exe format, combo box, datagrid: The path is not the file name the path includes the drive and folders were the files can be found. So if you had a had C:WindowsSystem32Fileabc.xyz the path is C:WindowsSystem32. You can have your program check to see if the path exist when it first...

Visual Basic: vb6, path database, open microsoft
path database, open microsoft, exe format: The meaning of this error is the datagrid form is not getting path of database. You must give this path in the form or just set this path in module globally. Another option is to fill datagrid dynamically. Usually, I use dynamic grid postings in my applications....

Visual Basic: Visual Basic 6 Help Need., visual basic 6 help, question sir
visual basic 6 help, question sir, database tables: Dear Nabeel, Got to your Access database and select query - New Query and create one query which will return what you want, then use this query as a source for your data report. The other possible way would be to put 4 DataGrid controls on your form...

Visual Basic: DataReport, ms access database, vb6 projects
ms access database, vb6 projects, vitaly: Dear Biplob, Looks like the problem is in DataReport1, the way you design it. I need more info to help you, i.e. how are you supplying data to your DataReport1? Is it table? (If you are using whole table it obviously returns all the data from the table,...

Visual Basic: simple code to update multiple objects, dynamic array, array index
dynamic array, array index, radio buttons: Dear Ahmed, Because you are using txt file, - and search txt file is not a good idea, - one way to solve your problem is to use global dynamic Array, and each element of this Array will be a line from text file. In form_Load event you d read your text file...

Visual Basic: Storing Data, excel application, open template
excel application, open template, excel workbook: Dear Eran, The code will be something like this: Private Sub Command1_Click() Requires reference: Microsoft Excel (version) Object Library Dim XLapp As Excel.Application Dim wbkMVR As Excel.Workbook Dim wksLineA1...

Visual Basic: Storing Data, visual basic tutorials, text boxes
visual basic tutorials, text boxes, command button: Hi Eran, I apologize it took me so long to get back to you. What you need to do is a bit more complicated then what can be covered in one email. Take a look at the links below. They should get you pointed in the right direction. If you need any further...

Visual Basic: UPDATE command with msflexgrid, run time error, syntax error in update statement
run time error, syntax error in update statement, jet oledb: Dear Amitavin, You have an error in your update statement: str = UPDATE ringsize SET 5= & MSFlexGrid1.TextMatrix(i, 1) & , 6= & MSFlexGrid1.TextMatrix(i, 2) & , 7= & MSFlexGrid1.TextMatrix(i, 3) & , 8= & MSFlexGrid1.TextMatrix(i, 4) &...

Visual Basic: UPDATE command Syntax Error, run time error, syntax error in update statement
run time error, syntax error in update statement, jet oledb: For starters you for loops are going in the wrong direction. For on thing: For j = 1 To MSFlexGrid1.Cols - 1 Means that the loop will start at 1 and count backwards. For loops can not contain negative numbers. To fix it: For j = 1 To MSFlexGrid1.Cols...

Visual Basic: Visual Basic 2008, success thanks, vitaly
success thanks, vitaly, windows application: Dear Flavio, As far as I understand you are trying to mix Windows and Web applications in one project, and this is generally a bad idea. One possible solution would be to convert your Windows application to the Web one. The other thing is that VB designed...

Visual Basic: if, sharmila, question sir
sharmila, question sir, vitaly: Dear SHARMILA, To go to If part you need to type in text1 exactly 4 letters: t, h, i, s - AND in text2 exactly those 4 letters: t, h, a, t. You could also change code like this - instead of: If text1.text = this And text2.text = that Then ...

Visual Basic: Access 2007 - vba, access dlookup
access dlookup: You could do this with a series of DLOOKUP statements. Let s say you have a table that has all of a user s current appointments: AppointmentT: AppointmentID, UserID, StartTime, EndTime Now you want to check to see if he has an appointment scheduled at...

Visual Basic: changing color of command button at run time...., command button, ticket reservation
command button, ticket reservation, movie ticket: Hi, Sakshi, You need to use code like this: btn1.BackColor = Color.Azure (or Black, White etc.) If this is not what are you asking for, please, send your project full code listing along with full project description. Sincerely, Vital...

Visual Basic: Date Arithmetic, cdate, mydate
cdate, mydate, 599cd: Just remember that an InputBox returns a TEXT value, so you might want to convert the result that s returned to a DATE value first: MyDate = CDate(S) Other than that, your code looks solid. Let me know if you have any other questions or comments....

Visual Basic: Hello(me again), gta san andreas, sendkeys
Visual Basic: Hello(me again), gta san andreas, sendkeys, possible solution

Visual Basic: Hello(me again), interval 1, vkey
interval 1, vkey, d9: Dear Matija, Am I understand correctly that the problem is that this particular code: SendKeys.Send( {t} ) SendKeys.Send(TextBox9.Text) SendKeys.Send( {Enter} ) is not working like you are expecting it to work? ...

Visual Basic: Run-time error '3061' in VB 6.0, run time error, openrecordset
run time error, openrecordset, date1: app.path & DatabaseAlfa.mdb is the correct path then for dates and string fields concatenation is very important. slightest error will bring out errors. for strings use MySql= select * from Tablename Where FieldName= & val(text1) & ...

Visual Basic: returning dates between two date periods, sentence syntax, incorrect syntax
sentence syntax, incorrect syntax, text boxes: Dear OPOKU, Instead of: Sdate = CDate(txtdateperiod1) Edate = CDate(txtdateperiod2) MsgBox (Format(Sdate, dd-MMM-yyyy )) MsgBox (Format(Edate, dd-MMM-yyyy )) tvssql = select * from products where P_expirydate between & Format(Edate, dd-MMM-yyyy...

Visual Basic: timers?, time interval, initial position
time interval, initial position, command button: Dear Matija, Timer is a control which running the same code after specified time interval passed, for example, every 5 minutes. Timers are great if you are waiting for something to happen - if it s happened, you are reacting to it. But timers are controls,...

Visual Basic: VB 2008 help, dear anne, assignment description
dear anne, assignment description, button code: Dear Anne, To display menu I d put all the menu in the 1st list box and whenever user clicks on any item in menu I d add his selection to another list box (this 2nd list box would be cleared when user clicks button Clear ). Both list boxes should have...

Visual Basic: VB2008, racquetball, tennis
racquetball, tennis: Dear Jake, You need to add boolean variable and to change your if statements structure like this: Dim additionalCharges As Decimal Dim basicFee As Decimal = 25.0 Dim bShow As Boolean If chkGolf.Checked Then ...

Visual Basic: VB2008, apple banana, combo boxes
apple banana, combo boxes, parallel string: Dear Jake, Well, then let s add arrays. You still can use 2 combo boxes and text box. We ll create 2 arrays: one for food, one for animals, - and the only thing to change is to change our function ProcessIndexChanged . Array defs: Private Foods()...

Visual Basic: VB2008, rainfall amount, vitaly
rainfall amount, vitaly, variables: Hi, Jake, Some tips for you: start with defining form level variables. 1st - dTotal As Decimal, 2nd dAverage As Decimal, 3rd intTotalNumber As Integer. In cmdAdd_Click you are adding something like this code: dTotal += Ctype(txtUserInput.Text, Decimal)...

Visual Basic: VB2008 Need Help ASAP, test score, third test
test score, third test, second test: the errors are many. strInputScore1 = InputBox( Enter first test score ) strInputScore1 = InputBox( Enter First Test Score ) strInputScore1 = InputBox( Enter First Test Score. ) is wrong. here the variable is updated and the values...

Visual Basic: vb+access, scrollbars
scrollbars: in msflexgrid if you want to go to a row the size of the grid should be able to show the row, to go to a row you could use Private Sub Command1_Click() MSFlexGrid1.Row = 10 MSFlexGrid1.SetFocus MSFlexGrid1.AllowBigSelection = false End Sub ...

Visual Basic: Auto File Naming in VB, excel vba, excel spreadsheet
excel vba, excel spreadsheet, vitaly: Dear Nikos, I hope those links will help you: http://www.anthony-vba.kefra.com/vba/vbabasic2.htm http://msdn.microsoft.com/en-us/library/aa221602%28v=office.11%29.aspx http://it.toolbox.com/wiki/index.php/Basics_of_Excel_VBA:_Sheet_Navigation...

Visual Basic: Combo Box, assignment description, combo box
assignment description, combo box, table updates: Dear Mark, Source for your details form should use a query that uses your combo box value as a parameter - this way each time you change combo box value your detail form source will automatically change. If this tip is not an answer to your question,...

Visual Basic: find and hilight cell value, macro code, existence
macro code, existence, email: your sheet is in openoffice document. my macro works in office 2003. initially you stated that you wanted the values in column A to be checked for existence in sheet2 and highlighted. but i see you want values from other columnss have been checked and...

Visual Basic: visual Basic 6.0, vitaly, siva
vitaly, siva, visual basic 6: Dear Siva, I need more information from you to answer your question, could you, please, provide FULL DESCRIPTION OF YOUR ASSIGNMENT, i. e. what is your input (what should be entered in form), and what are you expecting to be an output? In what form? (Is...

Visual Basic: What is the macro code for displaying in full-screen mode a slideshow inserted in a Word document?, english french translation, heart image
english french translation, heart image, macro code: Dear Jerome, Please, check this link: http://office.microsoft.com/en-us/powerpoint-help/create-and-distribute-a-self-running-powerpoint-presentation-HA001034817.aspx From above mentioned link: you should change your PPS file: Setting and rehearsing...

Visual Basic: Re: List box problem, time interval, paypa
time interval, paypa, dataone: you are the one asking question after question. a new problem close a form after some time. How much time? what is the specific interval. dont worry about payment you can pay thro paypa to the contact email id i shall give later. write to me at mgravi2005@dataone.in...

Visual Basic: Save Selected List box item into access database, listindex, database answer
listindex, database answer, question thanks: as i have told u before, i do not like to waste my time on hypotherical problems. but if you want me to help u out with this problem, you need to pay me for it. dont ask me how much because my rates are high. make me an offer and if ok i ll do it for u. else,...

Visual Basic: Thanks so much., timer value, time interval
timer value, time interval, subject names: Hi, Thomas, You can use Label control, just change it text every second with the timer value - the one you are using to close the form. Use standard Format function to display in this format 00:00 (minutes:seconds) - looks like you ll need User-Defined...

Visual Basic: Updating a Database From Visual basic, database in access, data grid
database in access, data grid, grid cell: Hi, Jade, I need to see the code you are using: 1) to change values in Grid; 2) to save changes to Access - then I could have help you. Meanwhile I could only suggest you could use grid cell value to make changes like this: Grid1(Grid1.RowSelected,...

Visual Basic: VB runtime error, type mismatch, command2
type mismatch, command2, runtime error: Dear Kaveri, Which part of the code producing an error? Is it Save_Fields function? I cannot answer your question because you didn t specify where the error originated from. This is what you should do: put Breakpoint at the very beginning of your code...

Visual Basic: VB6.0: SQL SELECT, sql code, ms access
sql code, ms access, sting: dim rs2.as adodb.recordset,sql as sting dim conn1 as adodb.connection set conn1=new adodb.connection set rs2=new adodb.recordset esql= select * from CusTable where Customername= & & text2.text & rs2.Open (esql),conn1, adOpenStatic, adLockReadOnly...

Visual Basic: Visual basic, vitaly, ehs
vitaly, ehs, msdn: Dear Mohammad, Please, check those links: http://visualbasic.freetutes.com/learn-vb6/lesson4.html http://www.saskschools.ca/~ehs/HeiseIntra/VB/Lesson57.html http://msdn.microsoft.com/en-us/library/21daexkw%28v=vs.80%29.aspx http://msdn.microsoft.com/en-us/library/eked04a7%28v=vs.80%29.aspx...

Visual Basic: vb error 91 while scrolling a dbgrid, public const, mod wheel
public const, mod wheel, mousewheel: Dear Ashish, frmFreeFormatOutput is a class and class by definition is exposing only Public members. grdPrompts is a control which by default is Friends not Public class member. You can change grdPrompts declaration from Friends to Public and see what will...

Visual Basic: vb rutime error in vb 6.0, command2, string x
command2, string x, vb 6: Dear Kaveri, Comment out all On Error statements (Like On Error GoTo Err1 or On Error GoTo ErrDate etc.). Step though the code, find which statement gives an error, tell me which statement it is, send me FULL ERROR DESCRIPTION with all the words and...

Visual Basic: Loading a multidimensional structure in Visual Basic, multidimensional structure, wholesale changes
multidimensional structure, wholesale changes, modal form: Dear Richard, As far as I understand: 1) you have all data saved to database; 2) on 2nd form you want to show all seasons for the selected team. If this is the case then you need to perform those steps: 1)When you open the project define global dynamic...

Visual Basic: note pad title center alighment in vb6, vbtab, productivity report
vbtab, productivity report, path database: Dear Hameed, Setting the alignment of text isn t quite so simple, VB doesn t provide an align property. Instead, we need to work out where the middle of the page is, and then take into account the width of the text. Take a look at this code, which prints...

Visual Basic: RND seed, matrix dimensions, rnd function
matrix dimensions, rnd function, computer clock: Dear Peter, As far as I understand you need a way to save your 2d matrix of values for a future use. One way to do it is to save your set of values to any database as a string. Let s say you have 3x2 matrix like this: 4 56 74 54 34 21 You can convert...

Visual Basic: Searching and displaying, using visual basic 6, members database
using visual basic 6, members database, vitaly: Dear Ludovic, Please, check this link: http://www.vbtutor.net/lesson23.html When you open it you ll see a very good tutorial on How to develop database applications in VB. The link is to a lesson 23, but you ll probably need lessons 24-27 also. ...

Visual Basic: Stop concatenating numbers, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, exercise standards: Convert your TEXT values to LONG INTEGER values: MyBox = CLng(Txt1)+CLng(Txt2) Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts...

Visual Basic: vb6+oracle, computer engg, vb6
computer engg, vb6, rnd: Dim num As Integer Private Sub Command1_Click() Randomize num = Int(Rnd * 16) + 1 Label1.Caption = num End Sub this gives a random no from 1 to 16 which can be changed by changing 16 to bigger no. the questions can be based on the...

Visual Basic: direct reading from SD/MMC, sd mmc, listindex
sd mmc, listindex, getfolder: Dear Naser, What kind of memory drive are you talking about than? How are you defining it? As far as I understand for the computer the memory card is just another drive which could have files or folders only. Could you please give me as much details as...

Visual Basic: Excel 2003 VBA TextBox, true text, text2
true text, text2, vitaly: Dear Vic, Try this: With Txt1 .MultiLine = True .Text = line one & Chr(13) _ & line 2 & Chr(13) _ & line 3 End With Please, make sure you do not miss this line of code: .MultiLine = True Sincerely,...

Visual Basic: Excel VB Problem, excel vb, chris answer
excel vb, chris answer, question thanks: Dear Chris, Try something like this: Dim S1 as String Dim S2 as String Dim i1 as Integer For i1= 100 to 1 step -1 s1 = d & i1.ToString If Range(s1) = Grained 8 Then s2 = i1.ToString & : & i1.ToString Rows(s2).Select...

Visual Basic: Macro Error, excel vb, window explorer
excel vb, window explorer, excel application: Dear Denine, First of all make a copy of the original file and put it somewhere in safe place (Some other directory different from where you normally save it). And if newer version wants to convert - convert! And see what s happened. If conversion is successful...

Visual Basic: Progressbar/Listview interaction, cd burning program, cd capacity
cd burning program, cd capacity, google: Dear Josh, Please, check this link: http://support.microsoft.com/kb/323088 As stated in linked article you need to create a new User Control - code provided in this article. Study this article, use their code as is or change it to accommodate your...

Visual Basic: reminder note, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, medicine reminder: Yes, of course. Just about anything is POSSIBLE with Access. Exactly WHAT you can do is only limited by your knowledge of Access. If you re a novice, I d recommend just a reminders form that loads up when your database starts. You can make a query with...

Visual Basic: save data unique from msflexgrid, activex data objects, jet oledb
activex data objects, jet oledb, microsoft activex: the flexgrid is for storing data retrieved from the database. instead of insert better use AddNew code sample is as below: just make changes as needed Option Explicit put a check mark on Project_References_Microsoft ActiveX Data Objects Library.Put...

Visual Basic: SNMP Project (Need Help), value host, oids
value host, oids, local host: Dear Madiha, Find your old project and check is it still working. If it is, then make your code changes again, but this time do one thing a time: 1. Add datagrid - run the project - make sure it s working 2. Add extra button (or any other control...

Visual Basic: SubRoutine and Function Question, igetit, question question
igetit, question question, final answer: Dear Vince, Because of this code line in DoThis function: iPart1 = iGetIT(iList1, “B”) So what is iList1? It s 1st parameter when we call DoThis function. This is a call to DoThis function in GetFinal function: Call DoThis(iListA, iListB) ...

Visual Basic: VB 6.0 and MS Access, esql, time2
esql, time2, connectionstring: sample for date filter Dim conn As ADODB.Connection, rec As ADODB.Recordset, esql As String, dater2 As Date, GOOD As String, time1 As Date, time2 As Date Private Sub Command1_Click() GOOD = Chr(35) dater2 = #1/1/2002# time1 = Format(Text1, short time...

Visual Basic: Visual Basic 2008 Codes, enable button
enable button: As with Visual Basic 2008, there is an Express Edition for Visual Basic 2010, which is totally free. Just go to MS website and download it. As for the rest: you have posed 3 question rolled into one, which is not allowed here. Please seperate the questions...

Visual Basic: Combo Boxes - Addition, combo boxes, dropdown boxes
combo boxes, dropdown boxes, store numbers: Yes, you are on the right track. You see, ComboBoxes do not store numbers as numbers (integers) but as texts (strings). This is why they they neither sort nor add numbers correctly. Let me know if you understand the different classes of variables and I can...

Visual Basic: SELECT with GROUP BY Joined to Subquery, syntax errors, pseudo code
syntax errors, pseudo code, dataset: Interesting problem :) It seems to me, that this is a problem of the parser: you as a human might know that the end result would be unique, but programs work on set rules, and as generally it is true that two non-uniques do not make a unique, the syntax...

Visual Basic: dbgrid32.ocx, deployment wizard, dbgrid control
deployment wizard, dbgrid control, computer copy: this is because the second computer has not got vb6 installed. these controls like dbgrid are not automatically added in a programme as they need to be registered in the second computer. copy the dbgrid32.ocx from the first to the second in the windows system32directory....

Visual Basic: pdf file opening, visual basic tutorial, command button
visual basic tutorial, command button, tutorial pdf: Hello sir, Actually i never tried to import content of pdf file into a vb6 application. So, I searched it on google and i got two references. There are two ideas from which we can try to import the data. I am not sure as i have not tried this at home, but...

Visual Basic: VB6, package and deployment wizard, ocx file
package and deployment wizard, ocx file, setup wizard: this is because the 2nd computer does not have vb runtime files. the setup wizard works fine if the 2nd computer also has vb but runs into snags if it does not have vb. so your problem of using exe and registering .ocx file seems to be the only way out...

Visual Basic: c++ dll, for use in Vb.net, c dll, release mode
c dll, release mode, c project: Dear Derek, Open your VB.Net project, right click on project name, select Add Reference, it should open pop-up form, and on this form you need to select tab Projects, and browse to your C++ project and select your DLL (just make sure your C++ project is...

Visual Basic: Save and email macro, outlook application, vitaly
outlook application, vitaly, subject title: Dear Jeff, Code you sent me has only code to send e-mail, so I can discuss only the e-mail sending part of your application. You have this statement: .Attachments.Add ActiveWorkbook.FullName So you are sending ActiveWorkbook, - which means you...

Visual Basic: Sorting identical information, sout, vitaly
sout, vitaly, messagebox: Dear Wayne, All you need is to find what is 1st dot position in string. After you have it - let s say it in the variable i1, - you just need mid part of the string starting from position (i1 - 2) and ending at the string end. You ll need 2 functions: InStr...

Visual Basic: Storing + calculating moving average, global variables, new numbers
global variables, new numbers, vitaly: Dear Derek, You need to start using Global variables. You entering them right after Class definition, something like this: Public Class Form1 Private iNumber As Integer = 0 Private arrNumbers(5) As Double Private dblAvg1 As Double ...

Visual Basic: update database, open database, vitaly
open database, vitaly, ms access: Dear Japetko, Looks like something s happening when you close it and do something in source code - you do not tell what, so I could only guess... Could you, please, check what you are doing in source code? Are there any Delete statements by any chance?...

Visual Basic: vb.net read registry, game starcraft, meaningful answers
game starcraft, meaningful answers, starcraft2: First thing before we begin: Do you know how the registry is structured and have you ever used regedit? I can help you in any case, but I need to know your level of knowledge to give you meaningful answers. And yes, I can help you to read the registry. ...

Visual Basic: VB6, sales and inventory system, price column
sales and inventory system, price column, fourth column: Sir, Computing the total of any column in the list view is very simple. I have written the code here. but i have not tried it before writing this because I don t have vb6. Here i assumed that your price column is the fourth column in the list view. dim...

Visual Basic: Adding value in ListView Vb6, 5th column, syntax error
5th column, syntax error, convenient store: Dear jhomz, I need more info: 1. What version of Windows are you using (Windows XP, Windows Vista etc.)? 2. What version of VB are you using? (VB6, VB.Net etc) And, please, send me your full program code and specifically what kind of syntax error you...

Visual Basic: reading the log file in vb6, array functions, string array
array functions, string array, split function: Hello Izhar, First of all, sorry for late reply. I think your question is how to split this (17 11/29/2011 5:55:15 AM 0 2.9192 66.6 29.27 29.272 993.98 2.3 -0.18 0.48) string. In VB6, this can be achieved using split function which is inbuilt in vb6. Also,...

Visual Basic: reading the log file in vb6, microsoft msdn, split function
microsoft msdn, split function, vitaly: Dear Izhar Nasir, Use Split function with space as a separator - as a result you ll have an array A, where A(0) will be 17, and A(9) will be 993.98. This is Split function reference from Microsoft MSDN: http://msdn.microsoft.com/en-us/library/6x627e5f%28v=vs.80%29.aspx...

Visual Basic: ctrl+c, student information system, password character
student information system, password character, password property: Hello Rhannie, VB6 allows to set the password character for textbox. Set the password property to the character which you want to show as a password character for e.g., *, #, $, etc. It will give the result like, *******, etc. This should work properly with...

Visual Basic: Display Amount in Word in VB 6.0, reverse number, vb 6
reverse number, vb 6, digits: Hi Manish, There is no in-built function to do this. You have to write the logic for it. Here is my logic. Break the number in each digit and store it in array. Before going further note that the array has reverse number that is if no. is 1252 it will...

Visual Basic: Display Amount in Word in VB 6.0
Visual Basic: Display Amount in Word in VB 6.0

Visual Basic: help, object oriented languages, sequential languages
object oriented languages, sequential languages, first languages: Dear James, I m not sure what you are looking for, and I m really guessing here that you are studying how programming languages changed over time. First languages were just list of commands that you could put in a special file - batch file, - and then...

Visual Basic: inputbox, box message, input box
box message, input box, vitaly: Dear Dimitris, You can use standard Input Box/Message box: Dim inpBox As String = InputBox( Enter String , My Input Box , Hello! , 156, 245) 156 here is equal to control Left property and 245 is equal to control Top property ...

Visual Basic: login form problem, chris answer, image layout
chris answer, image layout, class login: Chris, In your code block: Dim str As String = SELECT convert(varchar(10), DECRYPTBYPASSPHRASE ( 12 ,password)) from Authenticate where username = chris Dim ds As New SqlDataAdapter(str, con) Dim cmdGet As New SqlCommand(str,...

Visual Basic: rnd different num, ascii number, cint
ascii number, cint, vitaly: Dear Dimitris, a) and b) First of all: Change: Dim i, s To: Dim i, s As Integer 2nd, this code: For Me.i = 1 To s - 1 runs 9 times, if you need 10, it should be: For Me.i = 1 To s As for the main question: after you received...

Visual Basic: trap double spaces in vb6.0, student information system, array value
student information system, array value, array values: hello Rhannie lloyd, There is no inbuilt function to do so. You have to write the logic for that. Take an array. put the textbox value into that array.. and check for white spaces. If white spaces are rea[eting consecutively, remove that (shift the array...

Visual Basic: trap spaces, trap spaces, student information system
trap spaces, student information system, double spaces: You can use something like this TextBox1 on form = Visual Basic Dim TextString as String Dim TextLengthInterger as Interger Dim NewString as String Dim FirstHalfString as String Dim SecondHalfString as String Dim FoundSpaceBoolean and Boolean...

Visual Basic: VB6 to MS Access 2003, activex data objects, microsoft activex
activex data objects, microsoft activex, adopenstatic: put a check mark on Project_References_ Microsoft ActiveX Data Objects Library you can addnew and display in the same form1 and eliminate Form2. have 4 commandbuttons and 2 textboxes and add this code. you need to alter the path and add more textboxes...

Visual Basic: ADODB, activex data objects, jet oledb
activex data objects, jet oledb, microsoft activex: what is the story of a newly married girl? i am curious, as i don t remember my answer. there are lots of tutorials in the web for adodb. here is a sample code: the declarations: check Project_references_Microsoft ActiveX Data objects 2.8library (or...

Visual Basic: save two text b., filewriter, filereader
filewriter, filereader, tb1: Dear Dimitris, Please, check this link: http://www.homeandlearn.co.uk/net/nets8p5.html It has sample code which you can modify according to your needs. As always, you need to study the code, understand how it s working and then use changed version...

Visual Basic: VB6, question sir, command buttons
question sir, command buttons, text1: put a text box, 1 list box and 3 command buttons on form. add code: Private Sub Command1_Click() this is to be done for the first time to open the file and add the 1st record Open c:sample.txt For Output As #1 Print #1, Text1 Close #1...

Visual Basic: Visual Basic 2010 Express, expert settings, dear james
expert settings, dear james, release directory: James, Short answer is yes. The long answer has a lot of if . As far as I know, you can copy an EXE file whenever you want on the computer with Microsoft Visual Basic Express 2010 installed, and it will run - but only on this computer. It will not run...

Visual Basic: Auto Increment of number using system date, auto increment, caus
auto increment, caus, vitaly: Dear Karl, Yes, this problem could be solved using loops, so the problem is within your code, and you didn t supply one. So, please, send me your code so I could troubleshoot it. One more thing needs to be clarified: according to your assignment, this...

Visual Basic: Enter a Message, commandbutton, msgbox
commandbutton, msgbox, adu: press alt and f11. choose insert userform insert another userform then create a macro say Macro1 with code as below: Sub Macro1() UserForm1.Show UserForm1.Hide End Sub put a commandbutton each on the forms and add the code: on button in userform1...

Visual Basic: Excel VBA, excel vba, length len
excel vba, length len, double application: sample code Sub DateStorer() Dim adu As String, arra(1 To 10) As String, i As Integer adu = Cells(1, 1) this can be input box etc For i = 1 To Len(adu) If arra(i) = / Then GoTo 1 arra(i) = Mid(adu, i, 1) 1 Next i For i = 1 To 10 If arra(i)...

Visual Basic: Vb 6.0 + ACCESS, railway reservation system, text1
railway reservation system, text1, datagrid: when you use dataenvironment, you need to use datareport to show the results. you need to use the sql in DE select * from Tablename where Userid=? and in datareport you can use Private Sub Command1_Click() With DataEnvironment1 .Command1 Text1...

Visual Basic: Vb + Access, gym management, membership expiration
gym management, membership expiration, stuck in one: Private Sub Command1_Click() Dim adu As Date adu = CDate(Text1) List1.AddItem Format(DateAdd( m , 3, adu), medium date ) or label1.caption etc End Sub Private Sub Form_Load() Text1 = Format(Now, Medium date ) End Sub using this you can...

Visual Basic: Vb Combobx Locked and unlocked through condition, listindex, suitable changes
listindex, suitable changes, gotfocus: sample code: have another combo2 visible =false and add this code: Private Sub Command1_Click() Dim i As Integer Combo1.ListIndex = 0 For i = 0 To Combo1.ListCount - 1 Combo1.ListIndex = i If Combo1.Text = Val(Text1) Then Combo2.AddItem Combo1.Text...

Visual Basic: VB.net?, oriented programming language, object oriented language
oriented programming language, object oriented language, object oriented programming language: Dear Yohan, To answer your question I need to write a book, - so I can give you only a short answer. .Net platform and VB.Net, in particular, is an object oriented programming language, which has more possibilities compared to VB6. And because VB.Net...

Visual Basic: vb6, menu programs, vb application
menu programs, vb application, documents and settings: Put the exe in the startup. If you do not want the program to start for all users C:UsersUser nameAppDataRoamingMicrosoftWindowsStart MenuProgramsStartup If you want the program to start for all users C:ProgramDataMicrosoftWindowsStart MenuProgramsStartup...

Visual Basic: Visual Basic ms excel Link, excel application, basic ms
excel application, basic ms, documents and settings: Private Sub Command1_Click() Dim xl As Excel.Application Set xl = CreateObject( excel.Application ) xl.Workbooks.Open ( C:Documents and Settings avindraMy Documents est_bed.xls ) substitute your file here xl.Sheets( test Bed ).Select xl.Visible...

Visual Basic: accessing similiar worksheets from multiple workbooks, excel sheet, database access
excel sheet, database access, finding information: Hi Dennis If you are trying to create a program to transfer your data in the excel document to the Access database, Access can import the data from the excel sheet. Just make sure your rows in both the excel sheet and access table have the same exact name,...

Visual Basic: how to connect 35 checkboxes to db wherein i can edit it as well., aj6, case statement
aj6, case statement, vitaly: Dear Clarence, You can use Select Case statement - check this link: http://www.vbtutor.net/lesson8.html. Also instead of saving each field in database as 0 or 1, you can save it as one string of 35 0s or 1s, something like: 11010001...1 . Sincerely,...

Visual Basic: Added workbook 'status', vitaly, problem description
vitaly, problem description, formulae: Dear Stephen, You compare with ts - what is it? String? Number? And how are you set ActiveSheet? Also you are using to compare, but I prefer = , and use Else clause. If you are comparing strings - so in A7 you have string and ts is a string, -...

Visual Basic: Assistance with copyto in Excel macro, column widths, copyto
column widths, copyto, excel macro: Hi John Sorry I have not gotten back to you sooner, it has been a hectic week. Because you are using Macros and I only use Visual basic I can only give you a general answer. They are very similar but do have differences. You would need to use something...

Visual Basic: making increments based on random number generator, random number generator, integer type
random number generator, integer type, basicly: Dear Vinoraj, You are comparing Label.Text property - which is string - and Integer: you should not do this. You need to declare helper variable of Integer type and first convert Text property into Integer, then compare. And again, when assigning, first...

Visual Basic: Saving newly added data in a row or rows from DataGridView into SQL Server, datagridview, sqlcommand
datagridview, sqlcommand, exclusion criteria: That is so because you have no exclusion criteria specified (SQL WHERE command), and so all data is taken. You will have to add a field to the rows that specifies the datetime the row was added or changed and then enhance your insertion query with an appropiate...

Visual Basic: selcting tje right language for my problem, oracle 10g, concurrent users
oracle 10g, concurrent users, problem thanks: The language ist easy: as it s an NPO, VB.NET 2010 Express is the one you want. It also includes a license for SQL Server 2008 for 5 concurrent users. However, if you have more than 5 concurrent users, then you are out of luck: there is no decent free database...

Visual Basic: Selecting and printing multiple pages in Excel using VB Script, allexperts, web link
allexperts, web link: Hi Ron, When you say it does not work, what does it do? Nothing? Give an error, if it provides an error what is it? Please provide as much information about the error as you can. Also pleas provide your code from the program, it makes it easier to troubleshot...

Visual Basic: Vb.Net Programming, global array, student ids
global array, student ids, query result: Dear Mary, You need to create a global Array for your Application, and put your students average in this array. To calculate an average you need to get all the data for each student from your database - and to get an average you should create a query...

Visual Basic: Visual Basic, find the median, sum scores, median value
sum scores, median value, set of numbers: First this line is too long: sum = scores(1) + scores(2) + scores(3) + scores(4) + scores(5) + scores(6) + scores(7) + scores(8) + scores(9) + scores(10) + scores(11) + scores(12) + scores(13) + scores(14) + scores(15) + scores(16) + scores(17) + scores(18)...

Visual Basic: Calculating a date in Access 2007, developer level, relevant dates
developer level, relevant dates, allexperts: These are not going to be easy dates to calculate. You re going to need loops and some date functions. I ll try to give you a start, but you ll need to polish it yourself. First, to calculate the 4th Tuesday in February, I would start with Feb 1st, and...

Visual Basic: Excel VBA to MS Visual 2008, object oriented language, excel vba
object oriented language, excel vba, converting tools: Dear John, You said about conversion VBA to VB.Net: This is really tedious and I know there s got to be an easier way. Conversion is never easy and there is no easier way. There are several syntax converting tools, but they never catch procedure...

Visual Basic: General programing, visual basic tutorials, good starting point
visual basic tutorials, good starting point, engineering company: Hi Vicente, I have only written programs that interact with MS Office. I have not written anything that interacts with Autocadd, Photoshop or any other program. You can create macros with in MS Office. You can also create your own programs to interact...

Visual Basic: Referencing cells mutiple ways in Excel, runtime error 424, orng
runtime error 424, orng, followup question: Dear Jeff, Looks like there was a misunderstanding, and I m sincerely apologized for it: my code is run from VB.Net, not form Excel, and that make a difference - I m a VB expert not Excel VBA, so while this code is perfectly running from VB.Net, I cannot...

Visual Basic: Referencing cells mutiple ways in Excel, orng, vitaly
orng, vitaly, excel worksheet: Dear Jeff, second statement is not: i1 = 1 it is i1 = i1 + 1 (I was using short VB form i1 += 1 - it s working in VB but obviously not in Excel VBA). So try to replace with i1 = i1 + 1 - should work. And make sure you put i1 = 1 in...

Visual Basic: Searching, column name, value1
column name, value1, thanks in advance: Hi Jonarde, I don t know whether you know about BETWEEN keyword of sql. SQL has BETWEEN keyword to find or search type of records what exactly you are looking for. We can use BETWEEN keyword for any column having any data type for e.g number, date. ...

Visual Basic: How to solve it about surface area with VB, math pi, private function
math pi, private function, form1: Hi, Dongil, Create a new windows forms project (I m using Visual Studio 2010 Express). On the Form1 add 4 controls: 2 textboxes - txtLow and txtHigh (in 1st one you put your lower x value - 1 in your case, in 2nd - high - 2 in your case) - button Button1...

Visual Basic: vb6, activex data objects, microsoft activex
activex data objects, microsoft activex, esql: this is not a follow up to the above question. anyway, you need to create a query in access using the payment field and add a field showing the sum of this field. to the button click which gives you the datagrid details, add another recordset showing the...

Visual Basic: VBA Excel question, value contents, value application
value contents, value application, dear frank: Dear Frank, Providing you variable Contents is an Integer, I d slightly changed your code to: Sub ShowValues() Contents = 912 MsgBox Contents.ToString() Application.Workbooks( LunchMenu.xlsm ).Worksheets(1).Range( C6...

Visual Basic: connectivity between excel and vb6, excel application, documents and settings
excel application, documents and settings, createobject: Dim xl As Excel.Application Dim strFileName As String Private Sub Command1_Click() Set xl = CreateObject( excel.Application ) xl.Workbooks.Open ( C:Documents and Settings avindraMy Documents est_bed.xls ) substitute your file here xl.Visible...

Visual Basic: create a Visual Basic app for Network IP camera, visual basic application, network ip
visual basic application, network ip, ocx: Neither ActiveX nor the OCX format have been in use for over a decade. Microsoft dropped all support for it and VB6 14 years ago. Thus, my advice is to move to VB.NET immediately. This also has the nice side effect that you can address the camera directly....

Visual Basic: Error on calculated query field, run time error, currentaccount
run time error, currentaccount, aggregate function: you have not mentioned where the error occurs: on form load or button click. i also see that on form load event you have opened rec based on text1 value and used opendynamic. this is not proper. form load should just open the connection. assign recordset...

Visual Basic: create a Visual Basic app for Network IP camera
Visual Basic: create a Visual Basic app for Network IP camera

Visual Basic: Ranking Students Marks
if i remember briefly you are using vb 2010. is that right? i code only in vb6 mostly and i do projects only on payment. i think i suggested using a function. i can give you the code for the function but you need to pass this function in your code. if you...

Visual Basic: Ranking students marks, microsoft jet, jet 4
microsoft jet, jet 4, connection string: this ranking in access requires a bit of planning. the reason is that the ranking is same if the score is same. like your 7th,(70) which is same for the next 2 nos. to overcome this, you need to pass the marks to a function which will loop thro the records...

Visual Basic: vb6 access report, access report, poor response
access report, poor response, ccb: first of all you did not acknowledge receipt of my answer and tell me how it is working. i consider it poor response. i cant say why it should not run again unless you have changed the path or NOT closed the access application manually. the access application...