Recent content by LjushaMisha

  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
Top Bottom