Search results

Hi everyone, I am running into a little strange problem. I would like to change the default macro settings of an accdb-file.In the trust center everything is disabled and grayed out: Could anyone tell me why these are disabled and how I can get them active so I can change them? Thanks in...

Hello, We are doing some tests for moving the data from our MS Access 2007-applications to an MS SQL 2005-server. And so far all is going very well. I have one small issue though. In a form we have for each letter in the alphabet a button to move to the first occurrence begin with that letter...

Hi everyone, In an application I have after certain manipulations a string in very normal utf-16. But I really need this string in utf-8 (in memory, not stored yet). Is there a straight forward way in vba to convert a utf-16 character to utf-8? Regards, Rob.

Hi everybody, For an Access 2007 application we are in the need hashing some values before storing. I found a good class for Sha256 that work great. Now there is the requirement that the hashed value is also encoded with Base64 (for which I found also a very nice module). But the result of...

Hi everybody, Does anybody has experience with using SHA256 within MS Access 2007? We need to "tokenize" certain fields before the are stored into tables and SHA256 is the hash method they want to use for it. So I would like to ask if anyone is aware of a module or DLL that can be used to use...

Woot. That is a lot of useful information. This weekend I will experiment with it all. Thank you so much. Regards, Rob.

Hi everyone, Today I did run into a weird problem. For the first time I wanted to use the "Seek" function in a small program and test the result with ".NoMatch". The strange thing is that after the Seek-function, in the new code line of the name of the recordset "NoMatch" was not among the...

I was told that in case of a directory with a huge amount of file-entries the FileSystemObject would be faster as use "DIR". Regards, Rob.

Thanks. That looks rather useful. Rob.

Hi, If have written a small VBA program that shows all the files in a directory and it works as a charm: Public Sub LoopFiles() Dim strPath As String Dim objFso As FileSystemObject Dim objFolder As Folder Dim objFile As File strPath = "C:\Windows" Set objFso =...

I am the last years into online games a lot. Started with Ultima Online. Played Asherons Call, Lineage II, Starwars Galaxy. City of Villains, Everquest II and some more... Best game for is Everquest II and the worst World of Warcraft... Rob.

I am a software engineer.... in the past they called that a programmer :P Rob.

A small question here... We have here a number of MS Access 2003 applications we want to upsize to MS SQL server. What I would like to know is it possible to use MS SQL 2008 Server for this (or would we be better off with another version as MS SQL 2005 for instance)? Is ODBC our only option...

A small question here... In an application I am writing I use transactions to make sure all what that happens to the active records goes well (and if not a rollback can be performed). This all works well. No problem there. But I wondered, if I started an transaction on a record and for...