Convert Access to VB.Net 1

[LonnieJohnson]

Does anyone know of any free utilities that convert MS Access applications to VB.Net?

Thanks.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[chrissie1]

to lonnie,
i dont know of any free utilities but i recommend doing it by hand because much of the code cant be converted anyway. Like the reporting. and chances are that it will convert to adodb while ado.net is better. just my 2cents worth.

Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

 

[LonnieJohnson]

Thanks chrissie1. I am doing it by hand. I haven't had much training on vb.net. I am stuck trying to populate a combo box. Is there somewhere that has a step by step for something so simple as putting data into the combo box's "row source" from an sql server table?

I too am an Access fanatic, but our company wants to go to .Net, I am the only one in the company that knows about any of it.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[chrissie1]

dont think to much of it its easy ones you know how

filling a combobox

make a dataset with maximum two rows an id an a text one then set the datasource = dataset
displaymember = "nametextfield"
valuemember = "nameidfield"


Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

 

[LonnieJohnson]

Will I need a data adapter for each combo box? I have two of them. One will get data from one table and the other will get data from another table.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[chrissie1]

yes and no

if you do it programmatically you dont need two dataadapters but and only one dataset with two tables.

if you do it via the IDE then yes (but i could be wrong here because i always make them programmatically.

Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

 

[LonnieJohnson]

Cool, thanks.

You can stop answering me at any time, but what is the syntax for loading a second form from an already open form?

It's clearly not DoCmd.OpenForm

Nor is it

Load MyForm

I want to put it in a command button's click event.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[LonnieJohnson]

That's ok. I found the load syntax.

Dim f as New MyFormName
f.Show

Thanks for everything.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!