Search results

sorrry if i'm unclear I just dont have the database with me and I have to finish this query really early tomorrow morning, so i need to know how to do it now! The elapsed time is formated as Date/Time, it shows up as 00:20:45 for an elapsed time of 20 minutes and 45 seconds. Week of the year...

I'm not at work so here is a sample query.. it's just a rough sketch... Select Avg([Dwell_Time]) AS AvgDwell, WOY From OldDate Where date between #3/1/2008# and #6/30/2008

raskew. the elapsed time is already stored in the database, so what I'm trying to do is avaerage the elapsed time by week. I have a calendar table with WOY I joined with my main table so it is no problem pulling by week. When I pull elapsed time by average it just doesn't come out right.

I need to calculate average time!! I'm having a lot of problems doing this. I have a field that I'm trying to average that shows up as for example, 00:20:45 which is 20 min and 45 seconds, which is the amount of time a user has been in our facility. I want to average this field by week, but...

umm. how come when DoEvent is in the code it work and when I take it out the code will again delete my query??? that makes no sense

Dude that's what I said. That is the only code that runs when I click that button. I'm so clueless to what is happening...

After I run this code my object query get completly wiped out (as in the SQL gets deleted). I have no clue why this happens, Here is my code... help! Private Sub Print_Click() If IsNull(MachineBox) Then MsgBox "Please select a machine" Else DoCmd.OutputTo acQuery, "MachinePrintOut"...

thanks namliam, i guess all i needed to know is if i could use sendobject. that code is from another database.

I have this code in another database to create the report through VBA, but I have everything running in a macro... how can I just make the warning stop when I run my Macro that uses SendObject!?!? Option Compare Database Public Function Email(strTo As String, _ strCc As...

I have a macro that sends out e-mails and when the e-mails are sent out there is a warning that says something like "a prgram is trying to automatically send an e-mail on your behalf. Do you want to allow this?"... I want to use redemption to make this stop. can anyone provide the modules/code...

hey thanks for all the help.. i may utilize this, the only problem is this will lower outlook security, so we'll see.

thanks graf...ClickYes works, but to get the pro version it costs money... so hopefully there's an alternative.

I don't think I can use this. I send mass reports to mass amounts of email addresses through Macros/vba.

thanks for the response but my email is being mailed through Macros to send a massive amount of reports.. I think I should've clarified that in the original post, sorry.

I have outlook 2007. are there any other programs out there other than ClickYes and Redemption to stop the e-mail confirmation message?

lol tell me about it.. most the databases i work with are made by interns, which explains the issues. I myself am an intern.

My bad, overlooked those quotes

Brian, I changed my query to this SELECT [Q01 Generate Data with Duplicates].[Report Dt], [Q01 Generate Data with Duplicates].Controller, [Q01 Generate Data with Duplicates].[Eq Init], [Q01 Generate Data with Duplicates].[Equip Nr], [Q01 Generate Data with Duplicates].[Dwell Start Dt], [Q01...

Namliam, Changing it to Y or N did not work. When I run the query it brings up a prompt with Y then N, tell me to type something in. Here is my query... SELECT [Q01 Generate Data with Duplicates].[Report Dt], [Q01 Generate Data with Duplicates].Controller, [Q01 Generate Data with...

I have an IIF field 'Inbound : IIf([Dwell Start Event]="RMFC",Yes,No)' that outputs -1 or 0 depending if the value is Yes or No. How can I make is so the result will say Y if it's -1 and N if it's 0? I tried changing the Yes and No to Y and N, but it didn't work.