Questions tagged as 'ms-access'

Tagged questions
0
answers

Problem in changing a value in access

It is a table that shows different information one of them is that it shows a date of entry, but in that table sometimes I change the format per month. day and year and I want dd-MM-YY. There is some way to change the format in the query I have...
asked by 04.09.2017 / 00:37
0
answers

C # connection with Acces report wiewer

I get this error, the problem is that I am looking for a long link line and that is generated by Report Viewer , there is some % co_of% uncontrolled of the type Excepción in System.Data.OleDb.OleDbException    Additional i...
asked by 25.05.2017 / 20:57
1
answer

Check if A CONSTRAINT UNIQUE already exists in a table? Visual Basic .NET Access

I'm in Visual Basic trying to make a program to manage a database, well I have the following SQL statement in the program to add UNIQUE to two fields of a table: "ALTER TABLE RESEARCHERS ADD CONSTRAINT RESEARCHERS UNIQUE (resEmail, resPhoneNu...
asked by 27.04.2017 / 13:59
0
answers

Windows7, ISS7, Classic ASP with Access .mdb; Error in recordset .addnew statement

I would appreciate if you could guide me with this problem. I am retouching an ASP application that until now works in XP environment to work in W7 environment. There are no problems to connect and open recordsets in reading to the BD ACCESS (.m...
asked by 03.02.2017 / 15:34
1
answer

Error 3011 when exporting access data to excel

Good morning. I have a problem when I try to generate an excel from an access table (2010). I have the following code. Dim outputFileName As String Dim objExcel As Object 'New Excel.Application Dim objWB As Object 'Workbook 'Nombre del archivo...
asked by 06.02.2017 / 11:13
1
answer

Change datetimerpicker format to yyyy / mm / dd of DateTime type in c #

In this code I'm just showing the date dd / mm / yyyy datetime fecha = dateTimePickerFalta.Value.Date I want to get it in yyyy / mm / dd but of type dateTime How can I do it? example: When I select a date, the format it shows is...
asked by 09.11.2017 / 22:15
0
answers

Connect Access database with Visual Studio Servers Explorer 2017

I have the following problem, I can not connect a DB access to Visual studio 2017 through the server browser to use dataset, but if I can do it through code, the error that comes up is the following:    The application can not be started. The...
asked by 04.01.2019 / 21:54
1
answer

Server for VBA Access application

A friend has a business and has a system made in VBA .. He uses Access for the tables obviously, forms and reports, and encodes with VBA. I had proposed a client server system: Delphi + MySQL. But I do not accept. And you want to create a...
asked by 01.06.2018 / 15:42
1
answer

Export Access to Excel Report

I apologize I have a report in access with a format in the headers of the columns, and hypernicule fields, when exporting to excel I export it without format, how can I do the export respecting the format that I have. Thanks     
asked by 12.03.2018 / 19:12
1
answer

C #. Use sql data to do access searches

Bunas. I would like to know how I can extract data from sql and use each extracted data to do a search in a database in access. This is my code. public DataTable heater() { DataTable dt = new DataTable(); DataTable dt1 = ne...
asked by 28.11.2016 / 16:22