You are here:

Visual Basic/Questions Answered by Expert Ahmed Sayed Aziz

SubjectDate Asked
problem with vb6 coding8/3/2010
  Q: sir, i am a beginner and using VB6+adodb+ms access...i have a form having 3 textboxes..ie username ...
  A: Change the code as follows, hopefully it should work, I do not have vb6 on this computer so I can ...
Export Data Report5/3/2010
  Q: . how can i export data report into MS Word and MS Excel..? thnx
  A: export report to TXT file ========================== DataReport1.ExportReport rptKeyText, ...
vb6 + access3/27/2010
  Q: Sir, I am a student and i wish to ask a question about getting data from datagrid rows in the ...
  A: Private Sub DataGrid1_Click() Load AnotherFormName AnotherFormName.Show ...
vb6 + access3/27/2010
  Q: Sir, I am doing a project in which I have a question to ask. I have a datagrid ,adodc control ,a ...
  A: you need to change datagrid RecordSource sql as follows : With Adodc1 'Change the control name to ...
vb6+access3/27/2010
  Q: Sir, I am doing a project in which I have a question to ask. I have a datagrid ,adodc control ,a ...
  A: you need to change datagrid RecordSource sql as follows : With Adodc1 'Change the control name to ...
Can't retreive data from a text box3/26/2010
  Q: Private Sub Texta_KeyPress(KeyAscii As Integer) 'Dim dta1 As Integer 'Dim dta2 As Integer ...
  A: First I would like to welcome you to Allexperts.com Allexperts.com is a free service so you ...
Vb Question3/16/2010
  Q: what effect does this statement have: recordset.cursorlocation = aduseclient versus ...
  A: recordset.cursorlocation = aduseclient versus recordset.cursorlocation = aduseserver ...
ScrollBar3/3/2010
  Q: I put a vscrollbar on a form. Why the scrollbar is flashing when the form is shown? If i clicked the ...
  A: vscrollbar or hscrollbar flashes if it has focus. this is the inherent feature. if you donot want to ...
Animation3/1/2010
  Q: How can I make an animation in vb 6.0 using animated pictures? and what is the code of it? pls......
  A: Dim X As Integer ...
Distinct2/27/2010
  Q: . how are you? i have table like this kwitansi service Plat tanggal Total barang ...
  A: send me your access table. project not required ONLY Access Table I need to write SQL ...
hyperlink2/26/2010
  Q: in my Access 2007 database, i have coded forms. In a specific form I have set all fields to text. ...
  A: I said on forms place a text box and bound this text to table's hyperlink field. save the form and ...
Combine function x(a,b) and sub( )2/26/2010
  Q: I am putting together a cost estimate. I created a “function Cost(hours, wage rate)” to determine ...
  A: yes you can just use To call function fncTest from sub Test ====================================== ...
hyperlink2/26/2010
  Q: in my Access 2007 database, i have coded forms. In a specific form I have set all fields to text. ...
  A: Create a field in the table to which your form is bound and in its field property instead of Text ...
Regarding the date diff function and to display the output2/26/2010
  Q: What is the vb code to display the output * ** *** **** 2. To calculate the datediff between two ...
  A: 2. your code is correct, it will display 0 since difference is 13 days only. Instead if you ...
VB6 Exclusive locked issue2/25/2010
  Q: I am using VB6 application which connects to an Access database as follows: connString = ...
  A: I think when 2 users are trying to open the same record, then the user opens the record later gets ...
re2/24/2010
  Q: when i go to micrsoft word and go to visual basic i cant seem to get to standard exe i click file ...
  A: In MS word VBA / Excel VBA, you can not make standard exe file. third party tools can do that for ...
database related query in vb 6.02/23/2010
  Q: Actually i have office 2007, and when i connect an access dB file (which created in office 2007), ...
  A: Dim cn as ADODB.Connection Set cn = New ADODB.Connection With cn .Provider = ...
error facing in vb 6.02/18/2010
  Q: Actually i have office 2007, and when i connect an access dB file (which created in office 2007), ...
  A: you didn't write how you are connecting to access db. convert existing db to access 2000 OR ...
Sample Code2/18/2010
  Q: Hey might you be having any sample code i can use to insert a picture from a browse button into an ...
  A: you need a common dialog control (in this example named as CommonDialog1), a command ...
