Error deleting records in sub-sub-forms

  • Thread starter Thread starter Leif Andersson
  • Start date Start date
L

Leif Andersson

Microsoft Access 2007 wil not delete a record in a sub-sub-form.
I am sure that this is a bug in Access 2007.
I have tried to isolate the problem by creating a new database with to
simple related tables. And no code.
Does anyone know a hotfix?
 
Hi Leif,

if you are in the code behind the main form, try this:

with me.subform_controlname.form.subsubform_controlname
.form.Recordset.Delete
.requery
end with

WHERE
subform_controlname is the Namep prperty of the subform control
subsubform_controlname is the Namep prperty of the sub-subform control

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
I know that there are several options to solve the problem - for instance by
using code or to make the sub-subform to a parellel linked subform.
But I want the simple solution, which is suppose work.
 
FormC (based on tableC) is inserted i formB (based on tableB) is inserted i
formA.
The field [idb<] in tableC is joined to the key field [idb] in tableB.
FormC is linked to formB by Link Master fields = [idb] and Link Child
Fields = [idb<]
For Both formB and FormC Default View = Datasheet.
Then it is not possible to delete a record i sub-subfomC.
 
Hi Leif,

thank you for explaining how your tables are related. When you try to
delete a record in form C, how are you doing it?

is FormC form property AllowDeletions set to True?

is the RecordSource for FormC ONLY table C?

in the defined relationships for your database, is there a relationship
between tableB and tableC? If so, which table holds the 'parent' field?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
FormC (based on tableC) is inserted i formB (based on tableB) is inserted i
formA.
The field [idb<] in tableC is joined to the key field [idb] in tableB.
FormC is linked to formB by Link Master fields = [idb] and Link Child
Fields = [idb<]
For Both formB and FormC Default View = Datasheet.
Then it is not possible to delete a record i sub-subfomC.


strive4peace said:
Hi Leif,

please post the "simple" solution that does not work that you are using

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
Click to expand...
Click to expand...
 
As I mentioned in the start - it is a bug in Access 2007:
Because, when I run the Access-file with tables, that I have just described,
in Access 2003 there are no problems!
But how can I contact Microsoft to make them solve the problem - whithout
having to pay a lot of money contacting their support?

strive4peace said:
Hi Leif,

thank you for explaining how your tables are related. When you try to
delete a record in form C, how are you doing it?

is FormC form property AllowDeletions set to True?

is the RecordSource for FormC ONLY table C?

in the defined relationships for your database, is there a relationship
between tableB and tableC? If so, which table holds the 'parent' field?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
FormC (based on tableC) is inserted i formB (based on tableB) is inserted i
formA.
The field [idb<] in tableC is joined to the key field [idb] in tableB.
FormC is linked to formB by Link Master fields = [idb] and Link Child
Fields = [idb<]
For Both formB and FormC Default View = Datasheet.
Then it is not possible to delete a record i sub-subfomC.


strive4peace said:
Hi Leif,

please post the "simple" solution that does not work that you are using

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
I know that there are several options to solve the problem - for instance by
using code or to make the sub-subform to a parellel linked subform.
But I want the simple solution, which is suppose work.

:

Hi Leif,

if you are in the code behind the main form, try this:

with me.subform_controlname.form.subsubform_controlname
.form.Recordset.Delete
.requery
end with

WHERE
subform_controlname is the Namep prperty of the subform control
subsubform_controlname is the Namep prperty of the sub-subform control

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
Microsoft Access 2007 wil not delete a record in a sub-sub-form.
I am sure that this is a bug in Access 2007.
I have tried to isolate the problem by creating a new database with to
simple related tables. And no code.
Does anyone know a hotfix?
Click to expand...
Click to expand...
Click to expand...
 
Hi Leif,

you still have not described the method you are using to try to delete
the record

please also answer these questions:

1. is FormC form property AllowDeletions set to True?

2. is the RecordSource for FormC ONLY table C?
If the Recordsource is a query or SQL, please post the SQL statement

3. in the defined relationships for your database, is there a
relationship between tableB and tableC?
If so, which table holds the 'parent' field (double-click on the link
line -- which table is listed in the left column?) ?


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
As I mentioned in the start - it is a bug in Access 2007:
Because, when I run the Access-file with tables, that I have just described,
in Access 2003 there are no problems!
But how can I contact Microsoft to make them solve the problem - whithout
having to pay a lot of money contacting their support?

strive4peace said:
Hi Leif,

