Prev: navigation buttons
Next: Actual open a file using a Filedialog box
From: spieters via AccessMonster.com on 21 Jan 2010 07:58
Hi Stefan,

Thank you very much. It's works just the way I wanted it to work. Thanks
again.

Stefan Hoffmann wrote:
>hi,
>
>> "WHERE ((([vervolgdoosnr].[Naam vennoot]) = '"& (Me.Naam_vennoot& "') "'")
>> & "' "& _
>First of all, drop the parentheses as they are not necessary in this
>simple condition.
>
>Also use an table alias to write a shorter SQL statements and use a
>better formatting style.
>
>strNaamVennoot = "'" & Replace(Me.Naam_vennoot, "'", "''") & "'"
>strSQL = "SELECT V.doosnummer, V.[Naam vennoot], " & _
> "V.Soortmij, V.[tijdsduur archivering], " & _
> "V.[destroy datum] " & _
> "FROM vervolgdoosnr V " & _
> "WHERE V.[Naam vennoot] = " & strNaamVennoot & " " & _
> "ORDER BY V.doosnummer, V.Soortmij, V.[Naam vennoot];"
>
>mfG
>--> stefan <--

--
Message posted via http://www.accessmonster.com

First  |  Prev  | 
Pages: 1 2
Prev: navigation buttons
Next: Actual open a file using a Filedialog box