Okay, sorry for the delay in reply; someone stole the cabling for our office.
I assume I bind the sub-form to the main table as a data source? And set the form open mode to add? I admit I'm a little distracted by the repair job at the moment, so if something I just wrote is off please let me know.
Sunshard
Last Activity: Apr 15 '08, 09:14 AM
Joined: Feb 26 '08
Location:
-
Alright, I've created the subform inside the form. The subform is currently unbound. I'm ready to link the fields together.Leave a comment:
-
That approach sounds great, how would you go about it?Leave a comment:
-
Thanks for pointing this out NeoPa, I understand the importance of storing the same data more than once. In this particular case, it might be harder to do.
The products involved can easily be reclassified and there are a very large number of unique attributes available for each field that could be normalised. On top of this, these values are unlikely to be repeated very often as a lot of the products are tailored to suit the customer's...Leave a comment:
-
*sigh* I'm sorry about my poor communications. I'll try to actually answer you. If once again I completely miss the point, please just leave this thread be until you look at this without getting frustrated by my rambling. I can't really offer more than profuse apologies. ;_;
Your question:
This is correct, and to answer this:
In post #18, the fields listed there are propagated...Leave a comment:
-
Understood, no problem. I'll note the fields that will simply be copied from the original record:
The following fields are text type: Manufacturer, Manufacturer Number, Manufacturer Description and Manufacturer Remarks
The following field is date/time type: Modification Date
The fields mentioned in my post above are to be edited by the user.
Thanks for the prompt reply, is there anything...Leave a comment:
-
*slaps forehead* sorry about that. Okay, you are mostly correct. The fields I have described are the ones that either change or the user needs to input (so mostly is probably not quite right). The other fields remain unchanged, and can simply be copied.
The fields I have described are all present in the form of text boxes. The control names are the same as the field names given above with all spaces replaces with _. (i.e. Date_Of_Receipt )...Leave a comment:
-
The controls and their intended input is as follows:
ID Number - 'Unique' Identifier for records
Thickness |
Width |--> Number fields
Weight |
Date of Receipt |
Date of Issue |--> Date fields
Description |
Remarks |--> Text fields
The last input is a bit tricky.
Each item has a status code (an integer between...Leave a comment:
-
Hello, I have created the form described. Sorry for the late reply. So how would you go about doing this? :-)Leave a comment:
-
That sounds great actually. My only problem is my appalling knowledge of the method or syntax needed to program a form capable of doing that. I've bandied about doing that instead of using Inputboxes, but I haven't been able to figure out.
As my internet access is limited, you'll note that my response time's a bit slow. Thanks for bearing with it.Leave a comment:
-
Hello NeoPa, I am certain a fixed maximum is sufficient (say 9).Leave a comment:
-
Thanks NeoPa, after remedying that and removing the combo box that particular problem was resolved.
Continuing with the original problem, the command button that changes the status of the records works fine but the function is somewhat longer.
It creates a number of duplicates specified by the user, and then accepts user input to change critical fields for these 'child' records. Using InputBox (until I can figure out...Leave a comment:
-
Sorry for my bad manners. I'll be more careful.
As to my garbled query above, I'll try to untangle it going one problem at a time:
I have a query is based on two tables. One (main) holds the bulk of the record data. The other is a source for a combo box, which denotes the status of each record.
The table design looks like this:
StatusID - Autonumber (key field)
Status Description...Leave a comment:
-
Copy Record Structure (Related Records)
Hello, this was particularly helpful to me as well so thank you very much.
I'm new to using Access 2003, and I have a slight twist to this question; I've been asked to make this particular button create several child records that share several of the parent's base traits.
While it's simple enough to just duplicate and loop according to the number of records the user requests, I'm unfamiliar with the steps to take from... -
This was really helpful, so thank you for posting.
BrianLeave a comment:
No activity results to display
Leave a comment: