Questions tagged as 'ms-access-2010'

Tagged questions
1
answer

Read access file from php [closed]

Is it possible to directly read an access file from php, without using odbc or dns? I can do it with excel files without problems, but using only the access file can it be done? This is to import data to a mysql database on the web. Thanks     
asked by 11.01.2017 / 19:35
2
answers

Access images form

I have a field in an Access table of type Attachments where I store several images for the same record. I need to present in a form all the images associated with a record, in such a way that 4 or 5 images can be visualized at the same time, tha...
asked by 08.11.2016 / 13:13
1
answer

Save picturebox image in bd access with C #

I have a BD Access 2016 with a table that contains an OLE object field, in Visual Studio 2012 I have a WF project where I have a form that contains a pictureBox to attach the logo. I have an insert button that calls the statement made in...
asked by 29.05.2016 / 12:08
0
answers

Database: a table by "section" or a single table with all the capos

My question I think is simple and it is rather theoretical. I'm designing a database in Access. Basically, each record that contains the information that I need, has as its primary key the document number of the person. Each person will be re...
asked by 10.12.2018 / 18:38
0
answers

Passing rows to columns in Access 2013

I would like to know how I can do to pass the data of a table and show a concatenated result separated by commas in Access 2013, I show next how the table is and the result after the process. Original Table Response Table     
asked by 27.09.2018 / 18:02
1
answer

SQL. Table with quarterly averages based on monthly data

I have a table with monthly numeric data fields (January to December) for several years. I want to generate a new table that contains the quarterly averages for those numeric fields for each year, so that the generated table should look like thi...
asked by 27.09.2018 / 16:46
0
answers

cross-queries with two OleDbDataAdapters

I am trying to insert records in an Access table using an OleDbDataAdapter. The data to be inserted is previously retrieved from another table in the same Access database with another OleDbDataAdapter, but when I run the Update method of the...
asked by 18.07.2018 / 17:09
1
answer

Access 2010 - VBA Load Memo-type data in a text box of a report. Insufficient space

To load some data into an Access report, I use the following VBA code: Private Sub Report_Load() Call Acceso_Informacion Dim basica As DAO.Database Dim tabla_ejemplo As DAO.Recordset Dim Texto As String Set basica = CurrentDb Set tabla_ejemp...
asked by 11.07.2018 / 17:13
0
answers

error 53 when executing shell

In an Access form I have a button that I want it to execute: Shell ("c: \ Windows \ system32 \ osk.exe"). The bbdd runs on a touchscreen laptop so that when you click on the button the shell is run and the Windows screen keyboard appears in o...
asked by 03.05.2018 / 15:16
1
answer

Microsoft Access conditional format if a value is "x" and greater than 6 months

I have a database in Access , there are records that are in "Pending" value and have a date longer than 6 months so I want to make the date field turn red If the condition is as follows: If the "Status = Pending" field and the date is >...
asked by 22.12.2016 / 04:36