Values2/17/2010
  Q: I am having trouble with property values for Option boxes, Check boxes & Date pickers when saving in ...
  A: You didn't tell which property is giving error optionbox and checkbox don't have Text property ...
Dir command in VB2/17/2010
  Q: From a folder (say c:\folder1) that has files with with multiple extensions (.x1, .x2, .x3), I want ...
  A: Dir command has the following syntax Dir(pathname, attributes) Pathname can be used to locate kind ...
count database2/7/2010
  Q: i have list of Student (a,b,c and d) in a combo box which cal from access. after i choose 1 of them ...
  A: Try with the following code if succeed ok otherwise download sample project from ...
Quest for Print Option2/7/2010
  Q: I need to make print options for to printers. could you help how to make the dialog box and codes ...
  A: if you want to display windows common dialog box then simply use the following code : ...
DataBase1/31/2010
  Q: Im having a problem with these code, it marks me "Runtime error 3061 Too few parameters" and ...
  A: if idproducto store text data then ================================== Data2.RecordSource = "SELECT ...
find data1/31/2010
  Q: i have list of status (a, b, c, d from data access) in a combo box. When user choose a status, ...
  A: I have uploaded a sample database at http://rapidshare.com/files/343697378/StatusFilter.zip.html ...
Dirlistbox1/25/2010
  Q: can you please answer this: my form is connecting to Ms Access and I am able to add, delete data via ...
  A: save it to temp table. suppose make an access table say tblPath with field pathId,fldDetails I ...
image saving in local system using vb6.0 coding1/21/2010
  Q: i am doing one project in vb6.0 with ms-access 2003 database. multi user environment project [client ...
  A: You can use FileCopy Command as follows : Private Sub Command1_Click() FileCopy ...
repetition my Question1/15/2010
  Q: I'm sorry i repetition my Question . i have 3 text,1 database,1 adodc.i would when write in text1 ...
  A: I am unable to understand you question. you first wrote "now i would when text1="aziz" and ...
PDF Reader in VB 61/13/2010
  Q: Sir, How to make a pdf reader in vb6?
  A: you can use Shell command ... check the code below : Private Sub Command1_Click() Dim ...
vb61/12/2010
  Q: In a program where you are totaling the daily total sales for the month, which one of the following ...
  A: a. curTotal = curTotal + curSales because at start curtotal would be 0 suppose cursales for day 1 ...
vb61/12/2010
  Q: With the __________ loop, the condition is not evaluated until after the loop instructions are ...
  A: c. Do Until The expression is evaluated at the bottom of the loop after the statements in the DO ...
repetition structure1/12/2010
  Q: If you omit the stepvalue in a For…Next statement, Visual Basic uses a stepvalue of: _____ a. 1 ...
  A: a) If you omit the STEP stepValue clause, then incremental value defaults to 1 ...
Msflexgrid1/9/2010
  Q: I am developing a appointment management system for a saloon i have almost completed the application ...
  A: send me project at aziz_abroad at yahoo dot com **************Code************ Private Sub ...
treeview1/8/2010
  Q: . i have table A like this account_title account_head account_name account_type 101 ...
  A: Use the following codes: ========================= Private Sub cmdAddNode_Click() Dim nd As ...
VBA script to vlookup from external file1/8/2010
  Q: please correct error in the following script. With Worksheets("Sheet1") .Cells(2, 2) = ...
  A: send me your both xls workbooks i.e workbook running vba code and workbook(file1.xls) also tell me ...
treeview1/7/2010
  Q: . i have table A like this account_title account_head account_name account_type 101 ...
  A: send me your project ... you already have my email id *****Additional Comments******* you need to ...
need your help please,thanks1/3/2010
  Q: Which one of the following descriptions and filters tells windows to display only visual basic ...
  A: .vbp = visual basic 6 project file .mak = visual basic 3 project file .vbg = Visual Basic Project ...
please help,visual basic1/3/2010
  Q: Which one of the following descriptions and filters tells windows to display only visual basic ...
  A: .vbp = visual basic 6 project file .mak = visual basic 3 project file .vbg = Visual Basic Project ...
search and show result in datareport1/3/2010
  Q: excuse me i not write and speak english. in visual basic i have a form.in form i have two textbox ...
  A: place a button on form3 and name it cmdReport create command2 under connection1 in dataenvironment1 ...
