Recent content by suziqueue

Thank you Yizhar - it will make it easier.

Is there any way to automatically show all holidays as busy in thh calendar of Outlook 2000? or automatically set up a task reminder exactly 10 days prior to every holiday? The only way I know is to go to each Holiday and manually set it up. Any ideas out there or am I stuck with the boring...

I've tried your suggestion on both the OnLostFocus of txtPort and on the OnGotFocus of txtLength (the next ctrl). Setting the value of txtPort to null if it is inccorrect works great both places, but I had to use DoCmd.GoToControl ("txtPort") in place of Me.txtPort.SetFocus in the...

I'll try both and see which one works best. Thanks again - hope you don't mind if I holler back at you if I get stuck. P-)

Thank you JLitondo, I had almost given up hope on figuring this out. I'll give it a shot. Becki

I have this code on the after update event of a text box on a data entry form. Private Sub txtPort_AfterUpdate() Dim strNumPort As String Dim strValPort As String Dim strText As String strNumPort = Me.txtPort.Value strValPort = Me.txtValPort.Value strText = "There are only " &...

The only bad thing about them saving it to something other than qryUser is that, unless they have access to the database window, they will no longer have access to that query. The button when clicked only brings up a new qryUser. Eventually your database could get clogged up with all of the...

Hey Mike great minds must think alike - I came up with basically the same thing. Only I just put this code in the on click event Private Sub Command0_Click() DoCmd.DeleteObject acQuery, "QueryNull" CurrentDb.CreateQueryDef ("QueryNull") DoCmd.OpenQuery...

aha.. See what you started jcg6 - now you have three of us trying to learn something... What were you thinking?? <grin> I've just been lucky I guess, my users actually listened to me when I told them &quot;NO&quot;. There's a scary thought - the users actually listening...... I suppose it's...

You have my curiosity up now Mike, I actually use my previous suggestion and my users know not to save the query using a different name (they each have their own front end). I've never had a problem (yet). If there is a cleaner, better way I would love to hear it. My VB knowledge is somewhere...

Just create a blank query, save it, maybe call it qryUser. On your form create a command button and exit out of the wizard. Right click in the command button in design view and go to properties. In the &quot;On Click&quot; event, use the drop down menu and chose event procedure. Click teh button...

Well for all of you tuning into this saga - I finally got the database to stop asking me to confirm every query action by converting the macro to code, taking out all of the application.setoption lines, adding docmd.echo false and docmd.setwarnings false at the beginning and NOT setting them to...

Yeh, me too - but for some screwy reason this database has decided it wants the user to confirm everything no matter what. I'm in the process of changing my macro to code - maybe if I mess with it long enough it'll quit acting like a spoiled teenager and do what it's told. If it was just on one...

Ok - perhaps &quot;Query Prompts&quot; was not the correct terminology (sorry about that). What I am referring to is the prompts that ask you &quot;You are about to run a query blah blah blah - are you sure you want to do this&quot;, &quot;Table XXX is about to be deleted yadda yadda yadda are...

Jon - there's actually several ways you can do this but try this - add this bit of code to a command button on a form docmd.openquery (&quot;query name&quot;)