Search results

Thanks for your advice GOD BLESS YOU!!!!!

I have a table with the following fields: CR NO DT FNAME LNAME ADD AMOUNT In this CR NO is Pimary key. I want to find those people whose amount totals 50000 and above. The prob is that the names are typed haphazardly, For example Jack Jill Thompson...

I put it in the Before Update of the control , but it is not working.

Yes it works in the forms' Before Update event. Why is it not possible in the AMOUNTs Before Update event?

I am attaching the changes. But it is not working properly.

The field is currency. By default it shows Rs. 0.00. If someone crosses over without entering, how do I check? Will -> If (Me.AMOUNTs = Rs. 0.00) work?

Code: If (IsNull(Me.AMOUNTs) Or (Me.AMOUNTs = 0)) Then If MsgBox("Did you miss AMOUNT?", vbDefaultButton1 + vbYesNo + vbQuestion) = vbYes Then Me.AMOUNTs.SetFocus End If End If

In the attached DB if someone misses to enter AMOUNTs I have written a code to check that but it is not working.

Thanks. GOD BLESS YOU!!!!!!!!!

Thanks. GOD BLESS YOU!!!!!!!!!

Can we install 32bit MS Access on the same PC having 64 bit ms Office installed on it?

Thanks, GOD BLESS YOU!!!!!

Code not working in accde. When I enter the REMARKS field the popup window does not open.

I have Windows 10 64bit. Your 32bit DB is not opening.

Attaching both files.

How to convert a VBA code to a Macro. Is there any built in facility?

When I make an accde file the VBA code doesn't work. why? How to solve the problem?

Can I convert a .accde back to .accdb?

In the .accdb file everything is OK. But when I make its .accde the code stops working. only macros run.

My codes are not working. Macros are working. What could be reason. Is there any stop code settings which someone has played mischief?