| Subject | Date Asked |
|
| Copying a folder to a location | 11/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 update | 11/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 update | 11/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 order | 11/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 Problem | 11/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 location | 10/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 inheritance | 10/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 VB6 | 10/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 ...
|
| vb | 10/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 vb | 10/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 ...
|
| vb | 10/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 problems | 10/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 problems | 10/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 control | 10/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 Font | 10/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 Basic | 10/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 Table | 10/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 VB6 | 10/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 Table | 10/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 iserror | 10/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 iserror | 10/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 db | 10/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 Menu | 10/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 Problem | 10/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 ...
|
| coding | 9/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 SCRIPT | 9/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 SCRIPT | 9/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 SCRIPT | 9/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 button | 9/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 Basic | 9/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 vb6 | 9/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 - VB | 9/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 Orientation | 9/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 word | 9/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 ...
|
| hi | 9/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 chart | 8/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 2003 | 8/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 ...
|
| Magnification | 8/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 database | 8/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 Data | 8/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 Data | 8/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 chart | 8/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 Data | 8/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 chart | 8/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 list | 8/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 list | 8/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 ...
|
| datagrid | 8/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 ...
|
| msflexgrid | 8/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 ...
|
| Propertybag | 8/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 error | 8/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 Textbox | 8/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 vb | 8/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 vb | 8/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 = ...
|
| validation | 8/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 ...
|
| export | 8/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 another | 8/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 out | 8/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 another | 8/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 algo | 8/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 form | 8/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 DATAGRID | 8/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 13 | 8/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 ...
|
