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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MARKNLA2

    Substituting Values in a Report for Other Values

    Try the iif(isnull(....)) function.
  2. MARKNLA2

    Combining Text fields

    WELL SKYSHADOW, HAVE YOU TRIED THE TRIM FUNCTION IN A QUERY? OR EVEN AN IF(ISNULL...) MIGHT HELP. OR THE VISIBLE PROPERTIES IN THE REPORT'S DETAIL SECTION - AFTER PLACING THE FIELDS FROM THE FIELD LIST IN ANOTHER SECTION.
  3. MARKNLA2

    sendobject Report to Excel?

    TRY THE TRANSFER DATABASE MACRO ACTION WITH EXPORT INSTEAD OF IMPORT WITHIN THE ACTION ARGUEMENTS. THE SENDOBJECT IS THE EMAIL FUNCTION WHILE THE TRANSFER IS THE "SPIT OUT" FUNCTION.
  4. MARKNLA2

    Email with Access

    TRY ACTIVATING A MACRO ON THE FORM'S CONTROL. THE MACRO WOULD INCLUDE THE SENDOBJECT ACTION.
  5. MARKNLA2

    Click on E-mail address and Create Mail

    try insert hyperlink, then a option for email addresses is offered.
  6. MARKNLA2

    What's the best way to approach this?

    select each table name (one at a time) then cntl c for copy and go to database where snapshot will be filed and press cntrl v for pasting. each table will be pasted, not linked, into the new database. repeat for each table. querys, reports etc... can be done this way too - yet without pasting...
  7. MARKNLA2

    Sending Group Email from Access Table

    HAVE YOU TRIED COMBINING THE POWER OF MS OUTLOOK BY EMAILING TO SPECIFIC GROUPS/ADDRESSES FROM A SINGLE EMAIL ADDRESS, WHICH WOULD BE PLACED THE ACCESS "TO:" THAT IS, ONE ADDRESS FOR ALL IN OUTLOOK WILL SEND A MESSAGE TO ALL ADDRESSES IN THE ADDRESS LIST. AND THAT ONE ADDRESS COULD BE...
  8. MARKNLA2

    Is there a way to email a table as an attachment?

    HAVE YOU TRIED THE SENDOBJECT ACTION IN A MACRO.
  9. MARKNLA2

    printing subdatasheets

    i've got subdatasheets with subdatasheets inserted also. how can i print all the subdatasheets for one record? marknla2
  10. MARKNLA2

    insert text into report from text file

    have you tried the transfer text in the macro actions? marknla2
  11. MARKNLA2

    Link to tables on network start up.

    do you want to open a table/form/report on startup into you dbase? if so, try tools then startup then select the form\report for startup. i don't display database window while opening a custom made switchboard/form. additionly, you've linked the tables via get external data and link - right...
  12. MARKNLA2

    insert text from text file into report

    have you tried the transfer functions in the macro commands? maybe transfer the text file into a table and then query from the table. hope that helps. marknla2
  13. MARKNLA2

    substitute and replace functions

    how do i use the substitute and replace functions from the query design grid? can the be used as expressions in the field row or criteria row? what about within an update or append query? marknla2
  14. MARKNLA2

    Insert into replacing

    i tried the replace and substitute functions in an update's and append's criteria row. now i'm writing an expression based on iif. - which didn't work. where would the replace function be written? not the criteria row. marknla2
  15. MARKNLA2

    A challenge - Find & Replace within a column

    i tried the replace and substitute functions in an update's and append's criteria row. now i'm writing an expression based on iif. where would the replace function be written? not the criteria row. marknla2

Part and Inventory Search

Back
Top