Save a file based on 4 variables?

M

Martin

I need to be able to save a file and retrieve using four variables. I want to
have an Excel file saved based on: Today's date (the day I'm saving), Another
imputed date, name, and location. I want to the be able to retrieve a group
of files based on the variables.

For instance I have a file that I want to save: I impute today's date in the
first field (Dec 30, 05), I impute the date on the invoice in the next field
(Nov 23, 05), I impute the customers name (Blow, Joe), and I impute the
location of the customer in the last field (California or CA). When there are
multiple files in the database, I would like to be able to retrieve files
based on those variables, ie: Give me all the files with the location of
"California", Invoiced between "June 30,05 and July 30,05".

I'm not sure if Access will do this, but if it does, I'm hoping there is a
template. I do not know how to use Access yet. If there is no templates to do
this then does anyone have a suggestion for a purchased solution.

Thank you very much for your time,

Vaughan
 
L

Larry Linson

Martin said:
I need to be able to save a file and retrieve using four variables. I want
to
have an Excel file saved based on: Today's date (the day I'm saving),
Another
imputed date, name, and location. I want to the be able to retrieve a
group
of files based on the variables.
Click to expand...

I am certain you meant to type "input" (to enter, to type in) rather than
"impute" (for the meaning of which, use Google). So, if I understand what
you want to do: you have an Excel spreadsheet which you want to be able to
find by multiple values: two different dates, a name, and a location. It
will be simple to create a table with Fields for the two dates, name, and
location, and a field identifying the path-and-filename where the Excel
spreadsheet is stored.

It will also be simple to create a form to allow the user to enter the
values you describe, and simple to create another form where the user can
enter or choose values by which to search and return the path-and-filename
of the Excel spreadsheets that match the search values.

Although it is possible to actually store the Excel spreadsheets in the
Access database, I don't see a need to do so. I would suggest they simply be
stored as files, and the Access database used to find them, and open them in
Excel.
For instance I have a file that I want to save: I impute today's date in
the
first field (Dec 30, 05), I impute the date on the invoice in the next
field
(Nov 23, 05), I impute the customers name (Blow, Joe), and I impute the
location of the customer in the last field (California or CA). When there
are
multiple files in the database, I would like to be able to retrieve files
based on those variables, ie: Give me all the files with the location of
"California", Invoiced between "June 30,05 and July 30,05".

I'm not sure if Access will do this, but if it does, I'm hoping there is a
template. I do not know how to use Access yet. If there is no templates to
do
this then does anyone have a suggestion for a purchased solution.
Click to expand...

There's no valid business model for anyone to create "templates" for Access
databases, other than Microsoft, and I am reasonably sure that there is no
such template in the Microsoft library. I would also not expect to find an
example database that fits your requirements in all respects.

There are many participants here who could create a custom solution for you,
in Access. Many of us do not consider it proper to solicit work in the
newsgroups, and I would not even consider making a public recommendation
here. I'd suggest you look at various answers in this and other Access
newsgroups and contact some who seem to know what they are talking about. I
would recommend that you only consider those who _you_ contact, not ones who
scent an opportunity and rush to contact _you_.

Please Note: I am not a candidate to do the work... so it is as well that I
do not provide a valid e-mail address in newsgroup responses.

On the other hand, if you want to expend a little time and effort learning
something about Access, you are likely to be able to get significant free
assistance here in the newsgroup.



Larry Linson
Microsoft Access MVP
 
Top