KIS please!!

[Chease]

Hey ladies and gents,

I am currently doing a practicum project for a company and their database. In the Access 2007 database we need to create many forms that allows the user to create, update, delete information.

Myself and my group members have spent countless hours trying to make it work but we are running into errors everywhere.

Is there a simple access file that shows how to create forms using VB and no wizards available for download?

Everywhere I look I just get tutorials on how to use a wizard to create the form.

We are all new to VB so the more simple the example the better.

Thanks in advance!

 

[CEH]

This sounds like a little of "putting the cart before the horse" Seeing how the wizard creates a form from a table or query can help you to understand how to create one from scratch. You don't have to have an extensive knowledge of "VB" or "VBA" in the case of Access to create a database. Why do you NOT want to let the wizardcreate these forms?

 

[HiTechCoach]

Welcome to AWF!

I am currently doing a practicum project for a company and their database. In the Access 2007 database we need to create many forms that allows the user to create, update, delete information.

In Access it is common to use a single form to create, update, delete information in a single table.

So you will generally have one form per table. Some of the forms may be used as sub forms.

Myself and my group members have spent countless hours trying to make it work but we are running into errors everywhere.

What errors?

If you will explain what issue you are having, then maybe we can point you in the right direction.

Is there a simple access file that shows how to create forms using VB and no wizards available for download?

What do you mean by create forms using VB and no wizards?

Does this mean you are wanting to write your own code (in Access/VBA or a VB project) to that will generate form similar to the way the wizards work?

In Access you can manually create a form that can be used to "create, update, delete information" in a table without having to using any VBA code. I do believe this ability to create a bound form is one of of the major strengths of Access.

Everywhere I look I just get tutorials on how to use a wizard to create the form.

That is because using a wizard is a great way to get a form started. Kind of like a template to get your started quicker. You can modify to form created by the wizard to meet your needs.

We are all new to VB so the more simple the example the better.

Note: Access uses VBA internally. It is a version of VB specific to Access. VB (Visual Basic) is a separate application.

With 2007, you can do a lot without any VBA code.


Also see this tutorial:

Access Basics

Hope this helps ...

 

[missinglinq]

To be honest, this is a little confusing to me! A practicum, by definition, is a course designed to give students a supervised practical application of a subject that has previously been studied and mastered in the classroom, yet the original post here suggests that no one involved has any knowledge whatsoever of Access, as if they were literally starting from scratch!

I would suggest looking at the Northwind database that ships with all versions of Access, but to be honest, I doubt that this would be of much help to people who do not even know how to manually create a form.