What I want is to populate a hidden field based on a combo box option selected by the user, and I have decided to use the OnClose event of the form. So from your first paragraph question, the answer is yes, that's what I thought would be the way out to accomplish the task.
Unfortunately your advice and code has failed to solve the issue, the txtLiabilityCat egory default value-Madeni- remains unchanged regardless of the option chosen...
MfanyaKitu
Last Activity: Jun 10 '16, 11:28 AM
Joined: Jun 13 '14
Location:
-
-
Field auto-update based on another field value
Hi there,
I'm trying to automatically update a field in a table based on what has been inserted in another field. I have been successful in one table but not in another although I have been using the same code, and the same way. Here is the piece of code which is not working;
...Code:Dim rsLiability As DAO.Recordset Dim strSql As String strSql = "SELECT txtLiabilityCategory, txtLiabilityName FROM tblLiability;" -
For the sake of forum users:
If you are to use the code provided in post #4, it will work only if your data returns something. But when it returns nothing, such as it returns Null, an error 'invalid use of null' will occur. In order to avoid that, change that code into :
...Code:Dim myRevenueSet As DAO.Recordset Dim myRevenueSQL As String Dim curRevenueSum As Currency curRevenueSum = 0 myRevenueSQL = "SELECT
Leave a comment:
-
Pretty sure about that. This is the second time I get help within hours for what has been my headache for days. So much appreciating the readiness of you guys to help.Leave a comment:
-
Thanks for the reply twinnyfo. I at last manage to spot the real problem and make it work by the help of your code version and mostly by your ending hint;
The problem was with the logic that I used in conditional statement while validating the Start Date and the End Date.
Thanks again for your help....Leave a comment:
-
I have put the code on the onClick event of the button that is on the input form, the same form where the result is supposed to be displayed, but on different textbox.
The code does nothing, retuns neither an error nor wrong values. Hence the textbox results dispay only its default value 0.0 as I have set it to the currency data type.
Hope this explanation will help.Leave a comment:
-
Recordset looping fails to compute in ms access 2007
Hi there.
I'm trying to write vba code to loop through a table and add to the total wherever a certain condition is met, based on the form input. Here is the code:
...Code:'Assign date values(form input) into variables for easy manipulation Dim StartDate As Date, EndDate As Date StartDate = Me.datStart.Value EndDate = Me.datEnd.Value 'Create recordsets for storing database -
Subdomains in multisite wordpress are not available
Hi there.
First let me say that I'm not sure if I have asked this question in the right topic category as I've found no single precise topic to put it. After that let's go to the question:
I'm new to WordPress (although a bit experienced with web development). I have just freshly installed a multisite wordpress using Softaculous in cPanel and created two subdomains in dashboard. The issue I'm facing is that I can access neither subdomains... -
Thank you so much twinnyfo, it has worked at last. As you thought the problem was that Table and Query were not joined in any way, and by applying your proposed solution the desired result were obtained.
Thanks once again.Leave a comment:
-
Ok, thanks. I will work on it and let you know.Leave a comment:
-
Correct, each report card (for each student) should be one page, and hence one record; that's what I wanted to mean. Hence to edit my post #3 on that respect; the report is supposed to be a single page(report card) for a single student, and not many pages for many students.
1.My query
Record source
...Code:SELECT StudentByAcademicsQR1.*, AcademicInfos.monthlyCivics, AcademicInfos.monthlyBiology, AcademicInfos.monthlyMathematics,
Leave a comment:
-
Here it is:
1.Desired
2.Unwanted extra
3.With no data
...Last edited by zmbd; Jun 13 '14, 08:40 PM. Reason: [z{please do not use 3rd party sites. Many of the experts have secure ISP and these links are blocked - use the advanced post option}]Leave a comment:
-
No I'm not forcing the page feed after the report footer nor detail section. The record source is the single query that retrieve multiple records based on a single entity(student) : the report is a student report card on his/her academic performance which include personal details and scores from three different types of tests on 15 subjects each. It also include 3 unbound textboxes for comments from the teacher and the parent. The report print the...Leave a comment:
-
Extra page with replicated controls on an Access 2007 report
I have got this report which I've designed with a query(having 60+ controls) as its record source. Its a one page report. The problem that I'm facing is that whenever I preview it, I get one extra page with all the controls on the main page(of course with the exception of the report header controls).
I get this result whenever I supply it with the query parameters and when I don't, I get the desired result, but with no data of course. I've...
No activity results to display
Leave a comment: