14. april 2008 - 18:48Der er
5 kommentarer og 1 løsning
Søgefunktion i Access 2007 - customize?
De der har rodet med Access 2007 har nok også set den søgefunktion der er kommet på formularer (en af de få gode ting ved 2007) Er der mon så nogen der har fundet en måde at bruge den til at søge frem til en bestemt record via VBA kode - jeg tænker her på at hvis man nu sidder og indtaster nogle data f.eks. en nummerplade på en bil som man så checker og finder ud af at den allerede findes registreret, så ville det jo være smart hvis man kunne kaste oplysningerne ind i søgefeltet og så vupti står man på den record der indeholder de data.
It would be smart if it could Hugo but I dont think you can use VBA to do that.
If you think about it, when you enter data in the search field Access is aware that you want to find a record. So when you start entering data it tries to find a match for every character you enter. (Smart)
Wouldnt it be irritating if for every character you entered in any field if Access started jumping from record to record.
What I need is: When I have entered a licenseplate number I do a search in a table in background and gets a True or False if the plate exists. If it returns True I would like to put the value in the search box and have Access find that record for me. And only then. So there shouldn't be any flicker on screen :-)
By the way - I have come to be quite happy with Access 2007. Even the ribbon.
You could quite easily put some code in the fields On Key Up event and for every entry make a dlookup to see if the plate exists. Then if it does use code to go to that record.
I am quite sure that there has been some 'pædagoger' involved in developing the ribbons :-) It is not always logical where things are located. But the thing that I never will be happy about is that navigation panel - that is some (and here should be some very ugly words)!!!
Ingen definitive svar så vi lukker og slukker så vi kan få ryddet op inden sommerferien.
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.