By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

Updating tables based on Items in a Listbox

P: n/a
I am using Access 2000/Windows 2000 on a Novel network

I have a multi-user program that tracks documents and their holders.
There are three primary tables tblHolders, tblDocuments and a link
table tblDoc_Holders.

The program is complete other than a way to assign new documents to a
holder.
I am stuck on how best to accomplish this. I currently have a form
with two listboxes, lstSource (multi-select) is populated using a
predefined query of active documents in tblDocuments and lstAssigned
(multi-select)has a .RowSourceType of "Value List" and .RowSource =
"". Item(s) selected in lstSource have their Doc_ID and Doc_Title
added to a ";" delimited list in the RowSource of lstAssigned (the
document is not removed from lstSource when added to lstAssigned
becaues a holder can have multiple copies of the same document).

Here then lies my issues:

1) Limitation on the size of the lstAssigned.RowSource (2048 chr ?) I
know it is a lot but in testing this has been an issue.

2) Before writting to the link table each record will be assigned the
Holder _ID and a doc_Traking_Number based on the next available number
for that document. This number is stored as a field in tblDocument and
gets increased as a document gets assigned. I do not want to increase
the number in tblDocument until the user commits to the change and
need to prevent duplication of numbers if multiple users are assigning
the same document to diffrent people at the same time.

I have spent a lot of time researching this, and while there is lots
of information on working with lists boxes I can not find one that
covers these issues. I am starting to investigate the use of
recordsets but am unsure if this is a wise choice. Any help would be
much appriciated.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.