help me please vb1/2/2010
  Q: 1; which one of following filters displays the names of either the text files contained in the ...
  A: .vbp = visual basic 6 project file .mak = visual basic 3 project file .vbg = Visual Basic Project ...
Autonumber1/1/2010
  Q: . i've seen your coding about autonumber.. it's really nice. but when i try it,i found same number ...
  A: send me your project so that i can find out where you have the problem. at present i do not have ...
For Help12/29/2009
  Q: Sir 1.How Can i add data from text box to data grid 2.I would like to Insert date value in ...
  A: I would like to Insert date value in database using string .can I do this ? if no then plz describe ...
112/29/2009
  Q: how we can do validation for only inserting character in textbox in vb by some property or by other
  A: use following vb6 code in keypress event of your textbox(in the example it is Text1) Private Sub ...
Building a modal panel12/29/2009
  Q: i am trying to use panels that get added to the controls of the owner form instead of message boxes. ...
  A: Declare this in any module (Win API Function) ============================================= ...
For Help12/28/2009
  Q: Sir 1.How Can i add data from text box to data grid 2.I would like to Insert date value in ...
  A: In any module add these code and variables '---------Variables for Adodb connection Public rs As ...
Multiline textbox12/27/2009
  Q: How do i copy text in a multiline textbox to a normal textbox?
  A: add a command button (name it Command1) to your form which has multiline and normal textboxes (for ...
CROSS TAB12/26/2009
  Q: . i have created cross tab in crystal report 8.5. and i want to filter the cross tab by date using ...
  A: what is your cross tab query paste it to analyze. ***********ATTENTION************* why did you ...
table manipulation12/24/2009
  Q: in vb6,how to manipulate(new,save,delete,update)using 'ADODB'CONNECTOR WITH MS-ACCESS?
  A: use the following variables and code in any module to connect to access datbase: Global Con As New ...
sql syntax12/20/2009
  Q: . i have a table called table1. Name number No_Rekening Kantor Bulan Test1 ...
  A: This code is just appending existing records to table2 from table1. To add new record you need to ...
sql syntax12/18/2009
  Q: . i have a table called table1. Name number No_Rekening Kantor Bulan Test1 ...
  A: I uploaded a sample project at http://rapidshare.com/files/323064503/Anez.zip.html I assume you ...
sql syntax12/18/2009
  Q: . i have a table called table1. Name number No_Rekening Kantor Bulan Test1 ...
  A: In a module paste the following to connect ADO access database Public con As New ADODB.Connection ...
VB & MySQL12/17/2009
  Q: I am trying to make a client/server Stock Management Application connected through a network with VB ...
  A: you didn't write which databse you want to use viz. Access /Sql / Foxpro etc. To use Access ...
Help About Two Lists12/16/2009
  Q: i hope u will be fine, acctually sir i want to ask about two lists, suppose i have two lists list1 ...
  A: ******Button cmdAddtoList1 (This will add all selected items from List2 to List1 and Remove items ...
Datagrid inVB 612/13/2009
  Q: In datagrid how do i set the width of column ? If the Text goes beyond default width of column, ...
  A: use the following cod eto set datagrid column width on runtime. Me.DataGrid1.Columns(0).Width = ...
Coverting from numerical values to alpha values in VBA.12/13/2009
  Q: My employer has recently changed from a Numerical Location Code eg 1ME to an alpha location code NME ...
  A: send me your excel workbook with macro enabling me to check with the existing data and sheet ...
question about vb12/12/2009
  Q: input a 5 digit number from user and determine whether it is palindrome or not ? How to determine a ...
  A: you are asking question or ordering command ? no discipline for request ? check with the following ...
NUMBER12/11/2009
  Q: It's me andry, I have table like this Table A Nama jumlah Andry 2 Amir 3 Ahmad 1 I ...
  A: you can download the sample file from link below : ...
Help file12/10/2009
  Q: Sir, plz tell me how to build our own help file in vb project??
  A: First write your help in ms word topic wise. save it as Web Page (it will have extension .html) ...
Listview12/9/2009
  Q: . i'm sorry sir..for my mistake.. but i'm promise i wouldn't do again.. would you help me sir? I ...
  A: paste the modified code to click event of your command button ...
Listview12/9/2009
  Q: . i'm sorry sir..for my mistake.. but i'm promise i wouldn't do again.. would you help me sir? I ...
  A: I didn't find a command button on your form. place a command button on it and name it cmdDelete. In ...
Listview with checkboxes12/9/2009
  Q: . I know you're expert in vb 6 and i dont.. I have a listview with checkboxes and a command button. ...
  A: I have already answered this Question. do not raise 2 questions for the same problem. however the ...
autonumber12/7/2009
  Q: . i have textbox and 2 commandbutton. so when i click the command,in textbox fill the ...
  A: ok send me your project with database aziz_abroad at yahoo dot com ***** The following code will ...
autonumber12/7/2009
  Q: . i have textbox and 2 commandbutton. so when i click the command,in textbox fill the ...
  A: you should not write do you know ....... if I do not know i would be at your place asking questions ...
Listview setfocus12/7/2009
  Q: . i have a listview,textbox and commandbutton. when i fill data in textbox and i click command ...
  A: Paste the following code in click event of your command button : ...
SQL SERVER12/2/2009
  Q: would you help me how to make new user in sql server 2000 using vb 6? or may you give me the link ...
  A: check with the following code: Public Function AddUserTOSQLServer(ByVal UserName As String, _ ...
populate items in combobox using records from mssql table11/29/2009
  Q: How to populate items in a combobox in vb6 using records from mssql table? this is my code: RS.Open ...
  A: take some pain to give more details. do you have Stud_No a text field(nvarchar) in sql table ? if ...
Valid open statement11/22/2009
  Q: Which of following is a valid Open statement for the file test.dat? Open "a:\test.dat" for Append As ...
  A: I assume d1gEdit is the name of Common Dialog Control d1gEdit.Filter="Document Files{*.doc}1*.doc ...
vb11/22/2009
  Q: . i want to increase or decrease numbers of line control as per user choice at run time in vb then ...
  A: The following code will draw lines no. of times user enter into inputbox. Private Sub Form_Click() ...
Valid open statement11/22/2009
  Q: Which of following is a valid Open statement for the file test.dat? Open "a:\test.dat" for Append As ...
  A: open statement ============== Open pathname For mode [Access access] [lock] As [#]filenumber ...
Copying a folder to a location11/17/2009
  Q: I need your assistance on a code that will copy a specific folder from one location to another. e.g. ...
  A: same code will do the trick this will replace the old folder contents with new. to test this ...
VB6 - Access database - Could Not lock / placed in a state by user / could not update11/14/2009
  Q: I have developed a stock system which currently has a Access backend. The database is on a server ...
  A: try to change adLockOptimistic to rs.Open SQLStatement, cn, adOpenDynamic, adLockOptimistic ...
VB6 - Access database - Could Not lock / placed in a state by user / could not update11/14/2009
  Q: I have developed a stock system which currently has a Access backend. The database is on a server ...
  A: This message indicates that access database has been opened exclusively. open database click tools ...
display data in datagrid in order11/14/2009
  Q: good morning sir, how can we display data in datagrid in order, for example , if i'm entered bill no ...
  A: you need to use Recordset to update table. I am unable to understand why are you using duplicate ...
Crystal report printing Problem11/2/2009
  Q: I M using this code for Printing all datagrid colomn in my desiging crystal report bt when i run ...
  A: if you are using Val function then no need to add ' Try to change the sql part from " where ...
Copying a folder to a location10/29/2009
  Q: I need your assistance on a code that will copy a specific folder from one location to another. e.g. ...
  A: Try with the following code : Sub CopyFolder(folderpath As String, destfolderpath As String) Dim ...
2 level depth inheritance10/28/2009
  Q: Good day Sir. I just want to ask how to make a 2 level depth inheritance in VB6? Thank you for your ...
  A: vb6 is not 100% Object Oriented but vb.net is. hereunder is a example of using inheritence (Treeview ...
how to insert wav file in VB610/26/2009
  Q: Mr Aziz; Sorry I take ur time. but I know you're expert in Vb6, but I don't. my Boss want me to ...
  A: In a module Paste the following code : Public Declare Function sndPlaySound Lib "winmm.dll" Alias ...
vb10/24/2009
  Q: how to scroll treeview in vb and how it is possible to show all nodes of treeview on runing the form
  A: I am unable to understand How to scroll treeview in vb if treeview is populated with nodes the vb ...
sql queries and dbs connectivity in vb10/23/2009
  Q: Private Sub Form_Load() Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data ...
  A: change the following line s = "SELECT desg_name From designation WHERE desg_id=(select desg_id from ...
vb10/21/2009
  Q: I am getting a bill number in a text box. i want to print the whole details of that bill in a ...
  A: Simple SQl to select all data from a table SELECT * FROM urTable The above statement can be ...
VB problems10/21/2009
  Q: I want to check a text box value with sql2000 server db using sql query and show the new form. Where ...
  A: you missed to initialize eid better change the existing strsql strsql = " SELECT * FROM ...
VB problems10/21/2009
  Q: I want to check a text box value with sql2000 server db using sql query and show the new form. Where ...
  A: you need to use recordset as follows : change this Dim statement Dim strsql As String to Dim strsql ...
regarding with data grid control10/20/2009
  Q: I want to know how to load the msAccess datas to the vb data grid control?plese give me a answer. ...
  A: you can download sample project from link below: ...
Change Cell Font10/19/2009
  Q: My request is fairly easy. I'm using excel. I already occupied the 3 spaces for conditional ...
  A: For StrikeThrough (D4:D100) =========================== Dim c ...
Visual Basic10/15/2009
  Q: what is mean by ADODB? how it works in VB? give detailed discription with example?
  A: Activex Data Object DataBase Or ADODB ===================================== Microsoft's ActiveX Data ...
VB inserting into SQL Table10/15/2009
  Q: i want to develop a front end scren, from this screen the data input by the user needs to be ...
  A: *********************Additional Information*************** You should Create a Data Entry Form In ...
Imagecombo in VB610/12/2009
  Q: When I type anything in imagecombo, the icon it already had disappears. This is because the ...
  A: Place a command button on your form and name it cmdAdd. Paste the following code in its click event ...
VB inserting into SQL Table10/9/2009
  Q: i want to develop a front end scren, from this screen the data input by the user needs to be ...
  A: Pste this code in any module and call it to connect when needed ...
if iserror10/7/2009
  Q: I have two cells F25 and F26 that, depending on which on has data entered into it, the other one ...
  A: Actually I just gave you the example for one cell to change your existing formula,you can use the ...
if iserror10/6/2009
  Q: I have two cells F25 and F26 that, depending on which on has data entered into it, the other one ...
  A: What do you want to check in F26 before supplying formula for that cell ? Target cell is checked ...
VB6 and db10/3/2009
  Q: my vb project is to create an contacts book. can you please help me with the code to search for an ...
  A: create a form and name it frmSearch create a module and name it basconnect in frmSearch place 3 ...
Microsoft Outline control Menu10/1/2009
  Q: How can I generate menu as into tree structure ? ANSWER: while asking question take some pain to ...
  A: I have uploaded the Project with 2 forms. The form opens when you click Product master it opens ...
Tree Menu Problem10/1/2009
  Q: How can I generate menu as into tree structure ? ANSWER: while asking question take some pain to ...
  A: In Treeview Node Click event you can check the nodeid and then with select case open the required ...
coding9/30/2009
  Q: login functionality in vb ?
  A: create a form as follows : Place a combobox for user name , 1 textbox for password and 2 ...
SQL SCRIPT9/28/2009
  Q: i'm sorry sir..but the coding that you give still doesn't work. now the error say invalid column ...
  A: Use the following code instead: kata = "SELECT * FROM tbmasuk WHERE Tanggal_masuk Between '" & ...
SQL SCRIPT9/28/2009
  Q: i have 2 dtpickers and listview. do you know sql script for filtering date? so when i choose the ...
  A: check with the following : SELECT *, Tanggal_masuk AS Expr1, tbmasuk.* FROM tbmasuk ...
SQL SCRIPT9/28/2009
  Q: i have 2 dtpickers and listview. do you know sql script for filtering date? so when i choose the ...
  A: can you paste your code you are using to connect your sql2000 databse. I will check using the same ...
Save command button9/14/2009
  Q: How to create the save command button codes?
  A: you didn't specify how you are connecting to your database. For DAO Access connection ...
Visual Basic9/10/2009
  Q: How can I insert a group of data in datagrid and i want to click a button to save the content of ...
  A: you can use adodc control to display data in datagrid. make several buttons on the form that ...
treeview vb69/7/2009
  Q: i already create my project in vb6 with database from ms access, and the project look like library ...
  A: send me your database : aziz_abroad at yahoo.com if needed I will add fields to your database.Also ...
excel - VB9/6/2009
  Q: I´m a fanatic spreadsheet-developer. It´s like a game. But how can I make that the sheet is shown ...
  A: use the following vb code in excel vb window i.e Tools--->Macro--->Visual Basic Editor In vb editor ...
Printer Orientation9/2/2009
  Q: Please give VB Code for changing printer orientation in vb6.0 , Please give VB Code for changing ...
  A: Default Printer --------------- on a form place a listbox named as LisBox1 and a command button as ...
output access data to word9/1/2009
  Q: I am trying to use VB6 to output data that is prioritize by order number from specific field to a ...
  A: use ado or dao recordset DAO ---- Dim dbs As DAO.Database Dim rs as DAO.Recordset Dim StrOrder as ...
hi9/1/2009
  Q: i just need codes for may command buttons such as add,delete,edit print,next,previous and exit. I ...
  A: cmdNewRecord (Add new Record) ------------------------ Private Sub cmdNewRecord_Click() ...
Hiding columns if blank to update chart8/31/2009
  Q: Its me again! I have a question please. I have several drop downs on Sheet1 that show either "yes" ...
  A: Christina I am sorry for the delay. I was working on a databse mailed to me by Michael. I would look ...
Compact and repair access 20038/30/2009
  Q: I use an Access 2003 Database for my VBprogram and my access is password protected. In Access I have ...
  A: use the following code ====================== Dim OldName Dim NewName DBEngine.CompactDatabase ...
Magnification8/28/2009
  Q: Can you please explain what X in magnification means.
  A: actually this is not vb question. However I am trying to explain a little bit if you want to know ...
vb6 database8/27/2009
  Q: i just like to ask what will happen to all the records if i remove my program database(using vb6) ...
  A: if using package wizard you have added your databse file then uninstallation will all the files you ...
Transfer Data8/26/2009
  Q: I have some data in excel (column A,B,C,D) and i want to transfer value in column C,D into access ...
  A: I can sure help you if you provide me with complete details like: Which option you choose to import ...
Transfer Data8/26/2009
  Q: I have some data in excel (column A,B,C,D) and i want to transfer value in column C,D into access ...
  A: I didn't get any command button and even no Form in the attached databse. I created form1 and placed ...
Auto update chart8/25/2009
  Q: I'm new to VBA and trying to figure this out as I go along so please don't be upset if I come back ...
  A: yes even without password you can copy the range as follows.by mistake i thought Access instead ...
Transfer Data8/25/2009
  Q: I have some data in excel (column A,B,C,D) and i want to transfer value in column C,D into access ...
  A: Option 1 ---------- without using VB (directly import from Access File Menu --->Get External ...
Auto update chart8/24/2009
  Q: I'm new to VBA and trying to figure this out as I go along so please don't be upset if I come back ...
  A: First you need to check wheather the file has been saved with password or not.If password then no ...
delete records from the selected in list8/23/2009
  Q: how to remove item in the listbox by clicking remove button. the item is from database. how to ...
  A: what is the code you used for Conndb. you have not used open recordset object as I mentioned in ...
delete records from the selected in list8/22/2009
  Q: how to remove item in the listbox by clicking remove button. the item is from database. how to ...
  A: To remove item from list and at the same time from database ...
Creat relativity.8/20/2009
  Q: In V.B. I have two different forms. The first one is almost like a list. It contains name of the ...
  A: you can not create relation between forms.you need tables to create relations between them. for ...
datagrid8/20/2009
  Q: help me with some codes on how to list out all fields in an access database to a flex grid using sql ...
  A: have you placed the adodc control and named it adodc1. when message box flashes message for invalid ...
msflexgrid8/20/2009
  Q: help me with some codes on how to list out all fields in an access database to a flex grid using sql ...
  A: I would suggest to use Datagrid instead msflexgrid.not only display but also you can add new data ...
Propertybag8/19/2009
  Q: I had tried to write more than 1 property bags in one project but to no avail Only one value could ...
  A: To test the property write and read method just paste this code to form load event. Dim objBag As ...
message box: sum of cells must be less than 100%8/17/2009
  Q: I have another question for you please! I have three input cells (F75:F77) that are formatted at ...
  A: In F78 use formula instead manually input by user i.e. Sum(F75:F77) and paste the following codes . ...
message box: sum of cells must be less than 100%8/14/2009
  Q: I have another question for you please! I have three input cells (F75:F77) that are formatted at ...
  A: try with the following : Private Sub Worksheet_Calculate() If Cells(6, 75).Value + Cells(6, ...
VB menu error8/14/2009
  Q: I am new to VB. I was creating a small menu of the following pattern: File ...New ...Open Now ...
  A: I assume you have same menuname for 2 menus. Try Like this File caption : &File menu ...
Hide block Textbox8/13/2009
  Q: I'm making a useform and I want people to say if they are single cheking an option box, and if ...
  A: You need to check the value of checkbox. for example if chkbox1 is for single and chkbox2 is for ...
if and statements in vb8/13/2009
  Q: I have an input sheet with several data validation drop downs. Super-imposed on top of those drop ...
  A: Place Stop after this line to break the code If Target.Address = "$G$59" OR Target.Address = ...
How to append another text entries to the existing .txt file?8/13/2009
  Q: I'm trying to create a program of my own that puts all the text entered from a textbox to a notepad ...
  A: change this line i.e. For Output to Append Open "c:\Call_Loggers.txt" For Output As #nFile to ...
if and statements in vb8/12/2009
  Q: I have an input sheet with several data validation drop downs. Super-imposed on top of those drop ...
  A: Try with the following if I guessed correctly : If Target.Address = "$G$59" OR Target.Address = ...
validation8/12/2009
  Q: in our project section code is one field sir it actually accepts number but it i saccepting both ...
  A: check with Isnumeric function as follows : Private Sub txtPrdDesc_GotFocus() If Not ...
export8/12/2009
  Q: 1 How to export datagrid data from vb to Excel ? 2 How to export ms-access table from vb to Excel ?
  A: 1 Try with the following codes: Private Sub cmdExport_Click() Dim oExcel As Object Set oExcel = ...
word conversion from one language to another8/11/2009
  Q: A.Salam i am doing a small project in vb which should convert a word written in one language to ...
  A: you can use office file object to search with the following codes Dim objFSO, objFileStream, ...
VB 6.......PRINT out8/10/2009
  Q: i want to print my VB form at the center of my A4 page how can i do that..........i ve designed the ...
  A: do you wish to print Form Image this can be done by double clicking form. Then ...
word conversion from one language to another8/9/2009
  Q: A.Salam i am doing a small project in vb which should convert a word written in one language to ...
  A: use the following code Private Sub Text1_LostFocus() If Len(Trim(Me.Text1)) > 0 Then Const ...
confusion in a program s algo8/7/2009
  Q: hey sir! i have a truble in 1 project 2 develop plz give me its algo the question is "develop a ...
  A: Make a form from the tool box Click Frame (just below label displayed as A) and place it on the ...
entering data in a form8/7/2009
  Q: how to entering data in a form from access database its auto no click in form field so if you ...
  A: Paste this code in any module To open databse --------------- Public rs As DAO.Recordset Public dbs ...
How to lock the particular rows in DATAGRID8/7/2009
  Q: I really am having problem with DATAGRID in VB6, which eaten-up hell lot of hours. Please help!!!. ...
  A: In any module add these code and variables '---------Variables for Adodb connection Public rs As ...
error 138/1/2009
  Q: when i check the check box(second installment) then i want to update table. table has two ...
  A: I don't know what is your table. However below is the connection details and update commands. I hope ...

All Questions in This Category

Visual Basic

All Answers

Answers by Expert:

Ask Experts

Volunteer

Ahmed Sayed Aziz

Top Expert on this page

Expertise

All questions related to vb6 only. Excuse me for vb.net.

Experience

multiple years as a programmer.

Organizations
Print Media

Publications
Math Skill Test VB6 Game Source Code published at Planet-Source --------------------------------------------------------------- http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=72322&lngWId=1 Holy Quran Source Code published at Planet-Source ------------------------------------------------- http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=1&txtCodeId=72343&txtForceRefresh=82020091635140766 Right to Left Treeview & Listview Source Code published at Planet-Source ------------------------------------------------------------------------ http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=72376&lngWId=1

Education/Credentials
Commerce Graduate ICWAI

Awards and Honors
Wizard certificate from experts-exchange.com ============================================= http://www.experts-exchange.com/M_1214708.html Level 4 certificate from Yahoo!Answers ======================================= http://answers.yahoo.com/my/my;_ylt=AkjObjoI7Cr1x01J9syQ5RZ17hR.;_ylv=3

©2012 About.com, a part of The New York Times Company. All rights reserved.