desperateUser
Technical User
TIA for this, I know someone out there will be able to help.
I'm building a db to keep track of purchase requests. We have everyone using an Excel template to create a spreadsheet with their request. Currently, the storeroom enters this by hand into Access97. I'm trying to build a routine that pushes the data into Access instead of trying to rekey it. I have created a button on the Excel template to "push" data into Access97 -- this works great.
I'm using MichaelRed's ideas on creating an auto-number so when the user click's the "Add Record" button a function provides a new unique record identifier.
What I can't figure out is how to merge the two?
I have a new record being created on the form load, with the autonumber created and ready to go in the OrderID field, but that won't work if someone is adding a record via the Excel button. Excel opens the table and adds the information to the table, but my OnLoad event goes to a new record without using the data just added to the table.
Does my question make sense?
I'm building a db to keep track of purchase requests. We have everyone using an Excel template to create a spreadsheet with their request. Currently, the storeroom enters this by hand into Access97. I'm trying to build a routine that pushes the data into Access instead of trying to rekey it. I have created a button on the Excel template to "push" data into Access97 -- this works great.
I'm using MichaelRed's ideas on creating an auto-number so when the user click's the "Add Record" button a function provides a new unique record identifier.
What I can't figure out is how to merge the two?
I have a new record being created on the form load, with the autonumber created and ready to go in the OrderID field, but that won't work if someone is adding a record via the Excel button. Excel opens the table and adds the information to the table, but my OnLoad event goes to a new record without using the data just added to the table.
Does my question make sense?
