Search results

  1. S

    Creating Formatted Task

    Hello Can anyone please help? I am using Access to create and assign an Outlook Task using the following code:- Set myOlApp = CreateObject("Outlook.Application") Set myItem = myOlApp.CreateItem(olTaskItem) myItem.Recipients.Add ("") myItem.Subject = "NCR Action required" myItem.Body =...
  2. S

    Opening passworded document

    I have an access database with an action button on a form. This button is hyperlinked to a word document. I would like to encrypt this document; does anyone know the code I could use to give the password to open the document using VB from within the database. Hope this makes sense - thanks.
  3. S

    Alinging text within a text box

    Can anyone please help. I am adding string fields together in a report text box. How can I get consistent spaces between them, is there maybe some sort of tab command. I have tried the following, but I still get uneven spaces depending on the length of the first field...
  4. S

    Criteria filter within query

    I have designed a query with an expression field shown below. I am trying to filter based on the text result of the expression, but it won't let me do this. I'm obviously missing something - any help would be greatly appreciated. The expression is:- exp5: IIf(Date()>[expr4],"Cal within...
Back
Top Bottom