Search results

  1. L

    Solved File data icon in each record on form

    At the end, peace of cake. As always. I found icons I need, will make with with CASE ... is .xls ... Thanks a lot
  2. L

    Solved File data icon in each record on form

    Thanks moke123. I'm not looking for instructions of how open files on dblClickEvent In my continuous form (recordsource is CHILD table with full path filenames) I'd like to have a control with icons for appropriate file. If, for example, on the form are listed 3 files...
  3. L

    Solved File data icon in each record on form

    Hi theDBguy. 1. I wanted that attached file is opened on double clicking on file name In .FileName "field" I wasn't able to get full path name with LoadFromFile method - only the name of the file 2. Then I found out (some tutorials) that attachment fields are big "memory consumers" 3. For...
  4. L

    Solved File data icon in each record on form

    Hi everybody. I was working with attachment field. Noticed that attachment field in reality consists of (lets say the field name is "Attach") - Attach.FileData - Attach.FileName - Attach.FileType In attachment field I have attached different files, with their names. In the form I had...
  5. L

    Solved Form name from a combo box as variable

    Dim Forma As String Dim Kontrola As Control Dim ImeKontrole As String ImeKontrole = "" Forma = "" Forma = Forma + Forms!frmDBox!cboImena.Value DoCmd.OpenForm Forma, acDesign For Each Kontrola In Forms(Forma).Controls If Left(Kontrola.Name, 5) <> "Label" Then ImeKontrole =...
  6. L

    Solved Form name from a combo box as variable

    ... continue I don't know how to: 1. Open form with DoCmd.Openform ValueOfTheComboBox2 , acDesign 2. make loop with Forms!ValueOfTheComboBox2.Controls Any suggestion???
  7. L

    Solved Form name from a combo box as variable

    Clicked Post replay to fast ...
  8. L

    Solved Form name from a combo box as variable

    Hi. Ad1. I think making a loop will not be a problem (hope). Ad2. The real problem for me is: FOR EACH Control IN Forms!ValueOfTheComboBox2.Controls Let's say the value in second combo box is selected name of the form frmMyForm I don't know how to: put the value of second...
  9. L

    Solved Form name from a combo box as variable

    You have propably noticed typing mistake: WRONG: For Each c In Forms!s.Controls CORRECT: For Each c In Forms!f.Controls
  10. L

    Solved Form name from a combo box as variable

    Hi to ALL. I'm "building" a form with 3 combo boxes: First is ValueList RowSourceType, RowSource = "Tables";"Queries";Forms" Depending on decision from first cbo I get the names of all tables Except left(name,4) = "MSys", all queries and all forms Depending on decision of second cbo I get names...
  11. L

    fontname,fontsize table property CHANGE(ADD)

    Didn't work. Anyway, I've found solution which is HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Settings Thanks a lot for your time. So Thread is solved:D
  12. L

    fontname,fontsize table property CHANGE(ADD)

    You're right. But I'm affraid importef files (tables) will not bbe affected by this settings and will remain "MS default". At least this is happening now when importing stuff. Regarding VBA. I have seen on web something regarding tabledef, addpropery fontname, addproperty fontsize,... but I was...
  13. L

    fontname,fontsize table property CHANGE(ADD)

    For me now is 10 pm. I'll try your suggestion tomorrow. What about changing properties via VBA?? Can it be of any use? Although I don't know how to do it.
  14. L

    fontname,fontsize table property CHANGE(ADD)

    Hello guys. I'll ask for help on one metter which I know I maybe shouldn't ask for it. The case is that I'd like to work COMPLETE ACCESS in fontNAME "CONSOLAS" and fontSIZE 10 - so that default font would be Consolas 10. As far as I know it is not so easy to setup different fonts than...
  15. L

    set different visibility of controls in each record

    Yes. A,ready done what you suggested. It is not ideal, but I get what I want. Will mark thread as SOLVED
  16. L

    set different visibility of controls in each record

    I've found out solution, which I don't like much but I think it will work In main form (which will be Single & Unbound Form) I can do "all" I want. At the end of row I'll put command button Like "insert new record". This record will be than "transported" via VBA to subform, which's recordsource...
  17. L

    set different visibility of controls in each record

    Hello to All. I've made ACCESS CONTINUOUS form like the one in attachment (which is actually Excel shape) Main wish is to have VALUES in controls Range_m;Area_m2; Volume_m3; and their VISIBILITY depending on Measure unit value ("m", "m2", "m3") On AfterUpdate event of MeasureUnit I've made...
  18. L

    Changing default font in Access 2010

    At the end of this thread I wrote the solution of my problem if you are interested. Seems easy enough. Thanks for your help too Regards
  19. L

    Changing default font in Access 2010

    No, I have only followed your instructions - opened form in design view - Customised theme - saved "myTheme" (here where the problem was, could't find out where "myTheme" was autosaved ---> i had some maps hidden in my Explorer) NEXT File --> Options --> Client settings --> Default Theme...
  20. L

    Changing default font in Access 2010

    i STRUGGLED SOME TIME TO FIND WHERE "MYTHEME" IS SAVED. At the end I succed and now it Works. Without your help I'd be looking for the solution another 10 years. THANKS THANKS thread solved Regards
Top Bottom