In over my head

I have played around with Access but don't have a firm grasp of it. I bought
a couple of Access books, Using MS Access 2007, Access 2002 Desktop
Developer's Handbook & Access 2005 Comprehensive Concepts & Techniques. I
have Access 2007 on my home computer & Access 2003 on my work computer.

I have been working on a database for our agency to track enter seized items
and keep track of them. I have created the database, but it does not work
properly. I want the user to be able to enter a new case number and if the
case does not exist then it allows them to enter the information for the new
case. Once that form opens and they add the new information, they can go to
another form (pre-search form) where they input the information specific to
that case. I have a subform embedded on this form that should updated
automatically. It doesn't. Also, what happens when I enter test data, the
information entered into the pre-search is wiped out and a new record is
created.

I am willing to zip the database to anyone who wants a challenge. Like I
said, I am in over my head.

The newsgroups generally focus on helping folks with more specific issues,
rather than developing other folks applications. These newsgroups are
"staffed" by volunteers. You may or may not get someone willing to accept a
file from someone they don't know, then invest the time to develop the
functionality you seem to be asking for.

If this is urgent, also consider hiring someone ...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"mrrherrera" wrote in message
...
I have played around with Access but don't have a firm grasp of it. I
bought
a couple of Access books, Using MS Access 2007, Access 2002 Desktop
Developer's Handbook & Access 2005 Comprehensive Concepts & Techniques. I
have Access 2007 on my home computer & Access 2003 on my work computer.

I have been working on a database for our agency to track enter seized
items
and keep track of them. I have created the database, but it does not work
properly. I want the user to be able to enter a new case number and if
the
case does not exist then it allows them to enter the information for the
new
case. Once that form opens and they add the new information, they can go
to
another form (pre-search form) where they input the information specific
to
that case. I have a subform embedded on this form that should updated
automatically. It doesn't. Also, what happens when I enter test data,
the
information entered into the pre-search is wiped out and a new record is
created.

I am willing to zip the database to anyone who wants a challenge. Like I
said, I am in over my head.

I understand. I think I found a post that helps with one issue. Which was
the lookup of an existing record. Now, I need to keep looking for one that
helps me with the auto updating of the subform.

"Jeff Boyce" wrote:

The newsgroups generally focus on helping folks with more specific issues,
rather than developing other folks applications. These newsgroups are
"staffed" by volunteers. You may or may not get someone willing to accept a
file from someone they don't know, then invest the time to develop the
functionality you seem to be asking for.

If this is urgent, also consider hiring someone ...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"mrrherrera" wrote in message
...
I have played around with Access but don't have a firm grasp of it. I
bought
a couple of Access books, Using MS Access 2007, Access 2002 Desktop
Developer's Handbook & Access 2005 Comprehensive Concepts & Techniques. I
have Access 2007 on my home computer & Access 2003 on my work computer.

I have been working on a database for our agency to track enter seized
items
and keep track of them. I have created the database, but it does not work
properly. I want the user to be able to enter a new case number and if
the
case does not exist then it allows them to enter the information for the
new
case. Once that form opens and they add the new information, they can go
to
another form (pre-search form) where they input the information specific
to
that case. I have a subform embedded on this form that should updated
automatically. It doesn't. Also, what happens when I enter test data,
the
information entered into the pre-search is wiped out and a new record is
created.

I am willing to zip the database to anyone who wants a challenge. Like I
said, I am in over my head.

As another alternative, post the issue you are working on, what you've
tried, what happened, and what environment you are working in (e.g., Windows
XP, Access 2003, ...)

Folks here in the newsgroups can offer their assistance if they know what
the topic is...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"mrrherrera" wrote in message
...
I understand. I think I found a post that helps with one issue. Which was
the lookup of an existing record. Now, I need to keep looking for one
that
helps me with the auto updating of the subform.

"Jeff Boyce" wrote:

The newsgroups generally focus on helping folks with more specific
issues,
rather than developing other folks applications. These newsgroups are
"staffed" by volunteers. You may or may not get someone willing to
accept a
file from someone they don't know, then invest the time to develop the
functionality you seem to be asking for.

If this is urgent, also consider hiring someone ...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"mrrherrera" wrote in message
...
I have played around with Access but don't have a firm grasp of it. I
bought
a couple of Access books, Using MS Access 2007, Access 2002 Desktop
Developer's Handbook & Access 2005 Comprehensive Concepts & Techniques.
I
have Access 2007 on my home computer & Access 2003 on my work computer.

I have been working on a database for our agency to track enter seized
items
and keep track of them. I have created the database, but it does not
work
properly. I want the user to be able to enter a new case number and if
the
case does not exist then it allows them to enter the information for
the
new
case. Once that form opens and they add the new information, they can
go
to
another form (pre-search form) where they input the information
specific
to
that case. I have a subform embedded on this form that should updated
automatically. It doesn't. Also, what happens when I enter test data,
the
information entered into the pre-search is wiped out and a new record
is
created.

I am willing to zip the database to anyone who wants a challenge.
Like I
said, I am in over my head.