rette datoér i 18 forskellige forespørgelser på en gang

It could be done in VBA code with a bit of work, otherwise NO!

Add "maybe" after could :o)

You should NEVER hard code dates or ANY criteria for that matter into queries if you know they could change!

If you run your queries direclty from the dB window then you could replace the criteria field with between 01-01-2000 and [Indtast dato]

This will allow you to cahnage

This will allow you to cahnage
=
This will allow you to enter any date

Hej Terry,

Det med [] kender jeg godt, men jeg kan ikke bruge den, fordi jeg bruger Excel til at hente data i access og så bliver jeg nødtil at have en fast dato i feltet.

kan du hjælpe med noget VBA code, det kender jeg overhovedet ike noget til.

I can maybe this evening as it isnt something which takes five minutes. Can you send the dB to eksperten@santhell.dk and give a reference to this question so I know what I am receiving!

jeg kan ikke sende den, den henter tabeldata fra en ODBC kilde, men det felt hvor datoen ligger i hedder "REGISTRERET_TIDSPUNKT" og det felt er i en tabel der hedder "VISIT-CAS_DRIFTSRAP" hvis det kan hjælpe dig.

I will give you an explanation as to what I was intending to do!
In VBA code it is possible to create a query. So I would make a function which deletes the existing query(s) and then creates them again. The function would take two paramaters start date and end date and these whould be included in the query(s).

But lets make sure that this is necessary! Where do you use the queries?

Oh yes Excel!

Do you open Excel from Access? If you do then it would be possible to change the query as I mentioned and then open Excel.

I can see if I can make an example on how to delete/create a query and then you can maybe implement it in your application

jeg ved ikke om det er det du mener, men jeg bruger excel til at hente data fra access forespørgelser, og det er datoerne i acces forespørgelserne jeg vil ændre.

men det du siger med at slette de eksisterende datoer og sætte nogle nye ind er ok med mig, det lyder som det jeg kan bruge.

ja du må gerne lave et eks. jeg kan afprøve

Function ChangeQueryDates(startDt As Date, StopDt As Date)
Dim db As DAO.Database
Dim qdfTemp As DAO.QueryDef


    Set db = CurrentDb
   
    Set qdfTemp = db.CreateQueryDef()

    On Error Resume Next
   
    db.QueryDefs.Delete "qryTest"


    qdfTemp.Name = "qryTest"
    qdfTemp.SQL = "SELECT * FROM tblTest WHERE Dato Between #" & startDt & "# AND #" & StopDt & "#"
   
    db.QueryDefs.Append qdfTemp

End Function

you need a reference to DAO (tools+references menu)

ok, kan du skrive det sidste på dansk, for det fatter jeg ikke noget af.

hvor skal jeg sætte den kode ind henne??

Du kan sætte koden ind i en modul!

Du kalder funktionen

ChangeQueryDates SomeDateField, SomeOtherDateField

Når du er i koden kan to åben Tools+References menuen og sikre dig at Microsoft DAO 3.X er afkrydset. Hvis ikke den er findes den i listen.

ok, det tror jeg jeg har klaret, hvad så?

hvordan kommer der til at virke??

You could start by making a form with two fields for entering your two dates, and also a button. In the On Click event for the button you call the function like this.

ChangeQueryDates SomeDateField, SomeOtherDateField

Then YOU need to replace this line

qdfTemp.SQL = "SELECT * FROM tblTest WHERE Dato Between #" & startDt & "# AND #" & StopDt & "#"

with the SQL from the query as it is at the moment, at the same time you need to alter the Between so that it is similar to my example.

Sonos, as I said in my first answer "It could be done in VBA code with a bit of work, otherwise NO!"

If you dont know much about VBA then it si going to be a problem :o(

sonos>Do you still need help here?

Hej Terry,

jeg kender ikke noget til VBA, og jeg synes det er meget svært at finde ud af, hvad jeg skal gøre.

men tak for hjælpen alligevel

Sonos

Hi sonos, I understand your frustration. Its difficult to help if you dont know anything about VBA and you cant send the dB.

Thanks for the points anyway :o)