Hello All,
I have a problem that I have been trying to solve for days and I
have finally broke down and am asking for advice/assistance. I am
currently re-working on an Access front-end with linked tables,
Oracle back-end due to severe performance issues. It has been
difficult to say the least working someone else's code and logic.
Anyhow here is the run down of what I'm working with.
A single table MEMBER_TABLE that has fields PRIORITY,
LOOKUP_ASSIGNED_TO, LOOKUP_ASSIGN_DATE, BY_PASS_REASON, NRF_YN,
WORKED_RECORD
I need to:
1. Allow user to enter a parameter based on the PRIORITY
If records do not exist with the priority code enter and the
criteria, return a message stating "No records found"
If records do exists
2 .Select the TOP VALUE 20
3. Where BY_PASS_REASON IS NULL
and NRF_YN = `0'
and BY_PASS_REASON Is Null
4. Update LOOKUP_ASSIGN_TO GETUSER()
And LOOKUP_DATE DATE()
Currently there is an update query attach to a button, when the
users click it runs the update query using the parameter PRIORITY
attaches LOOKUP_ASSIGN_TO and LOOKUP_ASSIGN_DATE to the record.
There is no control on how many records a user will attach to, it
could 100 or 1. There is no confirmation that an update occurred
and if the priority entered in the parameter does not return records
it does not alert the user that records where not found.
I have tried different methods but nothing seems to work. I can
update the records but not get the top value etc, etc. Currently I
have a button when clicked it access a select query that loads the
records into a form/continuous showing only a few fields for
identification purposes. The recordset is counted on open if no
records are found it displays the message and the form does not
open. If records are found the form is opened. I have two buttons on
the form one to cancel and another to accept record assignment or so
I thought. When I try to update the records I get the message it
cannot be updated. My only issue now is updating the records loaded
in the form from the select query. This is where I'm stumped.
If anyone could offer assistance I would greatly appreciate it. Also
if I have not provided enough or useful information please let me
know and I will provide whatever is needed.
Thanks
Shawn
