There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
audio avg avg 8 backup bios boot browser bsod computer cpu crash css desktop driver drivers dvd email error excel explorer firefox firefox 3 freeze game graphics hard drive hardware help please hijackthis hjt install internet internet explorer itunes javascript keyboard lan laptop malware missing monitor msn network networking openoffice outlook outlook 2003 outlook express php popups problem router screen seo slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp wireless word
Archive: Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications > Archive: Business Applications >
{SOLVED} Access 97: Purpose of Forms?


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
jrh's Avatar
jrh jrh is offline
Junior Member with 10 posts.
 
Join Date: May 2001
04-May-2001, 07: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
Senior Member with 412 posts.
 
Join Date: May 2000
Location: Three Rivers, MI
04-May-2001, 08: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
Senior Member with 310 posts.
 
Join Date: Dec 2000
Location: Charlotte, NC USA
04-May-2001, 08: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.
 
Join Date: May 2001
04-May-2001, 09: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
Senior Member with 412 posts.
 
Join Date: May 2000
Location: Three Rivers, MI
04-May-2001, 09: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.
 
Join Date: May 2001
04-May-2001, 05: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
Administrator with 11,442 posts.
 
Join Date: Feb 1999
Location: Allentown, PA
Experience: Microsoft Word MVP
05-May-2001, 02: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!
Reply


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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 07:31 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.