Search results

On the other hand you can try using the EOF property. Try this: Set rst = .OpenRecordset(strTableName) If rst.EOF Then MsgBox "The table contains 0 records." End If

Use: Me!TargetFieldName.SetFocus

More to the story There's more to this story. The sort will be allowed when the field property is "Enabled = Yes" and "Tab Stop = Yes".

Field is Not "Enabled" I'm using Access 97. I've found my problem. The sort is disabled when the field's "Enabled" property is set to "No".

Field is "Locked" The fields are all bound to the same table. While in datasheet view, I believe the reason I am unable to sort some of the fields is that those fields have the "Locked" property.

While viewing a form in Datasheet view and I right click the column header, some of the fields allow Sort Ascending and Sort Descending but other fields have the Sort options disabled. The data source is a single table. Can someone explain the conditions that the cause the Sort option to be...

Datasheet view (Sort disabled) I'm having the same problem while viewing a form in Datasheet view. When I right click the field header, some of the fields allow Sort Ascending and Sort Descending but other fields haing the Sort options disabled. Has anyone been able to explain the...

Maybe it's my code but some of my subforms get a new "Modified" date occasionally. I changed the permissions so only an Admin can update the form. "Users" have only "Open/Run" and "Read Design". The date still gets changed but I don't know how or why. I'm experienced using VBA but cannot get...

Use Docmd.SendObject Hi Jayke, Search the help info for "DoCmd.SendObject". Here's a snippet of code. You will have to assign the values to the string variables (str...). If IncludeNameAndAddress = True Then DoCmd.SendObject acSendReport, "NameAndAddressReport", acFormatRTF, _...

Set property "Enter key behavior" In design mode: 1. Select the memo field. 2. Open the properties window. 3. Click the "Other" tab. 4. In the "Enter key behavior" drop down list, choose "New line in field". That should get you the behavior you expected.

Incrementing ItemData does not work I tried incrementing ItemData but that doesn't work because: "The ItemData property returns the data in the bound column for the specified row in a combo box or list box." Still seeking a solution.

Choose another Combo box value I am using Access 97. My main form has a combo box with an ID field linked to a subform. The subform displays related records. This works correctly when I select an ID using the combo drop down list. I would like to add "record" selector buttons to the main...