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
-
1
votes3
answers3400
viewsField value related to another field of another table?
In MS Access I have two tables: tbCursos and tbPeople tbPeople contains: ID, Nome, CursoID, CursoNome; tbCursos contains: ID, Nome; It is possible to make the field CursoNome table tbPeople have the…
-
1
votes1
answer182
viewsHow to copy multiple excel files in an access 2010 database using vba
am new in VBA programming. I need a vba code in excel that copies several excel files to an access table.
-
1
votes0
answers113
viewsConnecting Powerpoint to Access through VBA?
I’m creating a kind of "urn" Power Point would like to 3 (three) basic solutions for calculating votes; When you click the confirm button, the vote is automatically sent by e-mail, to a particular…
-
1
votes1
answer438
viewsDatabase loca + Node.js
I am working on a project using Node.js. I need to use a local database, but I wanted to reconcile performance with security, and if possible, portability as well. I only know MS Access (.accdb) and…
-
1
votes1
answer164
viewsHow to change runtime driver letter in Delphi
Friends, I decided to simplify the use of a system in Delphi, using the banco de dados and the executable available in a pen drive. With that, I have my tables on Access, and arranged in a…
-
1
votes2
answers550
viewsNull value showing zero MS Access
I need to set a field in Access to Null, through SQL, but after setting this field, it gets the value Zero and not Null. Due to a business rule, I need this field to be NULL and not Zero. The field…
-
1
votes2
answers1051
viewsJob created on SSIS does not work on SQL SERVER AGENT
I have a job created in SSIS (working perfectly) that does not work in SQL SERVER AGENT. The job extracts some data from an access table, via ODBC, and loads it into a sql server location table. Sql…
-
1
votes1
answer264
viewsHow to perform a procedure only once?
I set up a payment generator that takes multiple data and saves it in a bank table, the problem is that I used the Form Onactivate event, so every time I go back to the initial form, the procedure…
-
1
votes1
answer35
viewsMicrosoft access Update Datediff
I need to do a simple update where I update the "Days" column with the current date value minus the "Opening Date" column". "UPDATE tblPendencia SET DiasPendentes = (DATEDIFF(day, DATAABERTURA,…
-
1
votes1
answer803
viewsChange path linked table ms access
I have 2 database that to be used in an application copy them from the server on the user’s local machine. Between these two banks I have a linked table, I need that when I copy to the local…
-
1
votes1
answer93
viewsUpdate an Access application
What is the easiest way to upgrade an Access desktop application with VBA to a web application with sql server?
-
1
votes0
answers113
viewsAccess - put data from a table horizontally
Hello! I have already searched in several forums, but I could not find a satisfactory solution. I have the following table: ID COD VLR_REEMB N_FICHA DT_RECEBIMENTO 1 1 4.022,06 965 24/09/2010 2 3…
-
1
votes2
answers827
viewsRemove duplicated data and return the highest value date field
We are migrating signatures from an Access database to Mysql, but before migrating I need to process some parts of the data. I need: Remove duplicate id’s Return the highest value of the date field…
-
1
votes2
answers501
viewsSQL - query True or False records
I am mounting a simple page that show records marked as blocked by admin. The field is user-block and the options are FALSE or TRUE. I thought the Query would be: "Select * from Usuarios WHERE…
-
1
votes1
answer448
viewsProblem connecting Access to Visualstudio
I created a small database in Access and I’m trying to make the connection with Visualstudio, but gives the following error message: Unrecognized database format 'c: Users wss desktop dbteste.accdb'…
-
1
votes1
answer79
viewsHow to count how many instances of a program are running from a shared folder?
I am developing an application that runs from a shared folder. In the same folder is the Access database. To avoid conflicts in Access, it will only be allowed to run by only one user at a time, and…
-
1
votes0
answers71
viewsMacro for Import in Access
I need help to create an import macro in Access, in case using Visualbasic, I need to download a zip file, inside this zip there is an excel spreadsheet, I need to extract it, copy all the data,…
-
1
votes1
answer93
viewsOpen Access Report with Criterion
I’m a beginner in C# and I’m opening a report on Access, but this report has criteria, that is, it depends on a numbering to open. This numbering I have in a textbox and my doubt is how to pass the…
-
1
votes1
answer41
viewsLooping in Rows of a VB table
I’m trying to make this loop between the Rows in the database work. I have a code ready in C# and I’m using it as a reference, but I can’t get this part to run. It was like this: For Each Row In…
-
1
votes1
answer648
viewsImport MS Access data to Sql Server via code
I need to import data that is in an Access database via Sql Server code. My software that is made in C# for many years has been integrated into an Access database. From now on we are migrating to…
-
1
votes1
answer65
viewsChanging customer information via ID
I cannot change customer information through ID Code that makes the changes in the Database public void Atualizar(Contato contato)//metodo para atualizar dados: update { OleDbParameter[] parametros…
c# database asp.net ms-access type-conversionasked 8 years, 4 months ago André Felipe Jardim Firmo 127 -
1
votes1
answer182
viewsConnect PHP with MS-Access
I am trying to connect my Access database with PHP, but it is not finding the way. I didn’t want to put the path related to HD because I host my page on a host (it uses Linux) and so I wanted to put…
-
1
votes0
answers46
viewsVisual Studio 2017 Oledb Xamarin.Forms
Guys I’m in need of help in the following, I’m doing a cross-platform project using Visual Studio 2017 and Xamarin.Forms, the problem is: I need to make a connection to MS Access Database. I’ve seen…
database mobile xamarin-forms ms-access visual-studio-2017asked 6 years, 8 months ago Crash_Override 11 -
1
votes1
answer47
viewsUPDATE update without affecting all table rows without ID
I received a table with information from some customers and I needed to give UPDATE but as the table has no ID and most of the data repeat including Cpf there is some way to give Where only on the…
-
1
votes0
answers52
viewsSearch between Access Dates for Holidays
I’m having difficulty inserting a search in MS Access to score if a collaborator is on vacation, I’m inserting the following formula: Status_: SeImed([Data_] Entre [DT INI GOZO_] E [DT FIN…
ms-accessasked 6 years, 2 months ago Ed Oliveira 11 -
1
votes0
answers79
viewsWhat is the best way to do database replication?
I have an application in WPF + MS ACCESS where users register, query, etc. The main server is located in SP, but we have branches in RJ, BA, MG, PR, RS, GO, etc, which also access the tool. Due to…
-
1
votes2
answers13773
viewsSQL 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.…
-
1
votes1
answer21
viewsGroup By - Aggregation error?
good afternoon! Thank you for your time. I’m starting in SQL (and programming as a whole!). At my base, I have several lines for the NRPROT with different prices, low values and different resource.…
-
1
votes1
answer2146
viewsExport 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…
-
1
votes1
answer922
viewsSave 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
answer86
views -
1
votes1
answer726
viewsHow to use getElementsByClassName on an Internet Explorer object in VB.Net?
I’m trying to use a getElementsByClassName in an Access macro. You are showing line error: If ie.Document.GetElementsByClassName("msgErroAdic").Length > 1 Then Being Dim ie as Object and Set ie =…
-
1
votes3
answers190
viewsRun DELETE only when you return SELECT
I have a routine where I update the local database with the data from another database. I simply execute a DELETE and then a INSERT INTO tblX (SELECT * FROM tblY (tblY is a linked table)), as below.…
-
1
votes0
answers284
viewsWeb Application in ASP.NET MVC CRUD with MS access
I’m doing a job, and I need to do a web application to track tasks. The requirements are those of the topic. It is a web application made in ASP.NET MVC and access database creating a CRUD. I’m…
-
1
votes1
answer165
viewsCompress Access Database with C#
I have a method to compress my base Access, but when I run the program I have the following error: Error: A catch Exception brings this message: {"Retrieving the COM class Factory for Component with…
-
1
votes0
answers30
viewsRight access Join association does not show all records
After I made the association between the tables the system shows only the records associated between the two tables: Tbpaciente and Tbmotivo. SELECT TBPaciente.*, TBMotivo.* FROM TBMotivo RIGHT JOIN…
-
1
votes0
answers95
viewsAdd cascading data from a column in Access with Status by Row
I need to create a control of purchases per line where generates a purchase need considering the quantity of each product per customer compared to stock availability. As in the example of the table…
-
1
votes0
answers22
viewsQuery of two tables VS + Access
I need to link two tables in the same query, but it hasn’t worked very well. I created this code: try { String StringCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data…
-
1
votes1
answer54
viewsAccess - saving data
I have the VBA code below that saves a new release. When Close the Form, even if I have entered any name, it is not saved. But I noticed that Access automatically generates a new primary key, ie…
-
1
votes1
answer290
viewsSQL Query to Group Records in MS-ACCESS
Hello, I would like an SQL command for a query in a Access. The structure of the table is: tbList Id | Nome | Genero | Endereco | Estado | ... The result I would like to group by state and count the…
-
1
votes1
answer110
viewsACCDB + PHP grab column name and table
I will upload accdb files in the database to make an import of clients in my system, in a CRM that used I could upload this file and automatically already showed the columns to be able to link with…
-
1
votes1
answer676
viewsDelphi - Access Violation in login form
Guys I have a problem, I’m beginner in Delphi and I am developing a registration and consultation system, it is almost finished, I am doing the login part of the system, where only registered users…
-
1
votes1
answer26
viewsI need help with this select
I have the following tables CAMPO1_FK 103 103 103 103 103 103 103 103 103 103 103 103 103 103 103 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108 108…
-
1
votes1
answer254
viewsSimple Quotes in Access
I have an Excel macro that reads the cell’s contents and saves it in an Access type database, when I try to insert a string that has simple quotes in the middle of the string and the following…
-
1
votes1
answer100
viewsError in GROUP_CONCAT Access function
I am performing the following SQL: SELECT e.titulo, e.descricao, e.obs, e.cupom, e.inicio, e.fim, GROUP_CONCAT(p.nome) AS teste FROM ((eventos e INNER JOIN produtoseventos pe ON e.idevento =…
-
1
votes2
answers72
viewsCount values in multiple related tables
I have 4 tables tbl_Distrito, tbl_Unidade, tbl_Servidor, tbl_Processo. tbl_Distrito: Cod_Distrito, Nome_Distrito tbl_Unidade: Cod_Unidade, Nome_Unidade, Cod_Distrito tbl_Servidor: Cod_Unidade…
-
1
votes0
answers34
viewsDoubt with JOINS and GROUP BY in an SQL (Access) query
Thanks for your help. I am not very advanced in SQL and I am facing a difficulty here, is the following: SELECT tbl_afs_pregao.numaf, tbl_items_pregao.nomeitem, Sum(tbl_items_af.qtd) AS SomaDeQtd,…
-
1
votes0
answers38
viewsWhere am I missing? A code that tries to recover data from an Access database with VB.NET
Good night, My name is Lucas and may you help me with the following doubt. I have a Windows Form in visual studio where I have a button that executes the code below. It reads an X value in the…
-
0
votes1
answer154
viewsConnect VB6 to Msaccess
I created a Msaccess Database and created a connection module. However, when the executable gives connection error. Someone has another example of how to connect VB6 to Msacess? The code to my…
-
0
votes2
answers1443
viewsMove images on VB6
Option Compare Database Private Sub Command0_Click() Do Until Me.Width < 4000 Let Image1.Left = Image1.Left - 5 DoEvents Loop End Sub Just like this allows you to move the image from the right…