hi all,

I want to read MS-Access database tables through VB.

I try for reading excel file and i got success in reading excel file by adding reference microsoft execel library .

But i am...

for that you have to give update button to the user and for update button you can give code as follows

you write this code on update button click event


this code is for MySql server

for i...

you cann't update your table without using set.

for editing only particular column write this code

urGridName.Columns(1).ReadOnly = True

1 is the index of the column of which you don't want to edit through this code column 1 is turn into...

Thank you Maczoon
My problem is solved.

Regards,
Guest11

:)
Hey thanx buddylee
My problem is solved

Regards
Guest11

Hi all,

Can anybody tell me how to retrieve hard drive information in vb.net . I try my best search in google but not getting the appropriate information.

Its urgent.
Thanks in advance.
...

hi all,

I am using crystal report for displaying reports.
I want to display group by customers in report that i am displaying using group by funtion but i also want subtotal of that group by...

hi hkdani,

thanks for your support i got my problem. Actually i had taken all controls on tab control, and that's why i am facing that negative value problem. But now i got the solution thanks...

I use the same concept. But when i calculate the current left value then i got that value in minus(value i got is -68550). So whenever i try to calculate the new position using current left value i...

hi all,

I have one problem with resizing forms.

I am developing our application in vb and i gave code for resizing forms in resize event of form. First i save the sizes of all controls in forms...

thanks for ur reply debasis.
Can you give me the example for that .
I have 108 controls on my form.

hi all,
N good morning!

I am developing an application in vb. I had developed my application on my PC in 1024*768 screen resolution. When i rum my application in the same screen resolution then...

But i also want to assign value when user access data from database. Actually what i am doing is, when user enter new data that time i gave him selection from combo box but when user edit data that...

hi all,
I want to use combo box in my application and i want to give user only selection option for combo box when they are entry data so i make combo boxs style property to drop down list. But...

hi all,

I am making an insurance policy application in which i want give the facility of attaching file to user.
Actually i want to give facility that suppose customer give the required papers...

No forms are not the sequence forms I gave different name to all forms like AdmissionFrm , blockwiseFrm etc
Actuially I have two forms for viewing information and when I select one option from the...

I am creating vb appliction in which there are 20 forms i want to create two command buttons named current and previous forms. Can anybody tell me how i can do this ?
I want guide line.

Thanks...

Hi all,

I am facing problem regarding screen resolution. I mean i make one project and its run and look nice in my PC screen but if i run the same app. in others PC then its create problem i am...

Hi all,

I am making one project in which i want to give the facility of importing database data from text file to MS-Access database.
I know about importing data from excel to access but i am...

hi all,

Can anybody give me code for connecting vb 6.0 to ms-access 2007 with connectionstring

Regards
Guest11

hi all,

I have developed one application in vb and database MS-Access2003 it works properly if i use ms access 2003 or earlier version but if i run this application with latest version of database...

if rno and Rollno are same then try this query

INSERT INTO Section(FirstName, LastName)
SELECT FirstName, LastName FROM Student where student.rno=section.rollno

i hope it will work

give date value as

doj.text=09/01/2008
doj1.text=09/22/2008

i hope it will work try it

hi all,

I am using data report tool for showing my reports.
Everything is working well i am accessing records from table but when i set datasource to datareport it shows all records excluding...

You have to change report show property to landscape mode which u can do from here :
click start goto control panel menu then click Printers and faxes if you had installed the printer in your...

thank you very much selvaganapathy for ur rly my problem is solved .

regards
Guest11

hi all,

I am facing small problem in access database .
I am using MS-Access database in our application and i secure it by setting password to my database. But now i want to acces that database...

if your problem is solved than mark it as solved.

try this code
first of all make fields in your crystal report by using this steps
1. Open ur Crystal Report using crystal report wizard
2. select insert menu
3. select Field Object from Insert...

Try this :
set form's BorderStyle=none or 0 and when you click the button set forms WindowState property =2

set textbox Font property in whatever language u want. But u must know the font family of that language. for example i want to set textbox to marathi language then i set font property of that textbox...

passing variable values is also possible in crystal report. But type of value you want to pass explain using example means what you want to pass report title or what ?

hi all,

I am making an application which i want to make in multilingual means i want to make that application in many languagues. Suppose user select any language than font of my application will...

Actually what i want is suppose i have one program in which is created in vb, suppose Calcultor program and i want the output of that prg that is window of calculator in vb.net panel but when i use...

yes it is running using Process.start() but it is same as Shell command in Vb, it starts application as a seperate application but i want output in some type of container like suppose i have panel in...

hi all,

I want to run vb program through vb.net program is this possible in vb.net and i want to show output in some container.
In VB it is possible through Shell command but it runs the program...

Try our this code:

dim i as integer
dim j as integer
dim cnt as integer
dim rs as adodb.recordset

set rs=new adodb.recordset
rs.open urQuery,urDatabaseConnectionPath

hi all,

I am using combo box control in our application but facing one problem and which is like thisI am able to add items in combo box but i also want to add index in combo box in VB we do this...

Function GetRecord()

Dim ConnectionStr As String
Dim Uconnection As ADODB.Connection
Dim rs As ADODB.Recordset


ConnectionStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &...