Search results for query: *

Hi everyone, Is there a way to output multiple access reports to one single word file? I am able to output single report to .rtf without any problems by using the following code: Private Sub EditFinalsInWord_Click() Dim strCurrentPath As String strCurrentPath =...

Hi, I have a form with a subform and would like the choice I make in the subform to base on the content of two combobox;[Sex] and [SchoolNo] in the Main form. I have already written the code which is working ok. The problem is that if I want to change the Sex of the student I need to click...

Hi everyone, I have created a Report based on a Crosstab. I'm trying to add up the total of students from the different schools but got an Error. I am using a text box in the Footer with the following code: Sum([TotalOfStudents]) Why the Error? NB. I have calculated in reports base on...

Hi, Is there a way to sort records in crosstab queries? I try but it says: "Cannot have aggregate function in ORDER BY clause" Any suggestion? Thanks.

Hi, Have been trying to rank records according highest points in a report from a crosstab query and have create the module below in vba. Code Option Compare Database Dim lngLastPoints As Long Dim lngLastRank As Long Dim lngRankInc As Long Function RankFunction(lngPoints As Long) As Long If...

Hi, I need to rank records in a Crosstab query based on a select query name qryRanking_CategoryU16 as follows: Column1; Field: Category, Table: qryRanking_CategoryU16, Total: Group By, Crosstab: Row Heading Column2; Field: SchoolName, Table: qryRanking_CategoryU16, Total: Group By, Crosstab...

Hi. Have been trying to rename a label in access report based on certain criteria. I can easily do it in Access Forms using VBA but I can't in Report. The problem is like this: I have a textbox and label "Startlist" minus quotation marks. I want the caption of the label to be "Order" for Field...