J
Justin
I'm having a situation and hopefully someone can help me out
I have this database that user will upload text files and from a form,
it generates an excel sheet. The database looks at an excel sheet template
I made and then adds the data and renames teh sheet.the fields in the excel
sheet are as follows:
Name Column
CDI ID A
Date B
ORG C
Sub Inventory D
LOC E
CVC Part # F
Serial # G
CableDataBox Status H
Opr ID I
Corp J
Account # K
Coordinator ID L
CDI Comments M
Coordinator Comments N
column a-k are the data that is from the database. L-M are the columns that
the user will have to
fill in, with column M being a drop down
there are 5 options in the drop down,
1.Barcode Identity Issue
2.Pending research
3.Logistic asset validated
4 No trouble Found
5.Missed Issues
Now, the sheet varys in rows and different dept in my company will work this
sheet, not all at once and not
in a week. One dept may work they half one day and the other a week later.
This is where I need the help
Once the dept completes it work, they email the dept head to upload the data
to the database. I have a command
button that will upload the data onto another database. I dont' want that. I
need it to take a look at columns M, seeing if it "filled in"
1. if it not filled in and user press the upload button, nothing should be
upload
2. if M has a comment and it is Logistic Asset Validated, then it be
uploaded and deleted from the sheet
3. If M has a comment and it is any other comment, then it should be
uploaded but not deleted and if user
changes comment later on and presses upload, warning screen should
appear, asking if they want to replace
the same row with new comment
Also, when data is uploaded, it shouldn't go to another table but to the
table where the data came from.
what i mean is that the table in access is called CDI IMPORT_DETAIL
and fields are:
CDI ID (Autonumber)
Date (text)
Corp (text)
Account # (text)
Org (text)
Locator (text)
SubInventory (text)
Box Status (text)
Serial Number (text)
Part # (text)
Operator ID (text)
Date of Oracle Import (date/time)
Coordinator ID (text)
CDI Comments (text)
Coordinator Comments (text)
Date file Uploaded (date/Time)
The last 4 column of the table should be the only thing that is being filled
in. So from teh excel sheet, i just need
column L-M to be uploaded. And the way it looks at the access table to see
what row it should update is column A, CDI ID (which is a Unique Key)
Please help
I have this database that user will upload text files and from a form,
it generates an excel sheet. The database looks at an excel sheet template
I made and then adds the data and renames teh sheet.the fields in the excel
sheet are as follows:
Name Column
CDI ID A
Date B
ORG C
Sub Inventory D
LOC E
CVC Part # F
Serial # G
CableDataBox Status H
Opr ID I
Corp J
Account # K
Coordinator ID L
CDI Comments M
Coordinator Comments N
column a-k are the data that is from the database. L-M are the columns that
the user will have to
fill in, with column M being a drop down
there are 5 options in the drop down,
1.Barcode Identity Issue
2.Pending research
3.Logistic asset validated
4 No trouble Found
5.Missed Issues
Now, the sheet varys in rows and different dept in my company will work this
sheet, not all at once and not
in a week. One dept may work they half one day and the other a week later.
This is where I need the help
Once the dept completes it work, they email the dept head to upload the data
to the database. I have a command
button that will upload the data onto another database. I dont' want that. I
need it to take a look at columns M, seeing if it "filled in"
1. if it not filled in and user press the upload button, nothing should be
upload
2. if M has a comment and it is Logistic Asset Validated, then it be
uploaded and deleted from the sheet
3. If M has a comment and it is any other comment, then it should be
uploaded but not deleted and if user
changes comment later on and presses upload, warning screen should
appear, asking if they want to replace
the same row with new comment
Also, when data is uploaded, it shouldn't go to another table but to the
table where the data came from.
what i mean is that the table in access is called CDI IMPORT_DETAIL
and fields are:
CDI ID (Autonumber)
Date (text)
Corp (text)
Account # (text)
Org (text)
Locator (text)
SubInventory (text)
Box Status (text)
Serial Number (text)
Part # (text)
Operator ID (text)
Date of Oracle Import (date/time)
Coordinator ID (text)
CDI Comments (text)
Coordinator Comments (text)
Date file Uploaded (date/Time)
The last 4 column of the table should be the only thing that is being filled
in. So from teh excel sheet, i just need
column L-M to be uploaded. And the way it looks at the access table to see
what row it should update is column A, CDI ID (which is a Unique Key)
Please help