Posts by Humberto Faria • 98 points
13 posts
-
0
votes2
answers39
viewsA: Upgradeable zebra table
That’s the code already changed: /* Função para pesquisa na tabela de pool*/ $(function(){ $("#tabela input").keyup(function(){ var index = $(this).parent().index(); var nth = "#tabela…
-
-1
votes2
answers39
viewsQ: Upgradeable zebra table
I made a table in html with 5 columns and more than 300 lines. In this table I put a <th> with two lines, where in the first I have the titles of each column and in the second a field for…
-
1
votes1
answer915
viewsQ: Automatic login and password completion
I have some links that I access frequently at work, so I created a page with all these links to make it easy to access. Some of these sites I have a username and password for access. What I wanted…
javascriptasked Humberto Faria 98 -
0
votes1
answer1976
viewsQ: Use of Transferspreadsheet via VBA
I’m finishing my improvement project and there’s something that intrigues me a lot. I needed to make a report based on the result of an SQL query, which I even questioned in Export SQL query data to…
-
1
votes1
answer2146
viewsA: Export SQL query data to Excel
I managed to solve the problem. I’ll drop the code in case anyone else needs it: Public Function Relatorio() Dim sql As String Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim rel As String…
-
2
votes2
answers2802
viewsA: Excel/VBA file more than duplicates in size for no apparent reason while being saved
I once had a similar problem with Excel. I had a simple spreadsheet, no macros, no forms, no images. The only thing she had was cell information and formatting. Its initial size was 5MB, but after…
-
1
votes1
answer922
viewsQ: Save query results to an array
good afternoon! I need to get the results of this query: sql = "SELECT controle.ID FROM controle WHERE BP = '" & controlectform.nmbpbox.Value & "';" And save to an array. Later I’ll do a for…
-
1
votes1
answer2146
viewsQ: Export SQL query data to Excel
Good afternoon, everyone. I created a database to control the receipt and delivery of cards. The inclusion of the data is done through a form in excel. This form also has the option of consulting…
-
0
votes2
answers2427
viewsA: SQL Query VBA Excel
After much breaking my head, I was able to make the consultation. Below is the code developed Function SelectNome() Dim NOMEDB As Variant Dim sql As String Dim cn As ADODB.Connection Dim rs As…
-
0
votes2
answers2427
viewsA: SQL Query VBA Excel
Ishmael, Below is the complete code. This is the code of the button. Clicking this validates which of the two buttons is marked (true value). If neither is selected it shows error message. If the BP…
-
0
votes2
answers2427
viewsQ: SQL Query VBA Excel
Good afternoon! I have a problem with a query in Access via form. The Form is from Excel vba, which connects to the database. Below is the complete code. This is the code of the button. Clicking…
-
1
votes2
answers13773
viewsA: SQL query in VBA Excel
Reginald, I tried that way but still had some mistakes. After a few more searches on the internet I found something that served me perfectly. I’ll drop the code in case anyone else needs it:…
-
1
votes2
answers13773
viewsQ: SQL query in VBA Excel
good morning! First I would like to say that I understand almost nothing of Visual Basic and that all I have learned so far is in the race on forums. So if this is too simple to resolve, forgive me.…