i created an append query in which i need current to be append into another table.
SQL - INSERT INTO PaidFeeT ( FacultyPaid, MonthYearPaid, SecurityFeePaid, AdmissionFeePaid, TotalFeePaid, SR )
-
SELECT FeeT.Faculty, FeeT.MonthYear, FeeT.Security, FeeT.AdmissionFee, FeeT.TotalFee, FeeT.ID
-
FROM FeeT
-
WHERE (((FeeT.SR)=[forms]![FeeTF]![SR]));
from the form its working but from subform its not working it showing enter parameter. see image 
That could be something like: - Dim Source As DAO.Recordset
-
Dim Target As DAO.Recordset
-
-
Set Source = Me!NameOfYourSubformControlHoldingFeeT.Form.RecordsetClone
-
Set Target = Me!NameOfYourSubformControlHoldingPaidFeeT.Form.RecordsetClone
-
-
Source.FindFirst "SR = " & Me!NameOfYourSubformControlHoldingFeeT.Form!SR.Value
-
If Not Source.NoMatch Then
-
Target.AddNew
-
Target!FacultyPaid.Value = Source!Faculty.Value
-
Target!MonthYearPaid.Value = Source!MonthYear.Value
-
Target!SecurityFeePaid.Value = Source!Security.Value
-
Target!AdmissionFeePaid.Value = Source!AdmissionFee.Value
-
Target!TotalFeePaid.Value = Source!TotalFee.Value
-
Target!SR.Value = Source!ID.Value
-
Target.Update
-
End If
-
Target.Close
-
Source.Close
14 6750
Try with: - WHERE FeeT.SR=[Forms]![FeeTF].[Form]![SR];
But it would be much simpler to open the RecordsetClone of the subform as a recordset, and then use AddNew to insert the record. It would even update the subform automagically.
how should i do this? clone record
That could be something like: - Dim Source As DAO.Recordset
-
Dim Target As DAO.Recordset
-
-
Set Source = Me!NameOfYourSubformControlHoldingFeeT.Form.RecordsetClone
-
Set Target = Me!NameOfYourSubformControlHoldingPaidFeeT.Form.RecordsetClone
-
-
Source.FindFirst "SR = " & Me!NameOfYourSubformControlHoldingFeeT.Form!SR.Value
-
If Not Source.NoMatch Then
-
Target.AddNew
-
Target!FacultyPaid.Value = Source!Faculty.Value
-
Target!MonthYearPaid.Value = Source!MonthYear.Value
-
Target!SecurityFeePaid.Value = Source!Security.Value
-
Target!AdmissionFeePaid.Value = Source!AdmissionFee.Value
-
Target!TotalFeePaid.Value = Source!TotalFee.Value
-
Target!SR.Value = Source!ID.Value
-
Target.Update
-
End If
-
Target.Close
-
Source.Close
For info, the OP has since cross posted this same thread at another forum NeoPa 32,547
Expert Mod 16PB
Well, what you get out of something is generally related to what you put in. The answer's there if they want to work on understanding it. If not then they'll have the same problems wherever they go.
We (Bytes.com) have a question and an answer and that gives value, both to the site and any others who are interested in similar questions.
To be fair, there's no reason why members shouldn't be members elsewhere too. We just need to ensure our answers are as good as they can find - or at least as good as we can make them. I suspect we do a decent job in that respect from the feedback I've heard.
Well done to all of you for providing those answers :-)
PS. I just read the linked link. I have to say I accept much of what Ken says and agree with it. I'm a little ambivalent about some of his suggestions but nothing majorly. Many of our best experts post cross-sites and that's great. Not all do though.
AFAIAC its fine to post the same question at more than one forum PROVIDING the OP has the courtesy to say that he/she has done so and provide the link(s) to the other thread(s).
However doing so without providing that information wastes everyone's time...at each of the forums
NeoPa 32,547
Expert Mod 16PB
I would agree with that - with the proviso that any such links don't break the rules of the site you're posting on.
I haven't seen any public announcement yet but I'm certainly aware Niheel (Owner) is planning to relax such restrictions here pretty soon.
is there any problem if someone get any satisfied answer from this or other form? i think its not a religious form where i ask any solution from one religion and another.
No. I've also posted questions in two fora that were marginal to the core expertise of these fora.
But, when a solution is found, it should be referred to in the other forum/fora, as no forum like abandoned questions.
The trouble, that may prevent you from this, is that some fora doesn't allow links to other fora as these are seen as competitors (which I've never understood as no two fora have the some focus).
If so, you should copy the full solution to the other fora.
@Zhakadi
The fact that you asked the question in post #9 suggests you didn't read the link I provided at the other forum.
So I'll provide it again here: A message to forum cross posters.
NeoPa 32,547
Expert Mod 16PB ZKAHADI:
is there any problem if someone get any satisfied answer from this or other form? i think its not a religious form where i ask any solution from one religion and another.
I'm sorry that you don't understand why your behaviour is considered to be selfish and disrespectful. Nevertheless that is the case.
Those that struggle to understand are generally people who have no difficulty with the idea of letting others do their work for them and struggle with any concept of responsibility.
It's unfortunate, but doesn't break site rules. Thus we don't take action against such behaviour or members that exhibit it. However, you should be aware that experts everywhere are generally the least dim people, so recognise such behaviour and tend to steer clear of such members when it comes to the time when their expertise is required.
You may just find, when you behave in a disrespectful way to those you rely on to help you, that nobody wants to waste their time on your questions.
i am a learner and i want to learn everywhere. i am not disrespect, i respect all of you because i am as student and your are as teacher. but in search of a batter answer i post my problem on every form.
i am really sorry if you or anybody hurt.
NeoPa 32,547
Expert Mod 16PB
It may be also that you struggle to understand because you're trying to work in a foreign language. We should allow you some leeway for that. It's easy to forget how hard that can be for those of us that don't need to - and even for those who have to do so but are more practised at it (Some of our experts are not native English speakers either).
So, we understand that you are behaving well as you see it. Please follow the link ( A message to forum cross posters) posted by IslaDogs earlier and try to understand how you can post in multiple forums without upsetting people.
i apologize about that but you can see my english also weak. i cant properly speak english. may be my method to talk is not good. but i respect all of you.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Maria |
last post by:
Is there another way to delete the current record in a subform from the main
form, another subform or a sub-subform other than setting focus on a field
in the subform and using run command...
|
by: Melissa |
last post by:
I have a single (not continuous) form with an Undo button for entering
finished projects. On the form is also a subform that lists all finished
projects for reference. When I enter the...
|
by: tdmailbox |
last post by:
I have a form with a child form. In the child form there is a list of
names that can grow quite large. On the parent form I want to display
the first name from the child form. I set up a test...
|
by: Reginald Bal |
last post by:
Main Form/SubForm
When I requery or recalc my parent form after I updated a record in my
subform, I lose the focus of that particular record in my subform.
Instead, the first record is selected....
|
by: 130975 |
last post by:
Hi, I am working on a database. I have created a main form and three linked forms. When I enter an ID in the main form all the related information is also displayed on the linked forms. The problem...
|
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ |
last post by:
I am running Access 2007. I have a report that I want to filter. I
can go into Advanced...Advanced Filter/Sort... and setup a filter that
works fine on the report when I apply it. When in this...
|
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ |
last post by:
I am running Access 2007. I have a report that I want to filter. I
can go into Advanced...Advanced Filter/Sort... and setup a filter that
works fine on the report when I apply it. When in this...
|
by: michael george |
last post by:
Hi,
I am a recreational user of access and I enjoy making small databases. My question is when I add records to a form i want to create a report on the form currently displayed on screen, at the...
|
by: Redbeard |
last post by:
I am working with Access 2007. I am trying to print a report from the current record on a Subform. My form is comprised of a Main form with a sub-form and another sub-form with in the sub-form. ...
|
by: behedwin |
last post by:
Hey
I need some help to solve a problem with creating a new record.
i have uploaded my project in both 2016 and 2003 version of access!
Please view the zip file where both files are.
to...
|
by: lllomh |
last post by:
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: giovanniandrean |
last post by:
The energy model is structured as follows and uses excel sheets to give input data:
1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
|
by: Teri B |
last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
0ne-to-many. One course many roles.
Then I created a report based on the Course form and...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: isladogs |
last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, Mike...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
| |