Vba To Delete

Feb 29, 2008

hello,
can anyone point me to a thread that deals with vba code to delete.
i am trying to delete a file path in my table and at the same time it would delete a physical file in a directory that corresponds with the deleted file path.

thank u

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

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

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

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

Delete How? Please!!!!!

Nov 22, 2004

have searched forum for this but not getting what i want (or maybe i just don't understand very well) but here's my question anyway:

the table is related to several other tables and the cascade delete property is on.

on a master form (with subfrm for related tbls) i want cmdbutton to do this:

when the user DELETE a record, the deleted record (and! it's subdata) must be removed from the current table(s) but copied(?) to another table(s) which won't be accessed by the user, so that i can keep track of deleted records.

do i have to setup DUPLICATE tables (and relate them again) to capture deleted records ? and then have a qry that will cut(?) paste records that gets deleted?

i think i need only one qry that will do all this, but not sure how ?

any help much appreciated.
regards,
Piet.

View 6 Replies View Related

Cannot Delete

Mar 4, 2008

I have a table with several fields and I am trying to delete one of the fields. It tells me the field in related to one or more tables and to use Database Relationships to delelet the relation. I have taken every table out of the Relation Database, Deleted every query, form that ever related to the table and still can't delete the field from the table. I have done Database repair, delete the entire table and rebuilt it and I still have the problem. Any help out there? Thanks.

View 13 Replies View Related

Delete HELP!

Jan 11, 2006

ok ive made myself a DELETE query, that should Delete all records in a table that are 'TRUE'....
however i cant add it to a command button in my form...it wont appear in my 'command button wizard' as part of my queries, its not there...

any ideas why?:confused:

thanks

View 11 Replies View Related

Delete

Aug 17, 2006

Hi guys,

Why wont this query work??

DELETE Work.MemID
FROM Work2 INNER JOIN [Work] ON Work2.EMAIL = Work.EMAIL
WHERE (((Work.MemID)<>[Work2].[MemID]));

Two tables as you can see..

And all i want to do is delete records in one table which dont have the same MemID in another table..

View 2 Replies View Related

Delete XLS

Feb 7, 2007

Good day,
How I can delete an excel file from a macro in Access 2007?
Thank you.

View 2 Replies View Related

Delete

Feb 15, 2007

I have two tables. table A and table B. Both tables have a field called CASE.
What I want to do is delete from table A the CASE where table A and table B CASE is the same.
example:

Table A Table B
Case Case
1 2
2 4
3
4
5
I want the results of the query to delete CASE 2 & 4 from Table A

View 1 Replies View Related

Can Delete

Oct 13, 2005

I have a field that if another field matches the criteria then a user must fill in that field. If that makes sense!!

I have some code that if a user exits without entering any information on it asks them if they want to and if not undoes what the user has entered in the form. This works fine however a user can enter something into the field exit the field then go back in and delete it. When the user then goes to exit it doesnt flag up as it thinks it has been updated. Can anyone help with this.

My Code so Far:


If Me.No2Release = "Cayman Certificate of Release to Service" And Me.Eng2_Approval = "" Then
If MsgBox("You haven't entered an approval number. Do you want to?", vbQuestion + vbYesNo) = vbYes Then
Me.AC_Ser_No.SetFocus
Me.Eng2_Approval.SetFocus
Else 'user clicked no
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
Me.Base.SetFocus
End If
End If

Thanks

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

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

Delete Query

Apr 4, 2006

Can anyone help?

i have set up the delete query:

DELETE dbo_MP_Audit.*, dbo_CAD_SINV_HEADER.SIN_CANCELLED_YNF
FROM dbo_MP_Audit INNER JOIN dbo_CAD_SINV_HEADER ON (dbo_MP_Audit.Usr = dbo_CAD_SINV_HEADER.USR_CODE) AND (dbo_MP_Audit.Sin_DocNum = dbo_CAD_SINV_HEADER.SIN_NUMBER) AND (dbo_MP_Audit.company = dbo_CAD_SINV_HEADER.CMP_CODE)
WHERE (((dbo_CAD_SINV_HEADER.SIN_CANCELLED_YNF)=1));

but receiving error message: "could not delete from specified tables".

View 3 Replies View Related

Cannot Delete Field !!!

Jul 12, 2006

I have removed the relationship and still can't remove a field. Any help??

I also tried compact and repair and then still will not delete.

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

Text Box With Add/Delete Only

Mar 15, 2007

Is there any way that I can restrict a text box entry from being changed? I am working on a tracking system and presently can capture when a text field entry is added or deleted. I can't capture when a text field entry is overwritten. Therefore I only want the user to delete the present entry and then add a new entry in the text box. Is this restriction possible for a text box?:cool: :rolleyes:

View 4 Replies View Related

Delete Database???

May 8, 2007

Is it possible to delete an entire seperate database from within a database via code after an uodate procedure has been carried out on a click event of a commad button, what would the code be to acheive this if its possible??:rolleyes:

View 3 Replies View Related

Need To Delete Some Files

May 17, 2007

Before I spend a load of time on this, thought I'd check to see if it's even possible.

Thanks to some help from folks here, I have some code that allows me to output some reports to a folder and then email those reports as attachments, all from inside my db.

Now I'd also like to delete those files after the email is sent, before the module ends.

Anyone know if this is doable? If so, I'll get started working on the code.

Thanks
BeckieO

View 4 Replies View Related

Delete Query

Aug 24, 2007

I have a table that has records listed more than one time. Some of these multiple records have in the score field a zero for the score. I would like to remove all records that are in the table more than once that have a zero for the score in the score field. Any help is greatly appreciated!

View 1 Replies View Related

Delete Query

Feb 21, 2008

Hi,

i have set up a delete query to delete items ticked on a query. the form related to the query only shows the items with a "False" value in the criteria. anything set as "true" ( ticked ) is reserved for deleting. the delete query looks at the query and selects all items set to true. it works ok but i dont know how to get this work automatically without going trough the access prompts of deleting.

can this be done with code behind a button whereas if clicked, it runs the query and deletes all of the true items?


thanks,

NS

View 2 Replies View Related

Delete Tables

Mar 31, 2005

Is it possible to delete a table from a remote access db.
i.e
table "A" is in database "A"

from a form in database "B" i would like to run a routine that would
Delete table "A" from database "A"

i have tried using "DoCmd.DeleteObject acTable" but i think this only works for the currentdb
Can anybody help

Regards
Bjackson

I am using A2K

View 1 Replies View Related

Delete All Data At Once, Possible?

May 29, 2005

Because of a data-import I would like to import all new data into existing tables. Therefore I first need to dump all my existing test data throughout 30 tables which have several relations.
Is there a command in access or a batch script which performs a bulk delete among all tables?

View 3 Replies View Related

Delete A Object

Aug 7, 2007

I have created a database with Access 2007 and would like to remove some tables and reports that do not work as I had planned. I have tried to select them from the navigation pane and use the right click menu, however the delete option is grayed out.
Thanks
Jim

View 4 Replies View Related







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