G
Guest
I have a phone log database, (i may have posted this b4, but i cannot find
it) heres the setup:
date
time
For ( drop down table, single column)
Calling (drop down table, single column)
Company (drop down table, single column)
Return Number
Nature of call (memo)
Delivered ( drop list:msg taken, desk, telemarketer, lost conection, etc.)
Follow-up Actions (memo)
(atuo #)key*
category (table, dropdown): work orders, customer inqurierys, current
customer services, etc.
(office 2000)
Ok, what I'm trying/wanting to do:
1. when someone named 'bob' calls, i want to be able to seltect 'bob' from
Calling feild and any Company a 'bob' works for comes up, giving me few
options to have to look thru if more than one. ie , it automatcially looks up
Bob's Carpet and selects it the company field for me- saving me precious
seconds lol
2. Is it possible to have the time and date fields (seperate) to
automatcialy update themselves whenever i've gone to a new one, or if its
sitting for a while, it'll upate it when i start typing in the for field?
...and it'll stay the right time and right date on each record because i print
a report at the end of the week??
3. When someone new calls in or someone that just isn't in the dtb yet, is
there a way to save them into the dtb? like atm i have to print a list of
everyone who's called and then go back into the tables and stuff to type
everything in..with the calling, for, & comapny feilds, which just wastes a
lot of time i can be doing something else. and it'll work with question #1??
kinda please be simple in explaining. i've been working w/ access for nearly
8 years but i'm still learning everyday, i know enough to get me by but not
enough to say i know alot.
THANKS ALL! ;D
it) heres the setup:
date
time
For ( drop down table, single column)
Calling (drop down table, single column)
Company (drop down table, single column)
Return Number
Nature of call (memo)
Delivered ( drop list:msg taken, desk, telemarketer, lost conection, etc.)
Follow-up Actions (memo)
(atuo #)key*
category (table, dropdown): work orders, customer inqurierys, current
customer services, etc.
(office 2000)
Ok, what I'm trying/wanting to do:
1. when someone named 'bob' calls, i want to be able to seltect 'bob' from
Calling feild and any Company a 'bob' works for comes up, giving me few
options to have to look thru if more than one. ie , it automatcially looks up
Bob's Carpet and selects it the company field for me- saving me precious
seconds lol
2. Is it possible to have the time and date fields (seperate) to
automatcialy update themselves whenever i've gone to a new one, or if its
sitting for a while, it'll upate it when i start typing in the for field?
...and it'll stay the right time and right date on each record because i print
a report at the end of the week??
3. When someone new calls in or someone that just isn't in the dtb yet, is
there a way to save them into the dtb? like atm i have to print a list of
everyone who's called and then go back into the tables and stuff to type
everything in..with the calling, for, & comapny feilds, which just wastes a
lot of time i can be doing something else. and it'll work with question #1??
kinda please be simple in explaining. i've been working w/ access for nearly
8 years but i'm still learning everyday, i know enough to get me by but not
enough to say i know alot.
THANKS ALL! ;D