the comman or action SaveRecord is not available right now

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
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
 
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?
 
Back
Top