Tilskrive værdi med 1 ved læsning

If you make a query you can call a module(function) which could do this for you.

make your function in a module and callit say tilskrive. Alter you query to something like:

SELECT Annonce.AnnonceID, Annonce.Grafik, tilskrive() as tilsk
FROM Annonce INNER JOIN AnnonceType ON Annonce.AnnonceID = AnnonceType.AnnonceID
WHERE ((([AnnonceType]![AnnonceStoerrelseID])=1) AND (([AnnonceType]![AnnoncePlaceringID])=1));

You then need to make some code in tilskrive()

for example.

DoCmd.RunSQL \"UPDATE ANNONCE SET HitsAfviklet = Hitsafviklet + 1\"

Jeg har nu oprettet en Makro (er det ikke det jeg skal?) med indholdet: UPDATE ANNONCE SET HitsAfviklet = HitsAfviklet + 1

Og min SQL:
SELECT Annonce.AnnonceID, Annonce.Grafik, visbanner() AS Udtryk1
FROM Annonce INNER JOIN AnnonceType ON Annonce.AnnonceID = AnnonceType.AnnonceID
WHERE ((([AnnonceType]![AnnonceStoerrelseID])=1) AND (([AnnonceType]![AnnoncePlaceringID])=1));


Og til sidst min fejlmeddelse ;-)
\"DER ER EN IKKE DEFINERET FUNKTION I UDTRYKKET!\"

/Sønderup

Jeg har nu prøvet at lave funktionen i \"moduler\", men får samme fejlmedelse...

/Sønderup

macro, never touch em! No, a module with a function. In modules select new, then from the menu select INSERT PROCEDURE and give the new procedure the name visbanner.

In code enter..
DoCmd.RunSQL \"UPDATE ANNONCE SET HitsAfviklet = Hitsafviklet + 1\"

The visbanner() is trying to find a function with this name. Make sure that the finction is public and not private!

ok... nu har jeg lavet følgende MODUL ;-)

Option Compare Database
Public Function visbanner()
DoCmd.RunSQL \"UPDATE ANNONCE SET HitsAfviklet = HitsAfviklet + 1\"
End Function

og hvis jeg prøvekører den i visualbasic kører den korrekt, men ikke fra min forespørgsel i access!! 
Jeg får samme fejlmeddelelse!

/Sønderup

if it works form VB then it should also work from your query!
you can send your dB to dkTeBrSa@europe.lego.com

den er hermed sendt!

/Sønderup

OK will get back ASAP!

change the name of the module to something other than the name of the function Access is getting confused!

soenderup> Your still going to have problems though! You CANT update att thesame time your selecting on the record. Another solution is to put your hit sin another tabel!

soenderup> looking closer at your problem, this is maybe not the correct way to do this.
If I understand you problem, you want to update a specific \"annonce\" record when it gets opened, I was thinking that it was another record. So as things are now, you cant! I still would suggest that you moce your hits to another tabel using the primary key (annonceID) as the primary key in the hits table.

Stoop!

Jeg kan godt se, hvad du mener med at skille hits ud af tabellen, hvilket vel egentligt også ville være tilfældet, hvis jeg havde normaliseret DB\'en!

Men.. det er kun prototyping... den endelige version skal jeg udvikle på en MS-SQL2000 server. Så lad være med at fordybe dig mere i dette spørgsmål.

Men ellers tak for hjælpen ;-)

/Sønderup

In SQL SERVER things are much easier!

nemlig ;-)