All,
I have created a report giving the reader full and summarized views of the daily data. The detailed section of this report is being summarized underneath the report in the footer section. What I need to do is to save the data off the textboxes of the summary section to a separate table. The table will be supposed to accommodate all the summaries of the month day by day, then based on this table, a simple query can be generated...
mhegazy
Last Activity: Jun 8 '14, 11:34 AM
Joined: Aug 21 '12
Location:
-
Saving fields, calculated in access report, to separate table
-
Perfrom summations/counting for grouped fields in access report
I have built an access report that works as a stepped report based on grouped fields.
When perfroming sum or count for the one of the grouped fields, access always yields the sum/count of the individual records in the details section, even when set the sum/count function as to work on values.
For example, the report has 5 groups each one has two records of details, so acccess did not count 5 for the grouped fields, but... -
Building a form in access can filter specific records in a table
See attached please. this a live example. The 2013 DB
The 2013 DB is to a sysetm to gather all information for the chemical treatment in an oilfield in Egypt.
Open the form "CI Points Data", you can see a datasheet view of all records in the corresponding table for a number of specific fields in the same table which is "Detailed... -
Building a form in Access can filter specific records in a table
Is it possible for an access form to filter specific fields in the record source table so the user can deal with them only a part form the rest of the table fields.
The table contains many fields and the user needs to enter data in all fields for the different records in the table. To make it easy, I need to filter the records which have similar or are common in a specific character to enter their data, then remove the filter and put... -
MS access switchboard
The ms access swichboard is working in good fashion. What I need to do is make it more flexible while opening and closing other objects in MS access like forms and reports.
the switchboard form holds up upon the start of access and still shows up after openning a report for example untill I close it.
I need to minimize it and dealing with access freely then bach again to the switchboard if I want.
Thanks... -
Thanks Seth
It works fineLeave a comment:
-
Seth,
Would you please explain a litte bit more?
Thanks,
mhegazyLeave a comment:
-
Summing calculated fields in access
I have generated an access report that shows the process comments for the different locations we have in the organization. What I need to do is to count the total number of comments we have per day for the daily report I generated.
I used a textbox under the gourp footer with the expresson "=Count([Comment])".
It worked fine to get the count of teh comments under each goroup.
I need to gererate a... -
Controlling data edit of form objects while navigating the saved records
I have built a form on table which will navigate showing data stored in each record in the table.
I need to restrict the edition of data while navigating records from the form. Edition can be permitted by clicking a command button for example (Edit) to change the stroed data.
Can this happen?
If so, please advise. -
Dear all,
I have attached copy of the last version of my projects.
You can go to the HRs_Filter form or the DRs_Filter form.
Input the date as for example 12/10/12 or 13/10/12 (means 12-Oct-2012) it will work for the daily reports but not work for the history reports.
You can check this yourself.
Regards,
mhegazy...Leave a comment:
-
MS Access report load from a form having report criteria
I have designed a database with many reports of certain importance. Basically a report in my DB is one of two types; a Daily Report (requires a single criteria which is the date) and the second is a History report. To view or print a report, I have designed a Filter form to fill in with the report criteria and clicking a button to open the report.The first type (Daily R) work fine without problems.
The second type (History R)has a... -
MS Access not responding when opening a table
Dear guys,
Is there a reason for MS access to be not responding to open table order.
Upon trying to open a table in the datasheet view it doesnot while it do in the design view.
Would you please help on that?
Thanks in advance
mhegazy -
I will try and see.
Thanks for the smileyCoder.Leave a comment:
-
Access Subreport within a main report problem
No custom VBA having codes with un-native functionality.
All of them are regular.
No macros in my database.
I have attached a screen shot showing you the Link Master Field and Link Chield field properties.
thanks
mhegazy...Leave a comment:
-
Access Subreport within a main report
Thanks for TheSmilyCoder for prompt reply.
Yes sir, I am confirming the descriped problem in my 1st post. Also I have attached two screen shots explaining what happen with me. (See attached: Problem with MS Access.jpg)
Concerning your questions:
1- The subreprot is linked with Date field which is present in the subreport and not appearing in the main report....Leave a comment:
-
Access Subreport within a main report problem
I have some troubles with my database. I am trying to create a subreport within a main report, I tried this with two different ways. the result is the same in both ways.
Way #1 - In the main report, clicked Subform/Subreport icon and selected the subreport from the list which has been prepared prior.
Way #2 - In the main report, clicked Subform/Subreport icon then built the subreport form the corresponding query, so that the... -
Change property of command button by navigating access form
I have an access form having a command button which will perform a certain action onclick for the current record.
I need to disable the button function by navigating the records before the current one from the form or in other words, to have the button property (enabled) = false all the time except when the current record is new only.
this makes me thinking on how to inform access vba to navigate and if the current record... -
Calculation in Microsoft Access
What is the right way to do some calculation in MS access to be stored in the bound table through the user entry form.
Should I make use of VBA or simply from access. -
Text box to lookup its value form the bound table based SQL statement
I have a single form on which there exists several combo boxes and a text box. one combo box value (for the Wells) will be filled independently, then I needs the text box to have its value based on the value of the wells combo box value. I have created a query that solved the propblem partially, it requires parameter which is the wells combo box value. If I ran with query a part from the form, it wroks good and asks for the parameter and it is OK....
No activity results to display
Leave a comment: