Search results

The_Net_2.0 - You are correct. I pretty much cut and paste the code into my VBA code and it does run with little error. I think it's where to put all of the APIs in the code. You can't have them in a Sub and 3 are coming up with an error of being invalid. So I am playing and chopping.

I will look into that - thanks.

I was looking through online articles on how to set permissions via VBA and found this: http://allapi.mentalis.org/apilist/9C3BBC69930313A7D25B3142EF2C084B.html It's in VB and does have an expanded region and now that I have searched the code - I see the function defined way below - It's not...

Below is the code I am using to make a directory folder. I do need to set the Share Name and Security Permissions in VBA. I found that little three lines at the bottom but it is bombing on SetAccess. I am guessing it's a VB command and not VBA crossover - does anyone know a command for this...

I don't actually have a table field that is a memo with query or dlookups saving to it - That would be inefficient and too much work to format/unformat. I was trying to get a display field on a FORM named tbMemoPreview to push to a report. The back end of that field looks like this: Sub...

Not like that - The Memo field is comprised of over 20 DLookup calls and it recreates a summary of Q/As, I may not have found the solution I wanted - it's not as slick as I wanted - but receating the structures in Qs was the best solution.

I do - and so finally after all the unsuccessful attempts, I wrote a query that mimicks DLOOKUPs for the display and just made a report off of that.

I have a Tab on a form that is dedicated to rebuilding a response from a supervisor to an auditor when they get dinged in an audit. The response builds off of several fields on a Table by audit number into a big Memo named tbMemoPreview. From there - the auditor can accept/reject and it will...

OK - new idea sort of.... Telling me I cannot update - Can IO change the statement to let me have admin priviledges.

LOL! I thought I would love working with AD from a code level. I was so exited for this - but my excitement has been nothing but challenges lost. But Code is Law and I just have to find the right rules to play by.

Oh well... I guess I am off to finding method 2. I will resign to creating and calling vb.net code to write to the AD. I would have loved to have it all contained in VBA but we don't get everything we want. Thanks anyway!

I have an Object not found on server message. Trying to clear it up. I was hoping that was the reason. I have my Domain for companyname because they are the same. I have looked in some VB code we recently coded but that connection goes ou=companyname,uid=admin,pw=blahblah

Thank you DJKarl for the Link... That is close to where I was last Thursday. I am still a little stumped with the connection string. Set objOU = GetObject("LDAP://ou=companyname,dc=microsoft,dc=dc=com") I think it's because we use a port for AD. ou=MyCo dc=Domain dc=com so would I...

I need to connect to the Active Directory to create new Exchange accounts out of an Access DB. I can get a connection to read through current user settings, but need to be able to add. Any suggestions are greatly appreciated. :D

Well - here's the fix for running a 2010 database from a non-server shared location where it's using the users load of Access... You have to unlink all tables, uncheck all references and compact and repair, close, open..... Then reinstall references in the VBA and relink the tables for that...

I know - which is why I personally went over to the EU machine yesterday and untrusted all of her documents and opened this DB and re-enabled - re-trusted. I even made her an Admin on her machine. Still the same issues.

Seems like everytime they "improve" a version, they disregard the actual people who develop for use. The whole Enable and Make this a trusted Document crap is just that - CRAP. I hate having to enable editing on EVERY spreadsheet and Word Doc I look at. I think if the switchboard code were...

The only changes we made to the swithboard was to make it a 16 field instead of 8. (2 columned SB) Other than that it is standard. I also checked the Handle_click code. Even cut and paste the code from the prechange copy because the Switchboard code didn't change. Just listings in the...

Has anyone had any conversions issues relating to switchboards in Access 2010? We have 2 DBs NOT on our DB Server - works off a drive share. These are 2003 DBs that are now running in 2010 because we've upgraded user machines. I made some changes, built new reports, queries, and forms. I...

I have code that identifies the user based on Windows Login and matches PW and accessibility to Active Directory. We then take it ONE step further and match to a table in the DB for switchboard and user/admin permissions based on login. So the user has a login to the DB Server and then a login...