Delete Table Record With VBA?

Jul 7, 2013

This is my code:

my pro is string

prID is autonumber field

Code:

CurrentDb.Execute "delete from protbl where prID='" & mypro & "'"

shows this error:

Data type mismatch in criteria expression

View Replies


ADVERTISEMENT

Modules & VBA :: Copy Record To History Table And Then Delete It From Main Table

Jul 9, 2014

I have a form with a sub form. when a record is choosen in a combo box the sub form is filled out with a record.

what I am trying to do is have a button that will copy that record to a history table then delete it off the the main table.

I cheated by using the wizard to get the code to delete the record but I am having troubles modifying the code to copy that record to the history table. Here is the code below. I have tried to insert code in several places but it just errors out.

'------------------------------------------------------------
' Master_tbl_sub_fm
'
'------------------------------------------------------------
Function Master_tbl_sub_fm()
On Error GoTo Master_tbl_sub_fm_Err
With CodeContextObject
On Error Resume Next

[Code] ....

View 8 Replies View Related

Delete A Record From Table

May 9, 2005

Hi,

Is it possible to delete a record from a table whilst viewing that table through a form. The awkward part though is because I have another table linked to it.

Basically the main table is Orders and the other table is Items (these items make up an order). So when I go to simply click on delete an error message appears saying that I cannot delete the record but there are records attached to it in another table. This is fair enough but is there a smooth way off deleting off the items?

Many thanks,

Paul.

View 3 Replies View Related

How Do I Delete Last Record In Table?

Jun 21, 2007

Hi all, whats the simplest way to delete the last record in a table? based on
DoCmd.RunSQL "DELETE * FROM

Trying to use a button to do the above

Cheers

View 5 Replies View Related

Delete FIRST Record From A Table

Mar 17, 2015

How do I DELETE the FIRST RECORD FROM A TABLE ?? I am using MS Access 2003

View 4 Replies View Related

Delete Record From One Table And Have It Automatically Added To Another Table?

Oct 28, 2011

I have an employee and asset database. If an employee gets fired, I need remove them from the general employee records, but I want to save a record of that employee. Is there a way to delete an employee from one table and have it automatically added to another table?

View 4 Replies View Related

Queries :: Delete Max Record From A Table

Jul 23, 2015

I have table1 that I append data to. The unique_ID is the rpt_date.

On form1 (that shows the table1 data) I want to delete the Max rpt_date from the table1.

I have tried to create a query involving MaxOfrpt_date linked to the table1 by the rpt_date and then create a delete query but it doesn't work !!

View 1 Replies View Related

Delete Record From One Depending On Criteria From Another Table

May 27, 2005

Hello all,

I am trying to write a query that deletes all records from one table that meet the criteria of another.

The table i need to delete from is called StartingPoint and the other table is called R7e, both tables have a field called "Reference" and R7e has a field called "Change".

I have been stuggleing with various different delete query's to no avail.

So i need the query to delete a record from StartingPoint where [R7e].[Change] = "Suspended". The reference field is a primary key, this field will need to be used to determine which records to delete from StartingPoint.

Sorry if it all sounds confusing.

Any ideas guys?

Many thanks
Tim

View 1 Replies View Related

Forms :: Delete Record From Subform And Table

Oct 23, 2014

I am getting a problem with delete button..I want to delete record from subform and Table..

Table:Payroll
Subform:PayrollSearchQuery
Form:Payrollog

I am giving the code is ....

Private Sub Command58_Click()
'check existing selected record
If Not (Me.PayrollsearchQuery.Form.Recordset.EOF And Me.PayrollsearchQuery.Form.Recordset.BOF) Then
'confirm delete

[code]....

View 3 Replies View Related

Table Shows Deleted Record But It Won't Delete

Sep 19, 2014

I have a table that is showing #Deleted in several fields, not all of them. When I select the record and try to delete it I get the message that the record id deleted. How do I remove this record?

View 3 Replies View Related

Delete Records From One Table Based On Record From Another

Oct 10, 2014

