Irriterende inputprompt.

variablen fortdato kører i en løkke hvor værdierne er formatteret som kort datoformat, og den ser sådan ud


"kører i en løkke"???

Is this a variable in code? If so you need to get the value fromthe variable into your SQL

Try

DoCmd.RunSQL ("Insert into DT_tilbudskalender
(IDtilbudsbeskrivelse, IDrum, IDmedarbejder, dato, dato_gruppestart, starttid, sluttid, antalpladser) Values (Kombinationsboks96.Value, Kombinationsboks129.Value, Kombinationsboks125.Value, '" & fortdato "', '" & grupperingsdag & "', tekst61.Value, tekst63.Value, HoldPladser.Value)")

TY Terry for you response, ive tried your suggestion, and it produces a syntax error 3075 missing operator in query expression "00:00:00", which indicates that it is a time instead of a date...

there is no query in either of those fields in the DB, no relations or anything.

That is weird cause from the table to the code it is declared as date with shortformat.

But 1 thing i dont understand bout your suggestion. The other value entries are bound and unbound values from the form ive created, so why dont i need to make the " & " thing around them ?

BTW how do you understand Danish when your english :)

OMG it worked :) TY very much... it was the second variable ive forgotten to give the proper value.

But 1 thing i dont understand bout your suggestion. The other value entries are bound and unbound values from the form ive created, so why dont i need to make the " & " thing around them ?

If you had done that then I'm sure it would have worked also. Actually that's what I would have done myself as it makes it easier to find errors.

If you have a string variable which you had put the SQL into then you could see the SQL which is being execute in the debug window.

EG:
Dim sSQL as string
sSQL = ("Insert into DT_tilbudskalender
(IDtilbudsbeskrivelse, IDrum, IDmedarbejder, dato, dato_gruppestart, starttid, sluttid, antalpladser) Values (Kombinationsboks96.Value, Kombinationsboks129.Value, Kombinationsboks125.Value, '" & fortdato "', '" & grupperingsdag & "', tekst61.Value, tekst63.Value, HoldPladser.Value)"

DoCmd.RunSQL sSQL



If you had a breakpoint on line
DoCmd.RunSQL sSQL

you could then press CTRL+G to open debug window

then write
?sSQL

you can now see how the variables look in the string. Much easier to see mistakes ...


I've been in DK for over 30 years now so I understand Danish very well, also quiet good a writing too but I still prefer to write in Danish and as most Danes are good at English then generally everyone is happy :-)

And thanks for the points

TY very much for the explanation, im most certainly happy :)

Im starting off on a big Access journey, and as im constantly getting myself into trouble, these tips of the trade are priceless to me :)