Search results for query: *

Thanks for the info.

Is there a way to disable the MS.Outlook security prompt for sending objects using a MS.Access macro? I'm trying to schedual this macro to run nightly but wont finish because of the prompt. Here is the message that I keep getting: "A program is trying to automatically send e-mail on your...

PHV, Sorry to bother you again but I have one more issue. Now that my summing time query works for a access form--how do I sum all of those hours together at the bottom of a form? Here are the results from the first step/query: Activity SumOfNonEarned Adjustments 68:36 Appeals 3:45...

PHV...Thanks so much for your response. The revised code worked-- I just had to remove the "SS" part because I didn't need the seconds. Again thanks so much and enjoy a well deserved star!!

PHV-- I tried your query and unfortunately it did the same thing it did to me. Here was the outcome: fldClaimType SumOffldNonEarned Adjustments 2.22291666666667 Appeals 0.15625 ASK 0.398611111111111 Dashboards 0.186111111111111 dataentry 0.165972222222222 Participation...

Question, I have a Access2003 table that has a field w/a daytatype of "date/Time" w/format of "Short time". I'm trying to sum each activities time listed below (by each Activity) in a basic query for a Access form: Activity SumofHours Adjustments 0:37 Adjustments 0:45 Adjustments 1:00 Appeals...

Remou, Thanks so much for the above code. It's capturing each group every time it runs and doing the random function. Due to the "Top" issue however, I guess there's no way to run this code and still give me a set amount of ramomized claims i.e 15 total each time this code runs? Again, I want...

For the above table, I'm trying to run a query to capture claim #'s randomly from each Group# within the tbl.even if that group# only has one claim. Note: I would need that groups one claim to show up every time I run the random query.

Remou, The code did run however,after running it a few times--not all of the group #'s had claim examples in the random pull. For an example, I'm trying to get group#22222(1 claim) to show up each time I run the random sample query. See the below sample table: CLAIM_NUMBER GROUP_NUMBER...

I'm trying to run a "random" query in access03 from a table that has only two fields i.e claim# and Group#. The problem is that when I run the below code--it gives me the random amount of claims(360) needed however, its not capturing all groups within that random query each time I run the...