Recent content by SeanD

Never Mind, found it ^^ I didn't see this: You can still add a "Save" button, if some users expect it, merely having it set up to move to a new record. The users will still be asked to confirm the save, from the code above, but experienced Access users can run the app the way they know it's...

The code works perfect. I would like to save the modifcations when I press an 'update'-button and I want to execute this beforeupdate-event only when I didn't press the 'update'-button. How can I do this?

Cool ^^ I'll give it a try =D

It isn't a problem anymore ^^ The users are well aware of this thing. I think the solution will be to complicated ^^

Oke, Thanks ^^

Is that the only way? isn't it possible with VBA code?

Hi all, I would like to sort my table before I export it. I'll want my table sorted Ascending on Column 'Time'. How is that possible? To export the table, I use this code: DoCmd.OutputTo acOutputTable, "LogTable", acFormatXLS, , False Thanx!

try to add 21 days in stead of 3 weeks ;) Maybe that should do the trick ^^

Drop down list is a bit a lot of work to enter all the 100 values ;) Thats why i wanted check boxes. The value property only accepts numeric values ?

I know what you mean. In a form it is possible. I have 3 options. 1, 2 and 3 1 = Yes, 2 = No, 3 = Unknown. If I want to add these values into the table I need to work whit ifs: If blabla = 1 Then Blabla = "Yes" ElseIf blabla = 2 Then Blabla = "No" ... Then I Insert all the data with SQL. But...

Like I said, I'm not an expert ^^ Maybe this will help. http://www.techonthenet.com/access/functions/date/dateadd.php

I'm not an expert, but maybe you could do it with some code. How do you enter the date? Like dd/mm/yyyy? In VBA there are function who takes characters out of a string from a textbox. Put them all into variables. (dd = day, mm = month, yyyy = year) Add 3 weeks ( = 21 days) to the date. U need to...

Hi all, I'm a little familiar with Access. If you have 3 possible values for a field, u can use format property text and add as validation ="Value1" OR "Value2" OR "Value3". Is there a way to do it with a checkbox who has 3 values? The checkboxes Yes/No, True/False, .. have only 2 values. Any...

Is there an other way ?

add ORDER BY DATE to the query ??