Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 7th, 2007, 06:02 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default automate the fields

Hi all,

  In my Dabase i want to give some advance option to get the work more automate ..:) .

 Now iam running an database for Fund tracking in the I would have to enter the total fund amount and the fund amount will distributed by more the two installment..

 For eg.

Fund Table :
Date
07/01/2006
21/01/2006
08/01/2006

Fund Number
F101
F102
F255

Fund Name
Maintenance
Party Expenses
Maintenance

Amount Allotted
$.1058
$.2000
$.1058

Completed

Yes / No
- do -
- do-


Entry Table Fields:

Date of Entry , Issued to ,Fund Name ,Amount Issued


I want to get the result like ..

 The Fund F101 may get completed by the 1st month or by 3rd month but i ill get the maintanance fund every month. Now wat i want is every time the fund is going to finish the complete field should automatically change to Yes .. If the field changes to Yes then the field should Locked ...

 Did u understand because the end user are not much computer knowledged...

 Please help me.. if ur not able to understand .. reply ...

thanks in advance ...
anukagni

Learn as you can..
------------------------
pap...
 
Old February 7th, 2007, 12:20 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You should be able to set a condition somewhere to change the value of the Completed field to Yes under conditions you specify. When would you run this process? Is it determined by date, or some other action?

As to locking the records, on the On Current event of a form, you can set the condition that if Completed = True then Allow Edits = False.

You can also prevent users from viewing completed records in your data entry form by filtering for Completed = False, and then have another form for viewing completed records, or use reports instead.

HTH

mmcdonal
 
Old February 12th, 2007, 01:22 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

Please explain me in details.....



Learn as you can..
------------------------
pap...
 
Old February 12th, 2007, 08:45 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

When would you run this process? Is it determined by date, or some other action?


On Current event of form:

If Me.Completed = True Then
    Me.AllowEdits = False
Else
    Me.AllowEdits = True
End If





mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Automate Records Update phungleon SQL Server 2000 3 February 28th, 2005 05:21 PM
How to automate import with notepad timoma Access 20 February 11th, 2005 03:03 PM
Using Forum fields select fields on the fly hellosureshkumar Crystal Reports 0 December 17th, 2004 08:20 AM
Automate Queries Ben Access VBA 3 January 29th, 2004 08:50 AM
Automate Export roniestein Access 13 October 16th, 2003 04:05 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.