AcTableView

[Wayne311]

I have a form for user data entry. I need to delete some records using the form with the following code:
DoCmd.OpenTable "CaseNumber", acViewNormal, acEdit
DoCmd.SetWarnings False
DoCmd.GoToRecord acTable, "CaseNumber", acFirst
DoCmd.RunCommand acCmdDeleteRecord
Me.Refresh
DoCmd.SetWarnings True

The problem is that it opens the table for the user. I want just the form visible to the user. Any way to open the table to delete records without the user seeing it?

Thanks
Wayne

[ajetrumpet]

yes...you open the recordset of the form using a recordsetclone and delete your data that way. afterwards, some records on your form with show "#deleted" if you don't requery it after deleting it's own data.

[Wayne311]

yes...you open the recordset of the form using a recordsetclone and delete your data that way. afterwards, some records on your form with show "#deleted" if you don't requery it after deleting it's own data.

Hey Adam,

Recordset is new to me. The table that I am opening and deleting records from is a lookup table with only one record in it. It is not a table related to the form. Can I still use a recordsetclone for that?

Wayne

[ajetrumpet]

the recordsetclone is just what it sounds like - a clone of the recordset that's actually bound to the form. if that table you're playing with is not bound to that form, then you either have to run an sql executable statement to delete the record, OR you have to open the recordset using vba coding and delete it there.

(which of course, sql is easier and always recommended, given these two opt's)

[Wayne311]

OR you have to open the recordset using vba coding and delete it there.

I thought that was what I did...

Wayne

[ajetrumpet]

I thought that was what I did...

Wayne

so...........................................????

[Wayne311]

Thanks, the SQL statement works:

DoCmd.SetWarnings False
strSQL = "DELETE * FROM CaseNumber "
Me.Refresh
DoCmd.SetWarnings True
Me.Refresh
Me.[CRNumber].SetFocus

That was much less complicated.

Wayne

[ajetrumpet]

make sure to always refresh those forms twice too, as the first time never proves to work.

[Wayne311]

Did I tell you that I work for the Dept. of Redundancy Dept.?

Thanks (for the humor)
Wayne

[ajetrumpet]

no Wayne, you don't.

the perceived "redundancy" that should be popping up is still there, but new redundancy is requiring more hiring. The more problems the government causes, the more we have to pick it up, and stay employed.

no complaints here!