VB.Net & Access Forms

[Jesse10]

Hi there,

I am very new to VB.net but have a lot of experience in Access 2003 so please bear with me.

A little background:
- I created 2 forms in Access 2003 (Form1 & Form2) for the purpose of creating a 'smartform' of sorts for my company. In essence they can click on a search feature in the top cell and input an employee ID # which automatically fills in about 10 to 15 fields.

- There is only 1 table attached to the forms.

- The group I created this for is uncomfortable using Access.


What I would like to do with VB.net:

- I thought I would create an internal webpage using VB.net so they wouldn't need to log into Access [the DB would be stored on a separate server.]

- I would need a clean & simple interface that has 2 buttons, one for each form.

- When the form is called up I would need a search feature "EMPLID _________" which would connect to the Access DB table and retrieve the correct information.
- I’d also need to have the form printable & have the ability to search again or return to the front page.

Is this possible???

Thank you in advance

[tlhintoq]

Q: Is this possible???
A: Yes
Clarification: It's your design... your code... your imagination. So just about anything is possible.

[Jesse10]

I guess I should have been more clear. I have zero knowledge of code... If someone could point me in the right direction it would be much appreciated.

[tlhintoq]

I have zero knowledge of code... If someone could point me in the right direction it would be much appreciated.

There are so many great "How do I build my first application" tutorials on the web... There are dozens of "Learn C# in 21 days", "My first C# program" books at your look book seller or even public library... Asking a forum, any forum, to hand-hold you through it is just redundant. In many ways it disrespects the people who have invested dozens of hours in the on-line tutorials and those that spent thousands of hours in authoring books.

Build a Program Now! in Visual C# by Microsoft Press, ISBN 0-7356-2542-5
is a terrific book that has you build a Windows Forms application, a WPF app, a database application, your own web browser.

C# Cookbooks
Are a great place to get good code, broken down by need, written by coding professionals. You can use the code as-is, but take the time to actually study it. These professionals write in a certain style for a reason developed by years of experience and heartache.

Microsoft Visual Studio Tip, 251 ways to improve your productivity, Microsoft press, ISBN 0-7356-2640-5
Has many, many great, real-world tips that I use all the time.

The tutorials below walk through making an application including inheritance, custom events and custom controls.
Building an application Part 1
Building an application part 2

MSDN C# Developers Center with tutorials
Welcome to Visual Studio

Have you seen the MSDN Code Samples? They spent a lot of time creating samples and demos. It seems a shame to not use them.

• Anonymous Delegates: Demonstrates the use of unnamed delegates to reduce application complexity.
• Arrays: Shows how to use arrays.
• Attributes: Shows how to create custom attribute classes, use them in code, and query them through reflection.
• Collection Classes: Shows how to make non-generic collection classes that can be used with the foreach statement.
• COM Interop Part I: Shows how to use C# to interoperate with COM objects.
• COM Interop Part II: Shows how to a use a C# server together with a C++ COM client.
• Commandline: Demonstrates simple command-line processing and array indexing.
• Condiational Methods: Demonstrates conditional methods, which provide a powerful mechanism by which calls to methods can be included or omitted depending on whether a symbol is defined.
• Delegates: Shows how delegates are declared, mapped to static and instance methods, and combined into multicast delegates.
• Events: Shows how to declare, invoke, and configure events in C#.
• Explicit Interface: Demonstrates how to explicitly implement interface members and how to access those members from interface instances.
• Generics: Shows how to make generic collection classes that can be used with the foreach statement.
• Hello World: A Hello World application.
• Indexers Part I: Shows how C# classes can declare indexers to provide array-like access to objects.
• Indexers Part II: Shows how to implement a class that uses indexed properties. Indexed properties enable you to use a class that represents an array-like collection.
• Libraries: Shows how to use compiler options to create a DLL from multiple source files; also, how to use the library in other programs
• Named and Optional (C# 4.0): Demonstrates Named and Optional parameters, an alternative to method overloads
• Nullable: Demonstrates value types, such as double and bool, that can be set to null
• Office Sample (C# 4.0): Demonstrates how Dynamic and COM Interop make it easy to call Microsoft Office in C# 4.0
• OLEDB: Demonstrates how to use a Microsoft Access database from C# by creating a dataset and adding tables to it.
• Operator Overloading: Shows how user-defined classes can overload operators
• Partial Types: Demonstrates how classes and structures can be defined in multiple C# source-code files
• PInvoke: Shows how to call exported DLL functions from C#
• Properties: Shows how properties are declared and used; also demonstrates abstract properties
• Python Sample (C# 4.0): Learn how to call a Python script by using the Dynamic feature in C# 4.0
• Security: Discusses .NET Framework security and shows how to modify security permissions in C# by using permission classes and permission attributes
• Simple Variance (C# 4.0): See how Covariance and Contravariance are supported in generic interfaces and delegates
• Structs: Shows how to use structs in C#.
• Threading: Demonstrates various thread activities such as creating and executing a thread, synchronizing threads, interacting between threads, and using a thread pool
• Unsafe: Shows how to use unmanaged code (code that uses pointers) in C#
• User Conversions: Shows how to define conversions to and from user-defined types
• Versioning: Demonstrates versioning in C# by using the override and new keywords
• XML Documents: Shows how to document code by using XML
• Yield: Demonstrates how to use the yield keyword to filter items in a collection

[Jesse10]

Thank you for the help. Someone in my office said they had a copy of "Visual Basic .NET Codemaster's Library" by Matt Tagliaferri. I'll start there.