I want to Delete all records from the Table Named "CustomerWiseRotaryTillerRates" (Given Below) if the State in the State Filed in found in the "Customer_Master" Table (attached Herewith). What will be the correct procedure ?

I followed the steps referred in page no. 67 & 68 in the Book "Microsoft Access 2007 Data Analysis" by Mr. Michel Alexender.

Customer Name
State
Product_Code
Product_Name
Price_perunit

TSI Engineering Indutries (P) Ltd.
Assam
P_05
1500_Rotary_Tiller_220_RPM
Rs. 63,722.00

Kishan Krishi Engineering Works
Jharkhand
P_05
1500_Rotary_Tiller_220_RPM
Rs. 62,997.00

TSI Engineering Indutries (P) Ltd.
Assam
P_06
1750_Rotary_Tiller_220_RPM
Rs. 66,663.00

Shri_Tata_Enterprises
Bihar
P_06
1750_Rotary_Tiller_220_RPM
Rs. 65,683.00

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

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

Modules & VBA :: Delete Of A Record From A List Of Records In A Subform Deletes Wrong Record

Jun 28, 2013

When we browse through records in a subform we store the records in the database.When we want to delete a records for example the third record from the five records always the first records will be deleted. How can we delete the records where the cursor is at? When we are at the third record and press the delete button the third record from the list in the subform should be deleted.

Code:

Option Compare Database
Dim FocusBln As Boolean
Private Sub Identificeer()
Me.[Datum Aangemaakt].Visible = True
Me.[Datum Aangemaakt].SetFocus
If Me.[Datum Aangemaakt].Text = "" Then

[code]...

View 11 Replies View Related

Delete Record

Dec 4, 2006

I have a library database that I want to delete a record in my tblStatus when the book is returned. I have found the deleteobject function but it appears that that will delete like a table or query or report or something like that. I have no need to keep track of how many times a certain book has been checked out or that John Doe has checked out books X, Y and Z. As a mater of fact that is exactly what I don't want so I just want to delete the record that says Book ZZZ was checked out by John Doe. When the book is returned I just want it available for some one else.

Thanks in advance,

Rick

View 1 Replies View Related

Delete Record

Oct 1, 2007

Hello. I have form. and i need to delete record. Id is a unique key. When i have invisible textbox with source of this key, it's very easy to delete record from database. But is it possible to delete record with query without using textbox?

View 2 Replies View Related

Delete Record

May 31, 2005

Hi all, facing a little problem with my forms. Access gives me headaches everyday. Haha.

In a continuous form, I have a delete button with the following code

Private Sub cmdDelete_Click()
On Error GoTo Err_cmdDelete_Click

DoCmd.SetWarnings False
If MsgBox("Confirm deletion of the record?", vbQuestion + vbYesNo + vbDefaultButton2, "Delete?") = vbYes Then
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
End If
Exit_cmdDelete_Click:
DoCmd.SetWarnings True
Exit Sub
Err_cmdDelete_Click:
MsgBox Err.Description
Resume Exit_cmdDelete_Click
End Sub

However, after the record is deleted, the focus is immediately set to the next field which creates a new record of null data. And since the fields are all required, I am forced to enter data into the new record, if not a pop up will inform to user to enter data.

I do not wish for this new record to be created everytime I delete a row. How do I go about it?

I'm learning more each day! Thanks in advance..

View 9 Replies View Related

Delete A Record

Feb 13, 2006

I have a problem with 1 of my form (FrmEditDrawing) that I use to edit a specific record from 1 of my table (TblDrawing). The user will see the Data for each drawing on a form that I called (FrmViewDrawing) and will be able to edit the data for each drawing by clicking a button that will open the form "FrmEditDrawing" on the specific record. In that case I can't edit and change the data for any fields but if I open the form on its own, I can edit and change the data ?
I guess it has something to do with the fact that I open twice the same recordsets which locks the table, I am not sure. What would be the different option to solve this problem?

View 7 Replies View Related

Do You Want To Delete This Record - Pop Up Box

