Recent content by mato61

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...