Search results

Hi Rx, I Obviously did work a bit on the suggestions. First of all SORRY, I did not include strSQLED_EMWellSumRpt, BUT I created a module and named it DxED_Monthly. Then I built a form with TextBoxes Text0 and Text2 and button which calls the function. The way I placed an SQL in vba a bit...

Hi Rx Thanks for still beeing with my, I will concentrate in the evening (I am in UK) on the Database. For now I could tell I admire your proffesional aproach. Thanks again. Can't wait untill I will read every single word you wrote. And will follow the advice. Antanas

Hi thanks for respond. Long story short: the code I run - No surprises: Dim rst As DAO.Recordset Dim ApXL As Object Dim xlWBk As Object Dim xlWSh As Object Dim fld As DAO.Field Const xlCenter As Long = -4108 Const xlBottom As Long = -4107 strTQName =...

Saga of Exporting query still continues. I have a query which in normal conditions would ask for parameters in dialog box. After introducing the Code I got famost "Too few parameters. Expected 2". Any help how overcome the obsticle would be appriciated. Thanks in Advance

Hi, Sorry for being a bit desperate. If anybody interested, I would give my version of solving my problem and possibly many others. The problem ocures when you (me) want to transfer Report Data fro Access in to Excel. And there is no easy way to do so. So one of solutions I had to make: create a...

Sorry to disturb the silence again, but I am confident, that the initial question from MDRAY00 has not been answered. the question was about "exports removes all formatting". But the answer somehow slipped to excel formatting. It is not about excel formatting. It is about loosing formatting...

Hi Again still "mastering". Finally realised that if you have query without Caption in columns the code runs.... Exactly like DoCmd.transferspreadsheet (but thanks God finally the code does give me an Excel document with pre-set Sheet name) . A control of cells perhaps in Excel (did not tried as...

As Usual: "Argument Not Optional" sorted with OnClick Call SendTQ2Excel(strTQName, strSheetName) then next - "Too few parameters. Expected 2" - still "mastering"

Dear Rx, When I read your comment I feel like a poppet in the school. But I am probably the one who does not understands lesson when everybody does. And I will explain why every month there is an inquiry about query transformation to Excel. BECAUSE there is no clear answer. Majority (and I am...