Please Reply as early as possible

[Shoaib]

Hello,
I want some text boxes on my form not to be empty while saving. i have added validation rules for those particular fields in the table and the text boxes are unbounded. i m using append query to add the new record into the table... when i leave some text boxes empty and click on save it does not save cause the required property has been changed to "Yes", however i want it to display a message that please fill the "Empty text box " ..

Please help asap

 

[rainman89]

Hello,
I want some text boxes on my form not to be empty while saving. i have added validation rules for those particular fields in the table and the text boxes are unbounded. i m using append query to add the new record into the table... when i leave some text boxes empty and click on save it does not save cause the required property has been changed to "Yes", however i want it to display a message that please fill the "Empty text box " ..

Please help asap

So put some validation into the save button.

If isnull(yourfieldname)
msgbox "Please fill in the empty text box"
else
etc...

 

[Shoaib]

So put some validation into the save button.

If isnull(yourfieldname)
msgbox "Please fill in the empty text box"
else
etc...

is it possible to do it other way apart from coding,, through macro or stuff cause i aint allowed using code ,, anyway i tried the code it worked thnx for that

 

[rainman89]

is it possible to do it other way apart from coding,, through macro or stuff cause i aint allowed using code ,, anyway i tried the code it worked thnx for that

Im sure there is, but I dont use macro's unless I have too. Someone else might be able to point you in the right direction for that.

On another note. Why can you not use code?

 

[Shoaib]

Im sure there is, but I dont use macro's unless I have too. Someone else might be able to point you in the right direction for that.

On another note. Why can you not use code?

cause its a kind of test that does not allow any codes lol.

 

[MSAccessRookie]

Hello,
I want some text boxes on my form not to be empty while saving. i have added validation rules for those particular fields in the table and the text boxes are unbounded. i m using append query to add the new record into the table... when i leave some text boxes empty and click on save it does not save cause the required property has been changed to "Yes", however i want it to display a message that please fill the "Empty text box " ..

Please help asap

Have you tried (at the table level) making the Columns behind those boxes required? A required Column must have an acceptable value before it can be saved.

 

[Shoaib]

Im sure there is, but I dont use macro's unless I have too. Someone else might be able to point you in the right direction for that.

On another note. Why can you not use code?

k i will use the code whatso ever happens lol
anyways how do i use nested if cause i want three textboxes not to be empty .. hehe i forgot the coding used to do it 2 years back

it works with 1 .

 

[Shoaib]

Have you tried (at the table level) making the Columns behind those boxes required? A required Column must have an acceptable value before it can be saved.

yep as i said earlier i do have fields for the text boxes but the text boxes are unbounded on the form.. to append new record i m using append query n yeah i have set required field to yes..
it works properly by not saving but i wana display a message to a customer to fill any 3 empty boxes.

 

[Mike375]

So put some validation into the save button.

If isnull(yourfieldname)
msgbox "Please fill in the empty text box"
else
etc...

A macro is similar.

You use the msgBox action and in the condition column you put

[yourfieldname] Is Null.

You run the macro in the same way as VBA on events except you just enter the macro name on the line, that is, you don't via code builder etc.

To show the condition colum you go to View on the Macro Deign toolbar. But iof have A2007 it might be different.

 

[Shoaib]

A macro is similar.

You use the msgBox action and in the condition column you put

[yourfieldname] Is Null.

You run the macro in the same way as VBA on events except you just enter the macro name on the line, that is, you don't via code builder etc.

To show the condition colum you go to View on the Macro Deign toolbar. But iof have A2007 it might be different.

n what if i want more than 1 text box not to be empty then do i need to use another condition for that? n yeah how do i cancel my query event which will run if the text boxes are not empty? where do i put cancel event action if the text boxes are emptty?
Anyways Thanks A lot

 

[rainman89]

A macro is similar.

You use the msgBox action and in the condition column you put

[yourfieldname] Is Null.

You run the macro in the same way as VBA on events except you just enter the macro name on the line, that is, you don't via code builder etc.

To show the condition colum you go to View on the Macro Deign toolbar. But iof have A2007 it might be different.

Thanks for that. I didn't know that that is how its done.

 

[Mike375]

The macro conditions are basically the counterpart of If Then but Null is different in anything to do with Macros

Is Null

Is Not Null

Same as query criteria.

 

[Mike375]

n what if i want more than 1 text box not to be empty then do i need to use another condition for that? n yeah how do i cancel my query event which will run if the text boxes are not empty? where do i put cancel event action if the text boxes are emptty?
Anyways Thanks A lot

I am having trouble with your English as not your first language.

You can have lots of macro action lines and each with a condition. A MsgBox action (If conditions are met) will open the box and then when you OK it it will move to the next action.

Conditions can also cover more than one textbox in either an Or/And situation.

[Field1] Is Null And [Field2] Is Not Null etc.

[FieldABC]>10 Or [FieldXYZ]<5

[FieldABC] <20 And [FieldABC]>10