An estimate of time to do this?

[Guest]

I would like to create a search form that generates a report based on what
the user searches. It has to have a specific format, which follows:

Sort By: (Limited options will be in here like a drop down box i.e. SS#,
last name, by case number, etc)
Criteria type: (Check box list that enables the fields below so multiple
types of info can be sorted for)
Case Number: (Format AYY-000)
Name: (Can enter part of name and should generate all matches)
Investigator: (Limited by the employees in the department)
Incident Type: (Limited list)
SS#: (Exact match)
Display: (This option gives them a limited list of about 4 fields to display
on a single line for each of generated matches)

I have tried showing and pleading with them that Access has built in tools
that can do just about everything they would need. But it has been demanded
of me that it must have this format AND be done by the December 19th, 2005.
So I am at a stalemate, I have been trudging through VB snippets to see if I
can pick up enough to do something like this but, while it is fun, it is
consuming too much time.

I have three tables that I work from, one main massive table, one payment
table that has many records based on a single record from the main table, and
one table that keeps track of initial balances and calculated balances based
on payments entered.

I think I have an idea how to go about it but I really want to know what
experts think of the time this would take, assuming my knowledge of Access is
moderate, but shallow on the VB end?

Sorry for the length

 

[Gina Whipp]

If it were me... If the database were already set up it would be a matter
of creating a form then a report based on the criteria selected from the
form about an hour or less if the database was correctly set up already.
Hard to answer if the database has not been set been set because setting a
database can take 1 day to 1 year depending on what's required.

On another note if this is 'sensitive' information aas it looks like (SS#'s)
then I wouldn't do it in Access if it sits on a public network or any kind
of network at all. Access is (in my humble opinion) not the place to store
'sensitive' information.

HTH

 

[Guest]

Thanks that does help a lot. I thought Access was secure enough, but I am
new to it so it was not saying much. We do however have a vendor coming in
doing the same thing that is an industry standard but this is an interim
solution till they get theirs tailored to us. I am having a hard time even
getting the normal menu 'Find' dialog box to come up correctly, without
trying to search the entire DB file. So may take me a good bit more than an
hour, but now I have a basis.

Thank you again.