Search results

It was too obvious..thanks Mile

I don't find the option to save it in 97 format. That is an option only when you create the base or after too?

i've got only 2000 version but if its a prob I can eventualy install 97. I didn't think about access hippies :-)

the combo is on the form ANd I've putthis behind the after modify event : Private Sub nomclient_AfterUpdate() Dim searchnumber As Variant searchnumber = DLookup("[noclient]", "Clients", "nomclient=" & Forms![Plan sous-formulaire]!noclient) Me.noclient = searchnumber End Sub Says it ain't...

its like this in jungle language : subform x set up the source table x added a combo from some other table linked(table y) when I modify the combo I want as a aftermodify event to update a field on subform x whats the easiest way? table x : noA 'FK, noB, .... table y: noA 'PK , NameA On...

How do I reference the result of a query in code? Is it something like Querys!Blabla? What is the exact syntax? Thank you

Did u do that with the wizard? Cause I've go the same merde

Thanks D I did it like this and it works now Stupid wizard

ill try i tomorrow at work thanks a lot but even this would solve the problem, it is not normal because logically u don't double an index when u modify the subform.. Actualy id like to be able to make the subform as i wish without the wizard but i dont know how to link a query with the combo and...

I have two tables with a relation one to many - so in the first one a primary key and in the second a foreign key. I make a form with a subform using the wizard, based on those two tables . I replace the text box on the form with a combo, and I set the source of the combo with a query from the...

well it's like this (I wasn't very specific) when I do the totalhours from this table, I need to know when it's holiday (like christmas and stuff) and when it's not. So my query calculates the fields where finishtime is over midnight as if they were in the same day (which is logical). I'd like...

actualy there would be a little question let's say I have a form like name date starthour finishhour totalhours as I use the function that you gave us, totalhours is ok but how could I assign for the hours that go over midnight to be automatically took for date+1 ? I mean I need...

Rick, your function just opened my eyes. Thanks a lot.

thats what I was looking for - this kind of solution the thing is in a weird way, if I put starthour 23:30 and finish hour 00:00, it gives me the result 23:30. Without a minus. But the query that makes the total gives me minus. SO as I don't understand too much out of that, I was thinking that...

Thank You Alan It gets quite complicated if I do that. I mean the person who put data inside has something like this: Employee Client Date starthour endhour totalhours (totalhours calculates itself) And on a form I have a text which uses a query to make the total of hours. If I would...

So, again I'm stocked with hours/ in my table I have a starthour and a finishhour. And in the form there is a calculated textbox that makes the difference = finishhour-starthour. Now, when the finishhour is midnight, no matter if I write it 00:00 or 24:00, the returned value from the...

Thanks that was what I was looking for. But tell me, let's say I erase 5000 records in a table. The size remains the same. And after I put some other 5000 in that table. The records will go in the same place so the size will remain the same or it will be double?

Do you have any idea why after you populate a table let's say with 30000 records, obviously the size od the database grows let's say until 5 mega/ But my question is why, after you erase the all records, the size remains the same? That is not normal

As weird as it sounds, I tried the first function now, the conversiontime, and it works. It's just from time to time I get results that are not good (1 out of 10 tries), but I think it's because of some refresh issues. I'll dig to understand. Thank you Pat

Pat, I made it like this. But for instance the result now, instead of 30:45, how it should be, is 1 Day 45 hours. If it would have been right I could handle toward but it isn't. I'll try to figure it out. Thanks a lot.