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 / Queries / February 2008

Tip: Looking for answers? Try searching our database.

yes/no field in query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Song Su - 05 Feb 2008 22:25 GMT
Access 2003

I want to print label based on select query. The query pull out, for
example, 10 records. I want to use a form for user to check which of these
10 records to print label. My table does not have Yes/No field and I cannot
change design of the table. What are my options for this?  Thanks.
fredg - 05 Feb 2008 22:50 GMT
> Access 2003
>
> I want to print label based on select query. The query pull out, for
> example, 10 records. I want to use a form for user to check which of these
> 10 records to print label. My table does not have Yes/No field and I cannot
> change design of the table. What are my options for this?  Thanks.

Why can't you change the table design? That's what you should do.

The way to do this is to add a Yes/No check box field to the
underlying table.

Then add this check box field to your form.

Code the Form's  command button Click event:
DoCmd.OpenReport "LabelReport", acViewPreview

Open the query in Design View. Add the Check box field to the query.
As criteria on the check box field, write:
-1

When you open the form, place a check in whatever records you wish to
print a label for. Click the command button.
Clear all of the check boxes when done.
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Song Su - 06 Feb 2008 02:14 GMT
Thanks for your reply. I'm only allowed to develop front end, linked to
backend at server and I'm not allowed to modify the table structure. IT said
'NO'. Any other options?

>> Access 2003
>>
[quoted text clipped - 22 lines]
> print a label for. Click the command button.
> Clear all of the check boxes when done.
John Spencer - 06 Feb 2008 12:44 GMT
Add a new table to the Access FRONT END.
Table: tblMatches
Field:
 fldPK: Autonumber
 fldKeyValue:  field type is dependent of the key field value
 fldPrintThis: Yes/No

In a query, join this table (LEFT JOIN) to your main table
SELECT MainTable.PrimaryKey, tblMatches.fldPrintThis
FROM MainTable LEFT JOIN tblMatches
ON MainTable.PrimaryKey = tblMatches.fldKeyValue

Add any other fields to the SELECT clause that you need to display for the
user to make the selection.

You can base your report on an INNER JOIN of the MainTable and tblMatches
where fldKeyValue is checked.

You can add code that will check all fields or uncheck all fields using
update queries (or a delete query if you want to delete all the records in
tblMatches.  This process does have the disadvantage of causing your
database to grow over time, but you can periodically compact the database or
you can use a temporary database to hold the table.

See Tony Toews website
http://www.granite.ab.ca/access/temptables.htm
for an example of temporary database/tables
Signature

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Thanks for your reply. I'm only allowed to develop front end, linked to
> backend at server and I'm not allowed to modify the table structure. IT
[quoted text clipped - 26 lines]
>> print a label for. Click the command button.
>> Clear all of the check boxes when done.
Song Su - 06 Feb 2008 13:41 GMT
Thank you. I'll try that.

> Add a new table to the Access FRONT END.
> Table: tblMatches
[quoted text clipped - 53 lines]
>>> print a label for. Click the command button.
>>> Clear all of the check boxes when done.
 
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.