Right now at work, I get forms e-mailed to me in an Excel chart with a
serial number in one column and a new expiration date for a device's
trial period in another column.
For a while, when people only sent forms with one or two lines, I
didn't mind making a simple parameter query that searched for a serial
number (ESN) and showed me the relevant line of my office's tracking
database so I could change the date, etc.
Here's how it looks:
http://klg.cps.com/temp/googlegroups/accesscurrent1.gif
http://klg.cps.com/temp/googlegroups/accesscurrent2.gif
However, when I get 6-20 requests on the same form, it would be really
nice to just hilight the serial number column from the Excel form I
received...
http://klg.cps.com/temp/googlegroups...ionrequest.gif
....paste it into a form or something in Access, and have a query pop up
that shows the relevant lines of my database for all of those serial
numbers.
I have searched every keyword on Google Groups and Google that I can
think of. I've looked in reference manuals. I'm just plain stuck and
can't figure out how to do this.
If I'm asking in the wrong place, please redirect me. Thank you.
-KitKat