Search results

Hi, i run compatibility checker for my DB and get errors related to the non-existing table. Is it possible? Errors are: Web Compatibility Issues 1 Table ogsReportField Indexes UniqueOrder 2 Table ogsReportField Indexes UniqueRecord 3 Table ogsReportField TableColumn GroupInterval 4 Table...

I tried to use form with multiple select list box to select which ones to be exported. you are right it is module.. Even I used mcrSelectedExport("Me.lst_m_agenda") on click Event i get that message

I am running this: Sub mcrSelectedExport(ctrl As Control) Dim varItem As Variant Dim m_agenda_id_list As String Dim strSQL As String Dim rs As DAO.Recordset ' loop through list box and build value list For Each varItem In ctrl.ItemsSelected m_agenda_id_list =...

ok, i will try it with form, but how to construct that form and then, how to run or modify that macro? could you briefly explain it to me pls??

Yes i would like to modify this macro for current report. I would say that easier solution would by just type which M_AGENDA_KOD i want to export right to the macro /so question here is where to type these M_AGENDA_KOD/ or maybe more comfortable would be that when i run that macro it would...

Hello, one additional question here > is it possible to modify the macro i posted here to export reports just for selected value? or better question how :) :banghead:

Hi Gina, it is strange but i am getting what i want finally. I tried to add to each subreport that M_AGENDA_KOD, but it wasnt working. So i was wondering what is wrong and i just tried this: Set rs = CurrentDb.OpenRecordset( _ "SELECT DISTINCT M_AGENDA_KOD, M_AGENDA_ID FROM M_AGENDA") so i...

Sorry!!! No, i am not using a button on a Form. I do not need to call it through a Form. I just created report, and then need to run macro. I do not need open it.

i am quite confused now. I thought it will be simple and i am overlooking something. my main report contains just two comboboxes with M_AGENDA_ID (one for M_AGENDA_KOD and one for M_AGENDA_NAZEV from M_AGENDA table) to identify report. This report have picture, table of contents and a lot of...

I have M_AGENDA_KOD on main report, not all subreports contain M_AGENDA_KOD.

M_AGENDA_KOD is column in M_AGENDA. M_AGENDA is a table with PK M_AGENDA_ID and other columns, one of these columns is M_AGENDA_KOD.

As i wrote, if i run that macro it is working. It will do export how i want, each file contains one record from report. But now files are named by M_AGENDA_ID (means numbers from 1 till 374). M_AGENDA_ID is ID which conects all records within report. But i would like to get files named by...

Hello, i am not able to run this macro, sorry Gina, i do not why. But meantime i wrote something like this Sub expt2PDF() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset( _ "SELECT DISTINCT M_AGENDA_ID FROM M_AGENDA") With rs Do Until .EOF DoCmd.OpenReport...

Hi again, one more question here. I need to modify my project. I have the same situation as described above but there is two more citeria, i need average not just by period but also by office and KPI_ID so i have> KPI_ID OFFICE_ID PERIOD_ID Calc_KPI_Weighted_Value and i need average of...

Hello, i created report "rpt" with a few subrpts. I would like to export this report to word by value in column M_AGENDA_KOD. M_AGENDA_KOD column has about 370 rows, so i do not want to export each manually. So i would like to have each M_AGENDA_KOD value as separated word file named by that...

Hello guys, maybe simple question but i cant go over it for a while. I have a table period with three columns ID, Period_Start_Year, Period_End_Year I could have many periods in a future. What i want is to allow users to insert just first start year and lenght of period and table will be...

wow many thanks! firstly i did query with averages for periods as your subquery is, but then i wasnt able to continue...i just didnt know how to match these averages to the main query..thanks again!

thank you! that works perfect! but could you explain me what is behind that code?or what is wrong with my suggestion of code? i am newbie so i am trying to understand it..

i need get average of Costs_Per_Capita from values where Period is 1 to that row where period is 1. Excel equivalent is =SUMIF([Period],"="&[@[Period]],[Costs_Per_Capita])/COUNTIF([Period],"="&[@[Period]]) see the table what i want, but thanks for reply