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
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
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)>
Thanks a bunch... I used a subform for multiple items and it works great... easy fix
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)>
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
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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,...
|
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...
|
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 =...
|
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:...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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
|
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...
| |