Questions tagged as 'ms-access'

Tagged questions
1
answer

Adequate structure

I need to know what would be the most appropriate dynamic structure to load the records of an ID and a Timestamp of approximately 3000 occurrences. Corresponds to the data of a terminal for the entry or exit of personnel with fingerprints. T...
asked by 19.03.2017 / 01:31
2
answers

Query in Access with a While cycle

Good morning. I have a problem, I would like to select data from my database in Access with a range of dates and a specific name. How can I do it? My thought is with While but it does not work for me. select * from Registro While...
asked by 23.12.2016 / 17:00
2
answers

Run query in Access from C #

I have the following code in C # that I use to consult information from a database in Access: public DataTable selcfecharegitro() { DataTable dt = new DataTable(); OleDbDataAdapter da = new OleDbDataAdapter(); DataSet ds = new Data...
asked by 27.01.2017 / 17:30
1
answer

filtering dates

I'm doing a program that filters dates from three tables in my database, the problem is when I do a search, it only shows me a table and not the three tables that I want. This is my code query.Close; query.SQL.Clear; query.SQL.Text := ('sele...
asked by 02.10.2018 / 01:46
1
answer

Macro to print report "n" times (Access)

First of all, thank you spend your time reading and / or answering my post. I'm new to forums as well as using Access. I am developing a bbdd that allows me to print product labels, depending on a delivery note number. I have created a mac...
asked by 14.12.2018 / 13:22
1
answer

Variables in SQL Access

I have the following problem, I have tried to change the following statement sql in access to include variables, but I get an error. If I do not use variables, the query works without problems. SQL statement parameters @start da...
asked by 09.06.2017 / 11:39
2
answers

Date query about BD Access

Previous information: I have a database with a Date / Time type field in Access (dd / mm / yy to hh: mm: ss). The idea is to put a date (entered in three TextBox TBDia TBMes TBAnio ) and that I take the records of that date (...
asked by 25.04.2018 / 12:04
1
answer

List by DNI - Asp.net mvc 4 db Access

I am programming in ncapas, asp.net mvc 4 bd Access and what I need is to list a data by your ID that I sent to you. If you arrive but do not filter. I still list all the info. This is my code. public List<TAsistenciaDTO> ObtenerAsistenc...
asked by 19.01.2018 / 00:08
1
answer

Problems when doing update in GridView with asp.net

I am trying to perform an update with the function of RowUpdating of the same Gridview by giving it in update , this throws an error and does not continue the execution, I have tried everything, and I searched for the solutio...
asked by 22.05.2017 / 17:17
1
answer

Syntax problem of the SQL statement in Visual Studio C #, with Access

I am new in the world of programming; This semester the professor has put us a project in C# , managing the database in Access (I use the Access 16, since I have the license of it). The problem is that when I save the data of one...
asked by 14.07.2017 / 00:43