AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Wednesday, January 28, 2015

Getting localized NT AUTHORITY domain name

If you are dealing with built-in system accounts, like NT AUTHORITY\SYSTEM, this code can help you on localized Windows versions, where NT AUTHORITY domain is also translated, for example to NT-AUTORITÄT in German version. You can get localized name using it SID "S-1-5-18":

?GetObject("winmgmts:root\cimv2").Get("Win32_SID.SID='S-1-5-18'").ReferencedDomainName

You have to use this function, when you select system object using Object selection dialog as well.

Labels: ,

Tuesday, January 27, 2015

Object selection dialog

Object selection dialog (or Directory service Object Picker) can be useful when you need to change user right on file system or SQL server. I never used it before and it took me some time to find the right code, which works in Access and VB - Object picker with dispcallfunc.

image

Using the Windows 2000/XP Object Selection Dialog article helps to understand parameters of dialog, and Active-Directory-Object-Picker is a .Net version of dialog.

Labels: ,

Monday, January 05, 2015

Automate any browser with Selenium VBA

You can easy use Internet Explorer to do web tasks from your code, like screen-scraping or filling forms. But other browsers do not have COM interface, so Selenium VBA let you do such tasks with other browsers as well. Basically it provides a COM interface to the popular Selenium web testing tool. What you can do with Selenium VBA:

  • Automate repetitive web browser tasks.
  • Quickly fill a web form multiple times with data from your table.
  • Extract data from a web page into custom table.
  • Take screenshots of a Web site and save them in a PDF file.
  • Use the selenium automation framework .

Labels: ,

Saturday, November 15, 2014

Security Update MS14-066 causes major performance problems in Microsoft Access / SQL Server applications

 

Update: Switching to "SQL Server Native Client 10.0" ODBC driver helps to avoid performance issues, looks like update has effect on default "SQL Server" driver only

Labels: ,

Monday, June 23, 2014

A better ZoomBox

A better ZoomBox - the improved version of Access Shift+F2 zoom feature by Tom van Stiphout, Access MVP.

Labels:

Thursday, May 22, 2014

Access NetView - Extensible Control for Microsoft Access

NetView control – there are 2 reasons to look at it. First of all this is an Access native control, which you can use in your application, if you need to show multi-dimensional charts, bound to recordsets, or using it drag capabilities. And second reason – learn it source code, what could be useful for creating your own control or applications. Check it out!

Labels: ,

Friday, May 16, 2014

Access Spell Checker

MS Access™ 97 / 2000 / 2007 Spell Checker / Dictionary Tool with Source Code is built completely in Access, you can easy distribute it with your application.

Labels: