Questions tagged as 'ms-access'

Tagged questions
1
answer

Problem with IIf and '['] '

In a text box of a form, you can enter a code only with normal characters or characters followed by another code in brackets: [xxxxxxx]. Depending on the type of entry, you must return one chain or another. If the chain has brackets, they are...
asked by 16.11.2018 / 10:47
0
answers

Do I need to connect a rails app to access?

I need to open an access database with rails, in order to work with the tables in that database, if someone has worked with access db can help me. Greetings     
asked by 15.11.2018 / 21:16
1
answer

MS Access VBA Value typed in txtbox1 should show values in txtbox2 and txtbox3

In MS Access 2016, the tbl01 has three fields: std_Id, stdnomb and std_nota. I have a form based on tbl01 and it has txtid, txtname and txtnota. I have been trying to write a code for the following: Al is To write a value in the txtid, the co...
asked by 12.11.2018 / 16:55
1
answer

VBA Access: Else is never taken into account

Initially I had the following code: Private Sub btn_Cambiar_Click() On Error Resume Next DoCmd.SetWarnings False Dim CambiarContraseña As String Dim coincidenContraseñas As Variant If coincidenContraseñas = DLookup("[Contra...
asked by 14.11.2018 / 17:14
0
answers

VBA Access - Error in product search engine

I am preparing a product search engine in a table. I want to know if there is a product unless it meets the given condition. If in the input of the function I put a 'c' I would like to know if there is at least one record that contains a text...
asked by 05.11.2018 / 16:02
1
answer

Doubts with the if in access 2013

I want to put a condition in a DB in a table linking 2 data, one that adds variables put by the user, and another that decides what value is for example: The options would be: Never 0-8 Sometimes 9-17 Almost Always 18-26 Always 27-36 And t...
asked by 01.11.2018 / 02:25
2
answers

delete record that are within a range of dates

I am trying to delete records that are within a range of dates I have a small error in my code: begin query.close; query.sql.clear query.sql.text := (' delete from tabla where (campo_fecha between :fecha1 and :fecha2); query.Parameter...
asked by 12.10.2018 / 15:50
0
answers

Access 2010 VBA: Modify the recordset that feeds a report

I have a report to which I want to change the recordset that feeds it from VBA, so from the form of the button that feeds it, I select a query called OTaller and I add it to the records that have certain Id filtro = "SELECT OTaller.*"...
asked by 28.09.2018 / 14:04
0
answers

How to modify independent txtboxes and add them to table data?

I have an Access Database that calculates the time between two dates; but the dates that are calculated, are not added to any table. I can not find why they are not added. The form code Private Sub Comando8_Click() CalculaTiempoTra...
asked by 27.09.2018 / 17:56
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