473,322 Members | 1,287 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Form Requery with Multiple Users

Hi,

I've got a form where multiple users will be 'booking' their trades. Several
bound fields have on update/change requery code for the Form, this is to
limit the rest of the fields based on these. The first user has no problems
but the 2nd user, if tries to change on of these fields which force a requery,
I get an error in the code, I guess because the first user has 'locked' the
form from doing requeries...is there an easy way to fix this?

Any help appreciated.

Regards,
Jack.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1

Sep 18 '06 #1
4 1746
On Mon, 18 Sep 2006 17:42:12 GMT, "Jackson via AccessMonster.com"
<u11192@uwewrote:

If I understand you correctly, you are using several fields to filter
the result set based on those values. These fields should be unbound.

-Tom.
>Hi,

I've got a form where multiple users will be 'booking' their trades. Several
bound fields have on update/change requery code for the Form, this is to
limit the rest of the fields based on these. The first user has no problems
but the 2nd user, if tries to change on of these fields which force a requery,
I get an error in the code, I guess because the first user has 'locked' the
form from doing requeries...is there an easy way to fix this?

Any help appreciated.

Regards,
Jack.
Sep 19 '06 #2
Users fill out a form with bound fields to a table, the records of which they
are populating - is it bad to do this?

Tom van Stiphout wrote:
>If I understand you correctly, you are using several fields to filter
the result set based on those values. These fields should be unbound.

-Tom.
>>Hi,
[quoted text clipped - 9 lines]
>>Regards,
Jack.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1

Sep 20 '06 #3
On Wed, 20 Sep 2006 14:23:08 GMT, "jackwoodhead via AccessMonster.com"
<u11192@uwewrote:

No, generally you want to have bound forms. I must have misunderstood
your situation. Can you reformulate your question?
-Tom.

>Users fill out a form with bound fields to a table, the records of which they
are populating - is it bad to do this?

Tom van Stiphout wrote:
>>If I understand you correctly, you are using several fields to filter
the result set based on those values. These fields should be unbound.

-Tom.
>>>Hi,
[quoted text clipped - 9 lines]
>>>Regards,
Jack.
Sep 21 '06 #4
Is your application split between tables in one MDB and the forms etc
in a second MDB that is linked to the first MDB?

Forms don't get locked with multiple users. Records can, but not even
queries should have a problem (unless it is an update query).

Ron

Oct 4 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Sean | last post by:
Greetings all, I am attempting to make a form that will filter through several tables that (I believe) have refretial integrity. I am pulling data from several tables into the form and i would...
2
by: Uwe Range | last post by:
Hi to all, I am working on a form with a combi-field on a subform. I want to give the user the opportunity to alter the list-content (which is based on a table) in a separate form. The user...
4
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...
4
by: deko | last post by:
I'm a little nervous about slamming my database with a dozen Update queries in a loop that all modify RecordSources of open forms. Will the use of DoEvents and/or a Sleep function ameliorate any...
8
by: Zlatko Matić | last post by:
There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox. Cuurrent record should be the same as the value in the...
1
by: Robert | last post by:
I borrowed one of the forms from the MS Access Solutions database and altered it to fit my needs. The form was the 'EditProducts' form where you select a category from a combo which then populates...
3
by: Danny J. Lesandrini | last post by:
-- previously posted on newsgroup :: <microsoft.public.access-- Has anyone else noticed this behavior? Focus jumping from current cell to upper left in embedded datasheet. If not, would you be...
2
by: woodey2002 | last post by:
Hi Guys and thanks for your time. I have a search form for my database that allows users to select multiple criteria from multi select list boxes. I successfully integrated a multi select...
6
by: woodey2002 | last post by:
Hi Everyone. Thanks for your time. I am trying to create a search form that will allow users to select criteria from multiple multi select boxes. So far i have managed to achieve a search option...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.