473,322 Members | 1,566 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How to create new fields in a form on the fly

18
Hi everyone,
I am trying to create an access database for reporting in my division, and I need to be able to create new fields in a form as they get used. For example, if someone fills in a particular date field, I need to keep that date field, but add a new date field right below it in the form. This is because the commitment dates for certain projects can be changed, but the old dates need to be kept. I am pretty new to access and VB, but I am very good at Java and C. Any help would be appreciated.

Thanks
May 20 '10 #1

✓ answered by missinglinq

You really can't do this! Stop and think about it. You're not talking adding a field to the form, you're talking about adding a field to the record, which means to every record in the underlying table! If one project had, say 12 dates, every record would have 12 date fields!

You have two choices here. If you have a finite number of revision dates, say four or five, you can simply add these fields to the underlying table and only use them if needed. If you cannot guess at a maximum number or the number can be extremely large, you need to create a separate table for holding the commitment dates, with a data field and a project ID field. You'd then have to use this table as the basis for a subform on your main projects form.

Welcome to Bytes!

Linq ;0)>

4 2908
missinglinq
3,532 Expert 2GB
You really can't do this! Stop and think about it. You're not talking adding a field to the form, you're talking about adding a field to the record, which means to every record in the underlying table! If one project had, say 12 dates, every record would have 12 date fields!

You have two choices here. If you have a finite number of revision dates, say four or five, you can simply add these fields to the underlying table and only use them if needed. If you cannot guess at a maximum number or the number can be extremely large, you need to create a separate table for holding the commitment dates, with a data field and a project ID field. You'd then have to use this table as the basis for a subform on your main projects form.

Welcome to Bytes!

Linq ;0)>
May 20 '10 #2
cmbirk
18
Thanks a bunch... I used a subform for multiple items and it works great... easy fix
May 20 '10 #3
missinglinq
3,532 Expert 2GB
That's the way to go when you need an undefined number of fields holding essentially the same type of data, as was the case here. the Glad we could help!

Linq ;0)>
May 20 '10 #4
cmbirk
18
Now I have a main form with a project ID, and a multi-input form for each date change. I need to report on these IDs. Is there a way to group on the ID in the main form, and include the subform reports under each main ID?... That is, If I have ids 23, 43, and 54... can I group the main report on these IDs, and only include their corresponding subform reports in the grouping?

Thanks
May 20 '10 #5

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

Similar topics

1
by: shank | last post by:
I need advice on how to get started with this project. I want a page where a user can manually enter an order. Our users know our order# system and it's much easier to manually enter items as...
1
by: Don Stefani | last post by:
Hello, I have a form that I want to submit "onchange", OK I've got that working, but when the form submits, I want to pass along a value to a CGI script, as if that value was in a hidden form...
4
by: Jimmer | last post by:
How does one create/change a form on the fly? I have a situation where I would like the user to be able to determine the fields they view and how the data is grouped at runtime. For example,...
1
by: sunrisewinesalon | last post by:
New here--I posted this to another group called 'ms access problems,' but it only had one member... Access says you can choose fields from more than one table or query to create a form--but can...
1
by: VM | last post by:
I would like to display a child form inside of an MDI but the problem is that I'll be invoking that child form from within another child form. If I use this code: frmReportViewer frmReportViewer =...
0
by: vareck.walla | last post by:
I get this error everytime I run my project: System.InvalidOperationException was unhandled Message="An error occurred creating the form. See Exception.InnerException for details. The error is:...
2
by: ghadley_00 | last post by:
Hi, I have a form that collects information about up to 5 items. I would like the user to be able to select from a drop down menu how many items for which they want to compare information, and...
4
by: zazu | last post by:
I have followed the procedure for creating a form for supplying parameters to a query – http://office.microsoft.com/en-us/assistance/HA011170771033.aspx However when the query is run I still...
3
by: wolverines1 | last post by:
Problems with creating a form from two tables, in access. The data won't come from the on of the tables. Need guidance. All data is under A, but when I make a form B, none of the data comes over...
2
by: adwest | last post by:
Forgive me if this is a foolish question. I "play" in Access and have only created a few rather simple relational databases. My knowledge and experience is limited. I have no formal training, just...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.