Molehill into Mt. Everest

[Kris]

I've got a database project I've been working on and I've got a couple
of questions -- It's a one-to-one situation with project info and it's
respective financial information (monthly).

1st - I didn't see any way or reason to break it into multiple tables
-- should I have done this? The table has LOTS O' FIELDS.

2nd - When adding new information for a new project, I've got it set up
as a separate pop-up form. The problem is, when you add the new
information, the main form (based on a query)is not updated with the
new information. You've got to close and reopen the main form.

I'd appreciate any advice/help --

[Bas Cost Budde]

> I've got a database project I've been working on and I've got a couple

of questions -- It's a one-to-one situation with project info and it's
respective financial information (monthly).

1st - I didn't see any way or reason to break it into multiple tables
-- should I have done this? The table has LOTS O' FIELDS.
Find reading material on the topic 'normalisation'.
2nd - When adding new information for a new project, I've got it set up
as a separate pop-up form. The problem is, when you add the new
information, the main form (based on a query)is not updated with the
new information. You've got to close and reopen the main form.

Well, *you* have created your problem. :-) How does the separate form
differ from your main form? Maybe you can find some way to use that for
both purposes. But then again, it may be too complicated to be
efficient, if you use the same form for browsing, for editing and for
adding. I can see that.

When the popup form closes, the Close event fires. That is a nice place
to requery the main form:

forms!yourmainformname.requery
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
For human replies, replace the queue with a tea

[Kris Pilarski]

Thanks for the tip -- that worked like a charm! I'm going to do some
studying up on normalization --

*** Sent via Developersdex http://www.developersdex.com ***

[Kris Pilarski]

OK, I've got one more question -- I got the record to show up using
your suggestion (thanks!), but now I need to have all fields show a
default value of zero as soon as the new record is created.... I've
tried all I can think of and can't get it going.

I'm visual basically challenged... :-)

Kris P.
*** Sent via Developersdex http://www.developersdex.com ***

[Tom van Stiphout]

On Fri, 08 Jul 2005 14:16:01 GMT, Kris Pilarski
<kp*******@ewingcole.com> wrote:

If 0 is an appropriate default for those fields, set that default
value in the table design.

-Tom.

OK, I've got one more question -- I got the record to show up using
your suggestion (thanks!), but now I need to have all fields show a
default value of zero as soon as the new record is created.... I've
tried all I can think of and can't get it going.

I'm visual basically challenged... :-)

Kris P.
*** Sent via Developersdex http://www.developersdex.com ***

[Kris Pilarski]

I've got the default value set to 0 in the table AND on each field and
still nothing. The form is based on a query (based on that table) and
even when I run the query the fields do not get populated with default
0.00.

Kris P.
*** Sent via Developersdex http://www.developersdex.com ***

[Anne Nolan]

A default value will not affect already-existing records, only new records
at the moment of creation. And, you should only need the default value set
for the table itself. (Your mention of "running a query" implies to me that
you are seeing previously-created records.)

If you are creating a new record with these defaults set, and it's not
filling in your default values, something else is up.

If you just need to go back and "fix" previously-created records, run an
update query to set NULL fields to your desired default value. (You'll
probably need an update query for each field, but it's a one-time thing.)

Anne

"Kris Pilarski" <kp*******@ewingcole.com> wrote in message
news:Kz***************@news.uswest.net...

I've got the default value set to 0 in the table AND on each field and
still nothing. The form is based on a query (based on that table) and
even when I run the query the fields do not get populated with default
0.00.

Kris P.
*** Sent via Developersdex http://www.developersdex.com ***