?
Solved

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

Posted on 2003-12-05
1
Medium Priority
?
158 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
wcameron earned 500 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

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…
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. 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 :…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
Suggested Courses

752 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