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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cannot add record with acFormAdd
Hi I have a form called frmRelations" I need to add some relations to my
database. At my Switchboard I have a item which calls DoCmd.OpenForm "frmRelations", acNormal, , , acFormAdd I've this same form (differnent Access databases)connected to 2 different workspaces of the same Oracle database via linked tables. In 1 tablespace I get the correct form without entries so I can enter a new Relation. In de other workspace I get every time if I try it the first record of my table. Every thing is the same becase the latter is a copy of the first 1. Any help please. Regards -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Cannot add record with acFormAdd
Are you getting an error? Do you have a primary key defined on the table in
Oracle? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "janiotjoeawie via AccessMonster.com" u7669@uwe wrote in message news:6a68d182176a9@uwe... Hi I have a form called frmRelations" I need to add some relations to my database. At my Switchboard I have a item which calls DoCmd.OpenForm "frmRelations", acNormal, , , acFormAdd I've this same form (differnent Access databases)connected to 2 different workspaces of the same Oracle database via linked tables. In 1 tablespace I get the correct form without entries so I can enter a new Relation. In de other workspace I get every time if I try it the first record of my table. Every thing is the same becase the latter is a copy of the first 1. Any help please. Regards -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Cannot add record with acFormAdd
Hi,
I do not get an error. On the first table space it gives me my form just ready to enter a new relation (as wanted) on the other table space it gives me the first record of the table. The tables do have an index. Douglas J. Steele wrote: Are you getting an error? Do you have a primary key defined on the table in Oracle? Hi I have a form called frmRelations" I need to add some relations to my database. At my Switchboard I have a item which calls DoCmd.OpenForm [quoted text clipped - 8 lines] Regards -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|