update message

[kingsgambit]

On a form I have a button that runs an update query, it updates records between to number on the form, can I get rid of the update message and replace it with "You are updating records between xxx to xxx" click OK and update

 

[dcx693]

A forum search is a powerful tool. Here's one post I found: supress warning messages

 

[wraith]

In have seen some of these warning off method, but I wanted to be able to create my own, saying you are updating xxx to xxx continue then OK.
The xxx would be what the user has put in the text boxes on the form

 

[a.sinatra]

MsgBox "You are updating records between " Me.txtBox1.Value & " to " & Me.txtBox2.Value

If i am wrong about that, could someone explain
________
PERFORMANCE VEHICLES

 

[wraith]

MsgBox "You are updating records between " Me.txtBox1.Value & " to " & Me.txtBox2.Value

If i am wrong about that, could someone explain

I can not seem to get this to work my code is

MsgBox "You are updating records between " Me.fn.Value & "to" & ln.Value
Dim stDocName As String

stDocName = "qryupdateL"
DoCmd.OpenQuery stDocName, acNormal, acEdit

 

[R6Flyer]

I can not seem to get this to work my code is

MsgBox "You are updating records between " Me.fn.Value & "to" & ln.Value
Dim stDocName As String

stDocName = "qryupdateL"
DoCmd.OpenQuery stDocName, acNormal, acEdit

wraith,

Change your msgbox code to;

MsgBox "You are updating records between " [B]&[/B] Me.fn.Value & "to" & [B]Me.[/B]ln.Value

I can't guarantee that it will work if you have warnings turned off but I can say with some certainty that it would not have worked in it's former state.

Cheers

Flyer