Recent content by fcarboni

  1. F

    grey background

    hi, excuse me if I post on this old tread, ghudson into your signature you wrote Ac10 and SO win7, you use already the lebans method to put one custom img on mid background?? I've one program in AC07 32bit, my SO is win7 64bit, but the lebans demo don't run, if I open the example nothing append...
  2. F

    Specify the tab name when exporting to Excel

    Hi Isommers, I think that you've two ways: rename your query or rename the name sheet/sheets. If your way is the 2th, you've only to put this rows after your code, in the same sub: Dim xlApp As Object Dim xlSheet As Object Dim file_name As String Set xlApp = CreateObject("Excel.Application")...
  3. F

    Macro Autoexec

    Hi, with refeering my old post ....showthread.php?t=254715, i tried one different solution. I create one autoexec macro that after reading the current user, update the USysRibbons table with the tabs that this user can see. But I found that the macro run after onribbonload , correct?!?!?!? One...
  4. F

    Access 2007 retrieve current User and show their Ribbon

    Hi, actual ribbon at the top of the access program. If you saw my example, I've only one ribbon with some tab..., because not all guy can see all function, I want to show / hide this tabs at user level. example: User1 show Tab1, Tab3 and Tab5; User2 show Tab2 and Tab4. For this I've one...
  5. F

    Access 2007 retrieve current User and show their Ribbon

    Ciao, I whant to show one ribbon for any user level. Into attach file I use a UserTable to test different user/level. I retrive this error: Error 438"Object Doesn't Support This Property or Method" ... I's not possible that I want to do, or my code is wrong. Thank for any help. Fabrizio
  6. F

    Create pivot, use Late Binding

    Ciao SOS, The debug find error on .RefreshStyle = oWks.xlInsertDeleteCells same errore error 438 Object doesn't support this proprierty .... tnk
  7. F

    Create pivot, use Late Binding

    ;) Hi SOS, thank for your contribute, in the RED code i received this error 438 Object doesn't support this proprierty .... In thi days, I re-write this code some back, wath do you think?? Sub PVT_EXP() On Error GoTo ErrorHandler Dim stdocname1 As String Dim I As Long stdocname1 =...
  8. F

    Create pivot, use Late Binding

    Tnk but my problem is to create the pivot table. this is a part of my code (Early Binding) Sub TAB_EXP() On Error GoTo TAB_EXP_err Dim oRst As Object Set oRst = CreateObject("New ADODB.Recordset") oRst.CursorLocation = oRst.adUseClient oRst.Open "Select DATLAV, Order, DA, ID, CODPRP, Colli...
  9. F

    Create pivot, use Late Binding

    This is an acceess program, all guy that Haven't access use Access Runtime. Into access Runtime I don't have all library, and for that I need to re-write the code from E. to L. binding. tnk
  10. F

    Create pivot, use Late Binding

    Hi, I've a big problem to convert my VBA code for reading a qry, export to xls, create a range and with this range create a pivot table. Not all PC on my company are Access intalled, and I need to convert all code from Early Binding to Late Binding. :banghead::banghead::banghead: Somebody can...
See more
Back
Top Bottom