thank you for explaining how your tables are related. When you try to
delete a record in form C, how are you doing it?

is FormC form property AllowDeletions set to True?

is the RecordSource for FormC ONLY table C?

in the defined relationships for your database, is there a relationship
between tableB and tableC? If so, which table holds the 'parent' field?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
FormC (based on tableC) is inserted i formB (based on tableB) is inserted i
formA.
The field [idb<] in tableC is joined to the key field [idb] in tableB.
FormC is linked to formB by Link Master fields = [idb] and Link Child
Fields = [idb<]
For Both formB and FormC Default View = Datasheet.
Then it is not possible to delete a record i sub-subfomC.


:

Hi Leif,

please post the "simple" solution that does not work that you are using

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
I know that there are several options to solve the problem - for instance by
using code or to make the sub-subform to a parellel linked subform.
But I want the simple solution, which is suppose work.

:

Hi Leif,

if you are in the code behind the main form, try this:

with me.subform_controlname.form.subsubform_controlname
.form.Recordset.Delete
.requery
end with

WHERE
subform_controlname is the Namep prperty of the subform control
subsubform_controlname is the Namep prperty of the sub-subform control

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
Microsoft Access 2007 wil not delete a record in a sub-sub-form.
I am sure that this is a bug in Access 2007.
I have tried to isolate the problem by creating a new database with to
simple related tables. And no code.
Does anyone know a hotfix?
Click to expand...
Click to expand...
Click to expand...
 
I use the Delete-key to delete the record. Which is the normal way to delete
records. And this method is suppose to work.
And still - why doesn't it work in Access 2007 when it works fine in Access
2003?
And therefor your other questions are also irrelevant
I AM ABSOLUTELY POSITIVELY SURE THAT MY SETTINGS ARE OK - AND IT IS A BUG IN
ACCESS 2007!!!!
PLEASE JUST DIRECT TO A HOTFIX.

strive4peace said:
Hi Leif,

you still have not described the method you are using to try to delete
the record

please also answer these questions:

1. is FormC form property AllowDeletions set to True?

2. is the RecordSource for FormC ONLY table C?
If the Recordsource is a query or SQL, please post the SQL statement

3. in the defined relationships for your database, is there a
relationship between tableB and tableC?
If so, which table holds the 'parent' field (double-click on the link
line -- which table is listed in the left column?) ?


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
As I mentioned in the start - it is a bug in Access 2007:
Because, when I run the Access-file with tables, that I have just described,
in Access 2003 there are no problems!
But how can I contact Microsoft to make them solve the problem - whithout
having to pay a lot of money contacting their support?

strive4peace said:
Hi Leif,

thank you for explaining how your tables are related. When you try to
delete a record in form C, how are you doing it?

is FormC form property AllowDeletions set to True?

is the RecordSource for FormC ONLY table C?

in the defined relationships for your database, is there a relationship
between tableB and tableC? If so, which table holds the 'parent' field?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
FormC (based on tableC) is inserted i formB (based on tableB) is inserted i
formA.
The field [idb<] in tableC is joined to the key field [idb] in tableB.
FormC is linked to formB by Link Master fields = [idb] and Link Child
Fields = [idb<]
For Both formB and FormC Default View = Datasheet.
Then it is not possible to delete a record i sub-subfomC.


:

Hi Leif,

please post the "simple" solution that does not work that you are using

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
I know that there are several options to solve the problem - for instance by
using code or to make the sub-subform to a parellel linked subform.
But I want the simple solution, which is suppose work.

:

Hi Leif,

if you are in the code behind the main form, try this:

with me.subform_controlname.form.subsubform_controlname
.form.Recordset.Delete
.requery
end with

WHERE
subform_controlname is the Namep prperty of the subform control
subsubform_controlname is the Namep prperty of the sub-subform control

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
Microsoft Access 2007 wil not delete a record in a sub-sub-form.
I am sure that this is a bug in Access 2007.
I have tried to isolate the problem by creating a new database with to
simple related tables. And no code.
Does anyone know a hotfix?
Click to expand...
Click to expand...
Click to expand...
 
Hi Leif,

This is not a bug. The Delete key will only work if the RECORD is selected

to select a record:
1. click in the gray record selector rectangle on the left
OR
2. press SHIFT-Spacebar when an entire control is highlighted (F2
toggles between insertion point and highlighting entire control)
OR
3. choose 'Select Record' from the ribbon


