Search results

And then there was silence...

Very clearly spoken! ;) Thanks, and I think I will chnge the name of the periode field in the table. Indeed is a little confusing, I also keep in mind about the Case Insensitivity. Thanks for making this clear. And you're welcome to join the party as far as I'm concerned.. ;)

I'll attach the database.

This is the content of table periode: periode Id Periode Periode_startdatum Periode_einddatum 1 1 3-1-2011 30-1-2011 2 2 31-1-2011 27-2-2011 3 3 28-2-2011 27-3-2011 4 4 28-3-2011 24-4-2011 5 5 25-4-2011 22-5-2011 6 6 23-5-2011 19-6-2011 7 7 20-6-2011...

Changed to this: =DLookup("Periode", "periode", "datum BETWEEN #" & [periode].[periode_startdatum] & "# AND #" & [periode].[periode_einddatum] & "#") But syntax is not correct, errormessage is saying that a operator is missing, or a comma is missing or a ) is missing..

[periode_startdatum] and [periode_einddatum] are in the periode table, but not on the form. On the Form is just a field [datum] with calendar picker.. Is this still possible then?

Tried to create this Dlookup line.. (don't laugh): DLookup("Periode", "periode", "datum = #" & forms!Urenregistratie!datum & "#")

I removed the Dlookup string.. (didn't work so tried other things) I am work now, still have the string somewhere at home.. sorry...

Yes, I already read those links, but still struggling with the syntax. But what is the best way to set the control? Use a query or use Dlookup? And for both I'm not sure how to accomplish it.. If I wanted the query for control, where in the properties of the field do I define that? I can't...

Oke, thanks. But how do I set this query to be the control of a textbox on the form?

Tried Dlookup too, but don't know if this is possible.. can't get the syntax right Anyone?

Hi, I have this Query: SELECT periode.Periode FROM periode WHERE ((([Forms]![Urenregistratie]![datum]) Between [periode].[periode_startdatum] And [periode].[periode_einddatum]));This will give me the correct value if the Form Urenregistratie is open in the background. What I want is to present...

Oke, Thanks for your time and patience with me

Maybe you can show me a way that they are functional??

Ke, here it is

Oke, but when I start using this, there are no werk records, so how would I write hours on a project if I can't select it? Would this be your choice of design? In other words: do you have tips for this db? (Are you fed up with me already?)

Still it's not oke.. When I remove all werk records, No projectnames are shown on the form.. Im going to cry for a while..

Oke got some output now, I manually entered projectid in Werk table. Now how do I get those projectid's in Werk table by using the form??

No output at all..

SELECT Projecten.Projectnaam, Werk.projectid FROM Projecten LEFT JOIN Werk ON Projecten.projectid = Werk.Projectid; Gives projectnames, no projectid Be back in an hour