Recent content by shudini

if when you say 2-3 minutes you mean from 2:00-2:59 not including 3:00, then simply color the text red by default and then use the following conditional expression to set the text green: if Expression Is minute([shuffleLength]=2) if you want to include also where it's 3:00, or any other...

any boolean function passed to Expression Is should work. so using Expression Is (minute([MyTimeField])>10 and hour([MyTimeField])>2) will work. If you can give a little more detail on your problem I can try to suggest a more specific solution.

kudos terbs - thanks for explaining it!

it's actually really easy - look at my original post it describes the method. You would need to use vb to open a recordset with the primary key of each record you want to export to pdf, then loop through that recordset using docmd.openReport whereCondition:="fldID=" & rst!fldID let me know if...

my pleasure - good thing i was still subscribed to this thread :)

i haven't had access to 2007 yet, but I would assume it would work the same way. The way i've done this in the past is by creating a form with a button to generate the report. this button first opens the report in design view in hidden mode, changes the caption, saves the changes and closes the...

Just an update... After checking the logs, the form has been successfully looping without stopping over the entire weekend. Thanks for all your help!

As i mentioned, it is purely for convenience, to see where the form is holding in its countdown, and since nothing was crashing, I didn't see why not. I don't think you're correct that the TimerEvent is firing while it's still running - if that was the case I would have a system crash often...

Do you really think the Timer Event is firing even when it's in the middle of running the Timer Event? Why would this not cause my program to crash any time the processing takes longer than 1 second? This lead me to believe that the Timer Event fires 1 second after completing the previous...

When the counter hits 0, the timer even calls the procedures mentioned. These procedures can take up to a few minutes to process. Because the procedure is called from the timer event, the timer event is not again fired until the other procedures return control to the timer event which is when...

Dim strWhere as string Dim Count as Integer Count=0 If not nz(me.project,"")="" then 'THIS IS ONLY NECESSARY SINCE I DON'T KNOW IF THE VALUE OF THE COMBO IS NULL OR BLANK strWhere="[Project_Code]='" & me.project & "'" Count=count+1 End If If not nz(me.supplier,"")="" then...

what you really need to do is to dynamically build the where statement before you run the DoCmd function. This way it will include only the requested parameters and based on what they select, you can build a string that will only filter what you want.

You could always use an AutoKeys macro. Create a macro and name it AutoKeys. Then, you can assign key sequences to be trapped. For your case, {F2} would trap F2 function key. ^{F2} would require CTRL + F2. You can google to get a list of all shortcut keys.

i guess i can try that. i'll keep you posted. Any theories on why that would make a difference?

I know it's excessive, but this way I see the countdown. It doesn't matter from a processing perspective since it's on a dedicated system. As far as some kind of system parameter, I checked every setting I know of in Windows XP but every one I know of is turned off. This is why I'm hoping...