A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to not view record in Access after complete?



 
 
Thread Tools Display Modes
  #1  
Old December 15th, 2005, 05:26 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default How to not view record in Access after complete?

I hope someone can help me please!
I want to stop a record from being viewed once I mark an action "complete".
In the form, many actions can be selected for a record but once the user
marks it complete I dont want it to be accessed again.

Thank you
  #2  
Old December 15th, 2005, 05:38 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default How to not view record in Access after complete?

In the query (upon which your form is based) add some criteria to exclude
those records.

Under the "completed" field put criteria like...

Not True

--
Rick B



"mandm" wrote in message
...
I hope someone can help me please!
I want to stop a record from being viewed once I mark an action
"complete".
In the form, many actions can be selected for a record but once the user
marks it complete I dont want it to be accessed again.

Thank you



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Mail Merge to Word.doc files ? RNUSZ@OKDPS Setting Up & Running Reports 1 May 18th, 2005 06:31 PM
Access 2000 -vs- Access 2003? Mark General Discussion 5 November 30th, 2004 06:36 AM
Images in a database Franz General Discussion 10 October 7th, 2004 09:35 AM
Upload Image Jason MacKenzie General Discussion 1 September 1st, 2004 04:38 AM


All times are GMT +1. The time now is 06:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.