Search results

Actually it starts to scrash when there are more than 80 chars in the field.....

These 2 SQL alone works: (1) SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace, PridelHodnotyOperace("zmìna", Zaznam, "Støedisko",StrediskoOLD,StrediskoNEW) AS HodnotyOperace FROM [Monitorování zmìn - Evidence PC/Støedisko] (2) SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace...

These 2 SQL alone works: (1) SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace, PridelHodnotyOperace("zmìna", Zaznam, "Støedisko",StrediskoOLD,StrediskoNEW) AS HodnotyOperace FROM [Monitorování zmìn - Evidence PC/Støedisko] (2) SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace...

"If I want to edit data, such as change the employee's title on a form" Have you worked with Access yet? It sounds a bit strange to me. Generally I would say: create table, then perhaps QueryDef based on Table (datasource) and then Use Automatic Creation of Form. It will generate TextBoxes and...

Sorry guys, my fault. The BeforeUpdate fires, there is a problem with handling with tha values, so its not the question of BeforeUpdate not firing itself.

I am trying to monitor changes of the values in the record by using BeforeUpdate Sub on the form (not particular text box). So I suppose Access would recognize that if I make a change in some of the text boxes then beforeUpdate fires. But it does not!!! if there is no value in the textbox and I...

I am desperate. I make use of BeforeUpdate Sub of the form to handle data changes on the record. The problem is that BeforeUpdate does not fire when there is a change from/to NULL value in the text field. But when I try to use BeforeUpdate for the particular TextBox, the BeforeUpdates fires...