Recent content by rgreen511

Thanks for both of these posts. I tried some of the items in the second post's links, but I need to work out some of the bugs. I've tried to write code to export the query to RTF, then use this code to re-import it into an email, to no success, but I'm going to give it some more effort. I've...

I'd like to put an access report, or alternatively an Access Query into the body of an email. The SendObject Macro option works very well for attaching the report or query to an email, but I'd very much like to have the contents in the body of the email. I can accomplish this by running the...

Even more critical than the equations though is a graph that is showing the blanks as zeros.

I have an Excel file that links to another file and grabs data using a simple link, no macros. The entries are of the format (ex): 11/27/07 12.3 Several of the entries are blank, and the blanks screw up my equations that are using the data (calculating moving ranges, etc.). I'm looking...

Thanks. I already did have the if statement to prevent that, but certain equations still treat blanks as zeros. And graphs treat blanks as zeros as well. I will try using MS Query. I'm fairly familiar with it, so I'll see what I can do.

I have an Excel file that links to another file and grabs data using a simple link, no macros. The entries are of the format (ex): 11/27/07 12.3 Several of the entries are blank, and the blanks screw up my equations that are using the data (calculating moving ranges, etc.). I'm looking...

I got it to work, but kind of backwards. I was exporting the data from Access anyway, so I changed the Format property of the column to: 0.00"E-06" I think this worked in Excel too. I've never seen that documented anywhere, but it worked, so I'm happy. It's similar to concatenate, but much...

Thanks. I was able to do it by entering this into the Format box in the column properties: 0.00"E-6" and using ([yourColumn] * 10^6)

Thanks. I was able to do it by entering this into the Format box in the column properties: 0.00"E-6" and using only the lb/MMBtu: (([ppm]*(100-[% M])/100)/[BTU]*1000000)

I want to format a column of numbers in scientific notation, but all to the same power of 10. Example, I want them all to be E-06: 1.20E-06 0.25E-06 2.57E-06 etc. Excel by default makes them all whatever power naturally fits. I'd also like to avoid a concatenate function since that gets...

I'm using the following code, but I need to limit the first string to two fixed decimal places. How can I do that? lb/MMBtu: IIf(IsNull((([ppm]*(100-[% M])/100)/[BTU]*1000000)) , (([ppm]*(100-[% M])/100)/[BTU]*1000000) , (([ppm]*(100-[% M])/100)/[BTU]*1000000) & "E-06")

PHV, I can't get that to return the result I want. The first term of the string I'm trying to concatenate is an equation that returns Null most of the time. When I use that equation, it puts the E-06 in all the cells, and in the ones that don't return Null, it doesn't do the math right and...

Is there a way to have one column of my query display scientific notation to a specific power? Example, I want everything to be E-06. 1.26E-06 0.67E-06 etc. I couldn't find a way to specify it. Thanks.

I need to extract some audio from a powerpoint presentation. It is in the form of a click button that plays a sound. I tried exporting as html per this: http://www.rdpslides.com/pptfaq/FAQ00778.htm but that did not work. It had all the graphics files, but no audio files. Maybe the audio is...

I think that'll do it. Thanks.