Simple problem, simple answer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’m no expert in MS Access but I’m not a complete noob. Even though every
once in a while I get stuck on something so simple, such as my current
problem. To make a long story short I have a call log database to log
information for later statistical uses. My fields are as follows: ID, Date,
Start time, Callers name, Town, Software, comments, receiver, Call length,
and end time. Up intil now I have had a form that on opening it inputs the
current time then the user enters Callers name, Town, Software, and comments
then closes the form which enters the end time. Well I now need the Database
enter the software automatically when I select the town. For example, When I
select the town of Concord it will also select Avitar. Any thoughts on how to
do it? Each town have different software, keep in mind.

What I have done is take my town table and added a second column that has
that towns corresponding software companies already in it.
 
The simple answer is that you don't need to put the software into the table.
IF (notice the big IF) each town always and will always have its own
software, just knowing the town is enough. Your Town table that has a list of
towns and software. Use the DLookup function to show the Software on a form
or link the two tables together to show the name in reports.

=DLookup("[Software]", "TOWNS", "[Town] =" & Forms![Logs]![Town])

Of course this whole house of cards collapses if a town ever has more than
one software product.

On a similar note, Call length should not be stored in the table either. You
have the start time and end time so you can readily compute the Call length
when needed. Actually you don't need the Date field if you store both the
date and time in both the Start Time and End Time fields!
 
As far as the date and call length I knew that and I’m working on that for a
later process. Secondly, the town will never have more than one software.
It’s either state implement or third party. I need to pull my quires the
exact way I am right now by software. Any ways I think you are on the right
path... now where do I implement that code? Also can you explain the how the
function works? Such as the syntax so I can see if I can if I just need to
tweak that code you gave me?

Jerry Whittle said:
The simple answer is that you don't need to put the software into the table.
IF (notice the big IF) each town always and will always have its own
software, just knowing the town is enough. Your Town table that has a list of
towns and software. Use the DLookup function to show the Software on a form
or link the two tables together to show the name in reports.

=DLookup("[Software]", "TOWNS", "[Town] =" & Forms![Logs]![Town])

Of course this whole house of cards collapses if a town ever has more than
one software product.

On a similar note, Call length should not be stored in the table either. You
have the start time and end time so you can readily compute the Call length
when needed. Actually you don't need the Date field if you store both the
date and time in both the Start Time and End Time fields!
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Jeremy Corson said:
I’m no expert in MS Access but I’m not a complete noob. Even though every
once in a while I get stuck on something so simple, such as my current
problem. To make a long story short I have a call log database to log
information for later statistical uses. My fields are as follows: ID, Date,
Start time, Callers name, Town, Software, comments, receiver, Call length,
and end time. Up intil now I have had a form that on opening it inputs the
current time then the user enters Callers name, Town, Software, and comments
then closes the form which enters the end time. Well I now need the Database
enter the software automatically when I select the town. For example, When I
select the town of Concord it will also select Avitar. Any thoughts on how to
do it? Each town have different software, keep in mind.

What I have done is take my town table and added a second column that has
that towns corresponding software companies already in it.
Click to expand...
Click to expand...
 
The DLookup is something that you could put into an unbound text box on a
form or report. Actually a proper link to a report would be faster.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Jeremy Corson said:
As far as the date and call length I knew that and I’m working on that for a
later process. Secondly, the town will never have more than one software.
It’s either state implement or third party. I need to pull my quires the
exact way I am right now by software. Any ways I think you are on the right
path... now where do I implement that code? Also can you explain the how the
function works? Such as the syntax so I can see if I can if I just need to
tweak that code you gave me?

Jerry Whittle said:
The simple answer is that you don't need to put the software into the table.
IF (notice the big IF) each town always and will always have its own
software, just knowing the town is enough. Your Town table that has a list of
towns and software. Use the DLookup function to show the Software on a form
or link the two tables together to show the name in reports.