otherwise, to DELETE A RECORD, it is fastest to use:
CTRL -
(hold Control and press the minus sign)


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
I use the Delete-key to delete the record. Which is the normal way to delete
records. And this method is suppose to work.
And still - why doesn't it work in Access 2007 when it works fine in Access
2003?
And therefor your other questions are also irrelevant
I AM ABSOLUTELY POSITIVELY SURE THAT MY SETTINGS ARE OK - AND IT IS A BUG IN
ACCESS 2007!!!!
PLEASE JUST DIRECT TO A HOTFIX.

strive4peace said:
Hi Leif,

you still have not described the method you are using to try to delete
the record

please also answer these questions:

1. is FormC form property AllowDeletions set to True?

2. is the RecordSource for FormC ONLY table C?
If the Recordsource is a query or SQL, please post the SQL statement

3. in the defined relationships for your database, is there a
relationship between tableB and tableC?
If so, which table holds the 'parent' field (double-click on the link
line -- which table is listed in the left column?) ?


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
As I mentioned in the start - it is a bug in Access 2007:
Because, when I run the Access-file with tables, that I have just described,
in Access 2003 there are no problems!
But how can I contact Microsoft to make them solve the problem - whithout
having to pay a lot of money contacting their support?

:

Hi Leif,

thank you for explaining how your tables are related. When you try to
delete a record in form C, how are you doing it?

is FormC form property AllowDeletions set to True?

is the RecordSource for FormC ONLY table C?

in the defined relationships for your database, is there a relationship
between tableB and tableC? If so, which table holds the 'parent' field?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
FormC (based on tableC) is inserted i formB (based on tableB) is inserted i
formA.
The field [idb<] in tableC is joined to the key field [idb] in tableB.
FormC is linked to formB by Link Master fields = [idb] and Link Child
Fields = [idb<]
For Both formB and FormC Default View = Datasheet.
Then it is not possible to delete a record i sub-subfomC.


:

Hi Leif,

please post the "simple" solution that does not work that you are using

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
I know that there are several options to solve the problem - for instance by
using code or to make the sub-subform to a parellel linked subform.
But I want the simple solution, which is suppose work.

:

Hi Leif,

if you are in the code behind the main form, try this:

with me.subform_controlname.form.subsubform_controlname
.form.Recordset.Delete
.requery
end with

WHERE
subform_controlname is the Namep prperty of the subform control
subsubform_controlname is the Namep prperty of the sub-subform control

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
Microsoft Access 2007 wil not delete a record in a sub-sub-form.
I am sure that this is a bug in Access 2007.
I have tried to isolate the problem by creating a new database with to
simple related tables. And no code.
Does anyone know a hotfix?
Click to expand...
Click to expand...
Click to expand...
 
I have been programming Access databases for about 13 years.
so I surely know how to delete a record. Every possible way.
And also - you still have not explained to me why it is possible in Access
2003 and not in Access 2007.
I can send you the database, if you give me your email?

strive4peace said:
Hi Leif,

This is not a bug. The Delete key will only work if the RECORD is selected

to select a record:
1. click in the gray record selector rectangle on the left
OR
2. press SHIFT-Spacebar when an entire control is highlighted (F2
toggles between insertion point and highlighting entire control)
OR
3. choose 'Select Record' from the ribbon


otherwise, to DELETE A RECORD, it is fastest to use:
CTRL -
(hold Control and press the minus sign)


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
I use the Delete-key to delete the record. Which is the normal way to delete
records. And this method is suppose to work.
And still - why doesn't it work in Access 2007 when it works fine in Access
2003?
And therefor your other questions are also irrelevant
I AM ABSOLUTELY POSITIVELY SURE THAT MY SETTINGS ARE OK - AND IT IS A BUG IN
ACCESS 2007!!!!
PLEASE JUST DIRECT TO A HOTFIX.

strive4peace said:
Hi Leif,

you still have not described the method you are using to try to delete
the record

please also answer these questions:

1. is FormC form property AllowDeletions set to True?

2. is the RecordSource for FormC ONLY table C?
If the Recordsource is a query or SQL, please post the SQL statement

3. in the defined relationships for your database, is there a
relationship between tableB and tableC?
If so, which table holds the 'parent' field (double-click on the link
line -- which table is listed in the left column?) ?


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
As I mentioned in the start - it is a bug in Access 2007:
Because, when I run the Access-file with tables, that I have just described,
in Access 2003 there are no problems!
But how can I contact Microsoft to make them solve the problem - whithout
having to pay a lot of money contacting their support?

:

Hi Leif,

thank you for explaining how your tables are related. When you try to
delete a record in form C, how are you doing it?

