Search results

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 ??

Ok, I get it, thx ^^

Example: I have e record which has a 'name' and a 'birthday'. On the form, there are also other textboxes with for example 'Adress' For that record, in the form, the textboxes for 'name' and 'birthday' will be displayed, but not for 'adress' because it's not in the table. another record has for...

The problem is, i got 44 columns in this table. I think it's not practical to write this code 44 times ? Next problem: it's not always the same textboxes that are needed to be updated. I know how to do this when you need to add a new record, but not when you need to update it :)

I know a little VBA. But if the form isn't bound to a table, he will not show the values that are already in the table?

I have a form to update records in a table. The problem is that I only want to put the new values into the table when I click a button. Now, if I enter 'man' into a textbox, it automaticly add this value in the table when I leave the textbox. Any suggestions?