473,513 Members | 2,709 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

HELP! Multiple entries for a field or adding fields (by end user)

1 New Member
Not sure of the best way to do this, but here is what I am shooting for.
Basically, I am creating a DB for Project Management. I want the co workers to be able to make comments, and update those comments on an on going basis (and projects change).

So when a project in entered for the first time, we can make any notes on that project. But if something changes (like after a meeting) updates (comments specifically) can be made. I want to always keep the comments and only add to it..not edit existing (like a paper trial). the idea is that if a co worker is out, or you manager wants a project status, the can get the information from Access.

Also, I'm trying to do this from a Data Access Page. This will be published on an IIS Server.

thank in advanced for you help.
KJ
Jun 28 '07 #1
1 1287
MMcCarthy
14,534 Recognized Expert Moderator MVP
Create a new table for the comments with a foreign key reference to the main table. Add a continuous subform to the main form to allow the comments to be added as records.
Jul 4 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2195
by: Roy Adams | last post by:
Hello people I've recently been woring with multiple insert from text fields and got that woking fine thanks to the help from people from this forum now i'm trying to deal with multiple update,...
2
2902
by: Gail Zacharias | last post by:
I am investigating the possibility of using pgsql as the database in an application. I have some unusual requirements that I'd like to ask you all about. I apologize in advance if my terminology is...
1
1950
by: ccr | last post by:
Please view in a text editor so that the columnar text lines up. I used Terminal 9pt font to compose this post and copied/pasted to my newsreader program. I am writing in the hope that one of...
1
1814
by: ccr | last post by:
Reposted with a longer line length. Apologies if I did not cancel the 1st attempt before you got it. If necessary, please view in a text editor so the columnar text lines up. I used Terminal...
1
1218
by: RSB | last post by:
Hi all, Sorry for asking to many questions.. one more problem. i have a Form and in that form i am adding a user control "myUserControl" which has two text boxes. textbox1 and textbox2. ...
6
4365
by: anoj | last post by:
Hi All i need to prevent multiple logins from the same user at the same time. what is the best way to do this . How can i detect if a user closes the browser window without logging out so tht...
3
11231
by: Bernard Lebel | last post by:
Hello, Is there an option or a way to allow the selection of multiple entries in the Listbox widget? I could not find any, and would like to allow the end user to select multiple entries. ...
8
1822
by: Kasghost | last post by:
I am trying to create a DB in Access 2007 where the values in certain fields requires multiple entries. I would like to send this DB out as an HTML to my techs and have them fill the information...
3
1605
jenkinsloveschicken
by: jenkinsloveschicken | last post by:
I apologize for the rudimentary post, however I have a bit of a problem. I have been tasked with developing reporting for a ticketing system. Development has provided me with a rough output form of...
0
7254
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7153
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7432
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7519
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5677
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4743
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3218
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1585
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
796
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.