Search results

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, 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, 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 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 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, 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, Upgrading an Access 2000 database to Access 2003, integrating with Outlook 2003. I get the message: A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No". This interrupts the...

Hi, I am running the following code: Dim objOutlook As Outlook.Application Set objOutlook = GetObject(, "Outlook.Application") I get the error number 48: "Error in loading DLL" I am running MS Access 2000 SP-3. On this version I have the Microsoft Outlook 11.0 Object Library (MSOUTL.OLB )...

Hi, I've attached a screen shot from a form containing a subform in my database. My boss now wants to see section headers to break the rows up into sections, with headings "Objective 1", "Objective 2" etc. So at the top, just below the column headings "Apr 05" etc, would be the heading...

Hi, I build the WHERE clause in my form's record source dynamically, depending on the context in which the user opens the form. I can't put the WHERE predicates in the record source and refer to fields on another form, as the context will determine which predicates are required. So I have code...

Hi, I found the following article in the MS Knowledge Base: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/grobjdatasheet.asp That is what I need to do in my Access 2000 form: populate the data in a Chart (MS Graph object) by VBA. I tried the following code...

Changing toolbar button setting from "Default Style" to "Image and Text" in VBA Hi, I want to be able to show or hide the caption on a toolbar button according to the state of my program. I can't find a property of CommandBarControl that does the job. I can't just set the caption to empty...

Hi, I have a form with one control, an ActiveX TreeView (MIcrosoft Treeview Control, Version 6.0). I trap the CTRL-F4 event to prevent the user closing the form. However, this leads to a problem. Whatever node is selected in the treeview, the highlighting is lost. I've established the Selected...

Hi, I have an unbound text field named [Text_TargetTotalUpdateable]. To validate it, I added a validation rule: IsNumeric([Text_TargetTotalUpdateable]) However, this does not accept any value, even an integer. How can I validate this unbound field to require it to be numeric. Can I give it a...

Hi, I have scoured the forum but not found a satisfactory answer to my query. I hope someone can advise. I have a form I want to open first when the database is opened, and not allow to close until the user closes the database. I can disable the close button using Close Button property = No...

Hi, I have a subroutine where I need to know whether SetWarnings was on or off, so I can turn it off if necessary, and restore it to its prior state before returning to the calling script. In other words, I need to suppress warnings in the subroutine, but not affect the status of warnings in...

Hi, I (think I) need to create an unbound form to implement a spreadsheet-type interface. The form needs to present a one-character value from each row of data, in a grid which will be 7 columns wide and up to about 15 rows high. The problem is the need for the number of rows to be variable. I...

Hi, I am starting a new database. The database should allow users to set an attendance code for each hour of each day, for each member of a fire station's crew. The codes are = for available, blank for unavailable, and a range of other codes such as C for (Training) Course, A for Annual Leave...

Hi, I would like to open multiple instances of a form simultaneously, independent of each other. I checked out the information on this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=49847 The KB article referenced seems to depend on recursive references from one form to...

Hi, I have the following code in my form's open event: Me!Calc_Actual.SetFocus Me!Calc_Actual.SelLength = 0 This code has no effect. I want to avoid the field that initially gets focus from being highlighted (but it needs to be enabled and locked). The field already gets focus by...