Search results

  1. D

    Why is one field in this query being made too small

    Yes tbl_questionnaire (which is a linked sql server table) is large enough. Thank you guys. I seemed to have solved it with a "Union All" and using a select.
  2. D

    Why is one field in this query being made too small

    I am not gooe with SQL - I tried a Union All but it did not change it. Could you please suggest something else? EDIT: Sorry - hold on a second - my test just worked with Union All. I will keep testing and let you know
  3. D

    Why is one field in this query being made too small

    I realise my query may be complicated but I want to just show the full query. This is copied from a query where I am just testing it. The issue I have is that the field derwent_abstract can have up to maybe 500 to 700 characters. But the result of the below SQL always cuts the size to...
  4. D

    How to geocode an address ?

    I hope it is ok to post a comment here. That is to be expected from this API (non javascripted) Google offers two methods of geocoding 1. Through the google maps Javascript (you need a website) API http://code.google.com/apis/maps/documentation/javascript/v2/services.html and 2. geocoding...
  5. D

    Creating an appointment in outlook shared calendar using an access form

    I calendar at a time.
  6. D

    Creating an appointment in outlook shared calendar using an access form

    What you are doing is making an appointment on behalf of someone else. There can bo only one person that "makes" a calendar or email etc. But once you have an appointment ie irrespective if it is yours or you are doing it on behalf of someone else, then you can add recipients or invite people...
  7. D

    Creating an appointment in outlook shared calendar using an access form

    if there is a question in there then yes try it. your welcome.
  8. D

    Creating an appointment in outlook shared calendar using an access form

    With objAppt .Start =Format(Me!AbsenceDateFrom, shortDate) & " 08:00:00" .End = Format(Me!AbsenceDateTo, shortDate) & " 09:00:00" .Subject = Me!Subject If Not IsNull(Me!AbsenceNotes) Then .Body = Me!AbsenceNotes .AllDayEvent = True .BusyStatus = olOutOfOfficePlease note the space between your...
  9. D

    Creating an appointment in outlook shared calendar using an access form

    You need to set the start and end properties of the appointment objAppt.Start = #2/2/2003 3:00:00 PM# objAppt.End = #2/2/2003 4:00:00 PM# This I have copied from MSDN right now as I am not an a PC with Office. I do something like this to get that date time Format(Date, shortDate) & " " &...
  10. D

    Creating an appointment in outlook shared calendar using an access form

    strname needs to be before objRecip
  11. D

    Creating an appointment in outlook shared calendar using an access form

    I have no idea why. Outlook does not having leaks or objects which are not properly cleaned up. It is one of the few MSOffice / VBA things that is not so forgiving. I thus guess that in your testing you are setting outlook objects and then not cleaning them up. While testing, if you get an...
  12. D

    Creating an appointment in outlook shared calendar using an access form

    I know that "On Error Resume Next" is in my code somewhere but please understand what it means before using it. It basically means that it will skip through code without showing certain error messages. Set objRecip = objNS.CreateRecipient(strName) If objRecip is Nothing then MsgBox "You...
  13. D

    Creating an appointment in outlook shared calendar using an access form

    show your code from the point of getting the namespace to when you start to use your appointment object please.
  14. D

    Creating an appointment in outlook shared calendar using an access form

    Ok assuming you have a recipient object then it might not work with your own email address. You then need to get someone to share their calendar with you and for them to give you read AND write rights. Then you use their email address.
  15. D

    Creating an appointment in outlook shared calendar using an access form

    woooo slow down. You are missing some steps out. Your error message means that your appointmentitem object is not working. So is objFolder returning an object? If not then with whos email address are you trying this with? Try it with your own.
  16. D

    Reading a spreadsheet into access

    Hi hgus393 I am picking up your question as nobody else has yet. Your question is pretty broad at the moment and would take me a long time to even get started with an answer. May I suggest you get started and then use this thread to get some of the finer problems solved. I have no idea how to...
  17. D

    Creating an appointment in outlook shared calendar using an access form

    That is impossible. strName = Me.Text28 Set objRecip = objNS.CreateRecipient(strName) If you put your mouse over strName and Me.Text28 and it is an email address then strName on the next line must be the same.
  18. D

    Creating an appointment in outlook shared calendar using an access form

    yes provided that Me.Text28 is a control on your form that contains a properly formatted email address.
  19. D

    Creating an appointment in outlook shared calendar using an access form

    strName is a variable = you must either make that variable = to a proper email address OR you need to put Set objRecip = objNS.CreateRecipient("myemail@enail.com") The first option allows you to code this with flexibility and change whose email you use.
  20. D

    Sending multiple emails

    Have a try at the loop part, then if you cannot get it post your try and we will have something to work with.
View older results
Back
Top Bottom