Solved

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

Posted on 2003-12-05
1
152 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now