Search results

I did as June7 suggested, changed the name of the control to ctrSBancoNCont_P, so that it is different from the actual form name Me.ctrSBancoNCont_P.Form.Command58.BackColor = RGB(255, 242, 0) no errors, but still, no color was changed. the path to the button is now correct since...

Thanks for your reply. I get an error : Run-Time error '438' Object doesn't support this property or method I am going to create a new form from scratch, and test it. Shouldnt I set the focus to the subform before i change the back color of the button ?

I am trying from a button in the main form to change the background color of another button in a continuous subform header section Forms![frmConcilManual]![frmSBancoNCont_P].Form![Command58].BackColor = RGB(255, 242, 0) [frmSBancoNCont_P].Form.Repaint frmSBancoNCont_P is the name of the...

Mike, you are right i forgot the primary key, wich is a unique number "ID" June, i used your queries that work great, altough a litle slow, but i can live with that Many thanks

Hello, I have a table "myTable", with the folowwing data : dataM aValue bValue cValue 31-dez-23 19,73 15,86 52,56 31-dez-23 19,73 52,56 15,86 31-dez-23 52,56 15,86 19,73 31-dez-23 52,56 19,73 15,86 31-dez-23 26 31,71 80 31-dez-23 26 80 31,71 31-dez-23 31,71 26 80 31-dez-23...

thanks June and ebs, the way was definetly a query not a loop, your examples worked nicely

Hello, thanks for your reply I did make a copy of the database. so I have 70 records in one table, and a few records in the other one. I this case a match is found in a few seconds , but that is because as soon as I get a match I exit the loop, but it could take much more depending on where in...

Hello, I have query that list all the posible sums of three numbers in a table. the table only has 70 records, but when i runs the query returns about 275000 records 'step 1 (the query that returns the 275000 records) SELECT DISTINCT a.valor + b.valor + c.valor AS sum_of_3_numbers, a.valor AS...

thank you all. I used the code Gasman suggested that works great

hello, Is there a way to copy a string to the clipboard, and after that to be able to press the keys ctrl+V to paste it ?

Hello I had a SendKeys function in another event of the form, that Ihave removed, and now it seems that all is working well Thank you all for the kind help

Hello, I have a unbound text box (Text34), where a integer number should be entered, with following code: Me.RecordsetClone.FindFirst "[MovimentoID] = " & Me![Text34] Me.Bookmark = Me.RecordsetClone.Bookmark Me.Text34 = Null Text34.SetFocus Code runs fine and finds the expected record, but...

That worked, thanks

Inside of form "frmMain", I have two forms : frmSearch frmList from a button in frmSearch, I want to change the visible property of controls in frmList I tried the following, wich wont work If curr = 1 Then Forms!frmList.debitoPH.Visible = False Forms!frmList.Debito.Visible = True...

I am from Portugal, and since I moved to another country, I cannot access the URL https://www.e-leiloes.pt/info.aspx?lo=LO1063072023 I can if I use a VPN connection with a portuguese server, nevertheless when trying to scrap data from that URL, my vba code cant navigate to the page. Any...

Thanks Bob, it worked great !! (y)

The Locked property is set to NO if I add one more line to the code Me![frmDetalheMovFinanc].Form![ContaID].SetFocus Me![frmDetalheMovFinanc].Form![ContaID].SelStart = 0 Me![frmDetalheMovFinanc].Form![ContaID].Dropdown MsgBox (Screen.ActiveControl.Name) the MsgBox returns the name of...

When I click on a command button in the main form, I want to move the focus to a combobox control in my subform. the focus shifts to the correct control and the combobox dropsdown if I then choose one of the options of the control it also works correctly, but if instead I choose to type, the...

Thanks for your response. That worked fine

Hello, I have a form with a control named "cPDF". On the current event of the form I have the following code: If InStr(Me.path1, ".pdf") > 0 Then Me.cPDF.Visible = True Else Me.cPDF.Visible = False End If It shows the control cPDF with the set condition. My problem is when opening the...