Search results

  1. A

    Using form field value in query criteria

    Hi. I have a query named "ClientWrkHrs": SELECT ClientCal.Abbr, ClientCal.Start_Date, ClientCal.StartTime, ClientCal.EndTime, DateDiff("n",[StartTime],[EndTime])/10+1 AS Slots FROM ClientCal WHERE (((ClientCal.Abbr) Like "*" & "jo" & "*")) ORDER BY ClientCal.StartTime; This returns the...
  2. A

    Find matching fields in different records

    Hi. I have an unmatched query based on 2 tables. The query results are: I now need to filter this to those records where StartTime matches with any Expr1. Expr1 is calculated from StartTime using dateadd function. For example, in the above, the first 2 records would be ignored because...
  3. A

    recurring calendar events

    Hi I want to extract some details from my Outlook calendar (subject and start and end dates). I have this code: Public Function GetEvents() Dim oOutlook As Outlook.Application Set oOutlook = CreateObject("Outlook.Application") Dim oNS As...
  4. A

    Find text within email template

    Hi, I have a db that creates an email from templates (the template changes depending on a selection). Each template contains key words that are replaced by data input by a user through the db using an InputBox. It generally works fine but I want to avoid using specific InputBoxes where not...
  5. A

    trying to delete outlook contact

    Hi I'm trying to use this code that I found online: Dim myOutlook As Outlook.Application Dim myInformation As Namespace Dim myContacts As Items Dim myItems As ContactItem Set myOutlook = CreateObject("Outlook.Application") Set myInformation = myOutlook.GetNamespace("MAPI")...
  6. A

    problem getting file size

    Hi Can anyone shed light on what I'm doing wrong with the code below. I'm trying to get the size of each pdf file within folder c:\attachments\ and insert this (with file name) into table "temp". I get "file not found" when I try to run it. I've also tried using FileLength = MyFile.size instead...
Back
Top Bottom