A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Error when no description is present



 
 
Thread Tools Display Modes
  #1  
Old December 12th, 2006, 09:13 PM posted to microsoft.public.access.forms
Mary Hartman
external usenet poster
 
Posts: 38
Default Error when no description is present


I have developed a mineralogy database in Access 2003.

When the name of the specimen is entered, there are two fields that
fill in automatically from information in two other tables.

One is the mineralogy description. There is a metaphysics
description.

If both of these exist, it works fine. If one or the other does not
exist I get an error that says "can't find mineralogy" or "can't find
metaphysics" for such and such. All don't and will never have both
descriptions.

Is there a way to work around this error so that if the description
doesn't exist Access will enter a null value into the field.

Thank you!
  #2  
Old December 12th, 2006, 09:34 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Error when no description is present

Mary

I can't be sure from your description, but it sounds like you are having
Access enter data redundantly ("fill in automatically ...").

This is a common approach when you only have a spreadsheet to use, but as a
relational database, Access means you DON'T have to double up like this.

I'll guess you have a table with specimen names (else how would Access know
which minerology and/or metaphysics rows to look for?). If those other two
tables have some way of connecting (?specimen name?), then use a query to
display the information, don't re-store it.

Or have I misunderstood what your application is doing?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Mary Hartman" wrote in message
...

I have developed a mineralogy database in Access 2003.

When the name of the specimen is entered, there are two fields that
fill in automatically from information in two other tables.

One is the mineralogy description. There is a metaphysics
description.

If both of these exist, it works fine. If one or the other does not
exist I get an error that says "can't find mineralogy" or "can't find
metaphysics" for such and such. All don't and will never have both
descriptions.

Is there a way to work around this error so that if the description
doesn't exist Access will enter a null value into the field.

Thank you!



  #3  
Old December 12th, 2006, 10:09 PM posted to microsoft.public.access.forms
Mary Hartman
external usenet poster
 
Posts: 38
Default Error when no description is present

Actually, the data descriptions are being filled in on this form
almost for display reasons only. They are NOT being re-saved to a
redundant field in another table.

This is just so that whoever is filling in the data can see whether or
nott there is a description for that field. If there isn't and one is
needed they fill that in on a popup form.



On Tue, 12 Dec 2006 12:34:07 -0800, "Jeff Boyce"
wrote:

Mary

I can't be sure from your description, but it sounds like you are having
Access enter data redundantly ("fill in automatically ...").

This is a common approach when you only have a spreadsheet to use, but as a
relational database, Access means you DON'T have to double up like this.

I'll guess you have a table with specimen names (else how would Access know
which minerology and/or metaphysics rows to look for?). If those other two
tables have some way of connecting (?specimen name?), then use a query to
display the information, don't re-store it.

Or have I misunderstood what your application is doing?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Mary Hartman" wrote in message
.. .

I have developed a mineralogy database in Access 2003.

When the name of the specimen is entered, there are two fields that
fill in automatically from information in two other tables.

One is the mineralogy description. There is a metaphysics
description.

If both of these exist, it works fine. If one or the other does not
exist I get an error that says "can't find mineralogy" or "can't find
metaphysics" for such and such. All don't and will never have both
descriptions.

Is there a way to work around this error so that if the description
doesn't exist Access will enter a null value into the field.

Thank you!



  #4  
Old December 13th, 2006, 01:46 AM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Error when no description is present

Mary

Great! So you'll want to take a look at the .Column() property, which
returns the data that's in the 'other' columns of your query.

To get around the "some are, some aren't" situation, use a query. In your
query, use "directional joins" (my terminology). Highlight the join line,
right-click, and pick all of your main table and ANY of the related table.

This way, you still get the main table values, even if no corresponding
value exists in the "child" table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Mary Hartman" wrote in message
...
Actually, the data descriptions are being filled in on this form
almost for display reasons only. They are NOT being re-saved to a
redundant field in another table.

This is just so that whoever is filling in the data can see whether or
nott there is a description for that field. If there isn't and one is
needed they fill that in on a popup form.



On Tue, 12 Dec 2006 12:34:07 -0800, "Jeff Boyce"
wrote:

Mary

I can't be sure from your description, but it sounds like you are having
Access enter data redundantly ("fill in automatically ...").

This is a common approach when you only have a spreadsheet to use, but as
a
relational database, Access means you DON'T have to double up like this.

I'll guess you have a table with specimen names (else how would Access
know
which minerology and/or metaphysics rows to look for?). If those other
two
tables have some way of connecting (?specimen name?), then use a query to
display the information, don't re-store it.

Or have I misunderstood what your application is doing?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Mary Hartman" wrote in message
. ..

I have developed a mineralogy database in Access 2003.

When the name of the specimen is entered, there are two fields that
fill in automatically from information in two other tables.

One is the mineralogy description. There is a metaphysics
description.

If both of these exist, it works fine. If one or the other does not
exist I get an error that says "can't find mineralogy" or "can't find
metaphysics" for such and such. All don't and will never have both
descriptions.

Is there a way to work around this error so that if the description
doesn't exist Access will enter a null value into the field.

Thank you!





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.