Questions tagged [Microsoft Access] (235)

2
answers

How to get rid of duplicates in the database?

There are several offices which work with the local versions of the database on Access (in the database there is a table employees and a table with the agreements), then the base monthly merge in the database of the main office and are parsed in the database to MySQL. The problem is the following: after parsing in MySql dat...
samara_VonRueden42 asked April 19th 20 at 11:57
0
answer

How to look like a query in access?

Display names of employees whose last name begins with the letter "A" to "M", the name is in the middle of the combination of letters "ek", and the patronymic name Ivanovich, or N., or Petrovich. It is not clear how to split surname and first name when they are in the same cell. That is, there is the name of the employee...
Johnson26 asked April 9th 20 at 10:12
0
answer

How to programmatically fill in reportViewer C#?

Hello. There is a database created in access. On the form is completely empty reportviewer. I want to fill programmatically, not through the constructor. Trying to do so: OleDbDataAdapter dataAdapter = new OleDbDataAdapter("Select * FROM Orders", Connect.con); DataSet ds = new DataSet(); dataAdapter.Fill(ds); reportViewer...
lisette asked April 8th 20 at 10:38
2
answers

How to connect to MS Access database via IP+port?

There is a MS Access database on a remote server, how to connect to it via static IP? As Google explained to me that MS Access does not have its own servers, and because other databases (e.g. MS SQL) to it not to connect. And if for example the base share via http/https (using Xampp or a similar program)? Or are there othe...
Rosalinda.McClure96 asked April 8th 20 at 03:00
0
answer

How to set access .ldb with the right access rights?

Good afternoon. Something blunt and I can not think of a simple solution, and gurlentex does not help. There is a network folder, it file database. There is an employee who needs this file to read. Accordingly, we have 2 files: 1) .mdb read-2) .ldb read-write. In this situation everything works. But as soon as all employees...
Roosevelt_Kilback asked April 8th 20 at 02:15
0
answer

As privaste the value of a field from a form to a query in MS Access??

There is a form. It is based on the query parameter. It is necessary to run this form and selecting the query needs to change. If I put in the query parameter >3, then all displayed. But if I put the parameter in the query >field values in the form then gives that value not recognized by the kernel as a valid Access H...
Alysa.Larkin93 asked April 8th 20 at 01:51
0
answer

How to fill a field value set?

Screen There is, for example, a table that has a field Name_comp As one line to fill it array any records? For Example "One"; "Two" ; "Three"; ...
Nikko.Wo asked April 7th 20 at 16:28
2
answers

How to set the criteria of the query via MS Access form?

Input: There is a table. It includes data on the number of produced products of different companies on a monthly basis. Based on it made a crosstab query. Horizontally - names of companies, vertically - name products. Content - Amount of produced products per year for each company and product (by folding out of the table). ...
sunny72 asked April 7th 20 at 16:08
0
answer

How to make nested queries in access?

there is such a database on access with such connections need code order to deduce the full information on customers who purchased this wood, on the staff in charge of this vacation wood, on the delivery of the wood; I did 3 of the subquery, we need to combine into 1 query using sql 1 subquery [2-1]: SELECT Orders.[Order ...
Rolando asked April 7th 20 at 10:40
1
answer

How to combine 2 sql queries into 1?

there are two subquery in access, it is necessary to unite in one the subquery qr_0: SELECT Types.[Type code], Sum(Ordered.[Subtotal with discount]) AS [Sum-total discount] FROM (Types INNER JOIN [Wood (Cimal)] ON the Types.[Type code] = [Wood (Cimal)].[The Type code]) INNER JOIN Ordered ON [Wood (Cimal)].[Code Cimala] = O...
octavia_Flatley asked April 7th 20 at 10:11