Can't Delete A Form

Sep 30, 2005

I have a form in Access 97 which contains embedded charts.

When I try to open the from I get this message..

"282 error when you loaded the form or report. You loaded a form or report that has controls or properties that Microsoft Access does not recognise and will ignore."

If I try to open the form in design view from the main database window I get the following...

"The microsoft jet databse engine stopped the process because you and another user are attempting to change the same data at the same time." -this happens when I am the only user in the database.

and then

"A problem occurred while microsoft access was communicating with the OLE server."

When I try to delete the form Microsoft Access closes down.

i have created, from scratch, the form again which workd fine but I can't get rid of the old one.

View Replies


ADVERTISEMENT

Access 2010 - Delete Form Command Button With A Password To Confirm Delete

May 6, 2014

All I am trying to do is insert to have a form with a "Delete Record" button on it. The problem is I don't want anyone to be able to delete a record, I would like someone to have to insert a password to confirm the delete.

View 13 Replies View Related

Can't Delete A Form

Jul 11, 2005

I am using Access 95. Lately when I make a new Form it works for a few tries then I get this error message "The Form Name you entered in either the property sheet or a macro is missed spelled or refers to a Form that does not exits. " Well I know the form exits because I just made it and I can see it. Then when I try to delete it to start over it says it’s deleting the form but still remains in the database. Any help would be greatly appreciated. Thanks.

View 3 Replies View Related

Query Lets Me Delete But Doesn't Actually Delete...

Apr 2, 2007

I have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close and either re-open table A or the resulting query, that record is back. It doesn't actually delete. If I go to table A directly and delete it, it's gone for good.

How can I make it so that when I delete the record inside the query it actually deletes? And if that's not an option, can I make it so that it doesn't seem like I can delete records inside the query so that people don't make the mistake?

View 2 Replies View Related

Delete Record Form

Feb 17, 2005

Okay, I want to make a form with a combo box that you can choose a record and click a button to delete it.

As of now I have the records in the combo box but when i can choose a record... i can't delete. and when i cant choose a record.. i can delete. Can anyone help me???? :confused:

View 11 Replies View Related

Delete Query On A Form

Mar 20, 2005

HI there,
can anyone tell me hy I can't access/view a delete query when using the the wizard while putting a command button on a form?
The delete query is working fine i application mode.
thaks in advnace
Chris

View 4 Replies View Related

Delete Query On A Form

Apr 26, 2005

Hi, I have a form to which I update the information and hit a command button. Now this data has to be transfered to another form and get deleted from the original form. To acheive this I used Append and Delete Query(Both working). I have no problems assigning Append Query to a command, but I couldnt assign a delete query to a command button. I cannot see Delete query while trying to assign using a command button wizard. I even tried with an Build event while designing but its of no use. Can anyone help me with this issue????

Thanks in Advance
Naveen

View 1 Replies View Related

Delete Form Button Help

Sep 1, 2005

Hello

I currently have a button that holds a delete command. When the button is clicked, a MsgBox pops up and ensures that you want to delete (yes and no); Yes deletes, No cancels.

Now I need to change it around a bit so that it is more secure. I would like add an 'authorization' code (password). When the msgbox appears, I would like it to have a text box where the user needs to enter in the password, if the password is correct then it would delete, if wrong then cancel.

I need help. I finish my contract tomorrow and this is all I have left

thank you

View 8 Replies View Related

Delete A Record From A Form

Mar 19, 2006

How can I delete a record from a form?
I set Allow Datasheet view to yes, Allow Form No, and Allow deletions Yes.

Nothing happens. Perhaps A delete button could be added, but I don't know the code? I do not want to use the Datasheet view as the means of deletion.

View 3 Replies View Related

Delete Picture From A Form

Aug 26, 2006

Hi, I have finally managed to create a button wich add a photo with the code below, what I need now is to create a button DELETE wich will remove the photo I have loaded !

Private Sub cmdBrowse_Click()
On Error GoTo err_cmdBrowse

Me![txtPicture] = GetOpenFile_CLT("C:Documents and SettingsMarcoDocumentiB MedCrew SchedulerPhotos", "Select the File")
Me![txtPicture] = LCase(Me![txtPicture])
Me!Picture.Picture = Me!txtPicture

exit_cmdBrowse:
Exit Sub

err_cmdBrowse:
MsgBox Error$
Resume exit_cmdBrowse

End Sub

View 3 Replies View Related

Need To Delete Multiple Tables From One Form

Mar 22, 2008

Hi, I am designing a database for a basic payroll function. So far everything was going well until i started to design forms. I cannot delete multiple table entries from one table that connects two tables. This situation is as such:Employee Table: contains entries as follows:ID: Autonumber (PK)First Name Last Name PayCategory (Salary or Hourly) (List Box)PayInfo Table: contains entries as follows:ID: Autonumber (PK)Employee Name (Text)Pay RateThe relationship of these 2 tables is a one to many relationship; where the ID from Employee Table is connecting to Employee Name in PayInfo Table.When i created a form using these 2 tables and added a delete button to it, the entries from Payinfo table get deleted when i click the delete button, but not from the employee table.I have tried everything i can think of :( . What am i doing wrong? Can someone please guide me in the right direction. Any help would be greatly appreciated.

View 2 Replies View Related

Running A Delete Query From A Form

Jan 19, 2007

I have code in my form using Do.Cmd:

stDocName = "QueryName"
DoCmd.OpenQuery stDocName, acNormal, acEdit

which is code created using the Access Wizard.

I have another delete query that I wish to run from the form but when I edit the QueryName to be the name of the query it doesn't run and if I use the wizard to select the query from the list the delete queries do not appear. The query runs fine when executed separately - i.e. not from the form.

Is there an alternate syntax to the above to run delete queries or something that I need to change in the delete query itself so that it can be run from my form?

All help welcome

View 1 Replies View Related

Can I Copy A Form And Delete Suforms Others Don't Need?

Aug 12, 2005

I have a "core" data form with many subforms containing various pieces of information regarding the record, such as subforms for donor giving, alum degree, student, faculty awards, etc.

Users of this database may only be required to update certain portions.

Can I copy the "core" form and delete the subforms (or any field for that matter) that a person doesn't need to see or is not responsible for maintaining, leaving only what they need for data entry?

What effect with this have on updating the underlying tables? Synchronization of records?, etc.

Or is this too simple a soloution?

Thanks for any advice or thought.

View 2 Replies View Related

Delete Record On Continuous Form

Mar 2, 2006

I need to have a button on my continuous form that deletes the corresponding record... I used the wizard to create the button, but it doesn't seem to work...

Any Ideas?

View 4 Replies View Related

Delete Record In Form With Subform

Mar 15, 2006

I amd having trouble putting a delete cmd button in a form that has a sub form on it. The errror reads "the record cannot be deleted or changed because table "details" includes related records".

View 3 Replies View Related

Delete Record Button On Form

Jul 31, 2006

I have created a form and have put a delete button on it to delete the active record. This works fine in that it deletes the record as required.

However, at the top of the form is a combo box which can be used to find records. Once a record has been deleted, it is still listed in this combo box but as #Deleted!. Closing down the form and reopening it corrects this and the #Deleted! entry disappears.

How can I get around this? Possibly by making Access refresh the form after the delete command? If that's the correct solution, how do I do it?! Otherwise, is there a better way.

Thanks in advance,

Gary

View 6 Replies View Related

How Do I Delete A Form In The Project Window?

Sep 29, 2007

Hi,

I have a form named in the project window that does not exist. It used to exist when I was doing alot of data entry, but now that that is finished, I deleted the form and do not need it.

However, it is showing in the Project list.

How do I delete it?

Thankyou for your time

View 1 Replies View Related

Delete Command Button - Continuous Form

Oct 23, 2006

Good Evening,
I wonder if anyone could help me please.........
I have found Ghudsons attached ‘Browsing2’ example to be of enormous
benefit/use to me when I have been creating various Databases, however I was wondering whether Ghudson or any other kind person(s) would either show or point me in the right direction as to how to create a ‘Delete’ facility which is very similar to the ‘Open’ command button on the continuous form.

I have attempted to adapt the enclosed 'coding' to see if it will come up with the result that I want, but unfortunately I cannot!


Attachment kind courtesy of Ghudson
http://www.access-programmers.co.uk/forums/showthread.php?t=97787&highlight=browsing

Your help or assistance in this matter would be very welcome...........

Best Regards


CarolW

View 2 Replies View Related

How To Delete Current Record In Bounded Form?

Jun 19, 2005

Hi guys. I made bounded maintenance form customer table in my access db.
But when I try to delete a record by clicking on the delete button I get
the following error. I be happy if some one help me delete record successfully. Thanks


Code:Run-time error '91'Object variable or with block variable not set
http://i5.photobucket.com/albums/y180/method007/deleteerror.jpg
pic ===>delete error


Code:Option Compare DatabasePrivate Sub cmdSearch_Click() Dim strStudentRef As String Dim strSearch As String 'Check txtSearch for Null value or Nill Entry first. If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!" Me![txtSearch].SetFocus Exit SubEnd If'--------------------------------------------------------------- 'Performs the search using value entered into txtSearch'and evaluates this against values in customerno DoCmd.ShowAllRecords DoCmd.GoToControl ("customerno") DoCmd.FindRecord Me!txtSearch customerno.SetFocus strStudentRef = customerno.Text txtSearch.SetFocus strSearch = txtSearch.Text 'If matching record found sets focus in customerno and shows msgbox'and clears search control If strStudentRef = strSearch Then MsgBox "Match Found For: " & strSearch, , "Congratulations!" customerno.SetFocus txtSearch = "" 'If value not found sets focus back to txtSearch and shows msgbox Else MsgBox "Match Not Found For: " & strSearch & " - Please Try Again.", _ , "Invalid Search Criterion!" txtSearch.SetFocus End IfEnd SubPrivate Sub Command14_Click()'''On Error GoTo Err_CmdAdd_Click '''Me.DataEntry = True '''Me.CmdFilter.Visible = False '''Me.CmdShowAll.Visible = True '''DoCmd.GoToRecord , , acNewRec If DCount("*", "Customer") = 0 Then Me.customerno = 1 Else Me.customerno = DMax("Customerno", "Customer") + 1 Me.customerName.Value = " " End If '''Exit_CmdAdd_Click: '''Exit Sub'''Err_CmdAdd_Click: '''MsgBox Err.Description '''Resume Exit_CmdAdd_ClickEnd SubPrivate Sub cmdDelete_Click()Dim x As Variantx = MsgBox(" You are abut to delete " & Me.customerName & " from this table - proceed ? ", vbOKCancel)If x = 1 ThenWith myRS.Delete.MoveFirstEnd WithEnd IfEnd Sub

View 1 Replies View Related

General :: Delete Table From Combo Box On A Form

Mar 13, 2013

I am trying to delete the data in a table by selecting the table I want to delete the table in from a combo box on a form. This is what I am using :

Dim strFileName As Variant
strFileName = File_imported
DoCmd.DeleteObject acTable = strFileName

View 3 Replies View Related

Modules & VBA :: Delete Record From Unrelated Form

Jul 2, 2015

I have a form based on Table A. When a yes/no tick is clicked in the form, I want to delete a record from Table B. The tables are joined by ID numbers.

View 1 Replies View Related

Queries :: Setting Delete For User From Form?

Jun 30, 2013

What is the best way to set delete for user from the form? All code, or part code and use a query, or something different? What is the best criteria to have user use? I just go to datasheet and zap, but I don't want user going into datasheet.

View 3 Replies View Related

General :: Delete Query From Continuous Form

Nov 9, 2012

I have a continuous form with a button(delete). on click event I want to delete a record on another table. I though about doing this via a delete query. The sql is below:

PHP Code:

DELETE tblClientCourse.OrdersItemsID, tblClientCourse.ClientCourseIDFROM tblClientCourseWHERE (((tblClientCourse.OrdersItemsID)=[Forms]![frmDeparturesPaymentScreen-ItemListSubform]![OrdersItemsID])); 

The only thing that is exactly the same between both records is the OrdersItemsID.

i thought that it was simple. when i run the query it would delete the record but it doesn't.

View 11 Replies View Related

How To Delete Record Using Delete Query

May 19, 2011

I have two simple tables. I want to delete the records from Table1 that are on Table2. I've created a select query that gives me what I want but when I change to a delete query, I get this message: "Unable to delete from specified tables"

I think my problem has something to do with security but I can't figure out what to change.

View 13 Replies View Related

Forms :: Delete Records In Subform Based On Check Box In Parent Form

Mar 1, 2015

I have a parent form and connected to it is a subform. On the parent form I have a checkbox which enables and disables fields on the parent form and also hides the subform.

What I want to do is when the user unchecks the checkbox, this action also deletes the associated subform records, if there are any.I'm sure that this can be done with an SQL Delete query in VBA.

View 5 Replies View Related

Delete DB On Wed AM

May 9, 2007

OfficeXP
Access 2000

I have an issue where I need all but 2 users out of my DB on Wednesday morning for billing reasons.

I thought of writting a batch file that would delete the frontend DB from all computers from 8:00 - 10:00 every wed morning. However if a user comes in before 8:00 and have the DB open then it will not delete the front end from their desktop.

Can anyone think of a way to keep users out of a system from 8-10am every Wed?


Thanks All.

T

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved