Search results

Sorry but dont get it.. Made this query like you said: SELECT Projecten.Projectnaam, Werk.projectid FROM Projecten INNER JOIN Werk ON Projecten.projectid = Werk.Projectid; No output, while there are projects..

I dont need to store the projectname again, it's already in the projecten table. I just want to select the name on the form which is much easier for user to choose then a number. And I do see the names in the cb on the form, but in the projecten table there is no connection amongst the two items...

Yes I did. First I created a Query that selected the projectname and projectid from table projecten. Then told the wizard to use the projectname field from the query I see all projects on the form, but data is not stored or connected with the project.. when I look direct in the table...

Darn.. I removed the projectname field in Werk table and again all is messed up.. Can someone bake me an example query or form?

Got it ! Thanks a lot m8 !!

Hmm oke, did that for ease of formdesign..:confused: So the user can select the projectname to write hours on. You say that I don't need it, oke I get that, but how do I let the user choose the projectname on the form then? Have to go for a few hours, I'll check back later. Thanks so far...

Projectid field is there, but invisible, no need for a user to see this. But because there is a relation between projectname and projectid, I thought I could show the projectname, and autofill the projectid field, and get werkid and projectid connected. But I'm struggling with the autofill part..

So the design is oke? Have you looked at the Werk Form? Still have a question there.. When I enter the projectname, the projectid should get filled. How do I accomplish that? This the reason I think there is no link set.. projectid is not filled

So how can I repair this and get those two tables connected?

Hi, I'm trying to create a db to write labour hours on certain projects. Those project belong to a client. Labour hours are hired men who need to write the hours spend on the project doing specific work All this is defined in the tables and when I look in the table client, a + sign represent the...

Thanks guys, I'll have a look..

Hi Rainman, Yes, I always want to round down to the whole number, so no decimals. Can you tell me how this code would look like? Thanks

Hi, I have this query in VBA: SELECT CInt(Count([id])/2+1) AS Aantal FROM Wedstrijd WHERE (((Year([Datum]))=Year(Now())) AND ((Wedstrijd.Datum)<=Now())); Now the problem is that in case the outcome of Count([id])/2 is 6,5 Access seems to round this up to 7 +1 makes the final outcome 8...