find an Access template to track repeating orders

[doggydan]

I get repeating orders from several sources. I would like to have them in a
data base (entered by order number and item code) so I can tell when I sent
them in, and when I get paid for them ...

I am not smart enuf to figure out this whole thing. I have it in an excel
sheet, but I have to do individual searches for each item. There might be
100+ items in each week, and I dont get paid sometimes for 45 days.

Help

 

[Stephen Knapp]

Dan:
I scan old newsgroup postings for those that have only their initial
inquiry, to determine why no one bothered to react to your question, issue,
or concern. If you have not already resolved your "find an Access template
to track repeating orders" problem, I have a suggestion.
You posted this question in the "Access Database Design" newsgroup but
you didn't specify whether or not you intend to use Access or keep your
tracking system in Excel. Keep in mind that while Access is an excellent
tool for complex database designs, it is really appropriate for multi-user
involvement. If you are the only user and if you aren't working complex,
multiple data structures, then you might want to consider keeping your
application in Excel.
If you know how to program in VBA, a couple of Excel forms would
probably suffice to help you navigate through your order data. If not, a
bunch of macros could be devised to help you, you'll just have to do more
typing to run the different macros. Build one for a date search (give me all
orders placed before or after some date) or by order number or order number
range. Macros can be used to set filters or perform sorts (or just about
anything you can do in "regular" Excel.
I hope that this gives you a clue.
On your original posting, you should click the YES or NO buttons to
close out that entry on the system.

Steve in Ohio