• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

Can I omit Default values in Database Results Wizard when updating Access db

I have a site that updates a MS Access database and have an issue with FP's DRW requiring the insertion of Default values. For date fields, the requirement to insert a default date is screwing up other queries in the database.

Is there a way of omitting these defaults and leaving the fields blank?

Thanks in advance

Jez
0
jezmondo
Asked:
jezmondo
1 Solution
 
wcameronCommented:
The Update statement requires default values. There is no way aournd this. The secret is to do one of two things:

1. Design your form to always include a default value OR
2. Design you queries to deal with the challenge of a default.

Here is an example. In a form that you need to add a default to (assume it a text field), you are forced to add something, so add the word "none". The goal is to allow your query to display the null value. Yet you cannot enter a null value. So create a query that tells it to take values="none" as a blank value.

In your query, use an iif statement like the following:

FieldName: iif([Field]="none","",[Field]

This will create a new field called FieldName (call it whatever you want) that will display the field value if it does NOT equal the word none, otherwise it will display a blank value.

I use this on many forms to deal with this challenge.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now