inputsmaske ved dato kriterier i forsp

Maria, there is ALWAY problems with date fields, so if possible I would use for example the calendar control. This eliminates errors with entering dates.

The format you give (2302-04) will not be understood by your "Criteria" so MUST be converted to a correct date format before it will work.

In a query you can give the data type for the input criteria, this also helps eliminate errors.
To set the data type choose Parameters from the query menu when in query design.
The Parameter Name is the same as what you have already, for example [Indtast første]

hva med 230204

it is still not a date format!

Try this in the debug window (CTRL+G)

?Format(230204, "dd-mm-yy")

Or
?Cdate(230204)

Not much with dates is it?

Here is a possible solution.

Make a module with this code

Function LongToDate(l As Long) As Date
Dim s As String

    s = CLng(l)

    LongToDate = CDate(Left(s, 2) & "-" & Mid(s, 3, 2) & "-" & Right(s, 2))
   

End Function

Now in your query replace the criteria with this


Between LongToDate([Indtast første]) And LongToDate([Indtast sidste])

and if you change the parameter data type to a long int then you have some control over what is being entered

nej en løsning hvor - - kommer automatisk så der ikke fejl vil være optimal øv øv - kan man anvende en kalender i en forspørgsel?? og hvordan hvis det er??

have you tried the last idea?

The function converts an input of 230204 to a date (23-02-2004) and uses this in your criteria. Is this now what you asked for?

You could also have a form with two fields where you enter your dates using a calendar. Then alter th query so that it references the fields on your form!

den giver en fejl..

den siger navnet er tvetydigt!!

?
Well I cant see what you are doing so I can only suggest that you change LongToDate to some other name for example MariaDate to make sure the name isnt one Access uses.

It works just great here :o)

and now I ma off for the evening. Good luck!

takker kiggr på det imorgen..

jeg har valgt at åbne det fra en formular i dataark visning i stedet kan jeg så lave en formular - dialogboks istedet

Hej Maria,

Fik du min mail?
Jeg ville enten lave en dialogboks, som du selv nævner eller putte 2 tekstbokse i toppen af formularen. Hvis din formular er i dataarkvisning, ville jeg putte den ind som subform på en hovedformular og derved lægge de 2 tekstbokse der.

Disse 2 tekstbokse skal så bare have en inputmaske, som udfyldte bindestregerne selv.

Og SQL'en: Select * From DinTabel Where Dato Between [Forms]![DinFormular]!Startdato And [Forms]![DinFormular]!Slutdato

Jeg har lavet en dialogboks - Men TErry får det halve af pointene for sin indsats.

tak!