Search results

In middle of a report if I want to display data in tabular form, how do I do it? Is there a predefined tabular structure whose rows can grow and shrink according to data content?

Thanks, GOD BLESS YOU!!!!

Thanks, GOD BLESS YOU!!!!

In the attached db when I click on the SEND button the data of that particular record should go to MM.docx. How to do it?

Yes I will keep this in mind.

Yes I will keep this in mind.

Thanks a lot. GOD BLESS YOU!!!!!

In the attached DB I-00002 has allocation "travel" typed twice. I want to validate so that allocation name is not repeated. How do I do it?

The rec count is around 10,000. I can make a copy of the existing DB and make changes to the structure with out affecting the original.

Thanks GOD BLESS YOU!!!!!

Thanks a lot GOD BLESS YOU!!!! What should tblTrans have ? To straighten the messy database which is, Name Amount Jack Jill Thompson 20000 Jack J. Thompson & Others 15000 J.J. Thompson & Family 20000 I...

OK Thanks GOD BLESS YOU !!!!!

After cleaning the table, what should be the query to extract the required data(i.e. Persons whose amounts total up tobe =>50000 ?

Thanks GOD BLESS YOU !!!! If in case there is a prob in starting the database, is there any setting to start the REPAIR automatically ?

What is the benefit of pressing the Shift key and starting Access database?

The backup file is named orig file name_Backup

When we copy a .accdb file or overwrite a .accdb file a backup file is immediately created. Is this an Access feature or some other software?

I found the following: If (IsNull(Me.AMOUNTs) Or (Me.AMOUNTs = 0)) Then If MsgBox("Did you miss AMOUNT?", vbDefaultButton1 + vbYesNo + vbQuestion) = vbYes Then Cancel = True 'Me.AMOUNTs.SetFocus End If End If working better on the OnExit event of the control.

How would the code be in the BeforeUpdate event of the control?