troubleshooting Question

Appending primary ID

Avatar of Scott_Kemp
Scott_Kemp asked on
Microsoft AccessOracle Database
12 Comments1 Solution389 ViewsLast Modified:
First of all, I'd like to start out by saying I'm new to this forum.  Also I am somewhat skilled in programming and dabbling in Access.  Currently I have a massive database that holds manufacturing inspection data.  There are multiple dimension (as in measurement) tables linked to the 'Inspection form' along with a master table that holds things like quantity, date received etc...  The 'supplier lot number' is the primary key and the reference point between these mulitple dimension( part measurement) tables.  The database is shared between 2 plants and the data itself is held in Oracle.  Some of our multiple part suppliers use the same lot number method (such as the julian date) and deliver to both plants.  I'd like to append the 'part number' to the end of the 'lot number to solve this issue.  So I put in some VB code to deal with it in the 'after update' event.  The problem is I'll get a cannot insert null into <whatever> table #1400.  I'm sure it's something rather simple - any ideas?  If I need to I can attach the database itself (of course the data will be missing as it's on the local server).  Let me know.

Here's the code:

Private Sub SUP_LOT_NUMBER_AfterUpdate()

Dim COMPLEX_ID As Variant

COMPLEX_ID = (Me.SUP_LOT_NUMBER & "-" & Me.ctlPartNumber)

MsgBox (COMPLEX_ID)
Me.SUP_LOT_NUMBER = COMPLEX_ID
End Sub
screenshot.JPG
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros