Recent content by brumshine

The machine is a set aside workstation at my office. 10 or so different people log into this machine on a daily basis with unique user ids. Having everyone share the same id would be perfect, however I know that won't fly with info security downstairs....

I wish! Locking the workstation sadly is not an option. When I do lock the workstation other users remote into the unit and disconnect my session. They use the machine to access a very expensive single license piece of software installed on the box. Any other ideas?

I've been trying very, very hard to get a scheduled task to run a macro that I've created. The macro runs a few queries then exports a report to a pdf on a daily basis. If I double click my vbscript file that I created the reports generate correctly. No prompts come up, no errors, works...

Baldy my man... I got it working!!! I didn't even have to use the beforeupdate(). I just did some elseifs to validate the input. Here's my code. Thanks again for helping me work through this tricky little issue. This is what worked for me: Private Sub Command4_Click() If...

yes, sorry for not being specific...

For some reason it's just closing the form when I do this... ''input validation for dates If Me.BeginDate.Value >= Me.EndDate.Value Then MsgBox ("Begin Date must be before end date") Me.BeginDate.SetFocus Exit Sub End If

The click event parses the data into a "/" seperated string. I would have done the input validation in the onClick form the beginning if I knew how to. I don't know how to stop executing the code and return the focus back to a textbox if the data is invalid. You've been very helpfull thus...

That solved half of my problem. I was using the boxes update event. Now when I enter bad values it runs the code I have in the onClick event of the button before the form before update check. Is there any way to switch that around so it first checks the value???

I'm so close to the finish line but I've stumbled... Ideally I would like the input validation to be fired off once the user clicks a submit button. Now it kicks off anytime I tab to the next box to enter a vlaue. What is the fix oh mighty access gods???

Baldy, you the man. That was exactly what I needed. That sure is a spiffy litte function. I'm just going to return the focus to the first box. I think if I put a detailed enough msgbox then my users will see what they fat fingered in eitheir box. You ROCK! thanks brotha!!

I would like to do some simple error validation on a form of mine. Basically compare two input boxes and if box1 is greater than box2 display an error message then bring the user back to the form so that they can fix it. I just need to exit the function and go back to the form. What am I...

I agree whole heartedly. The organization I work for has a very obtrsive change control process or else that would change today! If I figure this one out on my own I will put the code up for everyone to see. Thanks for the effort Coach.

Thank you very much for your suggestion Coach. My users are use to clicking the report in the mdb file. I know it's not the best way but for them it's all they know how to do. I really would prefer them clicking the report and hitting print then bam! it works!

This is a good one, get ready..... The problem: I'm hoping it is possible to print selected pages from a single report pending weather a certain condition is met. The details: The users of my report are being dispatched from 2 locations instead of 1. Both groups need only parts of the...

Wazz, way to simplify the situation. Your solution worked perfectly. I really appreciate the tip. Thanks again. BRUMSHINE