New to VB 2

[CTR]

I've never used VB, but I am familiar with ColdFusion and comforatble with Access and query building.

Will I be able to learn VB?

What I want is to create a program that I can distribute to others. It will manage a lot of data through data entry fields and perform calcualtions. Reports will need to be printed. It must be able to opererate in a netwokr environment. I need a lot of control of user level and who can see and edit different elements.

I know I can do this in Access, but it requires two things I don't want to give up, first the end user needs to own Access and that turns into a version problem, second I don't like the security Access has built in.

Can VB do this for me? If so, which version? What is Visual Studio as compared to Visual Basic?

Thanks! _____________

Cliff

 

[RiverGuy]

Visual Basic is a part of Visual Studio, which includes VB, VC++, etc.

You should be able to do this in VB, although it will require lots of coding and learning. It might be easier to try out in VB 6 if you've done any macros is MS Office.

 

[CTR]

RG,
Thanks. I suspect it may be too much at this point.

I've downloaded some tools that manage data. While I do have Access installed on my PC, I don't belive they require Access to run. Is this possible? _____________

Cliff

 

[krisbrixon]

Visual Basic will be a lot more work compared to ColdFusion and Access for things like data entry and reports. You will also most likely have to write your own security for the program.

RiverGuy is right if you know Access and are not interested in being a full time VB developer then use VB6 since it will be a little more familiar. If you want this to lead into a career in VB development then I recommend you learn VB.NET.

Couple more thoughts:

1. You can write Access programs and have them run on computers that do not have Access. See link:

http://msdn.microsoft.com/library/d...odcore/html/deovrDeployingAccessSolutions.asp

2. What about makeing it in ColdFusion and running it as an Intranet program instead of an Internet program.

I hope some of this helps

Kris
[fumanchu]

 

[CTR]

Thanks to both.
I was hpoing VB would offer me some help.
The concern isn't that the end users won't have Access, it's I want to completely control the ability to modify the structure. I've found this difficult to do in a networked environment.

I did look at the Microsoft article you referenced, I suspect this might not work if the user did have Access. Also, it looks like it would require the end user to purchase Access developer.

What I plan to design is a package where users can enter data, likely from more than one location. It needs to be secure, and the structure can't be modified. It needs to be accessible form many locations. Options must be user defined / selected. Security must be multie-level.

It looks like I will move toward CF as this will meet all of these requirements. The drawback here is that the user will need access to the server I place the program on, I can';t consider distributing it for installation on their server. That would mean I'd need to set up either an annual or monthly fee. I would have preferred to distribute it outright.

Thanks for the suggestions. This is a great forum. _____________

Cliff

 

[CTR]

Thanks to both.
I was hpoing VB would offer me some help.
The concern isn't that the end users won't have Access, it's I want to completely control the ability to modify the structure. I've found this difficult to do in a networked environment.

I did look at the Microsoft article you referenced, I suspect this might not work if the user did have Access. Also, it looks like it would require the end user to purchase Access developer.

What I plan to design is a package where users can enter data, likely from more than one location. It needs to be secure, and the structure can't be modified. It needs to be accessible form many locations. Options must be user defined / selected. Security must be multi-level.

It looks like I will move toward CF as this will meet all of these requirements. The drawback here is that the user will need access to the server I place the program on, I can';t consider distributing it for installation on their server. That would mean I'd need to set up either an annual or monthly fee. I would have preferred to distribute it outright.

Thanks for the suggestions. This is a great forum. _____________

Cliff