J
Justin
Hello, need some assistance. I have this access database where it grabs raw
data from an oracle database and user will
upload file onto my database. Now this database will take that raw data and
spit out several excel sheets, depending on
location criteria. Now, these are the fields on the access database
CDI ID
Date
Corp (location)
Account #
ORG
Locator
Subinventory
Box Status
Serial Number
Part #
Description
Operator ID
Date of Upload
Now when the excel sheet is generated, it looks at a template sheet and adds
all data and save it as a different sheet
The fields on the excel sheets are as follows:
Unique Number (CDI ID)
Date (DATE)
Org (ORG)
Sub Inventory (Subinventory)
LOC (Locator)
CVC Part Number (Part #)
Serial Number (Serial Number)
CableDataBox Status (Box Status)
Opr ID (Operator ID)
Corp (CORP)
Account # (Account #)
Coordinator ID
CDI Comments
Coordinator Comments
Now that last three fields are what needs to be filled in. The CDI Comments
is a drop down. There are 5 options:
BARCODE IDENTITY ISSUE
PENDING RESEARCH
LOGISTICS ASSET VALIDATED
NO TROUBLE FOUND
MISSED ISSUES
I need a way to upload the data back to the table, BUT only the last 3
fields. I dont' want to upload data that I already have
What I need is when the user press UPLOAD (there need to be an upload button
on the excel sheet) that it looks at the 3 fields
and if the drop down is blank (default), then that line shouldn't be
uploaded. Only fields that should be uploaded are rows that
the CDI Comments are filled. Now if the CDI COmments are to Logistic Asset
Validated, then it needs to upload that line back to
the table and the delete it self from the excel sheet. If the cdi comments
are any other options, then it uploads but still be there
so user have option to change. When the next time the user press upload and
that row has already been uploaded, msgbox should
appear prompting user if they want to update with new data
Please help. Thanks
data from an oracle database and user will
upload file onto my database. Now this database will take that raw data and
spit out several excel sheets, depending on
location criteria. Now, these are the fields on the access database
CDI ID
Date
Corp (location)
Account #
ORG
Locator
Subinventory
Box Status
Serial Number
Part #
Description
Operator ID
Date of Upload
Now when the excel sheet is generated, it looks at a template sheet and adds
all data and save it as a different sheet
The fields on the excel sheets are as follows:
Unique Number (CDI ID)
Date (DATE)
Org (ORG)
Sub Inventory (Subinventory)
LOC (Locator)
CVC Part Number (Part #)
Serial Number (Serial Number)
CableDataBox Status (Box Status)
Opr ID (Operator ID)
Corp (CORP)
Account # (Account #)
Coordinator ID
CDI Comments
Coordinator Comments
Now that last three fields are what needs to be filled in. The CDI Comments
is a drop down. There are 5 options:
BARCODE IDENTITY ISSUE
PENDING RESEARCH
LOGISTICS ASSET VALIDATED
NO TROUBLE FOUND
MISSED ISSUES
I need a way to upload the data back to the table, BUT only the last 3
fields. I dont' want to upload data that I already have
What I need is when the user press UPLOAD (there need to be an upload button
on the excel sheet) that it looks at the 3 fields
and if the drop down is blank (default), then that line shouldn't be
uploaded. Only fields that should be uploaded are rows that
the CDI Comments are filled. Now if the CDI COmments are to Logistic Asset
Validated, then it needs to upload that line back to
the table and the delete it self from the excel sheet. If the cdi comments
are any other options, then it uploads but still be there
so user have option to change. When the next time the user press upload and
that row has already been uploaded, msgbox should
appear prompting user if they want to update with new data
Please help. Thanks