Most voted "ms-access" questions
Microsoft Access (full name Microsoft Office Access), also known as Msaccess, is a Microsoft Database Management System, included in the Microsoft Office Professional package, which combines the Microsoft Jet Database Engine with a graphical user interface. It allows the rapid development of applications involving both the modeling and data structure as well as the interface to be used by users.
Learn more…181 questions
Sort by count of
-
0
votes1
answer1976
viewsUse 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…
-
0
votes1
answer919
viewsDate handling problem in an ACCESS/VBA application with SQL Server database
I needed to migrate the database of an application made in vba using access. The database was native to access and passed to SQL Server. In access, as everything is native everything worked…
-
0
votes1
answer39
viewsTextbox Search multiplies search values
Private Sub txtSearchByDish_TextChanged(sender As Object, e As EventArgs) Handles txtSearchByDish.TextChanged Try con = New OleDbConnection(cs) con.Open() cmd = New…
-
0
votes1
answer62
viewsReplica in datagridview (Vb.net and ms-access database)
When I am making a new sale (in the case of this software I am developing), every time I add new items in the datagridview it appears together with items (or sales) previously added. I would like to…
-
0
votes2
answers137
viewsVery slow python code?? Access to Access database with pyodbc
I need to get some data from a huge access database (two, actually, depending on the input I have). I have a function that calls this bank by Chunks (if I try a fetchall gives memory problem). This…
-
0
votes1
answer335
viewsOpen Access file on linux
By connection , as I change my DSN ? one of the cases in my connection class that opens file in access case "fatura" : $strHost = ""; $strUser = ""; $strPass = ""; $strBase = ""; $strType = "";…
-
0
votes1
answer938
viewsSum and display more than 24 hours hours in Access 2007 VBA
I’m using Access 2007 to develop a garage control form, which contains information about trips made by drivers. I need to calculate the total time of each trip, and that period can be longer than 24…
-
0
votes1
answer17
viewsReportviewer deleting data from Access database
I recently added Reportviewer to my Visual Studio 2015 Community for creating and printing reports. My database already contained information, added before adding Reportviewer. I am currently 4…
-
0
votes2
answers192
viewsSeparate COM object from adjacent RCW
In this Try-catch occurs the following error message: The code: try { dbConnection.Open(); cmdQry.CommandText = "SELECT * FROM tbl_ItensEmbaOrdem WHERE idOrdem=?"; cmdQry.Parameters.Clear();…
-
0
votes2
answers65
viewsHow does this Join look properly?
I’ve been doing a lot of research on this Jay and I can’t seem to fix it: SELECT tbEquipamento.TIPO_EQUIPAMENTO, tbEquipamento.NUMERO_SERIE, tbEquipamento.COD_SITUACAO_FK,…
-
0
votes4
answers288
viewsWhat’s this Join’s syntax error?
When do I use this join, appears that there is a "missing operator" syntax error, someone can tell me where it is and why this error occurs? SELECT tbEquipamento_Movimentacao.NUMERO_ATIVO_FK,…
-
0
votes0
answers264
viewsRuntime error '424' when running SQL
I’m trying to send data from excel to access through a macro. I edited on top of a ready and it seemed to me that I was doing the same thing, but it gives "Error at runtime 424 - the object is…
-
0
votes1
answer209
viewsFiredac problem (Delphi XE 10.2 and Access 2000)
I am using Delphi 10.2, and I am trying to display the list of tables of an Access database. My BD path is higher than 128 characters... Way of my comic: pathbd := "C: basedata.......... data.mdb"…
-
0
votes0
answers369
viewsPyodbc Error: ('HY000', 'The driver Did not Supply an error!')
I’m having a little trouble using the pyodbc to connect to an MS Access. Until a few days ago, everything was operating normally, but after updating my Anaconda, a persistent error occurred in the…
-
0
votes1
answer73
viewsDoubt with LEFT or INNER JOIN and WHERE SQL Access
all right? So, I have this query here in Access: SELECT tbl_produtos.NomeProduto, tbl_produtos.PrecoVenda, tbl_precos_especiais.PrecoVenda FROM tbl_produtos LEFT JOIN tbl_precos_especiais ON…
-
0
votes1
answer308
viewsCalculate Average Cost of a Stock Position
Hello, I’m trying to create a query that calculates for all dates the average cost of the action. The formula is described below. The Average Cost Price formula in T0 is: ((Accumulated Position T-1…
-
0
votes1
answer69
viewsView SQL database data in a similar way to the Access database
Good afternoon gentlemen I am a layman in the subject of SQL database and I am trying to visualize the data of an SQL database in table form, below is the name database E3 already created being…
-
0
votes0
answers23
viewsBring only one record in a left Join even if there are more records in the relationship
Hello, how are you? This is my query: SELECT cf.id_clifor, cf.nome, lv.localvenda, ed.cidade, ctt.telefone, cf.descontoglobal, lv.id_localvenda FROM ((tbl_clientes_fornecedores AS cf INNER JOIN…
-
0
votes0
answers25
viewsuse yes in access and c# using checkbox in c# greenmark or false
I am creating a quiz and the questions are repeating. I intend to use the checkbox when checking whether or not the same checkbox has been used. I’m using the following code: int[] num = new…
-
0
votes1
answer32
viewsINNER JOIN with SOMA - SQL
Good morning! I have two tables in access that present me CPF and value, but I am not able to join the two tables adding the amount. As I do not understand access, I am trying to make the query via…
-
0
votes0
answers18
viewsRelationship between two Combobox in Access
I’m trying to relate 2 Comboboxes in Acess, but I can’t find how to do it. This is my form, I would like when selecting the value in the field "Expense Type", the values of the field below,…
-
-1
votes1
answer1241
viewsCopying record of table in itself via vba
Can you copy a record from a table and insert it in itself? I wanted to copy a record into a new one on the same table. INSERT INTO Produtos ( Produto, Preco ) SELECT Produtos.Produto,…
-
-1
votes1
answer552
viewsthe field is too small to accept the amount of data you tried to add. Try to insert or paste less data
I am using Acess, and I have already checked the size of all fields and format also direct from the bank and also in Vb.net itself.. "insert into aplicacao (codigo, convenio, descricao , valconv,…
-
-1
votes2
answers41
viewsI can’t get the stock down
I am trying to decrease the amount of stock at the time of sale and without success, I used the code below, no error appears.. Public Sub UpdateDecreaseQuantity() Try For Each row As DataGridViewRow…
-
-1
votes1
answer58
viewsRemoval of repeated values between two tables with VBA
I need help with the elimination of equal values between two tables. I have two tables with several different fields, they have a common field called cellular, one table has the number in the format…
-
-1
votes1
answer54
viewsSelect specific column of file . MDB in C#
I need to use data from a specific column in a file .MDB. I can read the file, but it only shows me first column, I tried to change the SELECT, changing the * by column name, but it didn’t work out…
-
-1
votes1
answer48
viewsMultiple Select Sum with related table parameters
I tried to make a Subselect query when a user wants to search the Asset by Product, by Location and by Situation the Total of the sum is changed. And it only adds the Asset to that = true. Follow…
-
-1
votes1
answer25
viewsDsoma using form as source
Halp! I need a text field in my form to show the sum of a given field, where the form is the source using a criterion. I can get Dsoma to run with the code below. However, as the source is the…
-
-2
votes1
answer3178
viewsMysql Error - Access denied for user 'root'@'localhost' (using password: YES)
Good morning, you guys, I really need this help, please. File: c: wamp64 apps phpmyadmin4.9.2 config.inc.php Here is the beginning of the code: if($wampConf['SupportMySQL'] == 'on') { /* Server:…
-
-3
votes0
answers23
viewsSimplify Conditional VBA Code in MS Access
I am new in MS Access and VBA, but I have been doing well with my needs. I made a code to click a button on a form that checks if the required fields are filled and runs Word Mailmerge. However, the…
-
-5
votes1
answer1017
viewsHow to search for the lowest value between columns?
I have a table with the product fields, price 1, price 2, price 3. How do I show the product at the lowest price?…