M
monroe via AccessMonster.com
I am trying to create a dtb for tracking all incoming calls at my office.Its
working ATM but want to simplify?
a. Basing combo boxes on another’s selection ie
Drop down list 1- row source type is table/query<single column table>
–Calling (has a list of peoples names that frequently call in)
Drop down list 2- row source type is table/query <single column table>-
Company (list of co’s from the people in the above list)
I want drop down list 2 to automatically bring up the company that persons
name in drop down 1 is affiliated with
b. Automatically putting in the name/co of someone new to drop down
lists 1 & 2. As of now, anyone new calling in, I have to go back manually and
type in their name and then their co into their source tables. Its not that
big of deal but just takes a lot of time that I could spend doing something
else.
c. Some of the people calling in are from management’s co.'s that
oversee different properties. Is it possible to add a drop down #3 list that
will list any properties that the co. in drop down 2 own?
d. Automatically add the date and time for each call on a new record. Just a
time saver :b
I’ve been trying to figure these things for a while now and I just can’t
wrap my brain around it when the code stuff comes into it. If someone could
please explain this (simply plz as i don't understand the code stuff yet!) I
would appreciate it TONS!
Just a bit more info if it helps:
All the tables:
Calling (single column source)
Company (single column source)
For (single column source)
Log:
Fields:
Date
Time
For
Calling
Company
Number
Nature of Call
Delivered
Follow up
Auto #
Also, I print out weekly reports and daily ones on occasion. I have those ok,
but I can't figure out a code that will automatically update it from week to
week so I don't need to go into the query.
Less time spent on the phone is more spent getting work done, so I am just
trying for as many shortcuts as possible.
Access 2000 Pro
Thank You So V. Much!
working ATM but want to simplify?
a. Basing combo boxes on another’s selection ie
Drop down list 1- row source type is table/query<single column table>
–Calling (has a list of peoples names that frequently call in)
Drop down list 2- row source type is table/query <single column table>-
Company (list of co’s from the people in the above list)
I want drop down list 2 to automatically bring up the company that persons
name in drop down 1 is affiliated with
b. Automatically putting in the name/co of someone new to drop down
lists 1 & 2. As of now, anyone new calling in, I have to go back manually and
type in their name and then their co into their source tables. Its not that
big of deal but just takes a lot of time that I could spend doing something
else.
c. Some of the people calling in are from management’s co.'s that
oversee different properties. Is it possible to add a drop down #3 list that
will list any properties that the co. in drop down 2 own?
d. Automatically add the date and time for each call on a new record. Just a
time saver :b
I’ve been trying to figure these things for a while now and I just can’t
wrap my brain around it when the code stuff comes into it. If someone could
please explain this (simply plz as i don't understand the code stuff yet!) I
would appreciate it TONS!
Just a bit more info if it helps:
All the tables:
Calling (single column source)
Company (single column source)
For (single column source)
Log:
Fields:
Date
Time
For
Calling
Company
Number
Nature of Call
Delivered
Follow up
Auto #
Also, I print out weekly reports and daily ones on occasion. I have those ok,
but I can't figure out a code that will automatically update it from week to
week so I don't need to go into the query.
Less time spent on the phone is more spent getting work done, so I am just
trying for as many shortcuts as possible.
Access 2000 Pro
Thank You So V. Much!