wrong usergroup?

[Nancy]

I have posted my question on 11/13 and 11/18 and have not
gotten a reply. Am I asking the wrong usergroup? You've
helped me once before and you are great. Just don't
understand why neither of my postings exist anymore.
Please let me know who can help?

My problem was a form I created to search & update. Works
fine except when I search before I update. Table is
locked by the search & I don't know how to unlock it for
the update query to work.

thanks for any suggestions

 

[Guest]

can you paste your code?

 

[Wayne Morgan]

This is just a guess, but it may be that the computer was still busy from the search. Try
a

DbEngine.Idle

command after the search to free things up.

 

[[MVP] S. Clark]

Nancy, I hate to have to tell you this, but... it's your deodorant. Ok,
hopefully you took that as humor, if not... press on..

I don't see a post from you on the 13th, but yesterday's is still there.
Often times, if no one knows a "really good" answer, they'll refrain from
posting to give someone else a chance that may have it.

This newsgroup is about Access Queries, but you're talking about a form, so
possibly posting in the Forms newsgroup will net a faster / better answer.

If you do repost, I would recommend that you post the steps that you take,
like....

When the form opens, what locking scheme is used.
What is the recordsource of the form
What is the SQL of the Update query.
What does you mean when you say that you have a form that is used for both
searching and updating.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Nancy]

Thank you all for responding. Unfortunately "
DbEngine.Idle " did not work. The form I created allows
the user to select some criteria and then, via SQL in the
code for the form, a search is performed - this works
fine. This form also allows the user to choose a control
to update the table used for the search via calls to
several queries - this works too UNLESS I do a search
before I do an update. I've tried closing the table =>
DoCmd.Close acTable , "TempProv"
and changing the record source for the form to a 'dummy
table' => 'Me.RecordSource = "Provider"
Nothing seems to work. Can you tell me what is the link
for the usergroup for forms?

Thanks again,
Nancy

 

[John Vinson]

Thank you all for responding. Unfortunately "
DbEngine.Idle " did not work. The form I created allows
the user to select some criteria and then, via SQL in the
code for the form, a search is performed - this works
fine. This form also allows the user to choose a control
to update the table used for the search via calls to
several queries - this works too UNLESS I do a search
before I do an update. I've tried closing the table =>
DoCmd.Close acTable , "TempProv"
and changing the record source for the form to a 'dummy
table' => 'Me.RecordSource = "Provider"
Nothing seems to work. Can you tell me what is the link
for the usergroup for forms?

news://microsoft.public.access.forms

or, if you're using Microsoft's webpage as your newsreader, browse
down under the Access row in the menu on the left and find Forms.

When you do post in the Forms newsgroup, please post the actual VBA
code. You shouldn't be opening a table at all, nor closing it! But
since I can't tell what you ARE doing, it's hard to say what you might
be doing wrong!