PC Review


Reply
Thread Tools Rate Thread

Finding the Transaction property of a form

 
 
=?Utf-8?B?ZW1lcmI=?=
Guest
Posts: n/a
 
      21st Jan 2005
Hello,
I want to check if my form supports transactions. Where do i find this
transaction property?
 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      21st Jan 2005
Bound forms are wrapped within transactions that are not exposed to you.

In Access 2000 and later, it is possible to:
- open a transaction,
- open a recordset inside the transaction,
- assign this recordset to the Recordset property of your form,
thus wrapping your form inside your own transaction.

Unfortunately, there does not seem to be any way to get a subform inside the
same transaction, because Access reassigns it every time you move record in
the main form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"emerb" <(E-Mail Removed)> wrote in message
news:F5AA79D1-B73A-4296-B4A9-(E-Mail Removed)...
> Hello,
> I want to check if my form supports transactions. Where do i find this
> transaction property?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Root transaction wanted to commit, but transaction aborted Vijay Anand Kannan Microsoft Dot NET Framework 1 12th Apr 2005 11:15 AM
"Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." Ollie Riches Microsoft C# .NET 3 11th Mar 2005 06:23 PM
"Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." Ollie Riches Microsoft ADO .NET 3 11th Mar 2005 06:23 PM
Finding the transaction property of a form =?Utf-8?B?ZW1lcmI=?= Microsoft Access Forms 1 21st Jan 2005 05:11 PM
Root transaction wanted to commit, but transaction aborted =?Utf-8?B?S2FydW4gS2FydW5ha2FyYW4=?= Microsoft Dot NET Framework 2 23rd Jul 2004 07:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:04 AM.