1-i have a main form to record the transaction with sub form for the detail.
sub form has the details as under:
serviceid Description qty rate dis. total
shipment xyx 3 300 0 900
Certificate
after entry in transaction invoice is printed.
2-i have a shipment form with a sub form to record the items detail of the shipments.
now, challenge for the shipments main form is to accept the 3 records for the shipments certificates as given is transaction sub form. and similar for all available records.
hope i made my point :)
11  1291  twinnyfo 3,653
Recognized Expert Moderator Specialist
RaoAli,
I'm sorry, but I don't understand what you are asking. I'm not sure what the three records you are talking about come from.
Are you just trying to filter your form/subform based on the records associated with one transaction? With one invoice?
I'm not sure what you are trying to do.
flowchart.xlsx
thank you for you words.
Please look into the form design in the attached file. Hope it will explain my point :)
twinnyfo 3,653
Recognized Expert Moderator Specialist
I still don't understand what it is that you want to do.
I don't know what you mean when you say the form "accepts 3 records". I know this is a language issue, and once we figure out what you mean we can move forward.
So far, I have not seen any "3 records" anywhere. Just a value in a field that is the number three. I'm really trying to understand what it is that you are trying to do. The excel file did not help.
My sincerest apologies.
i am sorry i just couldn't make my point clear. But i really appreciate your time n effort.
Thank You,
twinnyfo 3,653
Recognized Expert Moderator Specialist
RaoAli,
I am still willing to assist you with this question. I just need help understanding what you want to do. I am sure we can help you find a solution.
you are fantastic human :)
twinnyfo 3,653
Recognized Expert Moderator Specialist
Have you made any progress on this problem? Is there any way I can continue to assist?
RaoAli,
Is your end goal to write the three records from the subform back into the database? Assuming this you have a main form that you create your initial transaction in, are you attempting to split the quantity of the order into three separate records? If so could you please give us a bit more detail on how the information is linked? I am sure the excel preview makes since to you but without us knowing the flow of your data it is hard for us to interpret the concept.
yes i have sorted out this, but could you please help me regarding this?
my form opens to new record.
1-to save the record with save button, jumping to new record and locking the saved record.
2-unlock the saved record with edit button and save n lock it again.
thank you for your earlier response.
yes i have sorted out this.....Thank you :)
could you please help me for this?
i have form with few tabs on it. The problem is that on enter (the last object like text book on the form), control moves to new record instead going to object on tab.
thank you for all your support :)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Mark |
last post by:
This question refers to a main form with a continuous form subform.
After an error occurs after entering several records in the subform, how can I
delete all the data in the main form and all the...
|
by: Dave Boyd |
last post by:
Hi,
I have two very similar forms each with a subform. The main form gets
a few fields from the user and passes this back to a query that the
subform is bound to. The requery is done when the...
|
by: Darryl Kerkeslager |
last post by:
I don't do much with subforms - in fact I've deliberately avoided them - but
....
I have a tab control that will contain several subforms, each bound to a
separate table, and each table/subform...
|
by: jquest |
last post by:
I have a database about services and installations as well as warranty and
services for a company I run.
The main form is the customer info form. On this I record names, address and
phone numbers....
|
by: Scotter |
last post by:
Hello. I'm having problems understanding how to calculate a total on my main form based on the items in my subform. I've tried runing update querys and thats not working, and Ive tried just...
| | |
by: Sanjaylml |
last post by:
I have made a form in Access 2000. In addition to just simply enter the data through form, I have appended sub-form in main form to show the all the entered records as Sub-Form (DataSheet), which is...
|
by: ndhvu |
last post by:
Tables: Buy_Header and Buy_Detail.
- Buy_Header: info. of each buy (buy_id(PK, auto number), date, shop, bought_by, ...)
- Buy_Detail: info. of each item from each buy (buy_detail_id(PK, auto...
|
by: beacon |
last post by:
Hi everybody,
I have a main form, frmDeficiency, that has a tab control, deficiencyTabControl, that has a subform, fsubEpisodeDetail, on page 2 of the tab control. I also have a command button...
|
by: Seth Schrock |
last post by:
I have a form with a subform. To save time, I have set several of the main form controls to have default values so that I don't have to edit them most of the time. The subform is often the first...
|
by: wardwebber |
last post by:
I'm building a simple database (well, I thought it would be) to record personnel names and phone numbers. Each person could have multiple phone numbers (Home, Office, or Mobile). So to record these,...
|
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,...
| | |
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...
|
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...
|
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...
|
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,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |
