Automating Queries

R

Rick Deemer

I have to implement some tables for our shipping department. I know the
table that holds the shipping data in our system, which will be pulled from
the system using ODBC, but I have a few problems in figuring out the best
way to accomplish this task.

My problem is we use 2 distinct companies for our orders. So each company
will have a unique table containing the data for shipping their orders but
we have only one shipping department. What I would like to do is to make
copies of the tables, then merge them to be one single table. Next, copy
this merged table to an accessible place so that when the order comes
through, it can be scanned with a barcode reader, which will pull up the
shipping information, and the delivery information will be populated. The
additional issue with all of this is that because orders are constantly
being added to the system, I need to have a way of automating this so that
it runs on a fairly quick schedule approximately every 30 minutes or so.
Can this be done?
 
M

MGFoster

Rick said:
I have to implement some tables for our shipping department. I know the
table that holds the shipping data in our system, which will be pulled from
the system using ODBC, but I have a few problems in figuring out the best
way to accomplish this task.

My problem is we use 2 distinct companies for our orders. So each company
will have a unique table containing the data for shipping their orders but
we have only one shipping department. What I would like to do is to make
copies of the tables, then merge them to be one single table. Next, copy
this merged table to an accessible place so that when the order comes
through, it can be scanned with a barcode reader, which will pull up the
shipping information, and the delivery information will be populated. The
additional issue with all of this is that because orders are constantly
being added to the system, I need to have a way of automating this so that
it runs on a fairly quick schedule approximately every 30 minutes or so.
Can this be done?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You should have all the shipping data in one table w/ a column that
indicates which company (which it seems you're trying to do
programmatically). Then just access the table via an inter/intranet
without copying the data to another table.

If you can't modify the current 2 tables into one table, you can use a
View (aka Query) w/ a UNION of the 2 tables. Unfortunately, this View
will not be updateable (UNIONs are not updateable). Then you can access
the View (Query) from the barcode scanner terminal. The View should
always be current. You may have to refresh it (Records > Refresh) or
requery it (using VBA code: Me.Requery - assumes the View is the
RecordSource of a form).

The terminal with the barcode scanner has to be on a network that can
"see" the Access data. The data should be in a separate file - IOW, the
application was split (see "splitting the database" in the Access Help
file).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQwoyE4echKqOuFEgEQJUwACg4mBZWC+2Grh5xcf0RGwHqc5p/gAAnjtQ
4ypSXDs0/KyKnh3tx91Vhs3O
=Kaq1
-----END PGP SIGNATURE-----
 
Top