	AllExperts > Experts
	Search

About Ravindra
(Top Expert on this page)

Expertise
visual basic application programming from design to access information, sql, engineering and commercial applications. access databases, excel. Optional: 1)a large number of people want me to do work which takes some time and effort. Pl.note that i would like to be paid for such work. 2) if you want me to spend quality time and do special work, i expect to be paid a reasonable price for my time. 3) if you are pleased with my reply you could consider a donation of 1$. 4) you can visit my website http://ravindra.coolpage.biz (under constrn)

Experience

Past/Present clients
project work for a Norway company, and a Canadian company completed. Freelance Project work and Teaching
teaching vb

You are here: Experts > Computing/Technology > Basic > Visual Basic

Questions Answered By Expert Ravindra
In Category Visual Basic

Subject	Date Asked

Code problem	10/14/2008
Q: Hey i wonder if ya can help, im using VB 6 and bascially i have a code to hide rows that have spare ... A: i dont like your hiding the rows based on contents. it is not a good coding logic. why disturb the ...
Excel Macros	10/11/2008
Q: I have to sheets. Sheet 1 have some columns like 1,2,3,4 and rows A,B,C,D_ _ _not fixed. Can ... A: remember that this is a free site and you are using my time. if you want any help, you should be ...
VBA Option Explicit error	10/10/2008
Q: I am updating and maintaining a database written by someone else. I have very little VBA or Access ... A: option explicit means you have to predeclare the variables before using them. here validate and ...
don't read removable disk	10/10/2008
Q: sir i know you are an expert of vb, I hope you can answer my problem...i have a visual basic project ... A: if you make an exe of the project file and use a package and deployment wizard and turn out a ...
How to pass an array of TextBoxes by parameter to a Sub	10/9/2008
Q: I am working with Visual Basic 6.0 and my level is intermediate. I am working with forms containing ... A: have all the textboxs in one array and use this code to empty them Option Explicit Private Sub ...
VB code	10/9/2008
Q: I have sent you a question about VB and you said that it is not VB. I think that the code is VB ... A: the windows logon details are available in the registry and if you are at least an inter level ...
A Question related to vb 6	10/9/2008
Q: Please guide me how to scroll a ms flex grid using PgUp and PgDn keys on keyboard Thanking you ... A: i do not like your coding. anyway this is your lookout the scrolling by code can be done with this ...
vb excel	10/8/2008
Q: How can I populate the data I entered on our purchase order running on macro (PO number and date ... A: if you have excel, then access must be there; it is part of Msoffice. in excel alone, you may not ...
excel vba	10/8/2008
Q: can u guide me with excel vba. i have some questions. am working on current project on vba excel ... A: you need to make macros dealing with each range where formatting needs to be done. to format the ...
A Question related to vb 6	10/8/2008
Q: Sir, I want to protect my software using a username and password form to be loaded as soon as I ... A: a genereal description of such a nature cannot help me locating your source of error. how can i ...
vb excel	10/8/2008
Q: How can I populate the data I entered on our purchase order running on macro (PO number and date ... A: this can be done in Visual Basic and access. using Excel and macros may not be suitable. if you have ...
values	10/7/2008
Q: i make a value of alphabet example A=1,B=2 and write any person name the name value is appear how i ... A: you could use use arrays and make it a number. it is not such a hot idea. because letters z,v,w etc ...
Get Data from DBGrid	10/7/2008
Q: Sir. I want to get the data of only one column from DBGrid at runtime before updating the Database, ... A: question unclear to me. the dbgrid gets its data from the database, so what do you mean at ...
VB6 and Access DB, search between two dates	10/7/2008
Q: I read a question today regarding subject, I don't understand the GOOD=chr(35) . . . Using VB6, ... A: the problem here is you are picking my answer in part1, add your own code, and take my help and ...
VB6 and Access DB, search between two dates	10/7/2008
Q: I read a question today regarding subject, I don't understand the GOOD=chr(35) . . . Using VB6, ... A: 1)you dont understand GOOD? then have BAD=chr(35). it is used to avoid confusion of the characters ...
vb+excel	10/6/2008
Q: i am using vb 6.while exporting to excel i am not getting the negative values from ms access dbase ... A: why not export directly from access to excel using the auto wizard? you will get all the values why ...
Saving data entered in vb6.0. form to a table in Access 2003	10/5/2008
Q: I am getting an error regarding data type mismatch and parameters. When trying to save customers and ... A: that is better.i understand the question now but require some more clarification. it is clear that ...
Printing With DataGrid In VB6	10/4/2008
Q: How 2 Print Content Of Data Grid In VB6 i m using following codes Private Sub cmdPrint_Click() Dim ... A: you are using your own code for display and using a loop to fill a textbox. this does not make ...
Printing With DataGrid In VB6	10/4/2008
Q: How 2 Print Content Of Data Grid In VB6 i m using following codes Private Sub cmdPrint_Click() Dim ... A: rowset problem arises if grid is not displaying the data. 1)the code sent by me works alright. 2) ...
How to Open .hlp in vb project	10/4/2008
Q: Sir. I'm a computer engi student, i trying to studying Visual Basic my self. But Sir i have ... A: first, you need to correct your english syntax then vb syntax. i trying shows bad choice. then in ...
problem in filling datacombo in vb.6	10/4/2008
Q: I'm inter in vb.6 and i have a datecombo and a textbox in one of my form.i want my datacombo to be ... A: dim conn As ADODB.Connection, rec As ADODB.Recordset, private sub form Load() Set conn = New ...
Printing With DataGrid In VB6	10/3/2008
Q: How 2 Print Content Of Data Grid In VB6 i m using following codes Private Sub cmdPrint_Click() Dim ... A: first all the lines for datagrid1.columns(... in above code should be in one line. second, you dont ...
regarding to "Data Report of VB 6.0"	10/3/2008
Q: Repected Sir, i've completed project in VB 6 and in Data report i want to display the report ... A: your question is not clear. i couldn't success (gramatically incorrect) and does not say what the ...
about vb	10/2/2008
Q: ....i m a beginner in vb6, i hav refffered d code which u hav given to kevin...on 16/8/2006...i m ... A: have you put a check mark on Microsoft ActiveX data objects Library 2.8 under Project_References? ...
Importing lines of data from a text file	10/2/2008
Q: I wanted to know what Visual Basic (VB 6.0) code I might use to import specific lines of data from a ... A: in such a case you need to Read the text file move next if the lines are not required and then ...
Select data between two date fields	10/2/2008
Q: i have developed a VB6 project using ms access database. my level of knowledge will be between ... A: first, you need to modify your tables. the tables should receive data and you can use queries to ...
modifying a record	9/26/2008
Q: respected sir, please tell the coding for vb6 in modify a record. thank you A: Option Explicit dim conn As ADODB.Connection, rec As ADODB.Recordset, esql As String Private Sub ...
rs.addnew inserting rather than adding	9/22/2008
Q: I;ll pay you £20 for a solution...(probably obvious to you!) VB6, Access Database, DAO: When I add ... A: it is nice of you to offer 20GBP. i'm willing to solve your problem. 1st which is your version of ...
VB6 & Access 2003	9/22/2008
Q: I am a beginner with databases. In writing my program, I am creating a database programmatically. I ... A: no change in case of dates except it should be formatted to same as the table design. suppose the ...
vb 6.0	9/22/2008
Q: how can i prevent duplicate entry in database , i have Student table where idno and scholar no are ... A: Option Explicit 'put a check mark on Project_references_ Microsoft ActiveX dataobjects 2.8 library ...
VB6 & Access 2003	9/21/2008
Q: I am a beginner with databases. In writing my program, I am creating a database programmatically. I ... A: under project_references put a check mark on Microsoft Data access components 2.6 / 2.8 or ...
vb6	9/21/2008
Q: I have designed an application with vb6. When I run this application on other systems, fonts change ... A: you are asking the question in reverse. the standard fonts are already chosen on other computers. ...
Calender control	9/19/2008
Q: Im facing permission denied error while trying to add Microsoft calender control in my program.can ... A: check for existence of mscal.ocx this should be in C:\Windows\system32 directory you can get this ...
date setting control in vb	9/18/2008
Q: sir I want to change the date setting in system through vb coding. please give me an idea about ... A: this is an unhealthy practice because if someone changes the system date and time you need to have ...
Runtime Error	9/10/2008
Q: I consider myself a beginner when it comes to writing macros. I'm trying to write a macro that will ... A: type mismatch means data type error. the macro is working fine in my excel work book. the cola ...
Runtime Error	9/9/2008
Q: I consider myself a beginner when it comes to writing macros. I'm trying to write a macro that will ... A: note this is NOT visual basic but Visual Basic for Applications (VBA) they are different programmes ...
visual basic 6.0	9/8/2008
Q: i am a absolute beginner.i want to learn visual basic,but confused which version should i learn, ... A: 1)stick to vb6 2) links to sites http://www.codeguru.com/vb/ ...
VB6 & SQL Server 200	9/6/2008
Q: I have a project on VB6 and the back end is SQL Server 2000. My problem is how am I to run the ... A: sample code: esql = "insert into testable values" & "(" & "'" & Text1 & " '" & "," & Val(Text2) & ...
vb+oracle	9/4/2008
Q: my name is afnan zubair. i was the one who asked u to do a project on sports club management. i sent ... A: you are from Dubai right? ok, give me the details of what you want in this programme. i do a large ...
Excel listbox	9/3/2008
Q: Can you please help me with my problem regarding listbox indexing. I am trying to assign a specific ... A: try this: Private Sub ListBox1_Click() Static Myse As String Dim id As Integer Dim x As Integer ...
doing OCR on VB	9/1/2008
Q: 1.) VB6 2.) not really 3.) I can understand / manipulate some codes (begginer i think) 4.) VB + OCR ... A: checkout this link: ...
vb 6.0 quest	8/31/2008
Q: explain the difference between declaring a variable in general declaration section of std code ... A: it would be nicer if your question started like could you please explain... the tone appears ...
VBA 6.05 +Access 2003 EVAL function use	8/25/2008
Q: Requested info: VBA verison 6.05, ADO version 2.8 +Access 2003 version 11, Intermediate knowledge ... A: you could use a function like Private function Selector(olage as integer) and in the function add ...
Caesar Cipher - VB	8/24/2008
Q: I'm fairly new to Visual Basic but i have some basic knowledge and if you could help me with the ... A: it is not the problem in VB but the logic of how to set about. it may be a bit of a struggle if you ...
Visual Basic Commands for Microsoft Word 2007	8/22/2008
Q: (I would definitely say I am a beginner) I'm using what the about window says Visual Basic 6.5 and ... A: you are chewing more than your zone for a beginner. first,this has nothing to do with visual basic ...
Making a field that can act like excel in VB6	8/22/2008
Q: I am working on a database project (using VB6 and access database, ADO connect) for my own use. What ... A: by link a database to datagrid to DISPLAY? is that what you mean. the datagrid is only for display ...
Easy question	8/21/2008
Q: I want to insert a page break if there is a value in a column a. The break should be immediately ... A: 1) how do you say easy question? 2) what is a pagebreak in excel? it is only for printing. for ...
API	8/20/2008
Q: I have an application which needs to determine determine whether the caption of the command button ... A: why api have two command buttons and add this code Option Explicit Dim adu As Boolean Private Sub ...
VB 6.0	8/18/2008
Q: mr. Ravindra.i need your help. In my accounting audit system software, I need to audit the ... A: for a beginner your code is improper. now why not get the IDs into a listbox (not listview) and ...
vb6 Slider Plz help me...	8/17/2008
Q: I have added slider to my project. And i have changed its orientation to 1-sldVertical then the ... A: first, your words "Please some body help me." is plain STUPID. you are asking me the question and ...
Change code with cell value	8/15/2008
Q: I have code that get file names from a directory, but I do not want to have the user have to go into ... A: there are a number of errors in your code: 1 you are using Application.screenupdating etc before ...
Setup Wizard	8/12/2008
Q: I have been using VB 5.0, as a self taught programmer for many years. I have been using it for ... A: the package and deployment wizard is part of visual studio tools. perhaps this installation covered ...
Setup Wizard	8/11/2008
Q: I have been using VB 5.0, as a self taught programmer for many years. I have been using it for ... A: sometimes vb files get corrupted and produce some errors. try uninstall vb fully and reinstall. if ...
printing a form in vb	8/11/2008
Q: i want to print the current form and as wel as save the form in word document after printing it..plz ... A: first, you can print the form using printform command. i do not know why one should save the ...
Visual Basic	8/6/2008
Q: i can pay u, no problem. how is the payment system?.... i need the project on sports club management ... A: good. i'll make the project for you.before that,confirm these: payment thro' Paypal. easy. 1) you ...
vb+excel+notepad	8/6/2008
Q: I have used your code of extracting notepad contents to excel. Its working fine. I had a problem ... A: firstly, i dont like a weblink to my own reply. it is pure waste of my time. why cant you add the ...
pausing a macro for user entry. vb+excel	8/5/2008
Q: Using VB 6.3 Fairly good knowledge of vb, self-taught. I must transfer a lot of data from access ... A: any system design which calls for copy paste 40 times a day is surely not very logical. to make ...
pausing a macro for user entry. vb+excel	8/5/2008
Q: Using VB 6.3 Fairly good knowledge of vb, self-taught. I must transfer a lot of data from access ... A: i dont see the need for any macro or such when you open the access database, choose menu item ...
about excel sheet	8/5/2008
Q: Sir,, I want to open an excel sheet in my vb project which I have saved in D drive.... Is there any ... A: put a check mark on Project_references_ Microsoft Excel 11.0 object library. option explicit Dim ...
How to print Report from MS Access	8/2/2008
Q: Please help me. I want to print report directly from Ms Access using VB 6. I had geberated the ... A: check my code after the line appaccess.visible =true there is a line exit sub then 1 set ...
ADO, VB6 Delete	7/31/2008
Q: I am a bit stumped with trying to delete a record form a Textbox. 1. the record was selected from a ... A: the problem here is the apostrophe in Bob's. sql gets confused in concatenation. to get around ...
Combo Box Trouble	7/31/2008
Q: Hey! I am trying to create a ComboBox with a default value visible and then when the arrow is ... A: the problem here is you are in Visual Basic help line and you are asking a question which is in ...
Accessing VB code in a Word Doc from a VB Program	7/29/2008
Q: I am trying to write a little VB program that will open an existing Word document that has a lot of ... A: my code was to be used as a sample. if you change appword.visible=false then the document wont be ...
VB+Excel	7/28/2008
Q: Full name: Jovan Roy Level: Beginner I put a command button on an Excel sheet to perform a loop. ... A: 1) for a beginner, such analyses is not reccommended. 2) there is no VB in excel, it is VBA which ...
Accessing VB code in a Word Doc from a VB Program	7/28/2008
Q: I am trying to write a little VB program that will open an existing Word document that has a lot of ... A: 'put acheck mark on Project_References_Microsoft Word Object Library Private Sub mnuWord_Click() ...
vb6	7/28/2008
Q: my database test.mdb is protected with password I write : public DB as Database set ... A: your code does not make any sense. switch over to ado and use this code: 'check Microsoft ActiveX ...
date format using date picker	7/28/2008
Q: ravindra, i wanna ask how to know the day name like monday, friday, saturday, sunday, etc with date ... A: Option Explicit Private Sub Command1_Click() Dim adu As String adu = ...
VB6 & Access Report	7/27/2008
Q: I have a report designed in VB6 however i would like to know if it is possible to bind a criteria to ... A: 'first create a report in access where all records are shown. say this is RTestable 'Under ...
Search for a FIle on a Drive in VB6	7/23/2008
Q: I am using VB6. I have been having some trouble determining the proper search command to search for ... A: 'put a check mark on PRoject_references _ Microsoft Scripting runtime Public Function ...
nesting of if else and checking multiple conditions in if else	7/23/2008
Q: how to nesting of if else and checking multiple conditions in if else A: are you also ravindra? there are different methods: you could nest a select case if passing ...
VB 6 And report	7/19/2008
Q: Please, I designed Access report and use VB6 to invoke it, but whenever I invoke it, it opens ... A: in access database choose Tools_startup in display forms combobox choose none. uncheck all options ...
Regarding datagrid	7/18/2008
Q: Sir, I want to display records in datagrid from sql database ..How can I do that?????/ Kindly help ... A: your coding is improper. you use object, adodb, adodc everything. and for dates your coding makes me ...
VB6 - ADO	7/17/2008
Q: I ve got a simple program usin ADO to read from as database. I already populate a combobox with the ... A: if custId is a textfield then use: "select * from TableName where CustId=" & "'" & iDsearch & "'" ...
visual basic+ms access	7/16/2008
Q: .i am using vb6 and ms access..i have created a parameterized query including single parameter..the ... A: for command of dataenvironment use this: Select * from testable where FieldName=? and with the ...
VB6 Printform	7/16/2008
Q: Question V.B. 6 level Inter Michael Rae Saga simple question... How can i manipulate the width and ... A: in print command the label does not exist. you can change the fontsize just before and after this ...
Printer Label width & height	7/14/2008
Q: V.B. 6 level Inter Michael Rae Saga simple question... How can i manipulate the width and height of ... A: you cant change the lable using printer commands. the printer.print etc are used to print after the ...
To retrive records from sql database	7/12/2008
Q: Sir My query is how to retrieve records from sql database and display it into textbox .M using vb6 A: sample code: always use a label or grid to display results and not a textbox as the user may change ...
vb	7/10/2008
Q: how to retrieve values from access file in vb? A: 'put a check mark on Project_References_ Microsoft ActiveX Data Objects Library 'you can addnew ...
vb + access	7/8/2008
Q: please tell me how to connect a db other than biblio and nwind.mdb..i am using vb 6.0 as a ... A: this error is because of version of access if you are using data control. use this code: better to ...
VSS 6.0d and VS 2005?	7/3/2008
Q: After using Visual Sourcesafe 6.0d with VB 6.0 for several years, I recently installed Visual Studio ... A: thre reason the allexperts is not allowing ratings is I have disabled this feature as i wish to get ...
adodc	7/3/2008
Q: i am using vb6. I used adodc in order to display different fields from my database.. my problem is i ... A: i dont advocate use of adodc. change to adodb because no control is needed. here is sample code: ...
VSS 6.0d and VS 2005?	7/2/2008
Q: After using Visual Sourcesafe 6.0d with VB 6.0 for several years, I recently installed Visual Studio ... A: vb 2005 is a completely different way of writing code and you need to unlearn many aspects of Vb6 ...
Visual Basic 6	7/1/2008
Q: I am a beginner in visual basic 6. I am currently doing project in visual basic 6. In that I want ... A: Option Explicit Dim entry As String 'this puts the text into the textfile Private Sub ...
Error:input past end of file	6/30/2008
Q: I have used this code and getting an error input past end of file(written near line. )What does it ... A: it means the point of reference in text file has gone beyond the length of text file (instead of 11 ...
How to link the Help menu contents to one another???	6/28/2008
Q: In vb6 i have created a program i.e i took 1 form and i have created Help menu using menu editor. ... A: there are 2 methods, vbhelp and html help/ for html a chm file is needed. if you have a .chm file ...
Visual Basic, Opening a file to a multi-line txt field through a FilelistBox	6/27/2008
Q: I'm writing a program to help edit a specific .ini file for a program to help newcomers out. What I ... A: store the path of the selected text file to a variable and use the shell command to open the same. ...
adding text and data files in VB 6	6/26/2008
Q: I am creating an .exe program with VB6. I would like to have the program add certain files to a ... A: you cannot add the text files to the exe file. you can put them in a folder along with exe and refer ...
MSFlexGrid Data ,put it in .txt	6/23/2008
Q: read this type of data from .txt and put it in MSFlexGrid, Coke 4500 1 2 3 4 5 Minerals 4200 5 ... A: my system was down and restored now. because of the backlog of unanswered questions, i'll be able to ...
combo box with notepad	6/23/2008
Q: I have combo box in my vb project.but the combo list vl be more than 100 items.so i want to create ... A: no problem with 100 items in adodb open the connection and add this code: Private Sub ComboLoad1() ...
application disappears	6/22/2008
Q: vb6, access db, beginner, Hi, this my first commercial application after practising vb for sometime, ... A: if you are willing to donate some cash, ok, send me the following points: 1)what does the ...
Msflexgrid in vb6	6/20/2008
Q: I have a specific requirement of inserting a row into MSFlexGrid at runtime. This should be ... A: sample code for inserting a row at a selected point. G is the name of the msflexgrid. Dim i As ...
Combo box in VB	6/20/2008
Q: i wnat to ask a question ? My question is : i m making a project in vb. in this project i place a ... A: put your values red,blue etc in Combo1 list property and have combo1.enabled=false have a ...
Execution of between operator of access through vb 6.0	6/17/2008
Q: "i have two dtpicker and one cmdbutton in my application and i want display the datareport according ... A: your code is too simplistic. it wont work. the date between 2 dates produces errors in datareport. ...
about print option	6/16/2008
Q: sir i want to ask a another question. sir i have a tabstrip in my project in which i have a two ... A: you could use: printer.print text1 printer.print text2 'and so on printer.enddoc 'or you could ...
browsing pictures in common dialog box to load pictures	6/16/2008
Q: I am doing project in VB 6.0+ oracle.I am a beginning .I want to know the coding for browsing the ... A: common dialog isnt an ideal way of viewing pictures. better to load the full paths in a list or ...
problem in LostFocus property of textbox	6/15/2008
Q: First many many thanks for your previous valuable suggestion, Sir here i am doing a validation ... A: Private Sub Command1_Click() rec.Open ("select item from testable"), conn, adOpenStatic, ...
SET UP CAN'T CONTINUE BECAUSE SOME SYSTEM FILE IS OUT OF DATE	6/11/2008
Q: i created an application useing VB 6.0 and MS-Access.i made it exe and packaged as well as deployed ... A: the ideal case is where the second computer has vb6,windows xp3 and ms access 2000. or else, you ...
VBA+Excel	6/10/2008
Q: I am trying to write a program that reads a .txt file from notepad into excel then use that ... A: code in macro: Open "C:\test.txt" For Input As #1 ' change to your filename path linecount = 1 ...
vb with MS access	6/10/2008
Q: i m beginner in vb 6 my question is : when i start the project my first, last , previous and next ... A: the idea in giving a sample code is for you to study the same and pick out what is needed> your ...
problem in retrieving null value from database	6/10/2008
Q: i am developping an application using VB 6 and MS-Access.i just showing some records in the form ... A: dont waste my time by asking such partly hidden questions like Null for a date. Does your ...
have a problem in query expression	6/10/2008
Q: i make a project in vb & ms access. design a table name joborder and make some fields like ID ... A: you have not defined your problem clearly. the trouble with autonumber fields is that while ADDNEw ...
vb with MS access	6/10/2008
Q: i m beginner in vb 6 my question is : when i start the project my first, last , previous and next ... A: see sample code: 'put a check mark on Project_References_ Microsoft ActiveX Data Objects Library ...
problem in retriving null value in the front end	6/7/2008
Q: in the access table i assigned date and text datatype in two fields.and also set that allow Zero ... A: you have to tweak these factors in your access table. in design, see that the datatype is set to ...
problem in installing set up file in other system	6/7/2008
Q: i created .EXE file and Packaged it. while i am installing in own system it installed successfully ... A: this is because of version conflict in the third machine. if the version of VB or microsoft office, ...
How do i print form contents having same formating	6/3/2008
Q: how do i print formatted contents of the form my code is here and it prints simple text iwant to ... A: printer will take default values. you need to set them or use: when you type printer. you will ...
Simulate VLookup in Access VB Code	6/2/2008
Q: Ravinda, I have a table in Access that I need to change the value of a field based on a "similar" ... A: if the values are changing .how do you get them on to your table? by entry. Then enter them to an ...
Simulate VLookup in Access VB Code	6/2/2008
Q: Ravinda, I have a table in Access that I need to change the value of a field based on a "similar" ... A: function round(1.5) may meet your job. or you could compare using a function: sample: Option ...
VB and MS Access dB communication	6/2/2008
Q: I have a problem communicating between VB 6.0 and a MS Access database. The dB if in Access 97 ... A: vb is independent of access. it does not matter which version. vb6 can deal with all or any versio ...
vb 6.0 buttons codes	6/2/2008
Q: i want to know how i can code for the following buttons:Add,Update,Delete,and Search;when i'm using ... A: the adodc is not a good control to use the above options. better shift to ADODB. here's how it is ...
installation problem in set up file	6/1/2008
Q: i created .EXE file and Packaged it. while i am installing in own system it installed successfully ... A: there could be various reasons: path of mdb file different. version of office different. also vb is ...
Adodc	5/31/2008
Q: I'm actually using Adodc control on my form . I want to put a listbox where two fields from my ... A: use a Microsoft Remote Data control instead of adodc and use a DBlistbox instead of listbox. you ...
summing up the values of datagrid column	5/30/2008
Q: Sir I would like to know how to sum up the numeric values of a column of a datagrid whose answer ... A: i have already given you the method. it should come from a query and not by adding column values. ...
Datagrid in vb6	5/30/2008
Q: Please how to get selected row of datagrid in the next form of textboxes and comboboxes.For example ... A: i have already answered your question. assign the value of the row to an integer variable to ...
About click or doubble click of datagrid in vb6.0	5/30/2008
Q: Please how to get the selected row record of a datagrid on the next form having controls like ... A: i think i've already answered this question for you. dim adu as integer Private Sub ...
Domains	5/30/2008
Q: My version is Visual Basic 6. I would want the code for printing a data grid named datagrid1 with ... A: Option Explicit Private Sub Command1_Click() Dim rowVal As Integer printer.print "" ...
datareport	5/28/2008
Q: How to prepare the data report in vb according to the fields wise.. Ex. I've the fields ... A: in your dataenvironment on which you base the datareport.. add this command1 ... commandtype ...
vb6 datagrid	5/28/2008
Q: Please could you tell what to do, I want to print a dataGrid with all the data inside the grid.I am ... A: Private Sub Command1_Click() Dim RRow As Integer, RecNum As Integer RecNum = ...
While extracting selected row from Access being in vb 6 facing error	5/27/2008
Q: i am going to retrieve selected record from data base.there is an error i am getting which i did not ... A: change the code to sqlstmt = "SELECT * From CertificateStatus WHERE VesselName=" & "'" & TextString ...
Regarding datagrid	5/26/2008
Q: I have a datagrid that contains a coloumn of attendence of a particular ID.Whai I want is to count ... A: one method: Option Explicit put another ADODC2 on the form and a label and this code 'change the ...
excel vb macro to sort columns numerically	5/25/2008
Q: I am writing an excel VB macro that sorts columns based on the header column title ("DEVICE") and ... A: firstly, note that it is NOT a VB macro but a VBA macro. they are two different kettle of fish. ' ...
vb	5/25/2008
Q: how can i fetch the record set into the ms-flex grid .. (i want to, when i execute the query the ... A: your quetion is not worded clearly for me to understand exactly what you mean. however see the ...
VB - Nested loops, Beginner	5/24/2008
Q: 1. Create a program which will print a triangle of stars, given the size by the user(edit for this). ... A: 1) Private Sub Command1_Click() Dim adu As Long For adu = 0 To 27 Print (adu + 1) ^ 3 Next End Sub ...
Need Help in Connectivity in VB6	5/24/2008
Q: I am working as Technical Support Engineer in a Software company for Last 4-5 Years. I have the ... A: 'put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn ...
visual basic	5/23/2008
Q: what's the quiry of delete in adodc(access link) ? A: your question is badly framed. you want to delete a record using adodc? what do mean by quiry of ...
excel	5/20/2008
Q: I'm a newb w/vb. I have a code that runs long and I still have a lot to enter. You can see that ... A: 1) ok, looking at your problem, excel is NOT the ideal choice for a programme. a nice programme ...
Printing in Visual Basic 6	5/20/2008
Q: Programing Language - VB 6 Database - MS-Access Level of Knowledge - Inter I want to print ... A: you can print using the printer.print option with the tab(number) to print the format as per columns ...
vba excel	5/19/2008
Q: I'm a newb w/vb. I have a code that runs long and I still have a lot to enter. You can see that ... A: first, are you in Visual Basic form or user form in excel? secondly, my advice to you is you should ...
the use of &	5/19/2008
Q: what is the use of & in visual basic, when and why it is used, i am using it for data field as '" & ... A: &, which is known as ampersand, is used to concatenate (join) 2 string in vb dim adu as string adu ...
VB5 Shutdown	5/19/2008
Q: I am an intermediate user of VB5. I performed the Shutdown example that you showed using the ... A: when you ask a question please refrain from mentioning other querant's names eg; david. dont expect ...
Printing problems.	5/18/2008
Q: Halo there, my name is Konstantin Pecurov from Macedonia 3 year student applaed com. sience with ... A: printer.trackdefalut =true is not necessary use printer.print .. also when you multiply 9.52 by ...
vb6.0	5/17/2008
Q: i am create one excel document.eg.the excel documnt 6 coloum have.A,B,C,D,E,F.i make one visual ... A: i hope your question is to open a workbook and depending upon the commandbutton on VBform you want ...
Thank For last Time it works	5/17/2008
Q: Pls, I don't want to use adodc to connect to access(access 2000) using vb6, i want to use program ... A: you say your code.. did i give it to you? and what is the comma doing at the end of ...
Key deactivation	5/15/2008
Q: I d'like to deactivate Arrow keys on a drop down list. is it possible I use vb6 Thank you ANSWER: ... A: sorry thought it was for a textbox. it is not such a good idea to disable arrowkeys in a listbox. ...
vb6 + Access	5/14/2008
Q: I'm creating a Slam book, in which my users [friends] can save their slams using a User name and a ... A: once the user chooses a button to verify his username and password then you need to use adodb and ...
VBA Excel	5/14/2008
Q: Sorry i didnt realise we couldnt paste url's Im sure Excel.xlMultiply is the missing link but im ... A: see, you have used some code which is not based on your logic so every time you have an error, you ...
Error in SQL Statement	5/14/2008
Q: Kindly advise what is wrong in the following sql statements: INSERT INTO: (nor inserting the ... A: 1) what do you mean by nor inserting the record? the code for insert is: Option Explicit 'put a ...
vb6 datagrid	5/13/2008
Q: Please how to select a full row in a datagrid with a clik or dbclick and displays the data of the ... A: Option Explicit ' have 3 labels and 1 commandbutton in form1 and add this code in Form1 Private ...
Excel VBA	5/12/2008
Q: I work on Excel VBA.I wanted to know how to restrict the value in the cells to only numbers(It ... A: the data validation which you do on the first range of cells is not applicable to the cells to which ...
vb6.0 count male and female from table col.	5/12/2008
Q: in my table i have column name Categeory in this categeory Male and Female , how can i count Male ... A: you need to create a query with sql 'here sex is the fieldname SELECT Count(TableName.Sex) AS ...
Query in VIsual Basic programming	5/9/2008
Q: Wat is the syntax code to link one command button to another command button in Visual Basic ... A: i dont get your logic. why link 2 buttons? it makes no sense to me. of course you call the ...
vb 6.0(adodc)	5/9/2008
Q: i'm sidney again the beginner in vb and i appreciate for the last help you gave me.now my problem is ... A: the error is on the line And Programme=" & "'" "part-time" & "'" It should read And Programme=" ...
Errors in Previous Question	5/8/2008
Q: Looking through your replies to other questions, - I had already checked for any relevant ones, but ... A: do you want VB or VBA? these two are poles apart so be specific. for questions that require a lot of ...
Retrieving data from a sub Function	5/8/2008
Q: I am working with 'MS Visual Basic 6.5' from MS Office 2000. (specifically Excel, but I'm not ... A: by reading your question, i can rate you only as beginner not intermediate. it is not personal but ...
VB 6.0	5/8/2008
Q: How can we read text files word by word in visual basic 6.0, if each word is separated by tab space? A: Option Explicit Dim lincount As Integer, adu As String Private Sub Command1_Click() Dim pos1 As ...
DTPicker Query	5/7/2008
Q: I want to insert date through DTPicker tool. My database is in access..Fore ur conviencee i hav ... A: i dont know what your dat refers to: anyway here's a sample code for insert Option Explicit 'put a ...
VB6 , Winsock	5/6/2008
Q: i can run the project on my note book, but i can run it on other notebook / desktop, which dont have ... A: you need to use a package and deployment wizards from VB6 on yournotebook and build it around your ...
error 3251 in vb	5/5/2008
Q: I am working on one project. Database connectivity is ok. All others forms are running properly. I ... A: your code is following c or C++ format. VB does not recognise the varchar, no(4) etc. you need ...
vb6+access	5/4/2008
Q: how to display distinct number of columns in msflexgrid from access database.for example i have 5 ... A: first you get the adodb.recordset using adodb.connection and you code msflexgrid1.textmatrix(1,0)= ...
v.b 6.0 + Ms Access	5/3/2008
Q: i'm a beginner and i'm develloping a application in vb 6.0 which i connected to the Access database ... A: obviously you have not read the answer. i asked you to change to module name but you are asking the ...
v.b 6.0 + Ms Access	5/2/2008
Q: i'm a beginner and i'm develloping a application in vb 6.0 which i connected to the Access database ... A: i suggest you change the ADODC to ADODB. you can open One connection and have several recordsets ...
excel vba 2003	4/29/2008
Q: Scenario: I have a userfForm that contains a few buttons, textfields etc. And at the workbook, I ... A: 1) no, you can delete the user form. user form is required if the user needs some action on the ...
VB + MS Access & Internet Options	4/26/2008
Q: Sir i am a cyber cafe owner, trying to develop a software for its management. I am using a THIN ... A: first part of your question. it is better to change over to ADODB than ADODC . use this code: ...
VBA+Access Prob with SUM ... GROUP BY...	4/25/2008
Q: knowledge : Turbo C :) This is the output that I want the sum of the product for the year 2006 ... A: in view of security, i do not like to visit links posted by you. however this is my surmise and ...
Combo Box property	4/21/2008
Q: I am doing one project in Vb 6.0. I have placed a combo box in a form and using ADODB connection, I ... A: put an ADODC and a datacombo on the form point it to your database and table and point the ...
Special characters in access table	3/18/2008
Q: How do i restrict users from inserting special characters in a text box and how to remove any ... A: Option Explicit Private Sub Text1_KeyPress(KeyAscii As Integer) If KeyAscii = 33 Then KeyAscii = 0 ...
VB6	3/18/2008
Q: I want to put the contents of an array in an excel sheet.The content of the array will be entries of ... A: Option Explicit Dim adu(5) As String Dim xl As Excel.Application Private Sub form_load() adu(0) = ...
vb6 with data report	3/18/2008
Q: Good day sir! im constructing a program that enables to search a certain records from the database. ... A: for searching records: better to have the runners nos in a combobox rather than a textbox. 'put a ...
vb+access	3/18/2008
Q: sir, 1.I would like to know how retrive an image stored in MS access database and how to access the ... A: one of the methods: in access table have two fields no and path store the path of the ico file ...
Sending results of Macro to Text file, VBA Excel	3/13/2008
Q: Hey! I took a class a year or so ago on VBA but cannot remember for the life of me how to do ... A: there are many options but the simplest one is to concatenate them in the same row of an excel ...
visual basic	3/13/2008
Q: how to create more than one textbox in vb at runtime ANSWER: it is not a hot idea to create ... A: i still say that this is in no way a follow up anyway the sample code: sample code: Option ...
VB in excel	3/12/2008
Q: I'm a beginning VB user in Excel, writing macros to make my work faster. And I'm having trouble with ... A: firstly, it is not VB but VBA which is a different lanugage (though similar) here is sample code: ...
acess	3/12/2008
Q: how to connect the two table with each other. my histry table is no update automaticly which is ... A: First, your english makes it unclear. now what is meant by your stating hitry table is no update ...
connectivity with access 2000	3/12/2008
Q: i am new to vb. i have created a form and do not want data control on it. on a SAVE button i want to ... A: data control is a thing of the past. try this sample code: Option Explicit 'put a check mark on ...
vb+vb reports	3/7/2008
Q: im a beginer in vb 6.0.i have a datagrid table in vb form entered data in the table using visual ... A: this is not the way. first, the Visual data manager does not work witht the latest versions of ...
VB+Access+Records+Reports in word	3/5/2008
Q: You sound like and interested genunine person, I am looking for someone to help me. I have created a ... A: every person is a genuine person and i did not know where i sounded? now it is not clear how you ...
VB 6.3	3/3/2008
Q: Via a series of formulae I input rows of data by date into a spreadsheet. I want to find yesterdays ... A: your logic is not clear to me. you mean the dates for the whole month is already entered and you ...
VB 6.3	3/3/2008
Q: Via a series of formulae I input rows of data by date into a spreadsheet. I want to find yesterdays ... A: your question is confusing. you say vb 6.3 and state spreadsheet. there is no spreadsheet in VB. if ...
Designing a "loader" type interface	3/3/2008
Q: my name is Dustin. Let me begin by giving you a few details. I am a complete newbie to visual ... A: what you are attempting is not for a beginner. if the paths are stored in an access database then ...
VB 6 Data report	3/1/2008
Q: Sir, I am using data report by passing parameters and it worked perfectly. The problem I have now ... A: first create the query in access in the design mode ... go to sql mode which gives the design in ...
VB2008	3/1/2008
Q: Pardon me if english is bad. I'm new to vb2008 and havve access database. I try to create form ... A: dont ask question like frustrated etc. DONT you have a name? yes, you deserve to be frustrated. you ...
list view control	2/29/2008
Q: 1)can you please help me. I need you to help me with code for retrieving data from access database ... A: sample code: L1 is the listview control Option Explicit Dim i As Integer Dim conn As ...
Database Connectivity in Visual Basic	2/28/2008
Q: i m beginner of Visual Basic 6.0. i always had trouble in database connectivity using SQL in visual ... A: Option Explicit 'put a check mark on Project_References_ Microsoft ActiveX data object Library Dim ...
MSflexgrid	2/27/2008
Q: gud day sir!i am g graduating student and we have a thesis,can you help me or give me some code on ... A: sample code: 'put a check mark on Project_references_Microsoft ActiveX data 'Objects Library Dim ...
linking listbox to textbox fiels data	2/26/2008
Q: i have a list box and a text box. The list box displays the contents of the fieldname BNAME from the ... A: ' cn is the open connection Private Sub List1_Click() Dim esql As String esql = "select * from ...
please help me i badly need it in my thesis	2/25/2008
Q: i'm not as good in programming as you may be...sir can you help me cause i want to retrieve records ... A: i do not like your asking more than one disconnected questions. to backup code this to a ...
VB6 and ado connection with access	2/24/2008
Q: I am a beginner in Vb6 with access 2000 coding i am designing a project for the diabled people.I am ... A: remove the ADODC from the form. it is old hat. using ADODB , if you have opened the connection it ...
visual basic	2/23/2008
Q: Need help pls. i have a program that display a record from a database in texbox. Now i want that ... A: the access tables are to have unique data.. that means no duplicates. if you are saving data from ...
printing datareport	2/23/2008
Q: I am developing a project using vb, msaccess and datareport for reports. in one form i have ... A: 'you need to connect datareport to dataenviroment, adjust the command and configure them Option ...
calculation in grid	2/21/2008
Q: Q:In vb how i do calculation in grid, like excel. Example:(2+2=4). thanks A: which grid are you talking of? there are some grids which can get records from tables. but ...
VB6 and ado connection with access	2/21/2008
Q: I am a beginner in Vb6 with access 2000 coding i am designing a project for the diabled people.I am ... A: your create table code is OK, but the code is used everytime you open the project. so create ...
please help me i badly need it in my thesis	2/21/2008
Q: i'm not as good in programming as you may be...sir can you help me cause i want to retrieve records ... A: sample code to which you need to make suitable changes 'put a check mark on Project_References_ ...
Executing SQL QUERY	2/20/2008
Q: I need to execute sql query in VB and the output has to be displayed using report but i need to ... A: better to have the nos in a combobox rather than a textbox. 'put a check mark on ...
VB	2/20/2008
Q: I do have a command button. I want it to go the folder where my pictures reside and load the picture ... A: put a commondialog control on form a picturebox and a command button add this code Option Explicit ...
Date parameters - VB EXCEL	2/19/2008
Q: I asked another expert this question but they were unable to answer. VBA - using for excel. my ... A: as a beginner, you need to improve the logic than go for coding. here imagine there are 20 cells out ...
visual basic and SQL	2/19/2008
Q: i am doing project for OPD where i have chosen Visual Basic as frontend and SQL server as backend, i ... A: too many different questions joined into one. to connect to sql server on a server, you need to ...
vb data report	2/19/2008
Q: i got connection of database but after running it i get multiple data in it(how much data is ther in ... A: the datareport shows all records. to do what you want ,you need to make a parameter query. for that ...
vb data report	2/19/2008
Q: i got connection of database but after running it i get multiple data in it(how much data is ther in ... A: first, it is not Data report as that would mean a control called Datareport in your case, if you ...
VB6: Simple calculation but rough result	2/19/2008
Q: It is my first VB6 program. I simplified the problem as following: Dim a As Single, b As Single, c ... A: sorry, now your question makes sense to me okay, the problem here is not VB but how we communicate ...
VB6: Simple calculation but rough result	2/18/2008
Q: It is my first VB6 program. I simplified the problem as following: Dim a As Single, b As Single, c ... A: there is nothing wrong here. when you assign d as b/a it shows 3 but when you include this value in ...
vb6	2/17/2008
Q: i have one table in access.that table always have one record.if i click command button that record ... A: first, it is not such a good idea to open the record in Word from VB.there are other methods to ...
VB6 arrays + MsAccess 2002	2/15/2008
Q: I am a newbie to VB6 and arrays and would be most grateful for your help on the following problem. ... A: your code makes no sense to me. normally one needs to have a number field so that such filtering for ...
vb	2/13/2008
Q: Good Day!!! How to auto click a command button using a timer. thank you very much. A: it is not such a good idea becuase the timer needs to be running , stoped and rerun. i hope you ...
vb+access	2/13/2008
Q: I'm a beginner. I am trying to create a form in microsoft Access and would like to have a text box ... A: okay though it sounds illogical to me you may be having other reasons for this. Also there is no ...
v.b 6.0	2/13/2008
Q: Sir, i am having two tables by name unit and tempunit contains similar fields in a bills.mdb now i ... A: ' check microsoft DAO objects library Option Explicit Dim db As Database, rec1 As Recordset, rec2 As ...
Query in VB 6.0-basics	2/13/2008
Q: I am checking if a line containing the text "Trc 04500" is present before the line containing the ... A: are you in a text file?and how are you reading the lines. do not rush to ask questions.. you need ...
VB6 & MS ACCESS linked via ADODC control	2/13/2008
Q: I am a teacher in the UK. My students have simple one table databases linked to a VB form using an ... A: it is easier to do validation at the vb form as it does away with the data moved to access, ...
VB 2005	2/12/2008
Q: ok I want to know how to convert the node in treeview to 1- button and how to convert it to ... A: vb 2005 is a bit advanced for beginners and if you did not use vb6 there will be some snags. ...
Felxgrid and Saving to CSV	2/12/2008
Q: I am creating a application that will allow the user to enter information into a flexgrid and i have ... A: it requires some programming experience first you need to open the file ( text file separated by ...
TreeView VB 2005	2/12/2008
Q: I have question tired to find answer .. and I think its simple one but because am beginner in VB ... A: for a beginner and that too in vb 2005 the job is a bit too much. what do you mean by ebook.? it ...
I want to delete Macro in Word file but it says	2/12/2008
Q: I am just a normal computer user. Recently, I have just installed a macro in word file but when I ... A: ok you have tried a lot. try this: under Tool, Macros-Macros_choose the option chooe All active ...
Reading Text File	2/11/2008
Q: I am very new at VB I am learning on my own and have really no programming background at all. I have ... A: first throw your vb programme into the dustbin. kill means delete. that is what it is doing. you are ...
Reading a range into an Excel UDF	2/11/2008
Q: Hey Ravindra, I am writting a UDF (User Desfined Function) in Excel (of course using vb code). I ... A: no need for an array to get formulas Range("D16:D20").Select Range("D20").Activate ...
Reading a range into an Excel UDF	2/11/2008
Q: Hey Ravindra, I am writting a UDF (User Desfined Function) in Excel (of course using vb code). I ... A: i do not follow your logic. Note that there is NO vb in excel. it is VBA which is different from VB. ...
print a report during on data entry in vb6.0	2/11/2008
Q: How to print a report in vb6.0 after entering data on form ANSWER: your question is not clear ... A: from your questions you cannot be Inter level coder. once you open a datareport or crystal report, ...
VB6, MS Access and MS Word	2/10/2008
Q: I am currently working on a VB 6 project where I have a number of forms that display/add/edit/delete ... A: i answered this before, is this a duplicate question? i am surprised to see this question. i ...
Getting Started with VB	2/10/2008
Q: Previously i had done small Inventor & billing project using MSAccess, but now i want to start with ... A: sample code for ADODB better to have the runners nos in a combobox rather than a textbox. 'put a ...
Stand alone database	2/9/2008
Q: ..Im really problematic right now on how to make my library database system a stand alone program ... A: you cannot use ADODC in a stand alone application you need to use ADODB sample code for adodb 'put ...
Use of Timer	2/8/2008
Q: I now want to automate it and make it timer based so that the update can be made regularly. I have ... A: it is not such a good idea. for this the programme has to be running and it takes memory resources. ...
Visual Basic Search Command	2/7/2008
Q: How do I write the code for a Search Command? I want my search button to search my database for ... A: better to have the runners nos in a combobox rather than a textbox. 'put a check mark on ...
vb 6.0	2/7/2008
Q: sir, i am astudent. i created data report and data environment in my project when i passed two ... A: to the command1 text add this line after pointing it to connection Select * from testable where ...
vb	2/7/2008
Q: what is difference between scale height and scale width? A: these basically refer to the graphics property after you select the scalemode..vbpixels,vbtwips etc. ...
VB6	2/7/2008
Q: hallo sir, iwanted to join two fields in twoforms form1, form2 having 2 tables in MS ... A: add a .bas module to project and code Option Explicit Public StoredVal As String 'set the form1's ...
macro with VB	2/6/2008
Q: Hi this is Ram from INDIA. I have few questions in excel macro in VB, 1). How to enter/get values ... A: 1) you can open other applications (some. not all) using the shell command. But you cannot get the ...
Vb6	2/5/2008
Q: I want to know to get 5-10 employee details from the access database and to create a report with ... A: Option Explicit Dim cn As ADODB.Connection, rec As ADODB.Recordset, esql As String 'check ...
Crystal Reports	2/4/2008
Q: How r u There is a VB6 prog. with access database and crystal reports. All is working fine except ... A: your code is not proper. where is wdb declared. you are deleting, addingnew and filtering with a ...
VB	2/4/2008
Q: We are creating exe in vb.6. While executing it shows "Vb6.0 has generated errors and will be closed ... A: following points need checking declaration of variables, spelling errors, option explicit must ...
Uploading data from another table	2/4/2008
Q: I am an intermediate user of VB. I also have a little knowledge in SQL. I am having a problem ... A: you could link or import tables without using any code. if you want to use only code: then open ...
about 2 forms in one project	2/4/2008
Q: I am a begineer with Visual Basic express 2005. I am Creating Windows application and create one ... A: i hope you have some VB6 programming experience. to jump straigtaway to vb2005, it may be a bit ...
Hyperlink in VB6.0	2/3/2008
Q: I was wondering if you knew how to code a label to be a hyperlink? If so, could you include source ... A: 1.have the label1.font underlined 2.under project_references check microsoft internet controls. ...
Printing Report using Data Report with ado recordsets	2/2/2008
Q: Kindly guide me using data report with ado recordset connections. A: personally i prefer access reports to datareport anyway here is the method: put a dataenvironment ...
vb 6 & access 2003	2/2/2008
Q: please help me on connecting the Access 2003 database to VB6. how to check if jet 4.0 is available ... A: Dim db As Database, rec As Recordset, esql As String Dim rec1 As Recordset End Sub Dim db As ...
VB+DATABASE	2/1/2008
Q: I am just a begginer using vb with database By entering 16 digit no in a textbox ,automatically ... A: i consider your options not of good logic. why tup16 digits? instead have combo boxes showing ...
Visual Basic 6.	2/1/2008
Q: the code below produce an output of frm 0-10,i want this output to be put in a temporary file and ... A: automatic numbers cannot be incremented. however to increment numbers mentioned by you put a text ...
Visual Basic 6.	2/1/2008
Q: the code below produce an output of frm 0-10,i want this output to be put in a temporary file and ... A: this is a trivial question but i'll answer it. Option Explicit Dim i As Integer Private Sub ...
Password Change Input Boxes in Access	1/31/2008
Q: Ravindra, My Access database has a password-protected form using the following code: Private Sub ... A: first of all this is NOT VB but VBA which is a different kettle of fish. here's the code which you ...
Visual Basics	1/31/2008
Q: using grid controls ,how to multiply with one grid column with another grid colum A: first, there is NO visual BaiscS.. it is visual basic then which grid are you talking about, ...
About Sql database	1/31/2008
Q: Sir, I want to save unique images(i mean no duplicasy while saving images) in sql Is this possible? ... A: he's right. the images cannot be scanned pixelwise and matched like a fingerprint( unless you use ...
VB	1/31/2008
Q: I AM NOT ABLE TO ENTER LONG NUMBER (REQUIRED IS 17 DIGIT) Private Sub SERIALNO_LostFocus() ... A: it is not such a good idea to have such large numbers but you can get round this by using Option ...
Visual basic + Ms access	1/31/2008
Q: ! I have a question about visual basic and ms access. 1. How to display content of my database in ... A: Option Explicit Dim smenu As Variant Dim password As String Dim realpassword As String Dim iChances ...
Visual basic + Ms access	1/30/2008
Q: ! I have a question about visual basic and ms access. 1. How to display content of my database in ... A: first, i believe your table has these three fields. better to have the ID in a combobox rather ...
VBA form seaching	1/30/2008
Q: Im using 2007 MSA, VBA code, JAMES Graham OK i want a peace of code for VBA that searches a form, ... A: Option Compare Database Private Sub Command1_Click() Dim adu As Integer adu = CInt(InputBox("Enter ...
vb6 Form serch	1/30/2008
Q: sir i am beginner in vb6 programing i have a project and it has more than one forms how can i get ... A: each form is a separate object without reference to the other forms. i think from the form it may ...
vb 6 & access 2003	1/30/2008
Q: please help me on connecting the Access 2003 database to VB6. how to check if jet 4.0 is available ... A: to check if jet 4 is available, put a ADODC on form and properties point to using connection string ...
problem in getting data	1/29/2008
Q: i need the code for copying the data from one excel workbook and paste in another excel workbook ... A: curious to know why operate it from VB? do you have to do it often or only once. i know the method ...
How to use Replace function in VB 6	1/28/2008
Q: I am new to VB6 coding,I want to retrieve data from SQL server database table, where one name field ... A: try this one out: make changes that you want Option Explicit Dim conn As ADODB.Connection Dim rec ...
Search Command Button Coding??	1/28/2008
Q: I want a search command button coding for my school project that i am making on visual basic 6.0 i ... A: the adodc requires initializing. connect the adodc to the database and point to the table as the ...
VB form seaching	1/28/2008
Q: Im using 2007 MSA, VBA code, JAMES Graham OK i want a peace of code for VBA that searches a form, ... A: question unclear. do you want vb form search(uses VB code) or access form search. (uses vba code) ...
adodb	1/28/2008
Q: sir, i am developing a project using vb6 and access 2003 In purchases table i have fields ... A: Option Explicit Dim conn As ADODB.Connection, rec As ADODB.Recordset Dim esql As String Private Sub ...
vb6	1/28/2008
Q: how to open db(access) in word using vb6 A: your question is a puzzle to me. i cannot follow why you need to get a database into word. one ...
notepad to vb6	1/23/2008
Q: 1. vb6 3. inter 4. vb + notepad 5. Himanshoo Shourie 6. VB6 7. I want to transfer data from notepad ... A: to read the data from text file dim entry as string,linecount as integer Private Sub ...
VB6+Access Database	1/23/2008
Q: Iam developing a employee shift Scheduler using vb6 and microsoft access 2003 for my school ... A: to get month and date of system can be shown in label as in the form load event Option Explicit ...
VB Excel 2003 Question	1/22/2008
Q: My level of knowledge for VB language is at a beginner lever so I'm not quite sure what to do for ... A: you are again using the word tabs ..named otherwise or not they are NOT tabs and it is not called ...
notepad to vb6	1/22/2008
Q: 1. vb6 3. inter 4. vb + notepad 5. Himanshoo Shourie 6. VB6 7. I want to transfer data from notepad ... A: if you mean a text file .. it can be done if they are properly formatted. like abc,123,lmn or abc ...
VB6 screen melting issue	1/22/2008
Q: Ravindra, I was asked to post a new question because my prev question has too many follow ups. Okie ... A: no need for explanations, i did not ask. what i suggested was to close all the forms and save the ...
Query:: logic in Visual Basic	1/22/2008
Q: my question is like, i have many option buttons in my application. could be more than 100 option ... A: you can create a control array first is option1. copy and paste this and say yes to an array. then ...
How to concatenate multiple fields in Visual Basic...	1/22/2008
Q: If I have the following fields from a excel sheet how would I concatenate them to print out in a ... A: there are many options ..like concatenating these fields to another field, assign to a variable etc ...
Query:: logic in Visual Basic	1/21/2008
Q: my question is like, i have many option buttons in my application. could be more than 100 option ... A: of course there is a loop method of setting it but only 1 option will be true and all the rest ...
Save listbox items in MS Access Database.	1/21/2008
Q: I'm using VB 6 and MS Access Database with it. This is my second year as a vb user for school ... A: Option Explicit Dim cn As ADODB.Connection Dim rec As ADODB.Recordset Private Sub list1_Click() ...
VB6 screen melting	1/21/2008
Q: My level of knowledge is beginner. We are currently having an issue where one of our programs runs ... A: i got your screen shot. as a rule you need to close all the windows and the forms and save the ...
VB6 screen melting	1/21/2008
Q: My level of knowledge is beginner. We are currently having an issue where one of our programs runs ... A: just to check if vb installation is faulty do this. create a new project add a command button, a ...
VB referencing field names / variables	1/17/2008
Q: I am using Access 2003, VB 6.3 In my table I have some field names that are somewhat repetitive, ... A: 'create a function and check for field values Option Explicit Dim YesMatch As Boolean Private ...
vb access connectivity	1/17/2008
Q: how to perform vb access connectivity? transfer data from vb textboxes to access table fields? A: 'put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn ...
Print form	9/23/2007
Q: 1) VB6 (no SP) 2) Access 3) Inter 4) Print a form 5) Jacob Mendelovici 6) VB (I don't know what's ... A: your code is incorrect printer.width .. does it make sense to you? position the form to the ...
Visual Basic 6 and Excel	9/23/2007
Q: Ravindra, Thanks for the reply to my query about Excel. As this is the first time I have tried to ... A: you cant use code that you create. it has to be excel syntax. for column width you use ...
need a help with VB and exel	9/23/2007
Q: I need to copy to the other sheet certain rows that contain negative value in a certain column. ... A: Option Explicit Dim xl As Excel.Application Private Sub Command1_click() Set xl = ...
MaskedEdit field updating	9/23/2007
Q: I am new to VB6 and writing a windows application that uses and Access database. I am using ... A: i dont know what the problem is in the masked edit box's mask property enter (###) ###-#### you ...
recordcount	9/23/2007
Q: i m working on vb6.0 and ms access, my code is like below: Dim conn As New ADODB.Connection Dim ... A: strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\GSMMobile.mdb" & ";Persist ...
vb+excel	9/21/2007
Q: Using Visual Basic6 to insert data into Microsoft Excel workbook and format same. What do I write in ... A: 'check references Microsoft excel objects library Dim xl As Excel.Application Dim strFileName As ...
Dynamic calculation inexcel and saving the result back to SQL server using VB	9/21/2007
Q: I have an excel file created with several values from SQL server by a VB application. Now the user ... A: too much to expect in a free site. 1)why get to excel when you can calculate these in sql server ...
vb 6.0	9/21/2007
Q: i want in textbox using two fonts one default english and another hindi in one textbox and save ... A: Option Explicit Dim Badalu As Boolean Private Sub Command1_Click() If Badalu = True Then ...
VB6.0 question.	9/20/2007
Q: I maintain one Access database. It's huge. After each process user need to compact the database. ... A: in access itself have a switchboard form or any other form which has to be opened by default. and to ...
Textbox edit protection (VB+Excel)	9/20/2007
Q: I am making a "program" in Excel 2000 to check some data. My idea was to monitor everything in a ... A: could not fully understand what you are looking for. How do you post the data to the text/label? ...
project into a stand alone program	9/19/2007
Q: I am using XP with VB6 and I am trying to use Package and Deployment Wizard and I am getting an ... A: what does your programme do? any internet connection reqd? vb requires Internet explorer on your ...
ms access and vb	9/19/2007
Q: i have 1 employees table which contains combined primary key PS Number and Effective from date. the ... A: quite simple dim adu as string ' or integer if it is a small number adu=val(text1) if string ...
Date query in Datareport	9/18/2007
Q: I want to write a query to display only present days records(i.e today) in a Datareport. ... A: connect dataenvironment to the table connect it to your database add command command1 properties ...
Excel Cell with	9/14/2007
Q: Good morning. I have a VB Macro that is looking for Empty cells at which time it is to exit the ... A: use of empty etc is ambiguous sample code which you study and make your own, Sub CheckBlank() ' ...
VB6 and SQL query	9/14/2007
Q: I am using VB6 and Access. Most of my work is completed. However, being a beginner, I can not get ... A: 'put an ADODC on form , point to your databse. 'set its recordsource to adcmdtext and enter ' select ...
Looping listItems in a listbox	9/14/2007
Q: Ravindra I am trying to loop through a listview in the listitems: SourceAxisID = ... A: Private Sub Command1_Click() Dim adu As String For i = 1 To ListView1.ListItems.Count adu = ...
VB6 and SQL query	9/14/2007
Q: I am using VB6 and Access. Most of my work is completed. However, being a beginner, I can not get ... A: here the problem is in access. open the design view of these tables and for every textfield set ...
Detail section Height of Data Report	9/13/2007
Q: M new in vb,using access as a database with data control.i want to fix the height of detail section ... A: check height per record. check the property of detail section1 and choose forcepagebreakafter and ...
VB6 and SQL query	9/12/2007
Q: I am using VB6 and Access. Most of my work i