Search results

  1. L

    Code to Upload and Save Attachments External to Access 2007

    Yes, after some searching, I did locate a script that does what I wanted. Basically, it allows the user to browse/select a file, enter a description (optional) and then upload it to the database but in reality, it just copy and saves it into another directory with the record number appended to...
  2. L

    Add Attachment Grey Out in Form

    I have an Access 2013 database with a form that allows the user to attach files. Nothing fancy, just one of the basic features for adding data. On my desktop it works perfectly but after placing the database on a co-workers computer every button in the Attachment window is greyed out, except...
  3. L

    AddContactFromOutlook command problem

    I was having the same exact problem with my 2013 Access once I split the database. However, I found a posting on another forum and with one edit it worked perfectly for me. I cannot explain how everything works, but I wanted to share this solution with others on this forum. This is a link to...
  4. L

    error 2501 The SendObject was cancelled

    I am having the exact same trouble as MrRayj60 with my Access 2007 form. I have a button that opens Outlook and puts the forms email address in, click send and everything is good. However, if I close the email without sending, it gives me a "Run-time error 2501 The SendObject action was...
  5. L

    Compile Error: User-defined type not defined

    Just wanted to share my solution to the problem. I was getting the same "Compile Error: User-defined type not defined" when it his this part of my script: Dim OutlookApp As Outlook.Application The problem was that I did not have the correct reference for Outlook. However, when I looked...
  6. L

    Assign/Email Outlook Tasks w/ Access 2007

    BrokenBiker, I know this is a VERY old thread, but I am trying to do the exact same thing that you were attempting to do and running into the same problem. Thanks for uploading the sample file. Did you ever get this working? If so, could you post the solution? Thanks again!
  7. L

    Carriage Return Causes PDF OutputTo or Sendto to go CRAZY

    Just a quick follow-up on what I have learned. If my [Description] field property in the report is Plain Text, the Output Format to PDF works fine. It produces a perfect PDF with separate paragraphs. However, if I change the [Description] property in the report to Rich Text, the Output Format...
  8. L

    Carriage Return Causes PDF OutputTo or Sendto to go CRAZY

    Well, unfortunately, changing the field from Plain Text to Rich Text did not correct the OutputTo PDF problem. It still goes crazy if there is a blank line in the [Description]. Remove the extra line and it works fine.
  9. L

    Carriage Return Causes PDF OutputTo or Sendto to go CRAZY

    SOS, Thanks for the recommendation. I will change both fields to RTF and see if I get the same error during OutputTo a PDF format.
  10. L

    Carriage Return Causes PDF OutputTo or Sendto to go CRAZY

    Paul, Sorry for any confusion. The code you provided is correct. What I was trying to show as my desired results which does not have a break. This is what I am trying to achieve in the printed report: (U) This is the bold underscored [TITLE] Field with hardcoding on either side (U) The...
  11. L

    Carriage Return Causes PDF OutputTo or Sendto to go CRAZY

    pr2-eugin, Thanks for the fast response to my question/problem. I made the recommended changes to the &nbsp; which helped clean it up. However, if I add the opening <body> before the [Description] (which I know is correct) then the carriage returns in the field are removed. So, instead of...
  12. L

    Carriage Return Causes PDF OutputTo or Sendto to go CRAZY

    I am completely baffled and need help troubleshooting the problem. Here is my problem: 1) I have a report with the following Rich Text Formatting: ="<head><B><U>(U) " & Trim([Title]) & "&nbsp(U)</u></B></head>&nbsp" & "</body>" & ([Description]) 2) The report displays perfectly on screen...
  13. L

    Uploading a file and saving it as a link

    Paul, Thank you so very much for uploading the database file!! This is exactly what I was wanting to do, but I just did not know the first place to start. This is a tremendous help.
  14. L

    Code to Upload and Save Attachments External to Access 2007

    Well...the whole thing! I have been searching the forum (this and others) because I am sure this issue has been addressed before. As I uncover information I will try to update this thread.
  15. L

    Mail Merge from Access Form To Word Doc

    Just a quick follow-up. There is a more current version of Albert Kallal's Access to Word script than provided above via the .zip file and it has numerous updates. The updated version works with the newer .docx extensions and it has a feature to create unlimited number of Word Templates. So, you...
  16. L

    Code to Upload and Save Attachments External to Access 2007

    Wow! That was fast! Yes, that sounds to be exactly what I am trying to do. However, I don't know the first place to start. Can you point me to any tutorials, sample code, etc. to help me get started? Although I am a novice, I am pretty good at picking apart code to get it to work for me...
  17. L

    Code to Upload and Save Attachments External to Access 2007

    Background: I created a simple database that my office uses to capture the outcome of meetings. Users input about 25 lines of text to summarize the meeting and then can add Attachments. I use Access 2007, so I have incorporated an Attachment field for users to upload files (Powerpoint, PDF...
  18. L

    Mail Merge from Access Form To Word Doc

    Jennette thank you SO much for posting this database example!!! I have been struggling with exporting records to an RFT format but during the conversion some of the formatting wasn't what I wanted. With this mailmerge script I think I can modify it to suite my needs. Regardless, thank you so...
  19. L

    How do I combine a Text and Memo Field

    CJ, thanks a million. You pointed me in the right direction and after a bit of trial and error, I now have it formatted the way they want it. Here is what I did: 1) left the [Descripiton] field itself as text 2) in the report, made both the [Title] and [Description] fields as RTF 3) in the...
  20. L

    How do I combine a Text and Memo Field

    CJ, thanks for responding and offering som suggestions. To answer your question, I do not need to actually combine the two fields, but just format the output so that they appear to be combined. Your second comment about setting the Description control below the Title field control is exactly...
Back
Top Bottom