Search results

Hello everyone. The problem is when I click a record from a "Search form" this one links the original record form using the code DoCmd.OpenForm "Piezas", acNormal, , "PiezaID=" & Me.PiezaID Once this form is opened and I try to navigate through the rest of the records using a next and previous...

Hello Static First of all, sorry for my last reply. It was a bit late and I should have answered your post in another better moment. I have tried to code DoCmd.GoToControl Screen.PreviousControl.Name DoCmd.RunCommand acCmdDeleteRecord Maybe this is just not the right code for that I should...

I dont know. It doesnt allow me to delete it... maybe I am just doing it wrong. What code would you use if you put the runcommand? Thank you for your help

Hello Everyone. I have a problem with my database. I am trying to delete records from my subform but I cant find the solution for such a simple operation. I have been trying with code like DoCmd.RunCommand acCmdDeleteRecord but its been fruitlessly. To explain the problem in much easier...

Thank you for the advice. I'll take the word!!

Thank you sneuberg for your solution It worked!!! You saved me. Now i see that there are some values returning 0 euros so that might be the error that it was happening. thank you everyone for your replies!!

Hello everyone. First of all, thank you for all your replies. The thing is when I dont put the expression "FormatCurrency", the criteria works... There must be something. To make it clearer i posted a video on Youtube. https://youtu.be/oB3f1e9eDPM I hope this will help. Sorry for my English...

Hello everyone. I have a problem developing my query. This is to be used in a search form. The source of the query is just 1 table with 5 fields + 1 calculated. When I try to insert some criteria in the calcultated field (FormatCurrency(Dsum("Total","tblOrderDetail","[OrderID]="&[OrderID]))...

Hello there Thank you for your replies. First of all missinglinq, I don't think the problem is the code as the format seems to be okay when I debug it. It remains in European. I think that its when the code is transfer to access to the form. It changes it the date automatically. The pic is in...

Hello Static Thank you for your quick reply. The date picker was built on Access. I had 3 similar forms and they used to work fine. Now none of them do. Maybe its cos of the windows 10 update? I double checked my settings and they seem to be alright. Another thing is that sometimes the...

Hello there I have a search form in order to show some records according to show dates from some controls. The problem is when I choose the date from the unbounded control, this transforms the dates into American way instead of European and the outcome is wrong. For example: If I chose...

Thank you very much! I fix it. I don't know how could I be so blind :D

Hi there I bumped into a problem with my db. I have a form with a subform and I would like that when a press a button the properties of this subform change to Allowdeletions= False The problem is that I don't know what code I have to write to do so. Any ideas? Thank you

Sorry for the delay as I was on holidays and I was not able to deal with this. the code is the next: Private Sub cmdBuscar_Click() Call Buscar End Sub Sub Buscar() Dim SCriteria, task As String Me.Refresh If IsNull(Me.txtDesde) Or IsNull(Me.txtHasta) Then...

I dont know yet why this happens... It is really weird. When I debug the code, everything seems to be okay... Any idea? I also checked the language and region configuration from the settings of my windows and they are okay I think

Guys I need your help. I bumped into a problem.... The thing is that in this form when I introduce the date ("Fecha" in Spanish) in the txtbox to filter the form, this does not do it properly. I realized that the problem is that the Format of the date is in American (eg. "12/31/2016") instead...

Hello everyone I think I have solved this. What I have done is basically get a copy of my database and redo the form that I had problems with. I hope not to see that horrible message again :D BY THE WAY I bumped in to another problem.... The thing is that in this form when I introduce the...

This is the db. It is mostly in Spanish so I hope that is not a problem. The issue is under frmVerAlbaran "Buscar" button

Hello there Maybe this thread has been solved in the past. In that case my apologies but I couldn't find anything. The problem is that I am trying to add some functions to a form and a button. Well after finishing I get the following error message: The expression On Click you entered as the...

Fix it!!!!! Thank you Minty!!! I really appreciate the way that you share your knowledge!! Thank you a lot! you made my day!!