=DLookup("[Software]", "TOWNS", "[Town] =" & Forms![Logs]![Town])

Of course this whole house of cards collapses if a town ever has more than
one software product.

On a similar note, Call length should not be stored in the table either. You
have the start time and end time so you can readily compute the Call length
when needed. Actually you don't need the Date field if you store both the
date and time in both the Start Time and End Time fields!
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Jeremy Corson said:
I’m no expert in MS Access but I’m not a complete noob. Even though every
once in a while I get stuck on something so simple, such as my current
problem. To make a long story short I have a call log database to log
information for later statistical uses. My fields are as follows: ID, Date,
Start time, Callers name, Town, Software, comments, receiver, Call length,
and end time. Up intil now I have had a form that on opening it inputs the
current time then the user enters Callers name, Town, Software, and comments
then closes the form which enters the end time. Well I now need the Database
enter the software automatically when I select the town. For example, When I
select the town of Concord it will also select Avitar. Any thoughts on how to
do it? Each town have different software, keep in mind.

What I have done is take my town table and added a second column that has
that towns corresponding software companies already in it.
Click to expand...
Click to expand...
Click to expand...
 
I can't get this to work. Anyone wana try to program an example of how to do
this? I have an old version of my data base uploaded if someone would be
willing. The form I'm interested in changing is labled "call log". It
contains callers name, town, software, coments, and receiver. Currently the
software field pulls from software table but i would like it to pull from the
town table, collum two which would have the software type. This version is so
old though that the second colum isn't in there yet, but you can quickly add
it it. It dosn't matter whats in there but the fact that it will pull in that
information. You can download the DB at www.gradientventures.com/download
the file name is db progress.mdb Thank you every one! thank you very much.

Jerry Whittle said:
The DLookup is something that you could put into an unbound text box on a
form or report. Actually a proper link to a report would be faster.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Jeremy Corson said:
As far as the date and call length I knew that and I’m working on that for a
later process. Secondly, the town will never have more than one software.
It’s either state implement or third party. I need to pull my quires the
exact way I am right now by software. Any ways I think you are on the right
path... now where do I implement that code? Also can you explain the how the
function works? Such as the syntax so I can see if I can if I just need to
tweak that code you gave me?

Jerry Whittle said:
The simple answer is that you don't need to put the software into the table.
IF (notice the big IF) each town always and will always have its own
software, just knowing the town is enough. Your Town table that has a list of
towns and software. Use the DLookup function to show the Software on a form
or link the two tables together to show the name in reports.

=DLookup("[Software]", "TOWNS", "[Town] =" & Forms![Logs]![Town])

Of course this whole house of cards collapses if a town ever has more than
one software product.

On a similar note, Call length should not be stored in the table either. You
have the start time and end time so you can readily compute the Call length
when needed. Actually you don't need the Date field if you store both the
date and time in both the Start Time and End Time fields!
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

I’m no expert in MS Access but I’m not a complete noob. Even though every
once in a while I get stuck on something so simple, such as my current
problem. To make a long story short I have a call log database to log
information for later statistical uses. My fields are as follows: ID, Date,
Start time, Callers name, Town, Software, comments, receiver, Call length,
and end time. Up intil now I have had a form that on opening it inputs the
current time then the user enters Callers name, Town, Software, and comments
then closes the form which enters the end time. Well I now need the Database
enter the software automatically when I select the town. For example, When I
select the town of Concord it will also select Avitar. Any thoughts on how to
do it? Each town have different software, keep in mind.

What I have done is take my town table and added a second column that has
that towns corresponding software companies already in it.
Click to expand...
Click to expand...
Click to expand...
 
Thank you Ken that is EXACTLY what im looking for. Although i can not get it
to work, the direction could not be more clear. I think that it has to do
with this "converted" verison that im testing it on. I use 97 at work and
2003 at home so i think thats giving me the problem so i will give it a try
at work on monday. It makes perfect sense! i know it was a simple one.
 
Back
Top