Results 1 to 3 of 3
  1. #1
    amber mara is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Location
    sao paulo Brasil
    Posts
    3

    empty field


    How can i manage to avoid save a record if one field is empty or null in Access ? I need to save the record with the price saved....it cannot be saved if the price fields are empty or null. Is there anyone who could give me a hand on this?

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Hi Amber,

    Go to the relevent table in design view. Select the field, and change the "Required" property to "Yes".

    Cheers,

  3. #3
    amber mara is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Location
    sao paulo Brasil
    Posts
    3
    I have a subform based on a query where the table with this 2 numerical fields PC and PV are empty. The values for these fields are in another 2 tables, one for PC other for PV and the table must be completo with the replacement of this 2 fields by the values extrated from the PC and PV tables. I must bring in the prices before user saves the record. As the table in the query has not values in these fields, i cannot change the property to required. My problem is deal with the fact that the record cannot be saved unless the 2 fields PC and PV have values on them. if they dont, record cannot be saved at all without price. I have the fields displayied in the sub form and must make sistem bring the price from the tables putthem in the correct fields that are empty and only if there is prices on them, save the hole table.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Getting Rid of Empty Space
    By Pam Buckner in forum Database Design
    Replies: 5
    Last Post: 03-05-2010, 05:46 PM
  2. Empty Column in Query
    By sesproul in forum Queries
    Replies: 3
    Last Post: 01-18-2010, 06:04 PM
  3. replace a empty field with the word "none" how??
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 01-15-2010, 11:02 AM
  4. Go to first empty record
    By westcoastbmx in forum Forms
    Replies: 2
    Last Post: 10-30-2009, 01:37 PM
  5. Empty Lookup
    By mikel in forum Access
    Replies: 39
    Last Post: 08-07-2009, 01:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums