Delete Helps.Thanks

Jun 22, 2006

Hi all,

Dim vAns As Variant

vAns = MsgBox("Are you sure you want to delete this record?", vbQuestion + vbYesNo, "Delete")
If vAns = vbYes Then
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

I'm trying to create a delete function. First, it prompt me whether i want
to delete this record
vAns = MsgBox("Are you sure you want to delete this record?", vbQuestion + vbYesNo, "Delete")

However, after i click 'Yes". Another prompt will pop up and ask me whether i want to delete this record. This prompt is not this prompt vAns = MsgBox("Are you sure you want to delete this record?", vbQuestion + vbYesNo, "Delete")

I think it is access built-in prompt. my qn is that is there any way to prevent the 2nd prompt from being pop up?

Thank you

View Replies

Need Helps..

Oct 31, 2007

Hello everyone .. help me please..I am really new in Access.
Currently, i create one query; there i use " AS " keyword for example: Month(date) as month. Later, i wanna create another query which is to update some values of the month. When trying to execute the update code for the month, i always get the error message: month field not updatable. I wonder what's wrong with that. If is not updatable, could you give me some solutions?

Thanks in advance

View 4 Replies View Related

Helps! Access 2003

Apr 27, 2006

I cannot implement search function for my database through List Box Wizard
; it doesn't have option that "Find a record on my form based on the value I selected in my List Box".......

Who can tell me why......

If i don't use this wizard, is there any way that i can implement search function??

Thank you!!

View 12 Replies View Related

A Thorough Tutorial That Helps One Make A Mean Database

Oct 24, 2006

Hello all!

I have been searching online for the past couple of days for a thorough tutorial that aids the user to make his/her own detailed database based on example data (that does not necessarily have to be adhered to) supplied as the tutorial progresses.

As a student participating in an advanced computing class, I feel that this would benefit me as I can do as the steps ask and see how certain things are done. I am not a complete Access mug... I have a basic knowledge of the fundamentals, but stumbling accross an in-depth tutorial that details all of the standard features (tables, queries, forms etc) along with possibly some example modules would be excellent and beneficial.

All I have found so far is various snippets - "SQL basics" and "Macros: what they do and how to implement them" for example - these miss the bigger picture I am looking for. Surely a step-by-step tutorial on "Designing and working a fully-featured database from the gound up" is not that rare!

Thanks in advance for any help. :)

View 5 Replies View Related

Helps! Cannot Implement Search Using Combo Box

Apr 27, 2006

Who can tell me why I don't have following option in the Combo Box Wizard?
"FIND A RECORD ON MY FORM BASED ON THE VALUE I SELECTED IN MY
COMBO BOX"

I am appreciate!

View 2 Replies View Related

Need Helps On Query Retrieve Range Of Dates

Apr 18, 2007

4/11/2007 1:01:28 AM
4/12/2007 2:02:52 AM
4/13/2007 4:21:30 AM
4/14/2007 2:22:21 AM
4/15/2007 3:34:53 AM
4/16/2007 4:02:37 AM
4/17/2007 5:03:15 AM
4/18/2007 7:17:34 AM

I need some helps
I have a table with date + time, how can I query so that it retrieve a 7 days range from today and go back ti 7 days

i though this should work (it works if the the table has date only no time)
Between Date() And DateAdd("d",-7,Date())

thanks

View 2 Replies View Related

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

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