|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 26th, 2009, 08:26 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Set Default Value to User Function in Table Design
I have 2 functions that find the user name and machine name. I want to set
these functions as the default value for the respective fields in the Table design but it won't let me. However I can set them in a Form with the respective fields on the form. Is this normal? 
|
|
#2
August 26th, 2009, 09:23 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Set Default Value to User Function in Table Design
On Wed, 26 Aug 2009 12:26:02 -0700, Chertsey
wrote: I have 2 functions that find the user name and machine name. I want to set these functions as the default value for the respective fields in the Table design but it won't let me. However I can set them in a Form with the respective fields on the form. Is this normal? Yes. You cannot use user-defined functions in table defaults or in table validation; you can on a form. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
