Why my query is not updatable, it seems it is lock.. Pls i need help. (1 Viewer)

[moi]

What makes a query lock, pls i need help.. I have 3 tables(buyer, payment and lotdetails) they are link with "buyerid, propertyid..

 

[isladogs]

See Allen Browne's article: Microsoft Access tips: Why is my query read-only? (allenbrowne.com)

 

[moi]

thank you..i will see and study, in the meantime, i attached my db sample, can you please take a look. I want to use the query as a source of my form (payment entry form)..

 

[CJ_London]

you can change the query recordset type property from dynaset to dynaset (inconsistent updates).

If this is to be a recordsource to a form, you will need to change it in the form as well.

Note that it is generally bad practice to base a form recordsource on multiple tables. Make use of combo, listbox and/or subform controls to handle separate tables. Otherwise you may experience problems in creating new records

 

[mike60smart]

thank you..i will see and study, in the meantime, i attached my db sample, can you please take a look. I want to use the query as a source of my form (payment entry form)..

Hi
Can you explain your business process in a bit more detail?

Your Relationship diagram shows a Buyer has Multiple LotDetails

Or should it show the Property has Multiple Buyers??

 

[moi]

Hi
Can you explain your business process in a bit more detail?

Your Relationship diagram shows a Buyer has Multiple LotDetails

Or should it show the Property has Multiple Buyers??

Hi mike60smart
Yes buyer is possible to buy more than 1 lot within same block.. Property is not multiple buyer.

 

[mike60smart]

Hi mike60smart
Yes buyer is possible to buy more than 1 lot within same block.. Property is not multiple buyer.

OK
I deleted the query as it was of no use.

Study the relationship diagram in the attached and you will see that 1 Buyer can show an interest in Multiple Lots

The Form in the attached database consists of a Main form based on the tblBuyer table
with a Subform based on the tbLotDetails.

 

[XPS35]

This one is updateable....

 

[Pat Hartman]

RI needs to be enforced.

 

[moi]

OK
I deleted the query as it was of no use.

Study the relationship diagram in the attached and you will see that 1 Buyer can show an interest in Multiple Lots

The Form in the attached database consists of a Main form based on the tblBuyer table
with a Subform based on the tbLotDetails.

many thanks sir.. i will study the fixed db..

 

[moi]

many thanks sir.. i will study the fixed db..

OK
I deleted the query as it was of no use.

Study the relationship diagram in the attached and you will see that 1 Buyer can show an interest in Multiple Lots

The Form in the attached database consists of a Main form based on the tblBuyer table
with a Subform based on the tbLotDetails.

hi mike60smart,

Can you please help me more on form subform linking.. i can manage to link "mainform+1subform", but i would like to link 2 subforms.. What i wanted to do is, i would like to show the buyer, then show the property and the lot detail..

thank you..

 

[arnelgp]

another demo pare koy.

 

[moi]

another demo pare koy.

thanks pare koy.. trying to learn ms access..

 

[moi]

another demo pare koy.

Sir Arnel, i want to use your demo, would it be possible to add search feature on a textbox with button on to the form, pls need your help.. I know to put the combo to search with the wizard, but most of the time the macro is corrupted.. My access is only 2007..

 

[arnelgp]

another one, same tables, using datasheet subforms.
which search do you need, can you draw/snapshot of it.
the demo is A2007 version.

 

[arnelgp]

updated db, with search for location and navigation button.

 

[moi]

another one, same tables, using datasheet subforms.
which search do you need, can you draw/snapshot of it.
the demo is A2007 version

another one, same tables, using datasheet subforms.
which search do you need, can you draw/snapshot of it.
the demo is A2007 version.

another one, same tables, using datasheet subforms.
which search do you need, can you draw/snapshot of it.
the demo is A2007 version.

Thank you so much sir arnel.. are u in pinas or other country..?

 

[arnelgp]

pinas... and you?

 

[moi]

pinas... and you?

yes sir at baras rizal..