Hi.
I have code to trap required data in the Forms BeforeUpdate event which works only on an Insert. It does not work on an update which I want it to.
On an update I get the standard 'This fi...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20801580.html
Zones:
MS AccessDate Answered: 01/20/2004 Grade: A Views: 0
It seems that the control.Undo method works only on Bound Controls.
So how do I handle a non-bound textbox for which I want to check for a value in the Before Update, and if a wrong value is en...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21801216.html
Zones:
MS AccessDate Answered: 05/09/2006 Grade: B Views: 0
When I update a record in a subform and move to the main form, the BeforeUpdate event of the main form gets executed. I have other subform/main forms in the database and this doesn't happen. I need...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21812011.html
Zones:
MS AccessDate Answered: 04/12/2006 Grade: A Views: 0
Hi!
This is my problem:
I use a dbgrid and in dbgrid_beforeupdate I validate my
data .
if X="" then
msgbox "Please do something!!"
cancel=True
exit sub
end if
At runtime after this message I see...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10044765.html
Zones:
Visual BasicDate Answered: 04/07/1998 Grade: B Views: 0
Access v7 & v8. Within a date/time field in a table, entering, for example, 12/13 or 13/12 both result in a date of 12th December being interpereted. Is it possible to interperet only one of these ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10154591.html
Zones:
MS AccessDate Answered: 03/17/2002 Grade: A Views: 0
Hi guys... this is my problem.
In a form I have:
1) One Datagrid, linked to an AdoData control. this works ok.
3) All fields must be filled (IMPORTANT). This is a rule into the table (MDB).
4...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Controls/Q_10300105....
Zones:
VB ControlsDate Answered: 02/24/2000 Grade: A Views: 0
I have an Access 97 application where a user inputs an account number on a field. I have a validation function which runs in the before update event of the account number field. It looks like thi...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_11603738.html
Zones:
MS AccessDate Answered: 10/20/2000 Grade: A Views: 0
I have a form named frmmain where we have a business days calculation between 2 date fields DateReceived (which on frmmain is Text77) and DateCompleted (which on frmmain is text97)
In the Before...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20141253.html
Zones:
MS AccessDate Answered: 11/15/2001 Grade: A Views: 0
Hello,
I have a form with a combobox on it. I want to know if there is a way to go back to what was selected before the user changed the selection if there is an error. For example, in my Befo...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20690861.html
Zones:
MS AccessDate Answered: 09/05/2003 Grade: B Views: 0
Hi,
Let's say I have two tables (table1, table2) with a related field "FieldID". I've made a form (form1) to add/modify records of table1.
I've added a validation test in the BeforeUpdate eve...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20745082.html
Zones:
MS AccessDate Answered: 10/31/2003 Grade: A Views: 0
