Posts by Jean Barbosa • 369 points
25 posts
-
0
votes1
answer58
viewsA: Excel Spreadsheet Macro - VBA - Application definition or object definition error (Completed)
The error occurs due to editing protection in the spreadsheet. Below two treatment options, among others possible depending on each case: Include unlocking step in code You can control the lock and…
-
-2
votes1
answer50
viewsA: A query to the database that brings the data in sequence
The order needs to be defined by a ORDER BY. Utilize FIELD together to define the sequence of ids. See an example based on your specific case: sqlfiddle SELECT user_id, name, firstname FROM teste…
sqlanswered Jean Barbosa 369 -
2
votes1
answer39
viewsA: VBA - I cannot reference there is a Range using the Cells method - ERROR 400
You can’t mix the concepts of Range and Cells. Range Selects a cell or an interval, the argument is also referenced to that used in native formulas, with letter to column and number to row.…
-
0
votes1
answer33
viewsA: Send Emails with VBA attachment
It is necessary to adjust the search path of the attachments. Combine the ThisWorkbook.Path with "C:\CoParticipacoes\Excel\Participacoes\" & Cells(linha, 2).Value & ".pdf" will generate an…
-
1
votes1
answer50
viewsA: Update Data Power Query and Copy Values by VBA
It is necessary to define that the .Refresh does not occur in background mode (background update). but cells only update the second time I run the code Whereas the background update is enabled, the…
-
1
votes1
answer23
viewsA: VBA Macro Tip - Variable content selection
Create variables during code execution. The variable allows you to refer a value/content to it and repurpose that value/content throughout the macro execution code. In the example the variable was…
-
0
votes1
answer30
viewsA: Replace word set in Excel
You can define a function that does this search and return the column title, which is the name of each group. Below is a functional example, based on the question data: Defining the VBA Function The…
-
0
votes1
answer19
viewsA: Excel, how to extract data from a column with two variables relating these variables to two other variables
It is possible to perform this action with the formula =somases, it returns the sum of an interval/column based on conditions (Time and Type, in this case). It would look like this in cell B2:…
excelanswered Jean Barbosa 369 -
-1
votes1
answer60
viewsA: For if it doesn’t work
The original code has some problems, I’ll rephrase and explain some points. Example 01 - Following the original logic of a For for each test phrase: Sub testeFraseExemplo1() Dim linha As Integer…
-
1
votes1
answer22
viewsA: MYSQL - Select with Data Column Formatted with Convert
Need to treat as string, similar to: SELECT STR_TO_DATE(date, '%d/%m/%Y') AS data FROM tbl Origin: Mysql date format DD/MM/YYYY select query?…
mysqlanswered Jean Barbosa 369 -
0
votes1
answer41
viewsA: Vba - Function number in full
The path is to follow the same logic already used in the current function, which divides the number into its size (cents, unit, ten, hundred and so on) and applies a treatment for each case (each…
-
0
votes1
answer40
viewsA: How can I hide information in php?
For the content to be displayed from a button click on, you can use the display: none (CSS) and assign a function in Javascript that changes this display as you click and the current state of the…
-
0
votes2
answers81
viewsA: How do I click the + switch to - and click the - switch to +
There are several points that need to be improved in the code structure of the question. But a way to change the icon, keeping the current code, would be so: function mostrar(id) { if…
javascriptanswered Jean Barbosa 369 -
0
votes1
answer25
viewsA: Assign formula to a cell in VBA - Appears a @
How to fix a #NAME? In the specific question, I believe the error is in the declaration of the formula within the VBA, because it will not recognize the command PROCX in en. Try: Range("Q" &…
-
1
votes1
answer31
viewsA: UPDATE PHP MODIFIES ALL TABLE ITEMS
Need to include the condition WHERE in the UPDATE, as defined in SELECT (similar to WHERE id='$id'). See documentation for more details: Update This condition will allow the script to know that it…
phpanswered Jean Barbosa 369 -
1
votes1
answer35
viewsA: PHP - Return database value - specific value
It is necessary to include the WHERE clause in the SQL database query. The SQL WHERE clause The clause WHERE is used to filter records. It is used to extract only records that meet a specified…
-
0
votes1
answer55
viewsA: Problems with web automation in VBA - Radio Button
The URL you are trying to interpret through Internetexplorer.application has an iframe (basically a page inside another page, see more here). Iframes limit selections and executions, including…
-
0
votes1
answer23
viewsA: When uploading files using Bootstrap do I need to upload all files related to Bootstrap?
See the initial template suggested by the Bootstrap documentation, there is the link in 02 files: bootstrap.min.css; and bootstrap.bundle.min.js. Part of the recommended code, at Bootstrap/Starter…
-
-1
votes1
answer31
viewsA: Alignment does not work in a div
Horizontal centering To center something horizontally in modern browsers, you can use display: flex; Justify-content: center; However, in older browsers, such as IE8-9 that does not support flexbox…
-
1
votes1
answer21
viewsA: How to prevent Hover from changing other Ivs?
It is necessary to maintain the original positioning of each card, even with the Hover. For this I created the child in the example, he who is affected by the effect of size. main { height: 800px;…
-
-1
votes1
answer143
viewsA: Merge multiple excel sheets into one
Hello. I believe you can use Powerquery to join this content. I’ll leave an example here to help you adapt to your need. In a new excel, go to import data from "Folder": Select the folder path in…
-
0
votes1
answer63
viewsQ: Select the last months, also showing the months without records
Hello. I am doing a SELECT to return the last 06 months, showing the count of records (in the example: sales), grouping by year-month. My query currently looks like this: **Schema (MySQL v5.7)**…
-
0
votes2
answers539
viewsA: Incomplete Whatsapp API message
I have never used this api, but you may need to encode the url that is inside the api call (native PHP rawurlencode()), for example: //Parâmetros $row_share['Something is wrong_whatsapp'] =…
-
0
votes1
answer142
viewsQ: Cumulative count per month
I’m having difficulty making a cumulative count in mysql. I need to count the amount of active registration accumulated in each month. Table: id | data_cadastro | data_exclusao…
-
0
votes1
answer60
viewsA: Block Administrative Page with Session
To validate Session, you cannot call the POST data because it no longer exists. You should consult what is written in the PHP SESSION. Test if so solves: <?php if(!isset($_SESSION)) {…
phpanswered Jean Barbosa 369