Solved

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

Posted on 2003-12-05
1
156 Views
Last Modified: 2013-12-24
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
Comment
Question by:jezmondo
1 Comment
 
LVL 3

Accepted Solution

by:
wcameron earned 125 total points
ID: 9936496
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Ping and Performance monitoring an internal URL website 4 118
This webpage has a redirect loop 4 66
Search on a site 5 137
SPLUNK REST  API call to Splunk to create and index? 2 161
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question