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
4  2925 
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 opposed to using a shopping cart and
flipping through multiple pages.
On the page would be the following....
1) Billing address
2) shipping address
3) fields for order numbers
|
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 element.
BUT, I don't want that value to be in the actual HTML form, I want it to be created in my
submit function.
For instance:
|
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, the form might list Company Name, Last Name, Address,
Phone Number, Accounts Payable $ on time and Last Name, Address, Phone
Number, Social Security, Accounts Payable $ the next and Company Name
and Accounts Payable $ the time after that. Each one...
|
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 you use fields from one of each?
Thanks
|
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 = new frmReportViewer();
//frmReportViewer.MdiParent = this;
frmReportViewer.Show();
It'll create the form but it won't be inside the parent MDI form.
| | |
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: Item has already
been added. Key in dictionary:
'System.Runtime.CompilerServices.CompilerGeneratedAttribute' Key being
added: 'System.Runtime.CompilerServices.CompilerGeneratedAttribute'"
Source="Interbase® Project 2006"
StackTrace:
|
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 then have the form
change the number of input fields accordingly.
In other words, if the user selects enter info for 3 items, then input
fields for only 3 items are shown, if they change it to 4 items, then a
fourth column shows up in the table...
|
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 get individual dialog boxes for each parameter, rather than a form with all the parameters. When I have specified a combo box I still get text box and instead of getting a label such as "Category" I get as a label
|
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 here. Tried to make a query, but same result.
There is a relation between the 2 forms, but I cant see what is wrong
|
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 picked up a few books and have gone from there... I'm not sure how to relate my question using the accepted shorthand, so I'm afraid this will be a narrative description.
I am using Access 2003. The database is for property management. I have...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
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 we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
