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
-
9
votes1
answer378
viewsFront End Access on the server
Usually we put the Back End on the server and the Front End on the local machine. Is there any problem (maybe of performance) in leaving a copy of the FE on the server for each user and putting only…
ms-accessasked 10 years, 11 months ago Regis Santos 1,574 -
8
votes2
answers694
viewsReturn the total value of items calculated in a list
I have a table with Quant and Preço. On the form, beyond these fields, I have the field Total = [Quant]*[Preço] Also, in the main form I have the field SomaTotal = Soma([Total]) That is, the classic…
ms-accessasked 10 years, 11 months ago Regis Santos 1,574 -
8
votes1
answer270
viewsPrinting with path name saved in a table
I created a table called Funcionarios where I have at least 2 fields: ID and caminho_impressao. Where I put it for example: C: User Users1 Documents\ C: User Users2 Documents\ Then I tried to print…
-
7
votes3
answers6519
viewsHow to get a difference between two dates?
Let’s just say I have an initial date equal to 30/01/2014 10:00 and a final date equal to 02/02/2014 10:00. I would like to know if it is possible to obtain a grid containing these results: If…
-
6
votes2
answers606
viewsCompetitive when using time table
I am using a vba code that transfers some data to an auxiliary table, handles and back to the original table. How do I solve the competition problem? That is, I didn’t want two users to use at the…
-
6
votes1
answer370
viewsError as.POSIXlt.Character when importing MDB into R
Hi, I looked all over the internet for that answer and I didn’t find :) I am importing an MDB (Ms Access db) into R Studio (Windows 7 R v32b) using RODBC but when giving the sqlFetch command I am…
-
6
votes2
answers1076
viewsWhat is Microsoft Access for?
It’s a stupid question, I know. I have almost no contact with MS Access. I know it is a database. Does it have anything special? Any Feature worthy of note? How does it work? What demands does it…
-
5
votes3
answers3831
viewsCheck if number is integer in Access
How to check if a number is integer in Access VBA? I tried to If Int(Me.Numero) Then Msgbox "É inteiro" End If But it didn’t work. I wanted if I typed 8.5 it returned "It’s not whole". The field is…
-
4
votes1
answer451
viewsBlock fields in Subforms in MS Access
I have the following form with a Subform: And I need to enable Check in "Approve3" and lock the other fields, but I can only get "LOCK" all or none, how can I go around? Maybe by flying in? I…
-
4
votes1
answer365
viewsProblems with connection to the MS Acces bank
Staff I developed a web application whose database is MS Access, well, when the user logs in I send the data by ajax to the java class to do the login and password validation, the problem is that…
-
3
votes1
answer416
viewsMark duplicate fields in a table
I have a table in my database and I would like to mark the occurrences where a certain code is repeated. Remembering that this code field is not a primary key. Example: Data Código Repetição Status…
-
3
votes1
answer164
viewsWhere to make the connection to the database?
In the MVVM pattern where I must connect to the database, in View, Model or Viewmodel?
-
3
votes1
answer363
views -
3
votes1
answer143
viewsc# Microsoft Access converting data
I am having problems with INSERT and UPDATE because on my machine the dates are being converted automatically, but on users' machines not. Ex: OleDbCommand cmd = new OleDbCommand("UPDATE…
-
3
votes1
answer253
viewsUsing Access to export in Excel, Parameterized Query
I am using the database Access, need to export a query to excel. My problem is this:: I am using a parameterized query in Access for the access itself to export to excel. When I make the export…
-
3
votes2
answers146
viewsError writing new record in Access database
I’m making a CRUD with Winforms in the C#, I have an error entering the date in the birth date field. This displays the following message when trying to save the new record: Missing operator syntax…
-
3
votes1
answer258
viewsRandom Records with Criteria
I would like some SQL command for a MS-Access database where I have 500 records and only to return 20 records so random being these (10 FEMININE and 10 MALE) and sorted in alphabetical order by…
-
3
votes1
answer74
viewsQuery search C# Oledb
In the program I am working on, I have made a data search form, where the name entered will be searched in the database and will return next results (Search screen) The problem is that the query…
-
3
votes1
answer500
views -
2
votes2
answers7009
viewsHow to delete data from a VBA Access table
I need a command on vba to delete records from my table REPETIRTEL the moment I close my form. This form does not have this table as data source, so I need the command to call this table and then…
-
2
votes1
answer5772
viewsUsing the Excel Application object within Access
I am creating a VBA script that exports a table in multiple shared excel sheets in a specific directory. The problem is that Excel sends a warning to confirm the file save for each file. I would…
-
2
votes3
answers2451
viewsHow to make a mask in MS Access that works for 10 or 11 digit phones?
I would like to know how to make a mask that works for phones of both 10 and 11 digits in Microsoft Access. Which would be: (99) 1234-1234 (99) 12345-1234 I only know how to use the standard masks,…
-
2
votes2
answers4436
viewsHow to refresh a form in access?
I’m trying to make a refresh to a form, avoiding close it to open it, and thought of this function. However, without success. How can I do this procedure? Public Fuction (f As a String)…
-
2
votes2
answers615
viewsSplit in VBA does not work
I have the following code snippet: CorpID = rsSQL.Fields("Name") Tmp14 = Split(CorpID, , 1) Tmp15 = Join(Tmp14) Me.nomeUsuario.Caption = Tmp15 Where I want to find only the first name of the person,…
-
2
votes2
answers1187
viewsDelphi 7 Ado Dataset not in Edit or Insert mode
I’m doing a program on Delphi 7 with Access (I know it’s old stuff). But it’s making the mistake when I try to record in a very simple thing. tblPerguntas.Open; tblPerguntas.Insert;…
-
2
votes2
answers676
viewsHow to Save Datagridview Items within a Column?
I’m creating a Budget Form, similar to the one in the photo: As you can see, on the New button, I have a new line in the bank with the budget number in the field Código and the customer in the field…
-
2
votes1
answer504
viewsADO Command / Parameter in Excel (VBA)
Hello, I am developing a code in VBA in Excel 2010 in conjunction with a database Acces 2010. In this code, I use ADO Command to manipulate the data in the database, but I am receiving an error…
-
2
votes1
answer50
viewsError retrieving SQL data
I have this code: SELECT Colaborador.IdColaborador, Colaborador.Numero, Colaborador.Nome, Colaborador.[Centro de Custo], Colaborador.Usuario, Colaborador.Responsavel, Colaborador_1.Nome FROM…
-
2
votes2
answers1842
viewsHow to import ACCESS data to MYSQL
I have a db ACCESS with many tables and a lot of recorded data, I need to import these tables for my new dbin MYSQL. someone knows a way ? or a tutorial to follow ? I’m using Mysql-Front and…
-
2
votes1
answer198
viewsaccess - subtraction in query duplicates values
I coded the following queries: Somantradastotal: SELECT artigos.Nome, Sum(Entradas.quantidade_ent) AS [Total Entradas] FROM artigos INNER JOIN Entradas ON artigos.Cod_artigo = Entradas.Cod_artigo…
-
2
votes0
answers73
viewsAccess database connection using java
I’m a beginner in java programming, and I’m trying to make a program that connects to a database and saves the information there. I created a specific class for the connection and created a method…
-
2
votes1
answer52
viewsWpf C# Oledbparameters Update Where select
I’m trying to change a query to use Parameters but when running using Parameter I get the "Data type Mismatch in criteria Expression" error. Without Parameters works normally. Follow the two…
-
2
votes1
answer136
viewsGet last Access column value
I’m developing a small application that inserts data into an access database. I am able to enter the data however I wanted to get the last ID value entered (automatic number) for a msgbox. provider…
-
2
votes0
answers458
viewsAccess database getting heavy after running query via VBA
Next, I have a database Access with a table called tblDados. This table contains 19 initial fields. I import a CSV file que contains 1 million records, so far so good, saved and close the database…
-
2
votes2
answers211
views -
2
votes1
answer137
viewsHow can I decrease the running time in my application in VBA
Hello, I am developing an application in VBA that is responsible for searching in an excel spreadsheet 2 data in different columns: the serial number, and the beginning of manufacturing. Then, I…
-
2
votes1
answer110
viewsACCESS VBA - Consultations with several periods
Good afternoon! I’m creating a chart query form. Inside the form I have some comboboxes store a string in a variable and when the client clicks to filter this string is inserted inside the "WHERE"…
-
1
votes1
answer612
viewsProblems with sql in access, incompatible data types
Image of the test/error: I only intend to search the data between a date and another, using: SELECT * FROM tblTRAZA WHERE FECMOV >= '2013-01-03' AND FECMOV <= '2013-01-09'; But I’ve tried…
-
1
votes1
answer300
viewsParameterize trip count in a select VBA routine
I would like to get the following select, for so I will provide the example below, remembering that I use the VBA of Access 2007. Goal: Count the journeys made by the fleet vehicles by Line /…
-
1
votes1
answer437
viewsConsolidation of tables in Msaccess and VBA
I have the following access database: mov_atm n_mov conta data valor mov_sc 100 200 1/8/2014 500 n_mov conta data valor 101 900 5/8/2014 800 200 900 5/8/2014 800 102 100 1/8/2014 500 109 100…
-
1
votes1
answer521
viewsVisual Studio 2010 and Connection with Banco Access
My Visual Studio 2010 (10.0.40219.1 Sp1rel), is popping the following error message when I try to create a connection to an Access database (Office 2010): The 'Microsoft.ACE.OLEDB.12. 0' Provider is…
-
1
votes1
answer138
viewsRelational Combobox C# BD Access
I am building a C# application with Access database. I have two tables one of CIDADE and another of ESTADOS. What I need is when I am selected on combobox1 a state, the combobox2 load only cities…
-
1
votes2
answers2143
viewsFilter Datagridview by Interval Between Dates in VB.NET
I’m new to programming and I’m finishing a job, but I have a problem that I’ve been facing for weeks and I haven’t been able to solve. I created a simple system that registers the Oss (service…
-
1
votes1
answer702
viewsVBA DELETE command does not work
I have a project that adds and eliminates dates, to add I have the following code: Set dbs = CurrentDb dbs.Execute " INSERT INTO TMP " _ & "(diaMes) VALUES( " _ & "'" & tmp7 & "') "…
-
1
votes1
answer220
viewsMultiple Access instances
As it opens multiple instances of the same Access Bank, I saw that a former co-worker used the command: Shell "MSACCESS.EXE " & Chr(34) & CurrentDb.Name & Chr(34) But when executing me…
-
1
votes0
answers175
viewsMS Access 2013 ERROR - No unique index found for the primary table referenced field
I’m learning MS Access 2013 and trying to create relationships with 3 tables. When I link them without the option Enforce Referential Integrity the relation is generated, however when I put the same…
-
1
votes0
answers51
viewsPass values from a Gridview to a database
I would like to know how to take the values of a gridview in windowsform and pass to my database in Access.
-
1
votes1
answer920
viewsAdd cascading data from a column in Access
Hello! I need to make a query that returns the weekly balance of certain products in stock. For example: Ano/Semana | Saíram | Entraram | Saldo ______________________________________ 2015/01 | 4 |…
-
1
votes2
answers329
viewsBD ACCESS does not accept INSERT or UPDATE
I have a solution in C# with access database that accepts SELECT, but does not accept INSERT or UPDATE, Follow code of the insert button: OleDbConnection con = new OleDbConnection();…
-
1
votes1
answer148
viewsUse "SUM" in access + Vb.net
I have a small problem in the Access query , where I have the following code : Dim cn As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Dim Da As New OleDb.OleDbDataAdapter Dim Dt As…