Search results

Or: UPDATE Computers SET Computers.[Network] = [forms]![frmExistingForm]![Network] WHERE (((Computers.[Serial])=[forms]![frmExistingForm]![SerialNew]));

I'm create a update query where filed Computers.[Network] is updated to [forms]![frmExistingForm]![txtNetwork]. Criteria is: Computers.[Serial] is [forms]![frmExistingForm]![SerialNew]. This works perfect. Maybe is now articulated how to write VBA code. Thanks for assistance!

Msgbox note UPDATE Computers set [Network]=( select[Network] from Computers where Computers.[Serial]='79223TP' ) where [Serial]='701964K'

No, i've got the same error again

Hi, i have code with error, but don't see why. Dim db As DAO.Database Dim strSql As String strSql = "UPDATE Computers set [Network] = (select [Network] from Computers where (((Computers.[Serial]) = '" & Me.txtSerial & "'))) where ((([Serial]) = '" & Me.txtSerialNew & "'))" Set db = CurrentDb...

I am set command button on mouse move event to open some form with on timer event. But if mouse pointer standing on command button without moving, on mouse move event is repeating. How to set event to repeat only once when mouse pointer move trought command button? Thanks for advance, Gepetto

Thanks a lot!:D

I need to show in ControlTip Text filtered result from three table fields. How to do that? Help!!!

Thanks a lot!

Hi, i have to set pop up form to open with 5 seconds delay, and to close after 10 seconds. Could anybody help me about it? Thanks, Gepetto