Help - Can't create a from from 2 Dbs

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

I have created this type of form before without any
problem buy this time it is not working correctly. The
fields will only show up in the header and not in the
detail section of the form.

To begin with, I am using two tables within the same
database. But one table (contains co names & addresses
etc) was created by someone else. It has an autonumber
field "s_GUID" that I know nothing about except that it is
not a field we enter information into. The 2nd table is
for recording Tele calls received by sales. I am trying
to link the two tables so that when you open a telecall
form and type in the telephone number of who is calling,
it will bring up the co name, address etc. Then there is
an area for recording what the call was about. These
fields are from the 2nd Table.

I linked the two tables via the tele # field. Both are
configured the same. But the form will only open up if
the fields are in the header and not in the detail portion
of the form.

Does anyone have any ideas as to how to correct this???????

I am frantic, because my boss gave this assignment on
Friday afternoon and wants it completed before noon on
Monday.
 
Aurora said:
I am using Access 2000

I have created this type of form before without any
problem buy this time it is not working correctly. The
fields will only show up in the header and not in the
detail section of the form.

To begin with, I am using two tables within the same
database. But one table (contains co names & addresses
etc) was created by someone else. It has an autonumber
field "s_GUID" that I know nothing about except that it is
not a field we enter information into. The 2nd table is
for recording Tele calls received by sales. I am trying
to link the two tables so that when you open a telecall
form and type in the telephone number of who is calling,
it will bring up the co name, address etc. Then there is
an area for recording what the call was about. These
fields are from the 2nd Table.

I linked the two tables via the tele # field. Both are
configured the same. But the form will only open up if
the fields are in the header and not in the detail portion
of the form.

Does anyone have any ideas as to how to correct this???????

I am frantic, because my boss gave this assignment on
Friday afternoon and wants it completed before noon on
Monday.
Click to expand...

Is the "s_GUID" field the primary key of the table containing it? If
so, make sure you include that field in the form's recordsource query.
If you don't, the query will probably not be updatable, and therefore
the detail section of an empty form based on that query will be blank.
See the help topic, "When can I update data from a query?".
 
Thank you for replying for my cry for help.
s_GUID is not marked as a primary key, but if I try to
delete it I get this message --> s_GUID is a replication
system field. You can not delete it.

This field is included in my query. But the form will
only show me records I enter through the Datasheet design -
but will not allow me to add new records.

Does that help you at all?

Aurora
 
Aurora said:
Thank you for replying for my cry for help.
s_GUID is not marked as a primary key, but if I try to
delete it I get this message --> s_GUID is a replication
system field. You can not delete it.
Click to expand...

Ah, that makes sense. I don't know much about replication, never having
used it myself, but I assume this is one of the Access-added fields used
to manage replication.
This field is included in my query. But the form will
only show me records I enter through the Datasheet design -
but will not allow me to add new records.
Click to expand...

When you say "records I enter through the Datasheet design", do you mean
records you enter in datasheet view of the *table*, or of the form's
*recordsource query*, or of the form itself?

First make sure that the form's Allow Additions property (on the Data
tab of the form's property sheet) is set to Yes. This is probably not
the problem, but you may as well make sure.

Assuming that's not the problem, please post the SQL of the form's
recordsource query, and the names of the primary key fields of the
tables involved in it.
 
Thank you for replying again.

I was able to talk my boss into doing this form in a
different way. So I am OK as of now. One day I am going
to have to learn about "replication" also. The one thing
I like about Access is that there is always more than one
way to accomplish what you want.

Again - THANK YOU for your help

Aurora
 
Aurora said:
Thank you for replying again.

I was able to talk my boss into doing this form in a
different way. So I am OK as of now. One day I am going
to have to learn about "replication" also. The one thing
I like about Access is that there is always more than one
way to accomplish what you want.

Again - THANK YOU for your help
Click to expand...

I'll just have to live with not knowing, I guess. <g> I'll get over
it. Glad to help, for what it was worth.
 
Back
Top