Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / February 2008

Tip: Looking for answers? Try searching our database.

Create new table from Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carlos1815 - 27 Feb 2008 22:30 GMT
Hello.  I'm new to this group and I have a question:
I created a form to build a quiz by entering the question,
distractors, correct answer and graphic name if one is used, and some
other information needed for the quiz.  Once the user finishes making
the quiz, I would like to have the user press a button on my form so
that information in the form is put into a new table with the same
field names as the ones used in the form.  I don't want the current
db
that is linked to the form to be used as the final product; once the
new table is created and saved with a user-defined name, the form's
db
is then cleared, or refreshed, so the form can be used to make
another
quiz.  I would greatly appreciate an help.  Thanks in advance!
Jeff Boyce - 28 Feb 2008 02:48 GMT
In Access, it all starts with the data.  And to get easy use of Access'
relationally-oriented features/functions, it really helps to understand
normalization.

It sounds like you want it to start with a form.  If the users can enter any
combination of information, what's to keep the data well-normalized?

If you are trying to create a quiz/questionnaire/survey/test, take a look at
Duane H's AtYourSurvey:
   Duane Hookom has a sample survey database at
 http://rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> Hello.  I'm new to this group and I have a question:
> I created a form to build a quiz by entering the question,
[quoted text clipped - 10 lines]
> another
> quiz.  I would greatly appreciate an help.  Thanks in advance!
Carlos1815 - 28 Feb 2008 14:28 GMT
On Feb 27, 9:48 pm, "Jeff Boyce" <JeffBoyce...@msn.com-
DISCARD_HYPHEN_TO_END> wrote:
> In Access, it all starts with the data.  And to get easy use of Access'
> relationally-oriented features/functions, it really helps to understand
[quoted text clipped - 33 lines]
>
> - Show quoted text -

Thank you for the link.  As well as being new to this group, I'm very
new to Access (Authorware programmer for 3 years, never needed Access
before).  I appreciate the help.

Carlos
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.