15. juni 2003 - 22:34Der er
5 kommentarer og 2 løsninger
Kode der virker i XP men ikke i 2000?
Hej
Jeg har udviklet en database hvor jeg anvender en ganske almindelig filtrering. Filtreringen startes med F2 tasten hvorefter brugeren indtaster et filter. Det virker fint på XP, men giver en fejl på 2000. Koden til filtreringen ser således ud:
If KeyCode = 113 Then '113 svarer til F2 Dim SeekStr As String CritVal = InputBox("Angiv dit søgekriterie:", "Filtrering af kunder", CritVal)
Selve filtreringen bliver korrekt udført, men efterfølgende skal man kunne dobbeltklikke på et felt, hvorefter posten indlæses. Det er her fejlen opstår. Selve opstarten ser således ud (standard access):
Private Sub Navn_DblClick(Cancel As Integer) On Error GoTo Err_navn_dblClick
Dim stDocName As String Dim stLinkCriteria As String
You are both focused on the filter-function, but as I wrote, that works fine. Afterwords I am not able to start the other form. Anyway, I just wanted to see if anyone knew the problem and maybe could recoqnize the situation. I tested terrys suggestion but without result. Overchord: I cant use yours because the filter is dynamic. We split the points, and close for now.
Torben>I wasnt JUST focused on the filter property. Actually I VERY MUCH doubt that the problem has anything to do with the filter property but its hard to say from here as I cant see EXACTLY what it is your doing. Anyway thats for the points :o)
on one form and the double click opens another form? All I can think of is that your KundeNr is a text field so it should look like this
Kundenr is a numeric field (Autonum.) and the dblclick method works fine if I havent used the filter function. It seems wird, but I have upgraded the clients to xp (they where about to anyway), so it is no longer critical for me.
Torben
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.