Recent content by KeithWilliams

Hi, I need a function to return all the groups that the current user belongs to, from Active Directory. I have spent about a day trawling through Google search results but found nothing that I can make work in VBA. So far I have the following: Set oConnection1 =...

Hi MrK, DALeffler was right in his explanation, and his proposed solution is basically what I used, although I don't have time to review the code thoroughly (the original problem was some time ago!) Keith.

Hi lagbolt, Many thanks for your detailed response. Your approach with two constructors sounds really valuable, I will look into that. Not so sure about assigning values directly to the controls on the form, as this seems less object-oriented than assigning to the underlying data source. Its...

Made some progress! I think this is better, and works just as well. In Form_ValidateIncidents: Dim form_child As New Form_Property() Dim dr_newProperty As DataRow form_child.MdiParent = Me.MdiParent form_child.PropertyTableBindingSource.AddNew()...

Hi, I have a form, Form_ValidateIncidents, which has a button that opens another form, Form_Property. The second form has a number of textboxes and other controls bound to a data source. I open the form in this case for the purpose of adding a new record. I want to initialise some of the values...

Hi, Thanks for the further suggestions. I have a fair background in OOP, its just the practicalities of applying the principles in VB .NET. I've certainly got some reading material (and videos) to work through now! After that maybe I'll tackle some application development! Thanks, Keith.

Hi, Thanks for your reply. I have downloaded the VB.NET book, which sounds really useful, and hope I will get a chance to read it soon! I'm really reluctant to go down the road of writing lots of code, because of the maintenance overhead. I was hoping the Object data source might offer a route...

Hi, Can anyone recommend a really good book on using Visual Studio 2005? I'd prefer something that gives coding examples in Visual Basic. However the key thing is how to use the IDE itself to automate many of the tasks in creating web apps or windows forms apps. Therefore it needs to have been...

Hi, I've now resolved this issue. I was able to eliminate Access from the equation by creating a Custom Citrix session, and attempting to open Outlook from within this. Outlook failed to open, although it did not return any error message. I then found that there was a known problem with...

Yes, Office 2003 is installed, including Outlook 2003.

Hi, I have distilled this problem down to a one-line program. If I create an application with one form, and put the following code in the Form_Load event: Dim objOutlook as Outlook.Application Set objOutlook = CreateObject("Outlook.Application") I have included a reference to the Microsoft...

Hi, I tried this and got the following error: (title) Windows Script Host (message) Script: C:\TEMP\keithtest.vbs Line: 1 Char: 1 Error: Expected statement Code: 800A0400 Source: Microsoft VBScript compilation error. Is this what you would expect? It looks as though it could not recognize...

Hi, So if I understand correctly, you have a report which if run as-is, lists all order ids, and you want to customize it at runtime to list just the newly created order id, before emailing it? I can't see from the syntax of the DoCmd.SendObject command how you can specify link criteria. Can...

OK, I must admit I thought that was what you were trying to achieve. I don't understand what you mean by the "link criterion", so please post more details. Thanks, Keith.

Hi, How would I know if I had scripting loaded on the server? I have tried adding Microsoft Scripting Runtime to the References, but this had no effect (and is not needed to run the application under Windows XP on my PC. Thanks, Keith.