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...
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...
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...
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 =...
... continue
I don't know how to:
1. Open form with DoCmd.Openform ValueOfTheComboBox2 , acDesign
2. make loop with Forms!ValueOfTheComboBox2.Controls
Any suggestion???
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...
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...
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
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...
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.
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...