SQL data connection not in all forms

[samycbe]

Hi

I have a sql server connection in my user login form_load...

Con.CursorLocat ion = adUseClient
Con.Open "Provider = SQLOLEDB.1;Pers ist Security Info=false;user ID=xxxx;pwd=yyy ;Initial catalog = ;Data Source = xxxx"

it is working only in that form but it is not working in other forms. how to make it global. please help me ......

samy

[sashi]

Hi there,

Add a module file file to your existing project and place the code segment under a function, as a shortcut you can call the function whenever you need to get connected to SQL server. Hope it helps. Good luck & Take care.

Hi

I have a sql server connection in my user login form_load...

Con.CursorLocat ion = adUseClient
Con.Open "Provider = SQLOLEDB.1;Pers ist Security Info=false;user ID=xxxx;pwd=yyy ;Initial catalog = ;Data Source = xxxx"

it is working only in that form but it is not working in other forms. how to make it global. please help me ......

samy

[vijaydiwakar]

Hi

I have a sql server connection in my user login form_load...

Con.CursorLocat ion = adUseClient
Con.Open "Provider = SQLOLEDB.1;Pers ist Security Info=false;user ID=xxxx;pwd=yyy ;Initial catalog = ;Data Source = xxxx"

it is working only in that form but it is not working in other forms. how to make it global. please help me ......

samy

put the code in module with public access specifier

[samycbe]

I did that but shows an error like.....

okject variable or with block variable not set

[samycbe]

hi sashi....

Its working now. Thanks.

But i have one small doubt i am calling a function in all form_loads. Is it required?


samy

[vijaydiwakar]

I did that but shows an error like.....

okject variable or with block variable not set

first defind the conn object there as public in module