access

Access 97 or 2000?

Jeg har lavet et mindre eksempel som du måske vil se...

Jeg bruger access 97

Jes! send it to dktebrsa@europe.lego.com

The database too....

I have sent a mail, if it didn\'t arrive then let me know here.

Hvad så med dig reds2001 skal du også ha\' det???
Det er trods alt dig der uddeler pointene.

Hi nicki, I thought it was reds2001 that had an example, but I will take a look anyway, even after 15 years programing one can still learn!

hvorfor fungere det her ikke?
Dim db As Database
    Dim rs As Recordset
    Dim strSql As String
    Dim str As String
   
    strSql = \"SELECT svar FROM spørgsmål WHERE svar=\'Fck\'\"
    Set db = OpenDatabase(\"C:\\Programmer\\Microsoft Visual Studio\\VB98\\QuizDb.mdb\")
    Set rs = db.OpenRecordset(strSql)
   
    Text5.Text = rs.Fields().Value
   

reds2001> do you expect to get an answer when you give yourself the points?