| | |
Changing a default value on the fly
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Feb 2007
Posts: 1
Reputation:
Solved Threads: 0
I need to create an environment that allows a data-entry person to change the default date for records on the fly.
i.e. she's entering row upon row of historical data, and the date changes. I don't want her to have to manually enter the date for each record but I don't want her to have to go the design view of the destination table everytime the date on the paper-records changes.
Any thoughts?
i.e. she's entering row upon row of historical data, and the date changes. I don't want her to have to manually enter the date for each record but I don't want her to have to go the design view of the destination table everytime the date on the paper-records changes.
Any thoughts?
•
•
Join Date: Mar 2005
Posts: 65
Reputation:
Solved Threads: 0
You could use a variable. Put a form level variable that is set to the current date on form load and assigns the variable date to the field. Then on the field on the BeforeUpdate assign the date that is entered from the field to the form level date. In the OnCurrent event set the field to the form level variable.
There may be easier ways, but I just through that together.
Chester
There may be easier ways, but I just through that together.
Chester
![]() |
Similar Threads
- "Forbidden / You don't have permission to access / on this server." error (Linux Servers and Apache)
- Changing default save as field in IE 6 ... (Windows NT / 2000 / XP)
- Firefox default (Don't want Epiphany) (*nix Software)
- Changing the default "submit" button. (HTML and CSS)
- I can't view thumbnails with WIN2000 (Windows NT / 2000 / XP)
- changing default browser (Web Browsers)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: .Net Application Development Using Database
- Next Thread: [Stupidity] I Forgot My Ms. Access Database Password. Help..
Views: 2809 | Replies: 1
| Thread Tools | Search this Thread |
Tag cloud for MS Access and FileMaker Pro





