Recent content by stevo

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 =...

Thanks John, but if someone was able to open these documents it would only be an inconvenience not a big issue.

Hi John This is not code for finding an unknown password. It consists of opening a passworded document with a known password. It is for the database users to be able to open passworded documents that no one can alter. I have also included in my code Readonly: = True so that the database...

Thanks very much BOB for a your concise and helpful reply.

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.

Thanks for your reply david, however I tried using courier and I still find that alignment dependson the length of the first field.

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...

Thanks very much MStef - that does the trick.

Thanks for your help MStef, but the date reference I'm using is from an expression: - expr4: DateAdd("m",12,[FDate]). This seems to cause the problem; when refering to a simple date field it's ok.

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...