kjøre query med kriterier fra en modul (VBA) II

For hver variabel du har, skal du lave en Public Function som returnere værdien. Denne funktion kan du så bruge i forespørgslen:

Public Function GetvarKundenr as Long
  GetvarKundenr = varKundenr
End Function

Sorry! Dette spørsmål "kjøre en query med kriterier fra en modul (VBA) II" er allerede besvart OK i "kjøre en query med kriterier fra en modul (VBA)". Løsningen er beskrevet der og forklaringen på opprettingen av dette spørsmål. trymore

http://www.eksperten.dk/spm/458943
Trymore, if you place an answer yourlsef and accept it(if you can :o)) you get your points back

Doesn't matter terry. You got 60 points and that's OK. I think the problem was all about that I earlier gave you one comments as an answer to the question and that might be the reason why I got some problems to close it. I had to mark my own name to the left and push the "Avvis"-button before I marked your name and pushed the "Accept"-button.  If you put an answer to this question I'll give you another 60 points. My problem is solved and giving away 120 points,- it's worth the "money".

:o)

Thank's