Search results

Sorry understood db as a database.

here u are. You can see the table I am using to get the data from

Thank you Micron for your comments. Right I need to clarify what I really want. Ok. I have a form. The form is bound to the table where I am taking data from. It looks like a graveyard. On the form there are some labels coreposnding to each tomb. When I press label1 in the text boxes shows me...

Guys I know I am very new and I am trying to manage. sometimes making some silly mistakes. I am placing some code which is working only when I firstly press the label called,"Etykieta". However I need such functionality without clicking that label. Only when I select the name from the combox I...

Dear Ranman. I am not using the loop but still get the error: object variable not set. the lbl is a control type

the last before end if

it gives me run-timer error:91 object variable not set If IsNull(Me.choose) Then lbl.BackColor = vbRed Else lbl.BackColor = vbGreen End If

Hi there I am trying to use combox with selection the right label. When I select a name from the combobox called "choose" I would like to change the colour just the label where record is assinged to. When I select lets say name1 then the label nr1 is colored. THis what I have is changing me all...

https://www.access-programmers.co.uk/forums/threads/loop-all-controls.309782/page-2

I have tried to capture by: form2 code Private Sub Form_Load() Dim lab As Control lab = Me.TabControl.Pages(0).Controls("Etykieta").Caption lab = Forms!Sektor.LABEL_PREFIX.Caption '"LABEL_PREFIX" is declared as Private Const LABEL_PREFIX As String = "Etykieta" in form1 End Sub But maybe my...

They have the same name

Hi there few days ago I had a problem with changing the color of the label. Thanks to cheek.. it is resolved. II want to: when I click label on the form1 it changes the color, gives me the correct record after using the printbutton the form2 shows the same selected label with color changed. I...

Dear cheekybudha. Now it is working perfectly as wished. Thanks a lot for your time. I am very green in this yet.

there are more ...

It shows me: New OnClick: =LabelClick(1250) Label name: Etykieta239 Label index: 239 Original OnClick: New OnClick: =LabelClick(239) Label name: Etykieta_150 Label index: _150 Original OnClick:

yes. 2016

it is strange. When I copy and paste the new labels to the form without macros related to labels the code is working, giving just the error like above.

I think just this MID function. THe most importnat is "sektor" and "tom" table. the rest I do not think they couse a prolem

this is original which does not work

You can find there lots of labels. By reason I had to add such qty :)