Subject: | A Multiuser Problem |
Posted by: | Patrick Finucane (patrickfinucane…@gmail.com) |
Date: | Tue, 24 Dec 2019 |
I am working on an app written by person. And he did something that is har=
d for me to follow. But I think I know why he did it.
There is a Contacts table. The records are displayed in a continuous form.=
The record source is a query. It links the Contacts table to a secondary=
table. The secondary table has 2 fields, the foreign key that links to th=
e Contacts table and the field blnPrint.=20
The secondary table is linked to the Contacts table in an Outer join. This=
produces an un-editable query lists of records. =20
To select the records to print, one clicks on the blnPrint checkbox. But s=
ince the list is not editable it runs a routine in a field, i think a trans=
parent command button, behind the checkbox.
Why did the programmer do this? I believe since multiple people may be sel=
ecting records to print, you would not want records I select to be printed =
in the list of records you want to print. Iow, print the records you selec=
t, not all of them flagged to print.
This has been a pain in the ass to follow his code and logic. There are ze=
ro comments in the app so what the person does is ridiculous. He wrote the=
app like an object oriented java program.
Anyway, is there a way that I can have an easy way to select records to pri=
nt that would not conflict with the records another person might select to =
print?
How can I select the records I want to print that does not get included in =
another users list of records to print. Any advice gladly accepted. There=
has too be a better way than the one currently in use,
Thanks.