is FormC form property AllowDeletions set to True?

is the RecordSource for FormC ONLY table C?

in the defined relationships for your database, is there a relationship
between tableB and tableC? If so, which table holds the 'parent' field?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
FormC (based on tableC) is inserted i formB (based on tableB) is inserted i
formA.
The field [idb<] in tableC is joined to the key field [idb] in tableB.
FormC is linked to formB by Link Master fields = [idb] and Link Child
Fields = [idb<]
For Both formB and FormC Default View = Datasheet.
Then it is not possible to delete a record i sub-subfomC.


:

Hi Leif,

please post the "simple" solution that does not work that you are using

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
I know that there are several options to solve the problem - for instance by
using code or to make the sub-subform to a parellel linked subform.
But I want the simple solution, which is suppose work.

:

Hi Leif,

if you are in the code behind the main form, try this:

with me.subform_controlname.form.subsubform_controlname
.form.Recordset.Delete
.requery
end with

WHERE
subform_controlname is the Namep prperty of the subform control
subsubform_controlname is the Namep prperty of the sub-subform control

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
Microsoft Access 2007 wil not delete a record in a sub-sub-form.
I am sure that this is a bug in Access 2007.
I have tried to isolate the problem by creating a new database with to
simple related tables. And no code.
Does anyone know a hotfix?
Click to expand...
Click to expand...
Click to expand...
 
Hi Leif,

yes, I would like to test this for myself

strive4peace2006 at yahoo.com

please specify the steps you take from the database opening to press the
DELETE key


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
I have been programming Access databases for about 13 years.
so I surely know how to delete a record. Every possible way.
And also - you still have not explained to me why it is possible in Access
2003 and not in Access 2007.
I can send you the database, if you give me your email?

strive4peace said:
Hi Leif,

This is not a bug. The Delete key will only work if the RECORD is selected

to select a record:
1. click in the gray record selector rectangle on the left
OR
2. press SHIFT-Spacebar when an entire control is highlighted (F2
toggles between insertion point and highlighting entire control)
OR
3. choose 'Select Record' from the ribbon


otherwise, to DELETE A RECORD, it is fastest to use:
CTRL -
(hold Control and press the minus sign)


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
I use the Delete-key to delete the record. Which is the normal way to delete
records. And this method is suppose to work.
And still - why doesn't it work in Access 2007 when it works fine in Access
2003?
And therefor your other questions are also irrelevant
I AM ABSOLUTELY POSITIVELY SURE THAT MY SETTINGS ARE OK - AND IT IS A BUG IN
ACCESS 2007!!!!
PLEASE JUST DIRECT TO A HOTFIX.

:

Hi Leif,

you still have not described the method you are using to try to delete
the record

please also answer these questions:

1. is FormC form property AllowDeletions set to True?

2. is the RecordSource for FormC ONLY table C?
If the Recordsource is a query or SQL, please post the SQL statement

3. in the defined relationships for your database, is there a
relationship between tableB and tableC?
If so, which table holds the 'parent' field (double-click on the link
line -- which table is listed in the left column?) ?


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
As I mentioned in the start - it is a bug in Access 2007:
Because, when I run the Access-file with tables, that I have just described,
in Access 2003 there are no problems!
But how can I contact Microsoft to make them solve the problem - whithout
having to pay a lot of money contacting their support?

:

Hi Leif,

thank you for explaining how your tables are related. When you try to
delete a record in form C, how are you doing it?

is FormC form property AllowDeletions set to True?

is the RecordSource for FormC ONLY table C?

in the defined relationships for your database, is there a relationship
between tableB and tableC? If so, which table holds the 'parent' field?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
FormC (based on tableC) is inserted i formB (based on tableB) is inserted i
formA.
The field [idb<] in tableC is joined to the key field [idb] in tableB.
FormC is linked to formB by Link Master fields = [idb] and Link Child
Fields = [idb<]
For Both formB and FormC Default View = Datasheet.
Then it is not possible to delete a record i sub-subfomC.


:

Hi Leif,

please post the "simple" solution that does not work that you are using

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
I know that there are several options to solve the problem - for instance by
using code or to make the sub-subform to a parellel linked subform.
But I want the simple solution, which is suppose work.

:

Hi Leif,

if you are in the code behind the main form, try this:

with me.subform_controlname.form.subsubform_controlname
.form.Recordset.Delete
.requery
end with

