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 / General 2 / July 2007

Tip: Looking for answers? Try searching our database.

From a check to text

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Merey - 30 Jul 2007 00:32 GMT
I currently have a printed form that has all of the possible requirements
typed on it. The person filling out the form will circle which of the
possible requirements are needed for this particular being issued.  I want to
have the possible requirements be check fields on the database form so that
when the permit is issued via mail merge only the specific requirements for
this permit appear.  Any ideas on how I can accomplish this with Access?
John W. Vinson - 30 Jul 2007 01:33 GMT
>I currently have a printed form that has all of the possible requirements
>typed on it. The person filling out the form will circle which of the
>possible requirements are needed for this particular being issued.  I want to
>have the possible requirements be check fields on the database form so that
>when the permit is issued via mail merge only the specific requirements for
>this permit appear.  Any ideas on how I can accomplish this with Access?

Printed forms are *TERRIBLE* models for table design. The logical structure of
your tables should follow the logical structure of the data. It sounds like a
typical many-to-many relationship: each "particular" (you don't say what
real-life Entity this printed form represents) has zero, one or more
Requirements, and each Requirement applies to zero, one or more "particulars".
The normalized table structure for this would have three tables:

Particulars
 ParticularID <Primary Key>
 <fields describing the particular entity>

Requirements
 RequirementID <Primary Key>
 Description
 <other info about this requirement, if any>

PermitRequirements
 ParticularID
 RequirementID

That said... you can create a user interface which looks like the paper form,
with unbound checkbox controls and fields for the Particular data; you'll need
a little VBA code to loop through all the checkbox controls and add a record
to PermitRequirements for each one that is checked.

Then the mail merge will become very easy - you can simply base it on a query
joining all three tables, picking up the particulars of the Particular from
Particulars, and the description of the requirement from Requirements, using
PermitRequirements as the link between the two.

            John W. Vinson [MVP]
 
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.