Search results

  1. Ade F

    Add outlook entry to non default calendar

    http://msdn.microsoft.com/en-us/library/office/aa220100(v=office.11).aspx Hope this helps. Basically I experimented until I found the correct number for the outlook default calendar then used this to then move down to the custom calendar. In my case a google apps calendar. Which works great...
  2. Ade F

    Add outlook entry to non default calendar

    Thanks Fran. This is my last effort that worked. Here is the stripped down and streamlined code for anyone else. Dim olApp As Outlook.Application Dim olAppt As Outlook.AppointmentItem Dim olFldr As Outlook.MAPIFolder Set olApp = New Outlook.Application Set olFldr =...
  3. Ade F

    Add outlook entry to non default calendar

    Ok this goes out to Fran or someone else who can shed some light on this. I really need the calendar entry to be placed directly into the sub folder. The reason being this is being added to a google apps outlook calendar and they do not allow moving from the default calendar to the sub folder...
  4. Ade F

    Add outlook entry to non default calendar

    Thanks for you time Fran it works.;) I can use it but It pains me to ask but why cant an entry just be created directly in the specified Calendar. It would be perfect to putting it directly into the correct place.
  5. Ade F

    Add outlook entry to non default calendar

    Thanks Fran. I have tried all manner of combinations I wondered if anyone could give a code example. This is driving me crackers.
  6. Ade F

    Add outlook entry to non default calendar

    Firstly thanks to all the hard working people on here helping others. This forum has been the source for problem solving quite a few times. This is driving me up the wall now and it's probably wood form the trees but here goes. I have a folder under the default on in outlook named ANOTHER...
  7. Ade F

    ADP Best Practices

    Many thanks for your answer Michael. You have spent some quality time helping me. There are a lot of things for me to use / consider here. Have a great day. Best Regards Adrian
  8. Ade F

    ADP Best Practices

    Many thanks for the response Michael. There are keywords here that I am not familiar with. I'm wet behind the ears when it comes to sql daily maintenance and scripting. When you say re-drive I presume you mean moving the Dev Stored procedures from the Dev Back end to the Prod Back end?. This...
  9. Ade F

    ADP Best Practices

    I wondered if users here have a certain workflow when it comes to deploying and updating adp projects. I am considering making a project using access 2010 and sql express r2 2008. I am used to using access with jet projects on a split front end / backend format. I am not however familiar with...
  10. Ade F

    Sub Form data into outlook

    Cheers David, I should have called it tblMain. It contains a date and notes/memo box for observations. I'm not duplicating data the bird details/names are only in the sub form. Thanks you for the feedback anyway. I may just appoach this in a different manner and convert the report to pdf via...
  11. Ade F

    Sub Form data into outlook

    I have returned to this good ole faithful forum in the hope that somone could assist in my technical stumbling block. It has been years since my last visit but upon returning I still see the pro names with massive reply counts. My hat's off to those who are doing this as a profession and still...
  12. Ade F

    Loop / Copy from one form/table to another.

    recordset clone? From looking around in the forums would it be possible to do this with some kind of recordset clone. To then copy them into the underlying table?. I' really not familiar with such programming so I wondered if someone could come up with an example from my db? Any thoughts...
  13. Ade F

    Loop / Copy from one form/table to another.

    The DB I have attached the lash job DB I have made for this problem. I know the syntax of field is terrible but once I have this problem solved I will develop the DB from scratch. If you could look at it and even have a go then It would be greatly appreciated Many thanks neileg as you have...
  14. Ade F

    Loop / Copy from one form/table to another.

    Thanks for the reply It would be nice to go via a button route were upon pressing a button all presets stored in sequencial order on Sheetsub_ID are in turn copied into the main form at the bottom. Is this possible? If so I dont have a clue as to how to do it via vb!. Basically an engineer...
  15. Ade F

    Adding Multiple Values In A Memo Field

    Sorry to butt in people I wondered if anyone had and idea of how I would go about modding this code to overcome my problem here http://www.access-programmers.co.uk/forums/showthread.php?t=98787 It's really being a pain now and I would love some expert advice. Cheers Ade
  16. Ade F

    Loop / Copy from one form/table to another.

    Loop problem elaborated. To elaborate a little further this is the system I'm trying to put together The sheets are for commissioning reports Having chosen SheetID then Sheet_subID has corresponding parameters displayed in linked sub form. This way I can have a set amount of parameters for...
  17. Ade F

    Loop / Copy from one form/table to another.

    Please could someone enlighten me on the following scenario I have. I would like to get from a button click the information from Sheet_subID (cat_parameter) copied into the Main sheet Description field. I think this maybe would be done with a loop? Taking one from in tunr from Sheet_subID and...
  18. Ade F

    Display last 100 records

    Great stuff It works like a charm Wayne Sorry for the Names I did it very quickly to ask to question although yes it is a no no ;) . I feel a prat because all I had to do was add TOP 10. Many thanks for your ultra fast response. Regards Ade
  19. Ade F

    Display last 100 records

    Sorry but shoot me I still cannot get the query to work, I have attached a stripped down table and query for you to look at. Just the LAST ten ID's and notes displayed would be great. Cheers Ade
  20. Ade F

    Display last 100 records

    Sorry to be a dummy Please could you look at the following graphic I think I have cocked up the query. I would like the last 100 job history ID's I'm sure my syntax is wrong. Regards Ade
Top Bottom