Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 7th, 2007, 06:02 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
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...
Reply With Quote
  #2 (permalink)  
Old February 7th, 2007, 12:20 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
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
Reply With Quote
  #3 (permalink)  
Old February 12th, 2007, 01:22 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
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...
Reply With Quote
  #4 (permalink)  
Old February 12th, 2007, 08:45 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 08:53 PM.


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