Search results

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...

As i mentioned, the form is not hanging, just idling - almost as if the computer is on yet in stand by mode. When i move the mouse on the computer or click on the form, everything continues with no hitches, so it's not a problem with the programming. It also only begins to happen after a while...

Thanks for taking interest. The timer interval is set to 1000. Here is the Timer Event: Private Sub Form_Timer() anaActID = 11 analystID = 11 analystName = "Admin" sec = sec - 1 If sec < 0 Then sec = 59 min = min - 1 End If If min < 0 Then min = 0...

In the Value_if_true part of your iif statement, you are returning a comma "," if the value of me.PROJECT is null. Do you mind my asking why? A comma has no place being there. Also, after the word And you have an ampersand "&" which does not seem to be in place. Just for clarification, what do...

Hello all. I have a strange situation which I have not had much success in finding any solution for, so maybe someone here can help. I have a database which, when started, loads up a form. The purpose of this form is to perform certain actions on a one minute loop basis (basically, it checks...

a simple GROUP BY query with grouping on product and total, and aggregate sum fields for qty, cost and total would solve this. SELECT [Product#],Type,SUM(fldQty) as Qty,SUM(fldCost) as Cost,SUM(fldTotal) as Total FROM YourTable GROUP BY [Product#],Type