Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…
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…

867 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

22 Experts available now in Live!

Get 1:1 Help Now