Solved

Getting value from a blank field of a database

Posted on 2002-06-09
3
119 Views
Last Modified: 2010-05-02
my task is to get a value from several table let say table A, table B, table C and table D to a single table name table E.the problem that im facing now is that from these seperate table i need specific field from each of them and insert it into table E.i cant insert a blank/null value (field) from table A,B,C,D to a field in table E.the field that need in table E,must be fill up and cant be left blank/null or else error will occur.

e.g.:
Set rs1 = adoconn.Execute("SELECT PrinOut FROM Provision WHERE MasterAcNo in (SELECT MasterAcNo FROM account_Holder WHERE CustNo = '" & Trim(rs!CustNo) & "')")
rs1!PrinOut = Null

error prompt out:
the table cannot be zero-length.
due to this program is a data checking program, i cant make modification on the table on the field cos' all the fields in the table E is compulsory.

wat is the method or way that can help me solve this problem?
0
Comment
Question by:wpkay
3 Comments
 
LVL 50

Accepted Solution

by:
Ryan Chong earned 50 total points
ID: 7066296
then to ensure all the fields in Table E filled in, you must make sure all fields that fill in to Table E (fields from either Table A, B, C or D) are compulsory too (Set their Allow Zero Length and Required Property to True)

In addition, you can also check to ensure all the data insert into Table E is not empty/null. > Do a Select Statement to check whether fields are empty/null.

Cheers
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7873467
Hi wpkay,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept ryancys's comment(s) as an answer.

wpkay, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
0
 

Expert Comment

by:SpideyMod
ID: 7924938
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

831 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