Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Forms and data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pat-UK - 12 Mar 2008 10:47 GMT
Good Morning, First time here so be gentle please,

A few years ago I did a HND in Computing and was quite into Excel, and
seem to remember using forms to input data and get report type outputs,
THIS WAS DEFINATLY NOT DONE IN ACCESS.

I have been asked by a friend if It is possible to create a form based
excel file that can be used to log incoming call information such as
the following

Time/Date of call Autofilled
What it was about
Who it was for
Action to be taken
Resolved Y/N

I know this is so easy to do in access, but she doesn't have access
only excell, and her boss won't pay for it. this is not for a
commercial use as such, it's just to make her life easier in her
totally disorganised office.

If it is possible then i'll carry on digging to find out how, if not
then i'll give up now and tell her she's still on the pen and paper
method.

Many Thanks

Signature

Pat-UK

Pat-UK - 12 Mar 2008 17:31 GMT
Pat-UK;638261 Wrote:
> I have been asked by a friend if It is possible to create a form base
> excel file that can be used to log incoming call information such a
[quoted text clipped - 6 lines]
> Resolved Y/N
> Many Thanks

Well I decided that I was gonna go ahead with it anyhow and have don
most of it, , the form is working as required, the date and time ar
auto filling as they should, just gotta play with the pivot chart shee
to get it to display and print a daily list and i'm happy.

Any points that can be thown at me then please feel free.

Many Thank

--
Pat-UK

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.