| Subject | Date Asked | Expert |
|
| Copying a folder to a location | 11/17/2009 | S.Aziz |
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 update | 11/14/2009 | S.Aziz |
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 update | 11/14/2009 | S.Aziz |
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 order | 11/14/2009 | S.Aziz |
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 ...
|
| Macro Coding for updating the textbox | 11/13/2009 | Ravindra |
Q: Sir, Kindly tell me the coding for the text box, where the text box should not be blank when it is ... A: Option Explicit Private Sub Text1_LostFocus() If Text1 = "" Or IsNumeric(Text1) = False Then Text1 ...
|
| Key Sending Using VB6 | 11/11/2009 | Richard Rost |
Q: im new to the programming world, but i am looking for a way to make the computer think its receiving ... A: You can use the SendKeys command for this. For the pause you'll need to use the Win API function ...
|
| Printing a file | 11/3/2009 | Amal Raj A |
Q: I am using VB6 and am trying to print a file without ever opening it. This can be accomplished ... A: I cannot provide you the complete code for now. But I can offer some tips. You would need to use the ...
|
| Crystal report printing Problem | 11/2/2009 | S.Aziz |
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 ...
|
| Printing Data Report | 10/31/2009 | Ravindra |
Q: Good Day. I am a beginner in vb 6.0.My question is how to print a data report as a result of search ... A: your method has problems: here's a typical code: connect dataenvironment to the table connect it to ...
|
| Copying a folder to a location | 10/29/2009 | S.Aziz |
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 inheritance | 10/28/2009 | S.Aziz |
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 ...
|
| Excel VBA | 10/27/2009 | Ravindra |
Q: I'm not sure if you have any experience in the VBA side of excel, but I am trying to write a macro ... A: it is not the no of hours to write the code but the number of years understanding the ...
|
| Programming User Form | 10/26/2009 | Ravindra |
Q: My Knowledge is very limited. I have a user from set up and want it to get information from a ... A: for this the excel sheet needs to be open then you can put this code with changes as required ...
|
| how to insert wav file in VB6 | 10/26/2009 | S.Aziz |
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 ...
|
| vb | 10/24/2009 | S.Aziz |
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 vb | 10/23/2009 | S.Aziz |
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 ...
|
| visual basic 6.0 and data report | 10/22/2009 | Ravindra |
Q: i have following tables in my database master-containing all account no transaction2007-containing ... A: from your description it is not clear about the design of your tables. if you are filtering on dates ...
|
| vb | 10/21/2009 | S.Aziz |
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 problems | 10/21/2009 | S.Aziz |
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 problems | 10/21/2009 | S.Aziz |
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 ...
|
| VB problems | 10/21/2009 | Ravindra |
Q: I want to check a text box value with sql2000 server db using sql query and show the new form. Where ... A: strsql is just a string and not the recordset's field value you need to open it as dim rec as ...
|
| regarding with data grid control | 10/20/2009 | S.Aziz |
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 Font | 10/19/2009 | S.Aziz |
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 ...
|
| run time error 91 | 10/16/2009 | Ravindra |
Q: i have a exe of a project which one of my friend mailed me he says that the exe runs perfectly right ... A: i think that in your PC, the ActiveX Data Objects is not checked or it is wrongly declared. open a ...
|
| run time error 91 | 10/16/2009 | Ravindra |
Q: i have a exe of a project which one of my friend mailed me he says that the exe runs perfectly right ... A: exe will run only if you have vb in your comp. you can try adding vbruntime files (available frin ...
|
| Visual Basic | 10/15/2009 | S.Aziz |
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 Table | 10/15/2009 | S.Aziz |
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 VB6 | 10/12/2009 | S.Aziz |
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 Table | 10/9/2009 | S.Aziz |
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 iserror | 10/7/2009 | S.Aziz |
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 iserror | 10/6/2009 | S.Aziz |
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 ...
|
| storing data | 10/6/2009 | Ravindra |
Q: i feel i should have explained my state /problem clearly. my pc is interfaced with a current ... A: you can save data to 1) array,2)text file,3)excel sheet,4)access table etc. where is the data: in ...
|
| VB6 and db | 10/3/2009 | S.Aziz |
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 Menu | 10/1/2009 | S.Aziz |
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 Problem | 10/1/2009 | S.Aziz |
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 ...
|
| Get file path | 9/30/2009 | Frank G. Dahncke |
Q: I am developing a simply database application in Visual Studio 2008. Clicking a particular button ... A: Among the controls provided with VB.NEt is one called OpenFileDialog. Drop that on your form, select ...
|
| vb 6.0 question | 9/30/2009 | Ravindra |
Q: I have developed a software which server and client based i am asking you adopendynamic and ... A: this lockoptimistic etc does not prevent any insertion or update. If 2 persons are using this at ...
|
| coding | 9/30/2009 | S.Aziz |
Q: login functionality in vb ? A: create a form as follows : Place a combobox for user name , 1 textbox for password and 2 ...
|
| SQL SCRIPT | 9/28/2009 | S.Aziz |
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 SCRIPT | 9/28/2009 | S.Aziz |
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 ...
|