Search results

Yes that is! Its on the current event. Im not very good at coding. Could you explain that a little bit more Thank you Minty

Function SetformState() Dim State As AlbaranState If (Me.cboIDEstado.Value = 1) Then State = New_Albaran ElseIf (Me.cboIDEstado.Value = 2) Then State = InProcess_Albaran ElseIf (Me.cboIDEstado.Value = 3) Then State = Closed_Albaran End If...

Sorry RanMan256 that´s not what I am looking for I have a button that exports some data into a file and also disables some buttons. The only thing I want is that after pressing the "Export button", the rest of the buttons that are suppose to be disable, change its properties immediately. So...

hello there I bumped into another problem developing my database. This time after exporting some data to a pdf. file I want some command buttons to be disable. I set the me.refresh command but It does not make any difference with reference to this issue. I was wondering if there is any...

Hello!! Thank you for your help. I think I ve got it!! Thanks for everything

Hello everyone. Sorry for my lack of knowledge, but I am not too sure how to do it. It seems to be really complicate. I dont know If you could help me a little bit more about how to build that function... Arnelgp, regarding to binding the cbo to the field to the table, its been done...

Hello again. Maybe I didnt explain myself properly. I dont want to use the combobox to assign either the form is new, in process or closed. That is something that I would like it to be done automatically. It would be even better if instead of a combo box I used a textbox. For example if...

Hello everyone. "Developing" my data base I bumped into another problem. Now this time is that I am trying to set either a order is New, In process or Closed. To do so, I created a table with these 3 States and Referential Integrity with the table Orders, so number 1 is New, number 2 is In...

Dear Frothingslosh. First of all, thank you for your answer It is very nice to see people like you helping newbies like me. So as you said... If im not wrong, you mean that you would have put the variables Dim StrNumpiezas and Dim StrAlbaran as integer for example or long? Thank you again

Hello everyone again. Finally I was able to make it!!!! I used the DoCmd.RunSQL Ssql statement that I saw in a tutorial and It works. But I have doubts.... Is it correct although it works... Why is this? Should have used another statement? Thank you for everything!

thank you everyone for your help. It means a lot. I still wasnt able to make it work. I guess I am really noob on this. Could you please give me some tips with the debug.print Another thing is, if it is necessary to put CurrentDb.Execute(Ssql) to make it work? This is the print UPDATE...

Hello there. I am trying to create an UPDATE query on vba but I don't how to do it. I have been watching lots of tutorial about how to do it but I am too noob. I hope you could give me a hand. I have this code so far. I hope it would help to spot what is wrong. Dim Ssql As String Dim...

It worked with If CInt(Me.cboPedidoDetalleID.Column(6)) > CInt(Me.cboPedidoDetalleID.Column(8)) Then Thank you everyone. You are awesome!!!!

Hello Arnlgp. Well I dont speak on the video either :D :D

Hello Arnelgp I think that I know what the problem is. For some reason the comparison operation skips one of the steps and moves to Else. I recorded a video to make it clearer https://www.youtube.com/watch?v=lnZMgNM0xPg If you see. the result in one of the selections I made, NumeroPiezas...

Dear Arnelgp sorry for my lack of knowledge but in the columns there are several figures. The problem is that when any figure from column 6 (regardless if this has been selected or not) is bigger than column 8. it automatically returns that value in particular not taking into account the...

Hello there Developing my database i bumped into this problem. I wanted to compare 2 values from 2 columns of a combobox. Depending on these logical operations of these 2 values, a third text box would change its value. This is the code that I have so far to make it clearer. This code...

Re: Get rid of #ERROR [SOLVED] Thank you very much!! It worked perfectly!! you saved me this time!:):):)

hello everyone. Working on my database I bumped into this problem On my form I using some Dsum funtions to add some figures from the form, but when I'm going to introduce new data into the form, this fields are obviously empty and returns #ERROR and I would like to get rid of it. I have been...

Hi there. Unfortunately I have done this just by my self as I don't have any other support, only a 1200 pages manual (which I read). I had a lot of headaches when deciding whether or not I put ClientID in different tables. I took that decision because I consider that, for example: -Orders...