A
Alfred
Hi,
I've written the question already here, but I'm not sure,
if everybody checks questions within the answerhierarchy.
I have on 60 fields flat table, already populated with
loads of data, and I have to add additional fields, but
they have been too many for a single table (>200).
I know, it is bad db design, but I have to deal with the
circumstances.
What I did now is, that I made a second table, an one to
one relationship and the record source is a query over
table1.*, table2.* .
That leads me to another problem:
When I edit the form, changing to design view, the I get
the following error:
The expression On Load you entered asthe event property
settings produced the following error:
The object doesn't contain the Automation
Object 'Table2.'.
*The expression may not result in the name of a macro,
the name of a user defined function, or [Event Procedure].
*There may have been an error evaluation the function,
event, or macro.
How can I switch that off - by clicking it away it seem
everything allright... (but is is annoying)
Next question:
I think I can simply add my new table to an existing
table with all the data in, by connecting both primary
keys. Is that correct? (hope so!)
Thanks a lot in advance,
Cheers
Alfred
I've written the question already here, but I'm not sure,
if everybody checks questions within the answerhierarchy.
I have on 60 fields flat table, already populated with
loads of data, and I have to add additional fields, but
they have been too many for a single table (>200).
I know, it is bad db design, but I have to deal with the
circumstances.
What I did now is, that I made a second table, an one to
one relationship and the record source is a query over
table1.*, table2.* .
That leads me to another problem:
When I edit the form, changing to design view, the I get
the following error:
The expression On Load you entered asthe event property
settings produced the following error:
The object doesn't contain the Automation
Object 'Table2.'.
*The expression may not result in the name of a macro,
the name of a user defined function, or [Event Procedure].
*There may have been an error evaluation the function,
event, or macro.
How can I switch that off - by clicking it away it seem
everything allright... (but is is annoying)
Next question:
I think I can simply add my new table to an existing
table with all the data in, by connecting both primary
keys. Is that correct? (hope so!)
Thanks a lot in advance,
Cheers
Alfred