Search results

Hi! This works perfect in windows 7 Finnish version but not at all in win XP finnish version, allthough it is very very simple function! I converted it to vba and the result is exactly the same. Here is the code: Private Sub Form_Load() Dim Con1 As New ADODB.Connection Dim N1 As New...

No error when compiling.

Hi. I can not see what reference is wrong because there are no missing references. What reference has influence in functions? And this in not a question of VBA but pure query. What references are there? hanski

Hi! I have Access 2010 in Windows 7 Ent and my function works fine. Then I have Access 2010 also in Win XP, but my function does not work. Both files are the same. Here is the function, but there are many other functions that do not work either. So why? Not Left([name];2)="B," thanks...

Hi. Could it be some language prombelm because I changed something in the region settingns and now it seems to be working ok? But I´ll be back if it comes up again..thanks. hanski

hi. I have 2 databases. Both have the same table. I make a query and place in there function ucase([fieldname]). Firsta database is working correctly but another way do not accept that (or many other) function at all. How it is possible!! hanski

Hi! Thanks. It´s finnish:) I´ll check the settings.

Hi. I have 2 machines. First have WinXP and Access 2010 and second have Win 7 Ent with Access 2010. This function Mid([vakuormknro];5;10) works only in the second one. Why it does not work in the first one? Because of XP? Is there anything to do with it, else than install Win 7 Ent? hanski

Hi! I undestood that there is not anymore mdw-file in access accdb-format. Iif ten users use my access table and I do not want three of them to delete records from these tables, so how can i prevent them to do it? Thanks for answers

Thanks a lot! It works fine! Hanski

Hi. I have a macro which exports my records to excel and to My documents. But I would like to put the excel file allways in different places, depending on the user account. How can I tell to macro that I want my records for instance to "MyServer\SharedFolder\%username%" Hanski

Hi. Is it possible to send popup messages all over the domain from my access 2003? Hanski