PC Review


Reply
Thread Tools Rate Thread

Access 2003 -- getting a macro to set a field value to the default

 
 
AccessBob98101
Guest
Posts: n/a
 
      14th May 2009
I have a database that tracks items being exchanged a quarterly basis. Within
this info are some fields I use on a temporary basis to remind me when a
person needs to be cancelled form receiving the item the next quarter.

There are six fields, three yes/no, one date and two text. I have been able
to rest the yes/no value to a default of No.

But I get an error message saying I can't reset the value of the other
fields to a default of " " (zero length or blank field) because the object or
control doesn't allow for such automation.

The expression builder lets me put in changing the value but the eroor
message doesn't after I run it.

Hope this isn't too confusing. I would appreciate any help in this. I can't
seem to find the specific subject with the MS help search pages.

Thank you.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 -- getting a macro to set a field value to the default AccessBob98101 Microsoft Access Macros 8 19th May 2009 04:05 PM
set default value in field of form in Access 2003 New to this Microsoft Access Form Coding 4 13th Jan 2009 12:38 AM
Create field default using the ID field in Access 2007 JimG Microsoft Access Database Table Design 0 13th Jul 2008 05:34 PM
Default value of one field in access to contents of another field =?Utf-8?B?YmFkZW4gcGVucm9zZQ==?= Microsoft Access Database Table Design 8 11th Jul 2005 06:04 PM
Conditional macro to set default value of field in a form Lyn Microsoft Access Macros 3 30th Jun 2004 06:38 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:39 PM.