Search results

I found a solution by defining a variable as follows: intLang = Application.LanguageSettings.LanguageID(msoLanguageIDUI) If this parameter is 1030 then language is english. If it is 1040 then it is Italian and so fort. The complete list is here...

Hello Everybody, when setting properties of forms or controls the property value is a boolean ("true" and "false"). Unfortunately I have noticed that for different language package the property value can change. So when an application is used in MS Access runtime with a different language then...

Hello, thanks I will try your suggestion. In fact I am using Access 2010

Hello, I am trying to create command buttons with a picture (bmp) on it, and centering the label and the pictures in the middle. I selected bottom position for the label, but it seems to keep the pictures always aligned on the left. Any suggestion? Andy74

Thanks for quick reply RX. I tried with several options with and without the ";". Anyway I found an unusual behaviour: when I set the .connect property it correctly shows all the string (i.e. ODBC;Driver={Oracle in instantclient10_2};Dbq=flex;UID=username;PWD=password;) but when I click to open...

Hello, I am trying to replace my existing connections to an Oracle database from machine DSN to DSN-less. Connection string is like: "ODBC;Driver={Oracle in instantclient10_2};Dbq=flex;UID=username;PWD=password" The connection works but it keeps on asking the password when you open a...

thanks, but the same code compiles with an older version. I normally work on a accdb file and when I distribute (only 2 users over 50 cannot open the accdb) I have to "downgrade" it to mdb. I think there may be some corruption issues. I have tried to decompile/compile with no results. Apparantly...

Thanks, that is there. Microsoft DAO 3.6 objects library! The error I get is 461

Hello Everybody, I have some issues in converting an accdb front end go mdb front end (because some users have old access version). When converted it doesn't compile anymore and stops in some events like rst.lastmodifed where rst is a dim recordset variable. Any clues? thanks andy74

Hello, I have an application with many crosstab queries which the end users use to get summaries of data (like monthly sales, etc). Some of the users have Access Runtime and hence they cannot filter the queries with the context (right click) menus. For select queries I would normally build a...

SPIKEPL: thanks very much, well actually I changed the code with the outlook.folder datatype and it works! Anyway believe me that exactly the code with the folder datatype was correctly compiled in another application. Thanks very much andy74

JHB: yes, I pointed the correct references!

Hello Everybody, I have a strange behaviour on a module which reference to Microsoft Outlook Object Library 14.0. The below code got an error 461 on the folderoutlook.display code,i.e. the method is not found. The funny thing is that the same code gives no problem in another accdb file...

Thanks for the reply, I think I will proceed with setting the locked propertry on each control, for the users who can view and filter. Andrea

Hello Everybody, I have a simple split form with datasheet on the bottom and a couple of comboboxes (unbound) on the form header which the user can use for filtering the data. When some users open the form the allowedit property of the form is set to false, because those users can only view...

Thanks to everybody. At the end the issue was solved by installing the Sql native client 11 driver. Andrea

I think we used always the Sql server driver (and not the native client 11) also on the machines with access2010. Anyway I will check this on Monday! Anyway I will try using this new driver in the "old" machine. Thanks

Hello, thanks for suggestion. I have tried compiling and I think I will follow your suggestion with the 2010 runtime. Version of SQL server is 2012. Andrea

my application is 2010, and I have the problems on one pc with 2007 and only on this rst!update statement

Hello everybody, I have a problem when I move my application to Access2007 machines. There is a rst!update instruction which give back the above error, i.e. the it fails to update the underlying SQL server linked table. the table includes a varbinary(max) field which contains an attachment...