Recent content by Eikenhorst

Hmmmmm, have you tried using Shell to open the Explorer? I use the following code to open a certain map in the Windows Explorer: Shell "C:\WINNT\Explorer.exe C:\My Documents\" & Me.Textmapname & "\", vbMaximizedFocus I hope this is of any help for you?

Hello, I’m working on an unbound form that has sends the information on the form by mail to a user after the information has been saved to the table and before the new information is loaded. The users have to send this e-mail, even though most of them don’t want to. But Windows now gives a...

Sorry, I just saw a solution for my problem By ussing the next code as first in every KeyDown event the information in all the fields on my form is updated: If KeyCode = vbKeyReturn Or KeyCode = vbKeyTab Then Me.Refresh End if Thanks for your attention! :)

Hello, I have a problem with updating of a field. I have made a form where you can only navigate through the different fields by using the Enter or Tab key with a KeyDown event on every field. This event checks if the typed data is correct and if it is then unlocks the next field and moves the...

Hello, I have made an Access database that works perfectly. But the manager wants to have more security that it will never fail with huge loss of data. So he wants the program to create a backup on the personal hard disc so if something goes wrong the last user has a good backup of the complete...

I have another small question bassed on the last one. Is it also posible to hide ALL opbjects on my form. So something like this: Me.Controls(*).Visible = False Ofcourse this doesn't work, but is there a simple way to do something like this? Thanks

Thanks! _0_ That was just what I was looking for! You're my hero for today :D

Hello, I have a problem with VBA. I have a form with a lot of textboxes. I only want to display the amount of textboxes as divined in a table. So if the value in the table is 4, I only want it to show the first 4 values, but if it is 99 then I want it to show the first 99 textboxes. Since I...

Thanks everybody for pointing me at the ChrW() function (VBA help doesn't know it for instance). I have found the solution why ChrW(2265) doesn't works. When I tried to import this symbol in Word I saw that it was a Heximal number. So 2265 is actualy 8805. And gues what ChrW(8805) works fine...

Thinking of a posible solution. Is it someway posible to change just a part of the text of a Label. Because if I don't work with VBA I can show the right characters. So if I could just leave those and just change the values with VBA that would be a solution. I just don't have an idea if this is...

Hello, thanks for your reactions! I wasn't online this weekend so I couldn't reply until now. First of all, thanks Gemma your sugestion worked, so stupid of me not to think of that :( About the unicode character, Noel was right; ChrW(2265) should work fine, but the fact is that it doesn't it...

I wanted to do something very simple in VBA, to change the caption of a label so it shows some values loaded from a table. The code should be: Me.Label1.Caption = “Check if value is ≤ “& rst!Value< & “ and ≥ “ & rst!Value> This gives me two problems. First VBA doesn’t know the ≥ and ≤ symbols...

Thanks for your reaction! I have thought about it, but you will just need all the information to be viewed in one screen. It also need to be able to be printed at any moment. But you don't believe it is posible to enable vertical scrolling I understand?

Hello, I have a problem and I don’t know if Access does provide a solution for it. I have an unbound form at A4 format so it doesn’t fit on screen at once. I want users to be able to scroll up and down the form like in every other application. Access uses the scroll wheel to go to the next...

Hello, I have used the following VBA script in Access to open a certain map in the Explorer: Shell "C:\WINNT\Explorer.exe C:\My Documents \" & Me.Combonumber & "\" This opens the map with the name of the number in the Combobox. The problem is now that after it opens the Explorer window isn’t...