WHERE
subform_controlname is the Namep prperty of the subform control
subsubform_controlname is the Namep prperty of the sub-subform control

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
Microsoft Access 2007 wil not delete a record in a sub-sub-form.
I am sure that this is a bug in Access 2007.
I have tried to isolate the problem by creating a new database with to
simple related tables. And no code.
Does anyone know a hotfix?
Click to expand...
Click to expand...
Click to expand...
 
Hi Leif,

got your database

sorry to be the bearer of bad news, but what you sent has several problems:

1. you need to remove '<' from the field and controlname for 'idt1'

2. you have not qualified 'ID' with the type of ID it is... tableB and
tableC both have ID as a fieldname -- but, obviously being an autonumber
in each table, they are not the same information!

3. you have no defined relationships

4. the LinkChildField for the subform control containing TableC is idt1<
.... in addition to containing a bad character, it is also not filled in
the table (probably due to '<' in the name)

5. a datasheet view form cannot display a subform -- therefore, you are
actually using the 'subDatasheet' property of the table (which has
problems and is recommended to turn off), not a form -- and the subform,
since it is specified, probably has the table open

read 'Access Basics'


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*



Hi Leif,

yes, I would like to test this for myself

strive4peace2006 at yahoo.com

please specify the steps you take from the database opening to press the
DELETE key


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif said:
I have been programming Access databases for about 13 years.
so I surely know how to delete a record. Every possible way.
And also - you still have not explained to me why it is possible in
Access 2003 and not in Access 2007.
I can send you the database, if you give me your email?

strive4peace said:
Hi Leif,

This is not a bug. The Delete key will only work if the RECORD is
selected

to select a record:
1. click in the gray record selector rectangle on the left
OR
2. press SHIFT-Spacebar when an entire control is highlighted (F2
toggles between insertion point and highlighting entire control)
OR
3. choose 'Select Record' from the ribbon


otherwise, to DELETE A RECORD, it is fastest to use:
CTRL -
(hold Control and press the minus sign)


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
I use the Delete-key to delete the record. Which is the normal way
to delete records. And this method is suppose to work.
And still - why doesn't it work in Access 2007 when it works fine in
Access 2003?
And therefor your other questions are also irrelevant
I AM ABSOLUTELY POSITIVELY SURE THAT MY SETTINGS ARE OK - AND IT IS
A BUG IN ACCESS 2007!!!!
PLEASE JUST DIRECT TO A HOTFIX.

:

Hi Leif,

you still have not described the method you are using to try to
delete the record

please also answer these questions:

1. is FormC form property AllowDeletions set to True?

2. is the RecordSource for FormC ONLY table C?
If the Recordsource is a query or SQL, please post the SQL statement

3. in the defined relationships for your database, is there a
relationship between tableB and tableC?
If so, which table holds the 'parent' field (double-click on the
link line -- which table is listed in the left column?) ?


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
As I mentioned in the start - it is a bug in Access 2007:
Because, when I run the Access-file with tables, that I have just
described, in Access 2003 there are no problems!
But how can I contact Microsoft to make them solve the problem -
whithout having to pay a lot of money contacting their support?

:

Hi Leif,

thank you for explaining how your tables are related. When you
try to delete a record in form C, how are you doing it?

is FormC form property AllowDeletions set to True?

is the RecordSource for FormC ONLY table C?

in the defined relationships for your database, is there a
relationship between tableB and tableC? If so, which table holds
the 'parent' field?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
FormC (based on tableC) is inserted i formB (based on tableB) is
inserted i formA.
The field [idb<] in tableC is joined to the key field [idb] in
tableB.
FormC is linked to formB by Link Master fields = [idb] and Link
Child Fields = [idb<]
For Both formB and FormC Default View = Datasheet.
Then it is not possible to delete a record i sub-subfomC.


:

Hi Leif,

please post the "simple" solution that does not work that you
are using

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
I know that there are several options to solve the problem -
for instance by using code or to make the sub-subform to a
parellel linked subform.
But I want the simple solution, which is suppose work.

:

Hi Leif,

if you are in the code behind the main form, try this:

with me.subform_controlname.form.subsubform_controlname
.form.Recordset.Delete
.requery
end with

WHERE
subform_controlname is the Namep prperty of the subform control
subsubform_controlname is the Namep prperty of the
sub-subform control

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Leif Andersson wrote:
Microsoft Access 2007 wil not delete a record in a
sub-sub-form. I am sure that this is a bug in Access 2007. I
have tried to isolate the problem by creating a new database
with to simple related tables. And no code. Does anyone know
a hotfix?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top