accessing a data table from all forms

[JohnM]

I want to create a Call statement in 16 different forms. The Call would be to calculate a value from a database. As the using goes through the 16 forms, the calculated value wwill change. Instead of duplicating the database in each of the 16 forms (using the OleDbDataAdapter.fill(dataset)) in each form, I tried placing the created dataset in a module, hoping that the dataset could be access by each of the Call statements. But it doesn't work.

I would appreciate any direction I could go and work this out.

Sincerely

JohnM

 

[Arg81]

this is definitely in VS2003? It's possibly very easy to do in VS2005....

 

[JohnM]

Thanks

Thank you, I will do some searching and let you know.

John M

 

[Arg81]

search for what?!?! I asked a question of whether your profile is correct, and are you actually using VS2003?????

 

[JohnM]

vs2003

I apologized. I mis-understood.

I am using vs2003. I am going to upgrade to 2005 sometime this year.

 

[Arg81]

It's a lot easier to do it in 2005 than 2003 to be honest, that's why I was asking.

 

[JohnM]

Thanks for the push

Thank you for the push.

I solved it this. I put into a module the array I created to hold the 2 fields from a data set. I put the function into a module also. Thats the calculation I had used in the last page of the application. Now that's in a module, I am able to access it with a CALL command from the 18 indivisual pages of the application.

I am not very literate with .net yet. What I described above isn't very good .Net lanquage, so I hope you can follow my words.

I do very much appreciate your words. They were motivating to me.

Thank you

John M