Search results for query: *

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

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 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 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")

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

Is there a way to prevent advancing slides in PowerPoint? I know you can turn off advancement with a mouse click, but using the arrow keys, or clicking the arrows that appear in the lower left also still work. I am developing training modules, and would like to create them so that they must be...

I am trying to modify a report that is built in Excel. Currently, an Access DB is opened, and data is exported using several queries and macros to 4 Excel workbooks, then the Excel report is opened, and it pulls the data from the 4 workbooks, very clunky. I'm trying to pull the data directly...

If possible, please help me with this somewhat unique problem. I am trying to modify a report that is built in Excel. Currently, an Access DB is opened, and data is exported using several queries and macros to 4 Excel workbooks, then the Excel report is opened, and it pulls the data from the 4...

I've read some similar posts, but nothing with this unique problem. I'm trying to Query data into Excel from a Query that exists in Access. In the Excel query setup, the Access Query is showing up as a table, which is fine. However, the Access query requires a date input, which is normally...

I've read some similar posts, but nothing with this unique problem. I'm trying to Query data into Excel from a Query that exists in Access. In the Excel query setup, the Access Query is showing up as a table, which is fine. However, the Access query requires a date input, which is normally...