the comman or action SaveRecord is not available right now

[Guest]

I am using access 2003. I have a access database that was access 97 and did
convert it. However I was getting this message when I press a button on a
form that has a subform before the conversion.

On the form you select the record you want to open then click the open
record button. I get the error on the click of this button.

I did a search for this problem before I posted and am supprised nothing
came up. Has anyone else had an issue like this? if so how did you fix it?

Code looks like this:

Private Sub ExpenseReport_Click()
On Error GoTo Err_ExpenseReport_Click
If IsNull(Me![EmployeeID]) Then
MsgBox "Enter employee before entering expense report."
Else
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenForm "Expense Reports"
End If

Exit_ExpenseReport_Click:
Exit Sub

Err_ExpenseReport_Click:
MsgBox Err.Description
Resume Exit_ExpenseReport_Click
End Sub

 

[Michel Walsh]

Hi,


Maybe, just maybe, the database is open in a read-only mode, or, the
OS-flag attribute Read-Only is set for the file?


Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

I right clicked on the database icon and looked in properties and it is not
set to read only. Is this what you were referring to?
Thanks

 

[Michel Walsh]

Hi,


The file property reported by XP, yes.

The dabatase can also be open in ReadOnly mode, not allowing any, anywhere,
a "save" operation. Try adding an empty line to a VBA module, and see if you
can save it. If now, you probably have open the database in ReadOnly mode.


Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

hm....if properties say the file is not read only how would I be opeing it in
read only?... stumped me on that one. I can open other databases and all
functions work fine....I'm also not sure what you mean about adding a new
blank line of code .... can you clarify these for me.

Thanks

 

[TC]

It /shouldn't/ be this, but check just in case:
http://support.microsoft.com/kb/q280521/

HTH,
TC [MVP Access]

 

[Guest]

I am having the same exact problem. I even tried creating a new database and
importing the forms, but the problem persists. I can add and change any other
information in the database, but the SaveRecord command doesn't work.

Were you ever able to get a resolution to this?

Anybody got a resolution?