Search results

Im afraid it dont work :S It keeps displaying me missing parameters, or the error before.. :S Is there other way for running and SQL command with a button click ?

It has been produced an error '3075' in the runtime.. Syntax error (missing operator) in the consult expression 'Shipment='KTN2009000001' and' . I follow your steps on the CTRL-G but the Immediate window is empty.. However, I dont mind using the ORDER NO.. Its more than enough with only the...

Up! .. anyone?

Guus2005.. We're almost there! But now the problem is with the debug in the line .. CurrentDb.Execute strSql It is displaying me an error.. how can I solve this? Thanks for all the great help.

Guus2005 .. you are right.. thats what I want, I want to update a field on my main table where in the fields ShipmentNo='KTN2009000001' and OrderNo = '000001' But this must be filtered as the current value on a field in the form.. for example if Im navigating on KTN2009000003 and order 000003...

Im trying this On Form_Load Me.Cliente.SetFocus and on the Cliente field.. Cliente_LostFocus() If Me.Cliente = Null then Msgbox "you gotta type something in Cliente field" Me.Cliente.Setfocus Else Me.Order.Setfocus End if This is throwing me an runcommand error.. What Am I doing wrong? Thanks...

As the topic says.. I dont have configured those fields on the table to be required because other options in database will have conflicts. But I would like to make a VBA to check if one of those 5 fields, or the 5, or 4 fields are Null when user clicks on "button1" and then display a MSGBOX...

Greetings.. I would like to know if there is a VBA to apply a value on all the fields that are filtered in a subform.. For a better understanding I took a screenshot and made a detailed explanation on it. Thanks.

Still stucked on this one.. could somebody explain me how that code works?.. does it works only for the filtered data on a query?

That would not launch an InputBox for typing the value of the field..would it?

As the the topic says.. When Click on checkBOX for true then DISPLAY an input for adding value to a text field on the same table. What would be the code for adding what you type in that inputbox add it on the field? Thanks

Well I got this code on a subform in a checkbox. Private Sub SalidaAlmacen_Click() Me!SalidaNum = Forms!MYFORM!("[Shipment]").Value Me!chkBOX2 = False Me.Requery Forms!MYFORM!MYSUBFORM2.Requery End Sub What it does is when I click it, It will automatically get a field value...

Private Sub Data1_AfterUpdate() If fAlpha = LCase(fAlpha) Then MsgBox "You Have to type UPCASE word" Data1 = Null Me.Data1.SetFocus End If End Sub This code I made is wrong, even if i type UPCASE word, it will display the msgbox,null and setfocus.. Anyone knows what Am I doing...

Ok.. I figured it out It was simple Field = Null This may work for newbies like me out there googleing.

Whats the command to clear current field when adding AfterUpdate() and BeforeUpdate() ? Im using something like this but not working. Private Sub Data1_AfterUpdate() If Data1 = LCase(Data1) Then MsgBox "You have to use CAPS" Me.Field = Null Me.SetFocus Else Resume End If...

Then if I use this it launches an debug.. Private Sub Data1_AfterUpdate() Data1 = UCase() End Sub So I could do lots of things for displaying messages, but would I be able to change automatically the LCase to UCase on the final table?

My mistake.. used to that word. I meant CAPS on.

Thanks once again SOS.

What I do is closing the FORM and ther eit shows the last form, and I have the button configured in the last form... How i might do that?

Greetings, I need to know which is the code for launching buttons without pressing them. Ive tried button_Click.Execute , button.Execute, Me.button_click = true etc. Which is the correct way for this? thanks