181 Posted Topics

Member Avatar for Bile

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

Member Avatar for AndreRet
0
192
Member Avatar for kimangel

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 ( …

Member Avatar for AndreRet
0
201
Member Avatar for rishif2

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 …

Member Avatar for AndreRet
0
316
Member Avatar for rishif2

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 …

Member Avatar for AndreRet
0
148
Member Avatar for kimangel

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 …

Member Avatar for kimangel
0
2K
Member Avatar for eiramana06

i think its 10 for newline and you can get it using ord() function in php hope this helps you

Member Avatar for diafol
0
2K
Member Avatar for Anverdeen

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

Member Avatar for rishif2
0
64
Member Avatar for tifjones
Member Avatar for baabjitvk

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

Member Avatar for AndreRet
0
136
Member Avatar for vonnoy

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 …

Member Avatar for AndreRet
0
2K
Member Avatar for rishif2

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 `'` …

Member Avatar for AndreRet
0
130
Member Avatar for Krs13

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 …

Member Avatar for rishif2
0
118
Member Avatar for opera-rotas

you need only oneline code and that is as follow(on the form load) `Combo1.AddItem "item Name"`

Member Avatar for AndreRet
0
75
Member Avatar for rishif2

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 …

Member Avatar for rishif2
0
152
Member Avatar for vonnoy

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 …

Member Avatar for vonnoy
0
111
Member Avatar for sarman.boyslo

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 . . .

Member Avatar for sarman.boyslo
0
280
Member Avatar for rishif2

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 …

Member Avatar for AndreRet
0
136
Member Avatar for rishif2

how to make a mdiform fixed size(can't be resized or maximize) as there is no property like border style in mdi.

Member Avatar for AndreRet
0
140
Member Avatar for Slaman

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 …

Member Avatar for rishif2
0
174
Member Avatar for rishif2

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 …

Member Avatar for AndreRet
0
2K
Member Avatar for killer88
Member Avatar for plang007

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

Member Avatar for plang007
0
335
Member Avatar for rishif2

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 & …

Member Avatar for AndreRet
0
241
Member Avatar for ganges

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 …

Member Avatar for rishif2
0
162
Member Avatar for kshami92

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 …

Member Avatar for mark.scutt.7
0
109
Member Avatar for MutanaIK

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

Member Avatar for tinstaafl
0
172
Member Avatar for singh man
Re: hack

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.

Member Avatar for rishif2
-1
87
Member Avatar for rishif2

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

Member Avatar for tinstaafl
0
128
Member Avatar for mferarri

your code is working . . . . define your problem more clearly which belongs to the code or do you think about blinking the label ?

Member Avatar for samsylvestertty
0
629
Member Avatar for kedxu

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 …

Member Avatar for deceptikon
0
212
Member Avatar for Skate Bart

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 …

Member Avatar for rishif2
0
946