Search results

I didn't think platform mattered that much, but could it be because I'm using win 98? I'll have to see it I get the same problem on xp. Thanks for all your support. Rich

Sorry the 2__STUDENT_ENTRY_REGISTRATION form has the code we've looked at thus far. The error mesage occurrs in other delete methods Rich

The deletion occurs its just that I get an error message "Run time error 3021 - No current Record" afterward.

I guess even zipped the database is to large at 600kb. Any other suggestion? I don't know any other way to demonstrate this. Rich :(

Attempt number 2

Here is the current version on the database. The Student entry form has the code I've been working on though other delete modules produce the same error. Thanks Rich

I believe it does have a valid RecordSource. I'm building a single user database with a form I use to create a student that is bound to the Student table. The delete button is on this form and completes the deletion. The form has four fields, an auto number, and three text fields for student id...

After commenting out the on error GoTo statement I get "Run time error 3021 - No current record" And debug stops at .RunCommand acCmdDeleteRecord Thanks again Rich :o

Thanks SJ, Oldsoftboss. No luck. I implemented the code as SJ posted it and still get the alarm. I'm wondering if the way I split the database may be the problem. I first split off the tables to a new file and then exported the forms, queries, reports and macros to the file to get rid of a...

I'm using a Access Xp 2002 and Keep getting this error when I delete a record. The error is Run Time Error 3021 "No Current record". The error started after I exported all my forms, queries and reports to a split off of the database. The delete still occurrs it just produces this error. Any...

Thanks Surjer Yes, its a form bound to the table on a single user system and the deletion works. It seems to be erroring afterward like it's looking for another record. I've tried setting focus on the previous record after the delete command, but the error still appears. R Dayton Or. :rolleyes:

Thanks gHudson, but no noticeable change. :(

I'm using Access 2002 and after exporting all my working forms, queries, macros and spitting off the database to get rid of one errant vba class object, I now get Error 3021: No current record when I use a delete button on a a form that existed before the above transformation. It also errors...

To whom it may concern: Solution: I used the Database splitter utility and exported all my forms, reports, queries, modules and macros to a new db. A bass ackward solution for a kludgy programming enviroment. Rich :cool:

Hi Rich Thanks for asking. I tried deleting all and parts of the code. However when I tried to save the changes the save failed. I would like to use the right button menu command that reads "Remove form_Switchboard", but its dimmed for all vba class objects. I suspect some way to...

Here is the code that is left in from the the switchboard. :confused: Option Compare Database Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the form. ' Move to the switchboard page that is marked as the default. Me.Filter = "[ItemNumber] = 0...

I'm using Access 2002 and I created a switchboard and deleted it without using Switchboard manager. Now the left over module alarms every time I try to add code to the project or even click on the switchboard module. The alarm states that the form name maybe mis-spelled or missing. Please make...

Restating the problem: I'm using Access 2002 and I created a switchboard and deleted it without using Switchboard manager. Now the code alarms every time I try to add code to the project or even click on the switchboard module. The alarm states that the form is not available or mis-spelled...

Yes, thank you for the question. I created a switch board and didn't delete it using switchboard manager and now I'm stuck with the vba code. Thanks again R

When I right click on the module in project Remove is low lighted. Can I correct this? Thanks for your support R Vote early and often.