VB Newbie. Needs help from VBA

[Stevehewitt]

Hey,

I've been using VBA for sometime in Access 2000 - 2003 only. (Not Word or Excel)

I'm desperate for any documentation that can help moving my app from VBA to VB.net. MS Docs are useless as they are based on Word / Excel only - which although the language is the same, none of the examples are useful and the context isn't relevant.

Anyone give me a hand?

Thanks,


Steve.

 

[RiverGuy]

Steve,

The question is fairly open ended. Are you wanting to move a whole Access application to VB.Net?

If so, are you wanting to utilize the Access object libraries, or do you simply want to maniuplate the data with the Jet engine?

Do you want to change over your Access reports to Crystal reports, or are you relying on some, external reporting method?

You can probably get many tips here for specific problems. I'm not really sure of a site that will cover all bases to upgrade most common VBA coding from Access to .Net.

 

[Stevehewitt]

Hey,

Sorry about the delay!

Yeah, I'd like to change over from Access to an application in its own right. Having the data stored on a SQL Server.
I would be using Crystal Report.

I'm desperatly after a link to a site or mini-site on the differences between VBA / VB.net code and objects. There seems to be nothing anywhere on the web.

Thanks for your help,


Steve.

 

[infinitelo]

You have a tall order, Access vba is very different from other vb coding. You may have to start from scratch.
This foum will be good if your stuck on a specific part, but if you need a wizard/cut and past solution, You might check out the visual foxpro forum, they may be more help.
Ive lost touch with foxpro but last i heard was that it was dot net compatible,could make compiled runtime, and could use access files. (dont know about forms and report conversions)




if it is to be it's up to me

 

[Stevehewitt]

Thanks.

I'm not really after a wizard or cut and paste the solution, but some pointers and/or books on adapting your code to VB.net from VBA.
I know that VBA is unmanaged code, and isn't .net so its very different - but I can't find anything on the net regarding the differences.

Thanks,


Steve.

 

[kcj402003]

I was presented with the same problem. I found it easier to just start from scratch. One book that I found very helpful is from Wrox: "Beginning VB.NET 2nd Edition"
ISBN# 1-86100-761-2. You could follow up with "Proffesional VB.NET 2nd Edition"

KJ

 

[DigitalGeek]

I have a similiar project in Excel, very power app, very BIG app. I found about a half dozen books and soked up the material and dove in to start from scratch, my first release is almost ready. I am a happier man for this task!!!!!!!!!!!!!!!!