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
votes0
answers32
viewsMove images vb6, Msaccess.vba
I added an image and a Button to a form, created this code: Option Compare Database Private Sub Command0_Click() Do Until Me.Width < 4000 Let Image1.Left = Image1.Left - 5 DoEvents Loop End Sub…
-
0
votes1
answer724
viewsMS Access - how to get 30-day date range
I need to collect registered orders from a table with the name Pedidostalao in the last 30 days.
-
0
votes1
answer3120
viewsValidate field in VBA
In Mozambique there is a unique tax identification number (Nuit), and this number takes 9 digits. How an application would look to validate the Nuit meeting the following conditions? If there are…
-
0
votes2
answers1515
viewsRemember user and password of an Oracle ODBC connection
I am connecting an Oracle database with an Access database through Oracle ODBC Driver 11.2. The problem is that every time I access the base in Access, the driver from Oracle requests…
-
0
votes1
answer1160
viewsHow to view a BD Access form directly on a website?
I want to put the information of a .mdb on a website, to make it available to the public. When opened in Access, it has forms to carry out queries. I can have a website that directly displays these…
-
0
votes0
answers157
viewsHow to use INSERT INTO (Currency Value) + SELECT (String Value) SQL DB Access
I’m trying to insert some data into a format column Currency, but the data is String. I tried to make the conversion using the Convert(Dados_String, Currency), but it didn’t work either. Follow the…
-
0
votes1
answer2054
viewsFind directory using wildcards
How to locate a folder as a file? For example, the code to locate the file TESTE.TXT is: b = dir("c:\minhapasta\t*.*xt") msgbox b But for folders the asterisk does not work. Which alternative we…
-
0
votes0
answers85
viewsChanges made to a record are reflected in the other records (Access + VBA)
I created a Vehicle reservation form where I have a field where the user must enter the destination of the trip. The user may also need more than one destination, so I have created an…
-
0
votes1
answer91
viewsVB.NET with Acces database
I’m trying to make a CRUD here using VB.NET and Access, only when I’m going to perform a INSERT returns the error: "Sintax Error in INSERT INTO statement" Code: con.Open() Dim strCmd As String =…
-
0
votes1
answer65
viewsConflicts in MS-Access
I have a table in an access database with the following fields: DATA | SALA | AULA1 | AULA2 | AULA3 | AULA4 | DOCENTE | TURNO ----------------------------------------------------------------------…
-
0
votes1
answer132
viewsReports , Doubts with sums and dates
for a few days I have had a small problem where the client requested us a change in a report we have in our system written in VB.NET Basically, Filter my Datagridview, and through it I assemble the…
-
0
votes1
answer45
viewsMs access 2 querys for the same comboboxes
Good to all I am programming a database and I would like to have a kind of 3 querys. I’ll try to be as precise as I can. I have 2 combination boxes that are interconnected, in this specific case…
-
0
votes1
answer48
viewsFunction upload multi attchements
I’m trying to create a function to upload multiple files at the same time but even with one get an error. What I might be programming wrong? 'FILE DIALOG OPENS UPLOAD PANEL Private Sub…
-
0
votes0
answers178
viewsLoad multi-attachements in various attachments in form
I am trying to create a function to upload multiple files at the same time but I think because I am choosing the next function does not actually attach the file but creates a preview. In my optics I…
-
0
votes2
answers80
viewsWhere to create a database without privileges
I created, at work, a "program" in Access because I need a database, and have a graphical environment, everything was running on until the company "remembered" to delete Access from the available…
-
0
votes1
answer493
viewsJavascript check if the Windows user is registered in MS Access Database
The need is to check if the Windows user is registered in the Ms Access database (network database), but is not working as it should. I think the problem is in the strUserName variable inside…
-
0
votes2
answers449
viewsHow to expedite VB.net database searches / Access97
Use a query searching in 3 different tables, returning this query attribute in a Datatable that will fill a Datagridview. The problem is that the search itself, this a little time, I used the TOP as…
-
0
votes0
answers74
viewsCount values in a Msaccess table
I am creating my first application and would like to know how count values of a table in Msaccess with the following conditions: "requester" and "Status" must contain specific values; If it contains…
-
0
votes1
answer75
viewsBD Access, Data field
In an Access BD with a "Data" field, when entering data in this field, is it possible to do something so that dates passed 3 days ago are rejected? If possible, please teach me! In fact, I only…
-
0
votes0
answers256
viewsHow to access a linked table in access via C#
I wonder if there is any way to make a query in an Access file, but not in a normal table created in Access but a linked file (in this example a txt). The error you made when I selected was as…
-
0
votes1
answer65
viewsAccess Database, Record Duplication
In a BD Access with fields ID (Automatic Numbering), EMPLOYEE, DATE, QUANTITY, the data is collected daily (in a single message) via Outlook. So, is it possible to prevent the same employee from…
-
0
votes0
answers35
viewsMysql Table XML via Access
I first need to know if Access can connect to Mysql database. From this connection, I need to generate through Access an XML that contains the data of a table of my Mysql database. Later this XML…
-
0
votes1
answer62
viewsVBA MS Access - Version application
Someone knows how to change the version of my access app. Like, in C# one I put the version number in the Assembly file, and then I can take that is put in a label for example. How I do this in VBA…
-
0
votes0
answers216
viewsCan you open "accdb" access files with PHP using PDO on linux?
That’s right guys, I searched but did not find how to open accdb files using PDO in PHP, my environment is linux.
-
0
votes1
answer451
viewsJAVA Query with ACCESS - Slowness
I need to access the ACCESS database, the query is accessing correctly, but I noticed that to have the return of information, the JAVA first reads and all the tables and all the data, is that right?…
-
0
votes1
answer644
viewsProblems when working with dates in the database using a maskedtextbox in dd/MM/yyyy format
I am using a Maskedtextbox in BR culture to force the user to fill in the date in the correct format (dd/MM/yyyy). I remove the Maskedtextbox string to insert into the database and record…
-
0
votes1
answer770
viewsError 3706 Microsoft Visual Basic
I am making an application and when I went to program the VBA code to connect with Access Database which was my surprise gave the error: "Error 3706 Microsoft Visual Basic" The connection line is:…
-
0
votes1
answer53
viewsBanking integration
Good afternoon! I need guidance/suggestion. Here’s the thing: we have a clock software where it records all the markings in a MS Access database. I need to create a report of each employee on the…
php mysql codeigniter ms-access codeigniter-2asked 7 years, 5 months ago Laísa Ferreira Cardoso 116 -
0
votes1
answer139
viewsSearch/select database with C#
I have a form with a button and a simple datagridView, but my problem is that I have to search my file in ". mdb" (Access database) on the computer, so it will be shown in the datagridView then the…
-
0
votes1
answer896
viewsAccess function equivalent to COALESCE
Hello. I’m trying to build an INSERT with auto numbering in Access, but I’m not getting it. In SQL Server, Mysql and Postgres I use the COALESCE function, but I can’t find this function in Access.…
-
0
votes1
answer24
viewsComparing a value of one table, with interval in another table
I am very lay in Access, but I need to use it to solve a problem. Assuming I have two tables (just to illustrate): Table A: CEP INICIO | CEP FINAL | CDD | CTC 20000-000 | 29999-999 | CDD Exemplo 1 |…
-
0
votes1
answer2182
viewsMS Access and PHP connection
I have a problem making a connection with MS Access and PHP, giving an error that I do not know how to fix, someone could help me ??? The code is this: //Abre a conexão asdasda $conn = new…
-
0
votes1
answer305
viewsStock Quantity Management C#
I cannot find a solution for stock and sales management. The scenario would be a stock of Auto parts, where I register the entry of a product in the stock with a certain amount. Cod - name - Qtd -…
-
0
votes1
answer11
viewsMS ACCESS Subselect "At Most one record can be returned by this subquery."
Would someone know to tell me the pq of this subselect is causing the error: "At Most one record can be returned by this subquery."? (SELECT TOP 1 J.observacao " + " FROM tblPendenciaHistorico J " +…
-
0
votes0
answers36
viewsAccess and excel - load parameters
is it possible to use an excel table as parameters for access queries? I currently have 4 access files to carry out the same process, but with different filters (I used 4 files to leave organized).…
-
0
votes0
answers153
viewsWrite null Datetime field in Access base (mdb)
Good afternoon to all. Please I need your help. I am trying to record/update a Datetime-like Birth field, but not always this field will be populated due to business rule sometimes it will be null.…
-
0
votes1
answer25
viewsAccess SQL syntax error to find and delete duplicates leaving only one
Good afternoon, everyone. I’m trying to make an example SQL code that I found on the Internet to find duplicates of my Access table and delete only keeping the first record. However, when changing…
ms-accessasked 8 years, 2 months ago Rodrigo BRF 73 -
0
votes0
answers48
viewsProblem Related DB
I’m making a system in C#, connected the database (Access) and the program asked to copy the database to the system folder and everything else. The problem is that the application is not saving the…
-
0
votes1
answer43
viewsError when executing select with alias
When executing the query below using "AT" in place of "T" as alias of Join is returned the following error: "Ierrorinfo.Getdescription failed with E_FAIL(0x80004005)." OleDbDataAdapter da = new…
-
0
votes1
answer136
viewsI need to update my Acces(.mdb) database from an external computer
Hello, I have a client with two stores and I need the database to be interlaced. I need a north on how to start studying this. Obs: the database is local, not in the cloud
-
0
votes1
answer103
viewsError searching by name Access ASP.NET C#
I have an error searching by name(value entered by user) in the access database he says that the values in the inside of the parameters are null. Follow the code. Person.Cs responsible for the logic…
-
0
votes1
answer109
viewsAccess - Update in table without using VBA module
I need to update a table once a month, in which the entered data should be placed in the respective current month. I have been doing this via VBA code, however, as the table has approximately 30…
-
0
votes1
answer136
viewsINSERT with Random SELECT
I have a table with several information and another empty. I need to do an INSERT in this empty table with only one information from the other table, but SELECT has to be random. I am using the…
-
0
votes1
answer316
viewsHow to calculate Access days lag
Today I use the formula =DIAS(HOJE();H2) to calculate lag time in Excel: But this source I extract from Access, someone knows the syntax to assemble this formula in Access?…
-
0
votes1
answer40
viewsNumeric data type with Access characters
I have a bank in Ae I have several fields that are essentially numerical. Only that the numbers can contain the sign of < or >. These fields can be used for calculations so I didn’t want to…
-
0
votes0
answers49
viewsCompare 2 banks
Good morning, I have two Access banks, one is copy of the other, but one of them has a record that was added, I do not know in which table or field, I would like to compare them and find which…
-
0
votes1
answer48
viewsUpdate: ASP + Access
I am trying to update an ACCESS table on my website, only it displays this error: Microsoft Access Database Engine error '80040e14' Syntax error (missing operator) in query expression '[nome] ='.…
-
0
votes1
answer37
viewsFilter data that is not between dates
We are making a bucket rental system for our tcc, but on the sales screen we only need to appear the available buckets in the selected period. SELECT tabCacamba.CodCac, tabPrestadores.CodPre,…
-
0
votes0
answers17
viewsPASS SQL FORMULA IN ACCESS (TEXT MINING)
Good afternoon! I’m passing a sql formula for access WHEN ((SA_P1_RESULT_VISITA LIKE '%VISITAD%') OR (SA_P1_RESULT_VISITA LIKE '%FACHAD%') OR (SA_P1_RESULT_VISITA LIKE '%INSTALA%') OR…
-
0
votes2
answers2427
viewsSQL 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…