Search results

Sorry.Typing error while entering code to thread. In real code only db1 and rs1, also dimmed.

Hi. I have following Sub for On Change event: Private Sub txtSearch_Change() Me.txtDummy = Me.txtSearch.Text Dim db As Database Dim rs As Recordset Dim sql As String sql = "SELECT tblProducts.* " & _ "FROM tblProducts " & _ "WHERE...

set RS = me.forms Don't understand this. What you had in mind. I can understand it as "recordset is defined with entries in the me.forms". 🤔

That's exactly what I need (among other controls for which recordsource established with another RS. Anyway, thanks for your reminder. 😉

Worked as nothing. Great help. I was really only missing the correct syntax for Forms(formName).Controls("Text0").ControlSource = "=" & rs.Fields(0).Value. All the rest I already did. I wrote only shorter version of the thread. Sorry not mentioned. But you immeddiatelly knew what I need. ;)

Hi. I have an unboud text box Text0 on a continuous form. I would like to "define" control source for this control after the form is opened - - - > DoCmd.OpenForm("formName", acNormal) like Me.Text0.controlsource = rs(0) where rs.recordcount = 1 Is this anyway possible? Thx in advance

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

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???

Clicked Post replay to fast ...

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...

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

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...