Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Archive: Business Applications Archive: Business Applications
Search Search
Search for:
Tech Support Guy > > > >

{SOLVED} Access 97: Purpose of Forms?


(!)

jrh's Avatar
jrh jrh is offline
Junior Member with 10 posts.
THREAD STARTER
 
Join Date: May 2001
04-May-2001, 06:24 AM #1
I am trying to figure out what the purpose of the forms tab is and whether or not I truly need it for my database. What is the concensus or professional opinion out there?

Is the forms tab just another fancy way to show your tables?

This leads me to another question...does everyone generate reports that are basically mirror images of their tables? In other words, where you select a table and all the fields so that you have a 'fancy' print out.

Talismanic's Avatar
Talismanic Talismanic is offline
Member with 409 posts.
 
Join Date: May 2000
Location: Three Rivers, MI
04-May-2001, 07:25 AM #2
While forms are a fancy way to show the table, they are also a way for you to control what type of information is entered into the table, how the information is entered and forms give you the ability to maniplulate the information being entered with code. It will also alow you to protect the data that is stored in the tables from the user. You, as the developer have total control and the user gets an easy to use interface that will help them along the way.

In a nutshell the forms purpose it to make sure the data that gets entered into a table is accurate and protected.

I am no professional but I would never recomend giving users direct access to the data in your tables. By the way, you are not limited to using the forms supplied by Access. If you skilled in Visual Basic or HTML you can use either as a front end to your tables.
nczman's Avatar
nczman nczman is offline
Member with 310 posts.
 
Join Date: Dec 2000
Location: Charlotte, NC USA
04-May-2001, 07:38 AM #3
I'll get the last question
No. Very few of my reports are showing what is in the tables. Most of mine use queries and VB code to do things such as counts, sums, averages. We also use the report to look at how much time we spend on the support hotline, how many surveys that we get back and what their ratings are, and such to calculate what our bonus will be.

We also export the data into excel spreadsheets for graphs of what type of calls are coming in.
jrh's Avatar
jrh jrh is offline
Junior Member with 10 posts.
THREAD STARTER
 
Join Date: May 2001
04-May-2001, 08:29 AM #4
Thanks for the info and quick reply.

Another question, does each form created have to have all the fields from a specified table? My thought is no but I want to be sure.

Talismanic's Avatar
Talismanic Talismanic is offline
Member with 409 posts.
 
Join Date: May 2000
Location: Three Rivers, MI
04-May-2001, 08:58 AM #5
It is not required but I think it is good practice not to have optional fields in a table. At least at the form level. I could understand if a field would be left blank on a form and remain blank in the table but why have a field in the table that could be left off the form. You may as well eliminate the field all together.

Another thing you may consider is using a different table for the optional data/fields then you could create a relationship between the two tables and call the second table to the form when you need it and hide it when you don't.
jrh's Avatar
jrh jrh is offline
Junior Member with 10 posts.
THREAD STARTER
 
Join Date: May 2001
04-May-2001, 04:27 PM #6
Thanks Talismanic!

I did create some forms and my original thinking was that the "not required" fields were not necessary in the form. However, after reading your response, I like your idea better. I think it is a good idea to have a secondary table that links to the primary table -- thanks for the tip!

BTW...I can't say that I am a well versed VB person. The only code I know well is C, but I have also learned a great deal about html in the last nine months working on web designs.

Love this site...everyone is so quick w/ their responses and good info too!

Anne Troy's Avatar
Computer Specs
Member with 11,731 posts.
 
Join Date: Feb 1999
Location: Allentown, PA
Experience: Intermediate
05-May-2001, 01:20 PM #7
I never include the autonumber field on my forms.

Just my two cents while I'm in here marking this one solved!
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2