Cool Lilliabeth. I'll implement that suggestion. How do they create a new note in the form section? Right now I just have a memo field that they can "edit" in a sense by entering into the field and change it over and over again. Would you recommend creating a new form dedicated to entering in...
Wow this is really cool! Lilliabeth thanks for the help. Do you know of any way to save these "LastModifiedBy" and "LastModifiedDate" changes so they become permanent? In other words when someone enters some more information in the Memo field and they create a time stamp and created by stamp is...
Hey Lilliabeth, thanks for clarifying. Your suggesstion really helped. I understand for the most part whats going on with your code. How do you have that set up on your form? Do you have a text box that shows who last updated the information? Could you upload an image of your form or another...
Thanks for the help but it turns out my company doesn't need this feature anymore. I'm rather surprised MS Access didn't make this a central feature in their 2010 version. I would think I'm not the only person who wants this as a feature in the database. Oh well. Thanks again.
Hey thanks Lilliabeth. I know this is a little risky but this is really helpful for me. I've successfully linked the two tables and understand the relationship.
Here's my new question:
The ID from "tblPatients" links seamlessly with ID from "tblMemo". So any notes made for Patient ID#1 go...
Hello Everyone,
I've been struggling with a VB error I keep getting. The error is a "Compile Error: Method or data not found".
I found the code on an old thread here.
Here's the link: http://tek-tips.com/viewthread.cfm?qid=1646328
I'm trying to do the same thing as what says in the post...
Thanks Duane,
Your post will help me. Would you mind helping me out with another tip?
Here's what I have:
Patient Table
- PK is an automated ID number
- I can enter in a patients last name, and first name, and a lot of other information.
Memo Table
- PK is also an automated ID number (not...
Hey all. Here's my problem:
I have a medical patient database and I want to create memos for each patient. Right now I have a Patient Table with a Memo Field and have a Form to enter patient information as well as customized notes.
I've been reading on the internet that it's better to have a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.