By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,315 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,315 IT Pros & Developers. It's quick & easy.

Access 2003 Question...

P: n/a
Ladies and Gentlemen,

I recently took a new position with a University IT group and I'm
having a little trouble with a database I'm working with. Here's the
deal: because all computer component shipments are sent to the location
I'm working in, it's our responsibility to order AND receive all the
inventory we get from vendors.

Currently, the deliveries are scanned (the PO number is usually
barcoded on the package) and recorded into an Excel spreadsheet. Since
we have a record of the order in an Access database, what we're trying
to do is design a process where the package, when scanned,
automatically updates the record in the Access database by populating a
"Received?" field, or something like that.
Anyone know if this is possible? Thanks in advance!

JT

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
JohnnyTruant wrote:
Ladies and Gentlemen,

I recently took a new position with a University IT group and I'm
having a little trouble with a database I'm working with. Here's the
deal: because all computer component shipments are sent to the location
I'm working in, it's our responsibility to order AND receive all the
inventory we get from vendors.

Currently, the deliveries are scanned (the PO number is usually
barcoded on the package) and recorded into an Excel spreadsheet. Since
we have a record of the order in an Access database, what we're trying
to do is design a process where the package, when scanned,
automatically updates the record in the Access database by populating a
"Received?" field, or something like that.
Anyone know if this is possible? Thanks in advance!

JT

I don't know if this will help but...

Do a File/GetExternalData/Link. When the File/Open dialog is presented,
select FileType as Excel, then select the Excel file with your scanned
data then accept the link.

The Excel file will now be a table in your database. You can set a
relationship to the order number in a query.
Nov 13 '05 #2

P: n/a
Just as a point of clarity here: when we're receving inventory
(actually taking the packages and scanning them into our Excel
spreadsheet), we're usually accepting a large amount of merchandise
from several different vendors. So, the ideal process would be to scan
all of the inventory we receive into the Excel spreadsheet, then
automate a process where the data in the spreadsheet is scanned, and
the appropriate records are updated in the database. Additionally, we'd
eventually like to scan the packages directly into Access (without
bringing up the individual work order/record), but that's a little
further down the road.

Again, thanks in advance.

JT

JohnnyTruant wrote:
Ladies and Gentlemen,

I recently took a new position with a University IT group and I'm
having a little trouble with a database I'm working with. Here's the
deal: because all computer component shipments are sent to the location I'm working in, it's our responsibility to order AND receive all the
inventory we get from vendors.

Currently, the deliveries are scanned (the PO number is usually
barcoded on the package) and recorded into an Excel spreadsheet. Since we have a record of the order in an Access database, what we're trying to do is design a process where the package, when scanned,
automatically updates the record in the Access database by populating a "Received?" field, or something like that.
Anyone know if this is possible? Thanks in advance!

JT


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.