tyy8
asked on
Access frontend with a SQL Server backend
I have an MS Access frontend with a SQL Server backend. On several of my forms, I have a textbox bound to the primary key of the table. When the backend was solely in MS Access, the primary key would show up as soon as you start making the record. But this is not the case now that the backend is in SQL. The primary key value doesn't show up until you move off the record and comer back to it.
My problem is that I make use of the primary key value before the user gets off the record, so since it is NULL now - my code is crashing. Is there a solution to this.
My problem is that I make use of the primary key value before the user gets off the record, so since it is NULL now - my code is crashing. Is there a solution to this.
ASKER
I need to send the primary key into some other tables, so I need to set that up before the user leaves the record and goes to view those other tables.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
But I also need to send that users ID (for tracking the user's activity), and some other stuff that the trigger would never have available to it.
I guess I just don't understand all that is in play here...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- --
This question has been abandoned and needs to be finalized.
You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
ornicar
Cleanup Volunteer
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- -------
This question has been abandoned and needs to be finalized.
You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
ornicar
Cleanup Volunteer
--------------------------
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:
Split: jadedata {http:#9789733} & thorkyl {http:#9798989}
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
jadedata
EE Cleanup Volunteer
I will leave the following recommendation for this question in the Cleanup topic area:
Split: jadedata {http:#9789733} & thorkyl {http:#9798989}
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
jadedata
EE Cleanup Volunteer
You will have to modify your code somehow to work with this change in MO by the two different databases.
Is there any other way to identify the record recently entered to return to IT specifically?
regards
Jack