181 Posted Topics
Re: try this Dim fso As New FileSystemObject fso.DeleteFolder GetAppPath() & "\SPGPAC - File User Files\" & USER_NAME before putting this code first add references and so goto project menu and then select references option and then select Microsoft Scripting Runtime hope this helps you | |
Re: from the above posts , given by an expert , you question has been answered i've read this article and found why **Kimangel** using On Error Statement, in this case there is no need to use On Error Statement. Now i come to the topic and use the following ( … | |
hello expertes i have 2 tables , both having same table structure (i.e. same fields ) but having different Records. First Table for Male Candidate and another for Female Candidate. both tables have 2 fields namely :- name and marks. Now i wanna write sql statement using adodb to perform … | |
hello experts ! i've designed an application in vb6 with 1280*1024 resolution. it looks perfect when i see the application in system , having same resolution And now the real problem occures when i use it on another system having different resoltion like 1024*768. so how can i display the … | |
Re: use the following code(On form load event) to additems to combobox from database table con.Provider = "Microsoft.Jet.OLEDB.4.0" con.Open App.Path & "\db.mdb" rec.Open "select * from rates", con, 2, 3 While (rec.EOF = False) Me.Combo1.AddItem rec.Fields(0) rec.MoveNext Wend con.Close Set con = Nothing Now on the click event of combobox write … | |
Re: i think its 10 for newline and you can get it using ord() function in php hope this helps you ![]() | |
Re: you can create its exe (through file menu in vb6) and it will run as you think . . . or you can use package and deployment hope this helps you | |
Re: what efforts did you made to do so.... | |
Re: if you are familiar with connecting to access 2003 then just use the following connection string for access 2007 connector.Open "Provider='Microsoft.ACE.OLEDB.12.0';Data Source=Example.accdb" hope this may help you | |
Re: use following code to add items to listbox `list1.AddItem "item1"` if you mean retrieve data from database to listbox , then use the following code con.Provider = "Microsoft.Jet.OLEDB.4.0" con.Open App.Path & "\db.mdb" rec.Open "select field_name1,field_name2 from tbl", con, 2, 3 While (rec.EOF = False) List1.AddItem rec.Fields(0) List2.AddItem rec.Fields(1) rec.MoveNext Wend … | |
hello experts . . . i am using following code:- `con.Execute "insert into tbl values('" & Text1.Text & "','" & Text2.Text & "') ", adCmdText` i am trying to insert data using above statement and its working well but an error occures when i input data (contaning the symbol `'` … | |
Re: try the following:- Dim dt1 As String dt1 = Combo1.Text & "/" & Combo2.Text & "/" & Combo3.Text con.Provider = "Microsoft.Jet.OLEDB.4.0" con.Open App.Path & "\db.mdb" con.Execute "INSERT INTO tbl(dtfield) VALUES('" & dt1 & "')", adCmdText con.Close Set con = Nothing if still not answered , then please make your thread … | |
Re: you need only oneline code and that is as follow(on the form load) `Combo1.AddItem "item Name"` | |
hello experts . . . i've designed a form (two textboxes and one commandbutton) i wanna display id and user(fields of the table). and i display id and user on the basis of the id(inputted through textbox1).And for that i've written following code within command button's click event Private Sub … | |
Re: i assume that you are using MS Access as Backend and also not using 2007 or higher And Now , to do so you need to do following :- first of all add reference for adodb and for that go to project menu and select refernces and select Microsoft ActiveX … | |
Re: i think you should use label in the place of command button . you can perform almost all task by using label what is performed by a button . you can write code on label 's click or dblclick an so on . . . | |
hello experts `rec.Open "select * from tbl where id="& inputted, con, 2, 3` i used the above code to find records and now the real problem occures when a value is inputted and that doesn't exist in the database so in such a case i wanna display en error message … | |
how to make a mdiform fixed size(can't be resized or maximize) as there is no property like border style in mdi. | |
Re: its very simple just insert linux disk and run installation file and follow the simple instructions if you dont have linux disk then just download its iso from the internet(linux is open source , so dont be hesitate to download it) if still having problem then [Read this article](http://www.ubuntu.com/download/help/install-desktop-latest) finally … | |
Hello experts i am using following code in order to truncate a ms access table Dim con As New ADODB.Connection Dim rec As New ADODB.Recordset con.Provider = "Microsoft.Jet.OLEDB.4.0" con.Open App.Path & "\db.mdb" Dim query As String query = "truncate table tbl" rec.Open query, con, 2, 3 con.close but its producing … | |
Re: do you mean inserting data to database ? | |
Re: you can download dos-box turbo c++ from internet. it will work on all versions of window including win 7 and win 8 also try it now | |
hello experts . . . there is one textbox , one label and one command button i have written following to print textbox content to label `label1.caption=text1.text` and when & is inputted in textbox then underscore(_) is placed in the place of &. and i know that we use & … | |
Re: i dont know how to insert an image but here i am going to tell you the procedure which is normally opted by all programmers to do so you need to store the name of image file and just save this name to the database and store the image file … | |
Re: its very simple.just identify user or administrtor with their username and password and then call related function for ord.user or administrator for Example :- you user is found as ord.user then do following . . . in called function , you can write code for disabling some specific control that … | |
Re: its simple input device which accept data from bar code and put into focused control no seperate code is needed for that. its just a device like key board hope this helps you | |
Re: just visit tutorials websites to learn about visual basic and i think that this place is for solving programing problems and not for providing learning materials for beginners. come here when you have specific problem regarding your code. | |
there is a picture file ( 40*100 ) and i wanna show this image in the background and so , this picture file should be repeated both horizontally and vertically as we do in Html and css | |
Re: your code is working . . . . define your problem more clearly which belongs to the code or do you think about blinking the label ? | |
Re: Never use if statement again and again for a single task it comsume more time so now lets move to elseif it comsume less time then multiple if statement and finally there is one more tool exist in almost all programing language called switch case statement. And i will suggest … | |
Re: in order to execute your task , you can use the following:- Private Declare Function ShellExecute Lib "Shell32.dll" Alias "ShellExecuteA" _ (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, _ ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd _ As Long) As Long Const … |