Search results

Hi, I have now tried this directly on the server, so without the Citrix software being involved. I get the same error. I have confirmed I can view and create files in C:\Windows\System32, so I don't think it is a permissions problem. It seems as though the difference between my PC, where it...

Hi, In your VBA module, click on Tools>References. Tick the box fo something called "Microsoft Outlook 9.0 Object Library" or "Microsoft Outlook 11.0 Object Library". That should help, Keith.

Hi, I did not mean to imply there was a specific Poll function! I meant your VBA script should check for the existence of the file. Cheers, Keith.

Hi, I'm not aware of any permissions issues. If I didn't have access to see and run the DLLs, I think the whole application would fail. Keith.

Hi Ciaran, You can set up a rule in Outlook using the Rules Wizard. One of the action options is Start Application. You could specify your Access file as the one to start. Then put a call in the Autoexec macro to run a specific function, which you can code in VBA to respond appropriately, i.e...

Hi Ang, Can you use myMailItem.SaveAs "c:\Contacts DB\Send Emails\ " & Me.CompanyName & "\" & myMailItemName, olMsg ? HTH, Keith.

Hi, I have the following function on a form: Private Function GetCitrixClientHardDrive() Dim objFileSystem As Object, objDrive As Object, objDriveCollection As Object Set objFileSystem = CreateObject("Scripting.FileSystemObject") Set objDriveCollection = objFileSystem.Drives...

Hi Modest, I think I didn't make myself clear. The code snippet I am having trouble with is: argMailItem.Display True 'Verify that the item was sent (by the user). On Error Resume Next boolMailSent = argMailItem.Sent Although this should display the message as Modal, the...

Hi Modest, Thanks for your reply. I was using SMTP to try to get around the Outlook Security Update, which gives the message I described at the beginning of this thread. I have already looked for LDAP posts, but the one you linked to in this forum had disappeared. I think there was a problem...

Hi, I am sending an email generated from within my application. I want to allow the user to Preview it, and for the application to know whether or not they clicked Send. The code snippet is: argMailItem.Display True 'Verify that the item was sent (by the user). On Error Resume...

Hi, The Access 2000 help says: Maybe you should be using the CommandBars collection? Thanks, Keith.

Hi, After a further review of the Microsoft support site and this site, I wonder if I can use LDAP for Active Directory to check for a user id. Does anyone have a simple code sample? What are the software requirements for a machine running Access to be able to make LDAP queries? Does it need...

Hi, The SMTP method works OK for part of my requirement. The problem remains, I have existing code that I use to resolve the Outlook id of a user defined on MS Exchange, including the entry of a partial id. So for example a user can enter "kwi" and the system will resolve it to "kwilliams", the...

Hi, I'm not sure what you are trying to achieve or whether your code will work, but I would venture to suggest that when your code executes: DoCmd.GoToRecord , , acNewRec it is just jumping to the same new record, where you are expecting it to save the current new record and start a new one. I...

Hi, Thanks for all your replies. Looks like I might need to try using Redemption, which if it works as described, should allow me to do everything I need. ClickYes will not work for me as the scripts are running as a result of user interaction, so the user would see the message popup and then...

Hi Pat, I'm not sure the product Total Access Emailer will meet my needs. It says "Total Access Emailer avoids this problem by using SMTP rather than Outlook." However, I need to use Outlook to allow the system to validate network user ids against the outlook address book, and generate Outlook...

Hi, It is a built-in function.

Hi, You will need to change the table to have values for all 12 months. You only need to populate the values for the months you want. Then try Expr1: Choose(Month(Date()),[12],[1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11]) Keith.

Hi, I suggest you post the table structure (column names and data types) identifying the primary key. Post some sample data, and an example of the output you are trying to get. I understand your problem, and it does not sound too difficult from what you have described. Keith.

Hi, I think its behaving correctly. You had better explain the context a bit more - what are you trying to achieve? Do you want Expr1 to return the value of the 10th column in the query? Why not just use the name of the 10th column, instead of the expression? Keith.