Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rgreen511

  1. rgreen511

    Put Access Report in the body of email

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

    Put Access Report in the body of email

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

    Link data to another Excel file excluding blanks

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

    Link data to another Excel file excluding blanks

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

    Eliminate blank entries in linked Excel file

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

    Eliminate blank entries in linked Excel file

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

    scientific notation to specific power

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

    Scientific Notation Question

    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)
  9. rgreen511

    limit decimal places when concatenating text and eqn.

    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)
  10. rgreen511

    scientific notation to specific power

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

    limit decimal places when concatenating text and eqn.

    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")
  12. rgreen511

    Scientific Notation Question

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

    Scientific Notation Question

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

    extracting audio that is saved as sound OLE format

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

    block slide advancing in powerpoint

    I think that'll do it. Thanks.
See more

Part and Inventory Search

Back
Top