Questions tagged as 'ms-access'

Tagged questions
1
answer

pyodbc remote server connection

Dear, I am working on a database in ms access I make a query locally and everything works well with the module pyodbc I leave the syntax: conn = pyodbc.connect("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\Doron E\Desktop\...
asked by 01.03.2018 / 19:13
0
answers

Error data type DLOOKUP

I have the following code in access Dim mes, año, tcambioOk As String tcambioOk = DLookup("TCambio", "TCambioDivisaDolar", "IdDivisa=" & divisa And "MesFechaLIKE" & "'" & [mes] & "' AND " & "Año =" & "'" & [año] &am...
asked by 07.02.2018 / 21:22
1
answer

Does #Name appear? when I give a text box a default value in Access

I have a form in which I have a text field where the user's work date is entered, which by default I would like it to show the date of the current day. Investigating on the internet I found the function "Date ()" that does just that. The prob...
asked by 01.02.2018 / 19:53
1
answer

Query no longer works in Access

I am working in a database with information about courses and I created a query to know how many courses each vendor sold per month. This is the query: SELECT DISTINCTROW tblStudentCourses.SalesID, Format$([tblStudentCourses].[SignDate],'mmmm...
asked by 12.01.2018 / 23:03
0
answers

Help with Data Source OLEDB

Hello, good morning, my colleagues, I am trying to create a connection string through a program. The problem I have is that when I add the string and I tell the application to connect it gives me the following error. It is not a valid file na...
asked by 05.12.2017 / 17:18
1
answer

Voting system in Microsoft Access

Good morning, I just need you to help me with a code. I need to make a voting system, I already have the table ready but my code does not do what I asked. There are two questions: A) How do I correctly validate that the user has checked...
asked by 22.10.2017 / 23:19
1
answer

New Page in jqgrid

Good morning, it's a pleasure to say hello, I'm using Jqgrid to simulate an Access grid, I load it via ajax and everything right for now, my problem arises is when I need to implement the new page button that is in access I show it in the Next i...
asked by 18.10.2017 / 17:52
2
answers

Lists with Linq asp.net

I have been reading about the lists in asp.net and how it works, I currently have a web application where I do a lot of queries to the database and therefore the performance is not the desired one. I have done several exercises introducing th...
asked by 16.06.2017 / 16:42
2
answers

Check quantity and value of used items

I have a table called Modifiers : This is the structure: ----------------------------------------------------- | ModId | ModText | AdditionalCost | ----------------------------------------------------- | 58 | RANC...
asked by 22.06.2017 / 01:18
1
answer

Show Count of a Query in a Label

How about, I'm trying to show the result of a query in which I count the results depending on where my query is in a folder called conexiones and inside it has a class called conexion-general in that class I made the query in th...
asked by 06.06.2017 / 15:54