Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Access 2010 Problem will creating comments


(!)

PooBear's Avatar
PooBear PooBear is offline
Member with 3 posts.
THREAD STARTER
 
Join Date: Aug 2012
Location: Dallas, TX US
Experience: Beginner
18-Aug-2012, 11:36 AM #1
Smile Access 2010 Problem will creating comments
Greetings to all,
I am new to Access and very blue in the face. I trying to build a very simple case mgmt type database that will allow me to type comments/history on an existing record each time the record is accessed. I would like to include who posted the comments, date posted, and a follow up date. Thank you for any assistance.

Operating system - windows 7
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,545 posts.
 
Join Date: Mar 2005
Location: UK
18-Aug-2012, 12:38 PM #2
PooBear, welcome to the Forum.
So how are you currently trying to do this?
PooBear's Avatar
PooBear PooBear is offline
Member with 3 posts.
THREAD STARTER
 
Join Date: Aug 2012
Location: Dallas, TX US
Experience: Beginner
18-Aug-2012, 04:04 PM #3
Thank you.
Access 2010 - I hope I understood the question.

I created a history table. Then I created a history form. Then I read in an Access book that I could create subform continously, but it just doesn't work for me or I am probably not comprehending correctly. Then I created a time table to track my time which I got it to compute, finally. I am piece milling each action and hopefully can put it all together on one.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,545 posts.
 
Join Date: Mar 2005
Location: UK
19-Aug-2012, 06:32 AM #4
If you want more than one comment per Case there are basically 2 ways to do it.
The normal way is to have a separate table for the comments with the Case key field Number and the comment, you create a subform based on the new table and add it to the Case main form.
The second method involves using a "Memo" field in the maintable and using VBA code to add data to it. This is a much more advanced technique.
__________________
OBP
I do not give up easily
PooBear's Avatar
PooBear PooBear is offline
Member with 3 posts.
THREAD STARTER
 
Join Date: Aug 2012
Location: Dallas, TX US
Experience: Beginner
19-Aug-2012, 12:18 PM #5
Thank you. I will continue to try the subform. Thanks again.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