Search results for query: *

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;)

Morning everyone, I hope your day is going better than mine. I have a very frustrating problem that is driving me completely nuts!! I have a macro that runs a few queries then emails a report - no problem. Originally I set Echo and setwarning to &quot;No&quot; at the onset of the macro the...

I have a query that has worked fine for months, now out of nowhere I am getting an &quot;Error 3071&quot; msg. The exact msg is: This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try...

I have Access97 and 2000 installed on my computer (Win 2000 and Office 2000)I have installed the latest service packs for Acc97 and Off2000. Access97 was installed first then Office 2000, both to separate folders. If I create a shortcut to an Access97 or an Access2000 database I receive this...

Hunter, Thank You so much! I will probably add this as an extra step so it will only have to query around 500 - 600 records (Otherwise we're talking 15000)I'll give it a shot and let you know what happens. Thanks Again, RLW

Michael, I have tried changing my field joins every which way immaginable, changing my criteria every which way imaginable (including your suggestion) but have yet to successfully return only the records that are truly unmatched. I do appreciate your suggestions, thank you for your help. RLW