Dec 4, 2006

When you want to delete a record out of MS Access, you get the default pop-up message confirming you want to delete the record [YES] [NO].

I have a few users who are not paying attention and hitting a combination of keys (I am guessing Alt + D) and getting this message. They then do not look, and confirm the deletion of the record.

I am thinking of two ways around this.

1) Change the default to [NO] when this pop-up dialog opens up (the default is [YES]).

2) Disable this pop-up box, and then create my own to confirm the deletion.

Are either of these possible, or has anyone ever had to work around this issue? I have never had an issue with this, and was not sure how to attack it.

Let me know.

Thank you,

T.J.

View 7 Replies View Related

Delete Record

Nov 18, 2004

i have an order form somewhat like the northwind database one. I called mine A5_frmOrders. i have a subform called A6_sfrmOrders, which is in datasheet view. I need to add a "Delete Record" button into the subform, but when i put it in the subform footer, it doesnt appear.

Like any orders subform, i have "Item", "Product", "Quantity", "Unit Price" and "Subtotal" with their corresponding labels in the Detail Section. I tried changnig the subform to "Continuous Form" and doing this :
header : Labels for "Item", "Product", "Quantity", "Unit Price" and "Subtotal"
detail : "Item", "Product", "Quantity", "Unit Price" and "Subtotal" for user to fill in
footer : Delete Record button

but even when i change to Continuous Form, it doesnt allow me to separate "Item" from its label and put one in the header and one in the detail...

how do i add in the delete record button? Is it true i cannot use datasheet view if i want a delete button?
Thanks

View 1 Replies View Related

Trying To Delete A Record With Code

Dec 11, 2005

Why does this code not delete the current record?

DoCmd.RunSQL "DELETE * FROM [Tble-Readings]WHERE
[Tble-Readings].[ID]= " & Me![ID] & ";"

I have this code on the a Close Button and if the record is incomplete I want it to be deleted from the table. The ID field is an autonumber so it is the 1st field to get a value if a user starts entering data. I get a msg box saying 0 fileds will be deleted why? the id's do match but it does not delete??

jon

View 5 Replies View Related

Dont Delete A Record

Aug 17, 2006

Hi guys,

Could anyone give me a solution to protect a table and all the records in there so they can never be deleted when being viewed.

Many thanks, Ben

View 3 Replies View Related

Query To Delete A Record

Feb 15, 2008

i have a table1 in my msaccess and i linked another table in mysql to ms access, (table2).
when table1 matches the record in table2, it will delete the record in table1.

my query is
delete *
FROM Table1
where table1.artid = table2.artid;

but it always ask me the value of tbl2.artid, the value of tbl2.artid is in the database of mysql and it has already records...

how can i compare the records of table1 (msaccess) and table2 (mysql) and delete the duplicate records?
:D

thanks in advance

View 11 Replies View Related

Need To Delete Record And Can't Figure Out How...

Jan 24, 2005

Very new to Access and not a VB programmer. :confused:

With that in mind, I have created form for users to record address changes of members. I want to have a button that will "undo" what a user entered if they change their mind/decide an address change not necessary. My address change table has an auto-number field (ID) that is the index and I believe Access automatically creates a record regardless so how do we get rid of it?

I did a search and keep reading about a button wizard - Huh??? I don't know how to activate a button wizard (told you I was new). Also, I read about adding code but to where? and how? It also appeared the code examples might be using psuedo-names for tables or something ... how do I know a "real" name from a psuedo-name?

Can a "Delete" query be written? if so, what is the criteria to use?

I've looked at the properties of the button and all I can see is a place to add a macro or an expression. Am I in the wrong place for what I want to do?

Can anyone offer some help here?

Thanks!

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

Help To Delete A Record From The Subform

May 13, 2005

I have a subform its not in datasheet view and gives details of bookings for clients.

I am using the on click event of a field and I know that access knows which record I clicked. How do I delete it? which method do I use. can it be done without searching as I know which one i clicked?

regards in advance.
:eek:

View 6 Replies View Related







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