Results 1 to 6 of 6
  1. #1
    ak247 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2011
    Posts
    3

    Help needed - access populating outlook calender and a few other questions


    hello, i'm a complete beginner to access, outlook and the other programs in office

    i have previous experience with them, but it would be considered newbish

    at the moment, i am creating a database for a coach company
    i have a booking form - which is used to fill the database up

    from this i have created another table/form that has the "start date" "end date" "start time" "end time" and a few other fields so i know what is happening on those days

    is there a way i can get these dates to populate an outlook calendar automatically

    at the moment, i have tried export from access to excel, from excel to outlook, all manually. there must be a way to do it automated.

    second question - how do i email a single report/form to someone. say someone makes a booking and i want to send an invoice - at the moment i sent a form in pdf to an email - which had all the invoices in it, i only want the one needed.

    further help may be needed, if possible i would like to talk about this in some form of IM

    thanks in advance

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You can use SendObject to send the report via email. The report needs to filter itself in some way, as SendObject doesn't have an argument to filter it. Typical methods include having a criteria in the report's source query or having code in the report's open event to set its filter based on either a form control or global variable.

    The technique used to work with the Outlook calendar from Access is called "automation". Here's a start:

    http://support.microsoft.com/kb/209963
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    ak247 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2011
    Posts
    3
    thanks for the reply. that looks like what i need so i will try it out,

    for the first thing you said though, i have no clue what/where any of that stuff is, i might need a small how to guide on how to acheive something like that

    what it is accomplishing is :
    i make a booking - invoice is generated in a report or a form
    i need to email this single invoice to a customer (pdf seems to be the best one to keep the graphics and layout)

    thanks for the help,

    if you can add me to an IM sexybwoy5@hotmail.com (i'm not worried about spam on that account, so don't worry)

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Sorry, I don't do IM except for clients. I understand what you're doing (presumably for a class), I've done exactly that for clients and my employer. You can find info on SendObject in VBA help. Here's info on one of the report filtering methods:

    http://www.granite.ab.ca/access/emai...recipients.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    ak247 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2011
    Posts
    3
    can someone tell me how to make a query, so that when you open the query, it ask you to put in the filter you want, i've done it before, but can't remember how

    i've made a standard query, with the fields i want to show, but i want it to filter by a date i specify, each time i open it. i'm not sure what to write in the criteria box though

  6. #6
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Quote Originally Posted by ak247 View Post
    can someone tell me how to make a query, so that when you open the query, it ask you to put in the filter you want, i've done it before, but can't remember how

    i've made a standard query, with the fields i want to show, but i want it to filter by a date i specify, each time i open it. i'm not sure what to write in the criteria box though
    In the criteria use something like this: CVDate([Enter Date])

    I prefer to uyse a form. See: Report Dialog Examples

    Credits: Screenshot created with Snagit 10

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-02-2011, 03:08 PM
  2. Have problem with Calender, please help !
    By mhs5466 in forum Forms
    Replies: 0
    Last Post: 07-27-2010, 02:08 AM
  3. Inserting a calender in a form
    By Nixx1401 in forum Forms
    Replies: 4
    Last Post: 07-09-2010, 06:04 PM
  4. Calender Help
    By alanl in forum Access
    Replies: 5
    Last Post: 03-27-2010, 11:43 AM
  5. MS-Access into Outlook - possible?
    By techexpressinc in forum Access
    Replies: 0
    Last Post: 01-09-2009, 01:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums