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 Replies


ADVERTISEMENT

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

Run Delete Query With Command Button

Nov 11, 2005

Hello,

I have a delete query in my database which I would like to run from a command button on a switchboard. When I use the command button wizard, it does not show delete queries in the menu of available queries. If I create a command button manually I will need VBA code for the event procedure.

Can someone give me an appropriate code for running a delete query with a command button?

Thanks

View 2 Replies View Related

Delete All Record Using Command Button

Nov 7, 2004

Hello all:

Code:

Private Sub DeleteRecords_Click()
Dim db As Database
Set db = CurrentDb
db.Execute "Delete * FROM tblJune 2005 applicants;"
End Sub

I am trying to delete all records from a dabase created in access. When I click the command button, I get this message: "User-defined type not defined"

Any suggestion on how to fix this error?

Many thanks in advance,

Dion

View 4 Replies View Related

Making A Command Button Of A Delete Query?

Feb 16, 2006

Hi!

I'm having problems making a command button(Ta bort från engelska till svenska) of a delete query.
The name of the query is"Ta bort från engelska till svenska", which is also the name of the button on the form(huvudformulär)

Could someone please help me.
I'll enclose my zipped database.

Nille

View 2 Replies View Related

Command Button To Delete Data In Textboxes

Apr 9, 2005

Dear All:

I have created a form where data is entered. I wish to place a command button on the form and when it is pressed, it deletes data in specified textboxes. The texboxes are: LAST_NAME, FIRST_NAME, MIDDLE_NAME.

I assume this is done using vb, but I am clueless.

Any help is most welcome.

Regards,

Dion

View 2 Replies View Related

Modules & VBA :: Delete Table Record - Command Button?

Jun 27, 2013

I have created a form and need to be able to delete employees from a table. I built a command button using the wizard and this is the current vb code-

Code:
Private Sub cmdDeleteEmployee_Click()
On Error GoTo Err_cmdDeleteEmployee_Click

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
Exit_cmdDeleteEmployee_Click:
Exit Sub
Err_cmdDeleteEmployee_Click:
MsgBox Err.Description
Resume Exit_cmdDeleteEmployee_Click
End Sub

But when I click on the button I get a message saying it would create duplicate data in the table.

View 13 Replies View Related

Modules & VBA :: Command Button To Delete Records In Sub And Main Forms

Jun 24, 2013

I am trying to create a command button that will delete the current records in both the subform and main form.

I know how to create a command button that will delete the current record of which ever form I'm in (either the sub or main form) but I wish to do so both at the same time with one event procedure. I currently have been experimenting with a button in the subform but I don't really care if it's in the subform or main form.

View 2 Replies View Related

Modules & VBA :: Before / After Delete Confirm Events

Oct 4, 2013

I'm using Access 2007..I have a table that contains transaction records from a bound form.When the user enters a certain type of transaction, I create a corresponding transaction in the after insert event.

Example
User record - tranId = 1, tranAmt = 10, tranType = DISB, tranAssocID = 0
My record - tranId = 2, tranAmt = 10, tranType = RECV, tranAssocID = 1

When the user deletes a record, I want to delete my corresponding record using the tranAssocID ( delete * from tran_tbl where tranAssocID = (the tranID of the user's record)

Problem:
1) I don't know how to save the tranID of the users record
2) I don't know how to reference the saved tranID in the delete statement.

I'm using the before delete confirm event to try to save the users tranID to no avail.I'm using the after delete confirm to delete my record in a case statement - acDeleteOK...I tried to save the value of the ID in the form (Me.tid) to a public long variable, a hidden field on the form, and a temporary variable to no avail.

View 8 Replies View Related

Opening A Password Protected Excel File From A Command Button In Access

Dec 22, 2006

Hi All,
I have three excel files (ActualHires.xls, ActualPromotions.xls and
ActualSeparation.xls). These are password protected files (with the
same password). They are linked to an access database and whenever the
files are opened, one must supply the password and click the 'Enable
automatic refresh button.' What I was wondering was if this could be
done in access with a command button. I have pasted some code below
that I found but now I'm getting an error.
This is the code:

Dim BookNames As Variant
Dim B As Long


BookNames = Array("O:ExcelFilesActualHires.xls",
"O:ExcelFilesActualPromotions.xls",
"O:ExcelFilesActualSeparations.xls")


For B = LBound(BookNames) To UBound(BookNames)
WorkBooks.Open FileName:=BookNames(B), _
UpdateLinks:=3, Password:="*******"
WorkBooks(B).Close SaveChanges:=False
Next B


But when I click the button, I get this error:
Run-time error '9' Subscript out of range.


and this line is highlighted:
WorkBooks(B).Close SaveChanges:=False


Any help would be greatly appreciated.


Thanks.

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 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

Forms :: Password Reset Form Doesn't Work In Runtime Access 2010

Feb 6, 2014

I created a small database with a user login form, along with a password reset form. Running it in my sandbox as an accdr file, the password value resets just fine, but on my test machine with the Access 2010 runtime installed, the password reset form doesn't reset the password. I will try to describe the state of things as of this point.

1. The LoginF presents with a combo box for the user to choose their name, and a text box to enter their password. The code below is on the After Update of the password text box.

Code:
Private Sub txtPassword_AfterUpdate()
'Check if user has been chosen
If IsNull(Me.cboUser) Then
MsgBox "Please Select User Initials", vbInformation, "Warning"

[Code] ....

2. The password reset form has two text boxes for the new password and to re-enter the same, as well as a command button with this code.

Code:
Private Sub cmdResetPassword_Click()
If Me.Password = Me.PasswordTest And Len(Me.Password) & "" > 0 Then
DoCmd.RunCommand acCmdSaveRecord
DoCmd.Close
DoCmd.OpenForm "LoginF"

[Code] ....

As I say, this works as an accdr file, but not in the actual runtime environment.

View 1 Replies View Related

Confirm Delete "No"

Jun 13, 2005

I use datasheetview, when I want to delete the record I just select the row and press delete button and click "yes". However, when I click "no" (means I don't want to delete) the record is disappeared.

I create refresh button to Requery and Refresh the form but the record still not comes up. I have to close and open my form every time.

Any suggestion would be very appreciated.

View 7 Replies View Related

Password On A Command Button?

Feb 11, 2004

Hi, i have a slight problem that i could really do with some help on.
I have a form in which u can edit/add or delete details of a record. What i would like to do is when someone presse's the delete button i would like a box to pop up asking for a password to be entered before the record is deleted just to prevent certain records from being deleted.

Thanks,

Ben

View 6 Replies View Related

Password On Command Button

Aug 2, 2006

On a "delete record" command button I want to put a password prompt so when you press it, it will only allow you to delete the record if a password is entered.

How?

View 3 Replies View Related

Modules & VBA :: How To Automatically Delete Information In A Table With A Command

Oct 30, 2013

my database just records end of day sales figures which are entered though a form, after they are entered the total for the day is archived. However the problem i have is that the i need some way of clearing the input table with a command in the form.

View 2 Replies View Related

General :: How To Undo Delete Command In Datasheet View

Jul 9, 2013

When I had a subform (continous form) I had a code which check, that record was used in other form, if yes, then code not allowed to delete this record, if not, record was deleted. But now I have a datasheet form, and the question is, What should I do, to have the same results what I had in continous form.

Now it doesn't matter that I past this code in "Before Del Confirm", "On delete", "After Del Confirm", this code doesn't work in this view of form. Always if I click (right button) on record, then i choose "delete record" MS Access delete my record without checking that was used in other form or not.

Code:
If Not IsNull(DLookup("Id_Gora_Zlecenia.Value", "TblDolZlecenia", "Id_Gora_Zlecenia.Value=" & ID_gora_zlecenia)) Then
MsgBox "You can't delete this record because it is used in another form"
Exit Sub
End If
DeleteRecord Me
End Sub

DeleteRecord:

Code:
Public Function DeleteRecord(ByRef f As Form) As Boolean
DeleteRecord = False
On Error Resume Next
DoCmd.SetWarnings False
If Not f.NewRecord Then
DoCmd.RunCommand acCmdDeleteRecord

[Code] .....

View 14 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 Button

Mar 29, 2006

Hi all,

I have a wizard made delete record button on my form and up until today it worked fine. Now when clicked an error message comes up saying: cant find the field 'forms' referred to in your expression. I have no field 'form' in any of the tables or queries relating to this form, in any of my tables in fact, i don't have a clue what is wrong and why it suddenly wont work. Can anyone help please. Thanks

View 2 Replies View Related

Auto Delete Record Button

Oct 7, 2005

Hey.

I have created a button which when clicked imports a table from Excel into Access. Every month the users want to click on this, they want to update the Access table with the updated info in the excel table. My problem is that the whole table is imported again and not just the new rows which have been added in excel. I was just wondering if there was a way to have a button which when clicked it clears all of the records out of my table in access, instead of manually deleting them. So that my users can just click this and then click the import button.

Thanks in advance for your help.

View 8 Replies View Related

The Delete, Add, New, And Next Record Button; How Do I Get Ride Of It?

Aug 24, 2005

I want to remove the record buttons at the bottom of my form and only have a submit button. I will have a form for editing, because I don't want people to have edit access, only new record. Can this be done?

Scott

View 1 Replies View Related

Add/Delete Record Button Error

Aug 2, 2006

I am creating a form that includes an add and delete button on the form. I have two other databases that these buttons work with. Using the same VB code (and name of the button) in my current database gives me the following error:

"The express On Click you entered as the event property setting produced the following error: A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control.

*The express may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].

*There may have been an error evaluating the function, event, or macro."

My VB code is as follows for the two buttons:

Option Compare Database
Private Sub add_Click()
On Error GoTo Err_add_Click


DoCmd.GoToRecord , , acNewRec

Exit_add_Click:
Exit Sub

Err_add_Click:
MsgBox Err.Description
Resume Exit_add_Click

End Sub
Private Sub delete_Click()
On Error GoTo Err_delete_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

Exit_delete_Click:
Exit Sub

Err_delete_Click:
MsgBox Err.Description
Resume Exit_delete_Click

End Sub


Any ideas on what may be the problem and how to rectify this error? All help is appreciated. Thanks in advance.

View 1 Replies View Related

Delete Current Record Button

Dec 11, 2004

read other threads, read and used the codes, but it wont work.

i want: in a form, the record i´m looking at, when i press the "delete record" button, that the current record is removed from the table.

only thing i´ve achieved is deleting all the records (godbless backups!)

it all looks pretty clear but if you need more info just ask.

thanks

View 2 Replies View Related

Add/delete Button Wont Work

Dec 27, 2004

hi.. i have 3 forms: master, request & progress. progress is a subform for
request, and request is a subform for master. i added "add new record" and
"delete record" buttons using the command button wizard in request form. the problem is,
when the buttons are clicked, i get this message:
you cant go to the specified record.
you may be at the end of a recordset.

by the way, each of the forms source is master, request and progress table respectively.
please helpppp

View 1 Replies View Related

Forms :: Delete Button Warning?

May 8, 2013

Windows Vista
Access 2007

I have added a button to a form that would delete a record. This works just fine.

I would like to add a confirmation that this is something that i'd like to do.

View 2 Replies View Related







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