Posts by Marco • 649 points
31 posts
-
0
votes3
answers1128
viewsA: Oracle - Select distinct in one column only
As @Confuse said in the comment, you can simply use the grouping with the Max(), in that way: select ac.cod_matricula, he.cod_usuario_log, max(he.dt_atualiza_log) dt_atualiza_log, he.txt_ip_log,…
-
1
votes1
answer476
viewsA: Title getting out of the div
It’s not the title that’s out, it’s the title itself div that descended as it is the standard property of displaying the element is display: block. Just add display: inline-block in the style of…
-
0
votes2
answers40
viewsA: Check if edge is applied
You are checking the class in the wrong element. $(document).ready(function () { $('#Finalizar').click(function () { if (!$(this).hasClass("selBordaCor")) { // <-- Aqui você está verificando se o…
-
0
votes1
answer57
viewsA: Shake Animation won’t stop?
The error is on the line var shakeit = setInterval(function(){, where you are setting a variable shakeit within the scope of the function fecha(), thus the function abre() do not have access. It’s…
-
0
votes1
answer1252
viewsA: Macro Vba - IE... Click, Not Working button
In your HTML I don’t see a button called download_token_value only one input of the kind hidden that has no event click associated with it, nor should it, as it is a hidden element on the page. If…
-
0
votes3
answers1529
viewsA: Eliminating duplicate values in SQL
I do not know if I can reproduce exactly your need because I do not know how are the records in each of these tables, but I believe that it is enough to group and add the freight in one subconsulta…
-
0
votes2
answers82
views -
0
votes2
answers71
views -
2
votes2
answers960
viewsA: Problem with Datepicker
There is another way besides the one suggested by @Caique Romero, which would use the option showOn: $(document).ready(function() { $(".datePicker").datepicker({ showOn: "both", buttonImage:…
-
3
votes1
answer815
viewsA: Autofilter Excel VBA
Why Excel is interpreting the value in Criteria1 as a number and the values in the column C as text. Try changing the column formula C for =VALUE(LEFT(C7, 4)) or if it is Excel in Portuguese…
-
1
votes1
answer340
viewsA: Switchery with tooltips (bootstrap), how to do?
What happens is that the Switchery creates an element span stylized to give this iOS control face and hides the original element. Precisely why the tooltip does not appear, because the element that…
-
1
votes1
answer134
viewsA: Calling Vba Project password
There’s a way to find the ID's which may be used in that method FindControl, it would be something like that: Private Sub ListarIDs() Dim ctrl1 As CommandBarControl, ctrl2 As CommandBarControl '…
-
1
votes1
answer2674
viewsA: How to configure the Materialize Pickadate correctly?
In relation to the language of datepicker, is just overwrite the startup settings. By automatically opening I found a solution customizing the method close taking the focus off the field:…
-
1
votes1
answer1560
viewsA: change select values with jQuery
I found it strange that their version 1.1.0 of the plugin is different from the one they present on github: https://github.com/hernansartorio/jquery-nice-select/blob/master/js/jquery.nice-select.js…
-
1
votes1
answer451
viewsA: Calculation with comma in Javascript
It was a set of small mistakes, but the main thing is that the function calMediaAfericao() that was called in the onfocus of the last field is who ended up returning the error valor.indexOf is not a…
javascriptanswered Marco 649 -
2
votes2
answers4105
viewsA: .addeventlistener() is not a function
Complementing the @jbueno response /a/199222/13469 You would have to choose which index of this array you would add the event, for example: loginBtn[0].addEventListener("click", function(){}); So…
-
2
votes4
answers11284
viewsA: How to create temporary mirror table in another
Simply: SELECT * INTO #tabela FROM TabelaOrigem
-
2
votes2
answers792
viewsA: USERFORM: I can’t remove items from my Listbox (Error 80004005)
I couldn’t find a source Microsoft talking about it, but when you define the property RowSource of a ListBox, cannot remove or add items in the list. So what you can do is always popular the list…
-
1
votes2
answers1102
viewsA: Enter a password in the VBA Project via module or Sendkeys
Just you enter the VBA editor, and in the project tree, set a password for the same. Follow the step by step (done in Word but serves for all Office): Step 1 Step 2 Issue 1: According to your recent…
-
2
votes1
answer1070
viewsA: VBA: Declare variables online
You need to define the type of each variable, otherwise the type of the same will only be defined after the assignment of a value, just as it occurs in javascript. With the function VarType it is…
-
1
votes1
answer1976
viewsA: Use of Transferspreadsheet via VBA
As I said in the comments on your question, there are other ways to do what you want, but directly answering the question of how to use the DoCmd.TransferSpreadsheet in the VBA inside Excel, you can…
-
3
votes1
answer1448
viewsA: how to sort by line number in a query in postgres?
From what I understand you would like to have a sequence of 1 a n no matter the value of the field id. I think it would be something like this: SELECT row_number() OVER (ORDER BY id_grupo) AS…
-
1
votes1
answer181
viewsA: Excel - VBA: Need support to lynch the Max function
Just reference the Range that you need. Example: Application.WorksheetFunction.Max(Worksheets("Plan1").Range("A1:A10"))
-
0
votes3
answers759
viewsA: How to style a select with Javascript only without Jquery?
Although I find the @Sergio example ideal, follow a slightly simpler example: select.custom-dropdown { /* Remove a borda */ border: 0 !important; font-size: 14px; padding: 10px; width: 220px;…
javascriptanswered Marco 649 -
0
votes1
answer101
viewsA: How to call one function together with another
You may not use the id of the elements input and p because by good practices you should have a id unique per element, so you couldn’t get the new elements created using the getElementById. However…
-
0
votes1
answer81
viewsA: Search topic and topic
Maybe this javascript plugin is what you’re looking for: http://www.listjs.com/ A functional example: var options = { valueNames: [ 'name', 'born' ] }; var userList = new List('users', options); h2…
javascriptanswered Marco 649 -
-1
votes1
answer451
viewsA: Block fields in Subforms in MS Access
Using conditional formatting you can lock/enable a field from a criterion:…
-
2
votes2
answers693
viewsQ: CSS content property generating an image
I was taking a look at a class from a Wordpress template and saw that it created an image of a facebook logo using CSS content with a string of characters. The section that generates the image is as…
-
4
votes1
answer1790
viewsQ: Divide in circles with responsive layout
I’m trying to make a page that contains div in circles and which fit one below the other when the layout decrease, for example, to cell phone sizes. With the common size I would like them to be 4…
-
0
votes0
answers416
viewsQ: Configure external access to a local Magento server
I have a 64 bit Ubuntu server configured on a virtual machine (Virtualbox) using the Bitnami installation package with Magento. I can normally access the application via any computer on my network…
-
1
votes0
answers401
viewsQ: The MSDAORA Provider is returning "?" instead of special characters
I’m going through a problem trying to configure my computer to run the application the same way it runs on the server, the characters that are returned from the Oracle database, appear with a ? in…