Search results

Microsoft Office isn't under Administrative Templates for the group policy. This was the group policy for every computer connected to the network and the administrator told me that this is because Microsoft Office is not pushed through the networks group policy. If there is a group policy for...

This didn't work because Microsoft Access isn't configured through the group policy on our domain, it is installed onto each computer individually. Do you or anyone else have any other solutions? Thanks for all your help

Thank you for all your help. I am however doing one bit wrong and its making the function return a recordset. Could you help me with this bit

I want to fill out a combo box, I was hoping that it could directly fill out the combo box, im guessing I will need a loop to do this. The design will be like this: There is a combo box where users select a department. Once they have picked a department there will be another combobox that...

Even if there was a way to get email addresses from outlook that would be great, however the emails have to update as the outlook address book updates By the way I tried changing the select statement to this to try and show the IT departments email or even every member of the IT Departments...

Thanks I adapted it to show my email address, however I had trouble adapting it to show a departments email or even a list of all emails in the active directory

Thanks ill contact the Administrator and try and get it set using the Group Policy.

In the active directory it has each user, the department each user works in and the email address of each user

Okay so I know how to send an email using access but I wanted to know if anyone knows how to get the emails address that are in the active directory Thanks

Hi Below are the ways I know of getting around the 'Security Warning - Certain content has been disabled from the database' , however I'm not really sure which one would be best for the situation I am in. The application will be used in the work place and stored in a network folder. Making a...

It turns out finding the department is as simple as: WHERE department='DepartmentName' Its weird though because for some departments it shows some of the users whose accounts are inactive but not every inactive account. Thanks for the link because I found out how to filter by department from...

Thank you that is what I wanted. The only problem is that I want to filter the results because it showed some suers that I didnt expect to show up. I know I would have to do this with the SQL To try and fix this I will filter the results that show by department so I went into the active...

Galaxiom I don't know how to get the names of all the users though. I just rad your threads now and I do understand LDAP a bit better now but I don't know enough to get a list of all the users. Thanks

Yeah I have tried them and they either don't work or I am doing something wrong. Thanks anyway

Hi I would like to get a list of all the users in the active directory and put them in a combo box. Does anyone know how to do this? I would like it to show there CN name Thanks

Sorry i meant to say you can no longer see te control ( a close button) when the form is scrolled horizontally so when you scroll horizontally you will no longer be able to see it because the header and footer do scroll horizontally with the form.

If the query results open in a new form then do this. In the Load event of the form you wanted the results to open in put this code: If Me.Recordset.RecordCount = 0 Then DoCmd.Close DoCmd.Close acQuery, "QueryNamehere" MsgBox "No records were found matching the search criteria" End If

Is it possible to make a control have a fixed position so that when the form is vertically scrolled the object stays in the same position? I have a continuous form that shows records based on criteria that the user puts into an earlier form. There is a close button on the page but you cannot...

I just got Me.Dirty to work, thanks guys. Bob Fitz are you suggesting I use Me.Dirty in the BeforeUpdate?

I use the code below when a form is closed to either save or undo changes. However I only want the msg box to appear if there have been any changes to the record that the form is based on, if there aren't any changes then it will just docmd.close without the msgbox. How would I check if there...