Access Forms Programming • View topic • Turn off delete record message using code.

Turn off delete record message using code.

4 posts • Page 1 of 1

Jump to:

Next

1. Hyperlink Button
Hi all I have a form which contains a field for a hyperlink. The user should be able to edit the hyperlink by pressing the avaliable button. The following code is then started: Me!photo1.SetFocus RunCommand acCmdEditHyperlink This is only an extract, when I try to run this I get the error 2046, command not avaliable. Can someone help me get this on track. If you need more of the code I can post it. Thanks
2. 3 separate Forms, How do I move each form record forward wih one b
I want to be able to move the record forward in 3 separate subforms on a (tab page) within my main form, but when I set a macro with the oToRecord command, I get the following error: The table inal Top 10 Ais already opened exclusivley by another user, or it is already open through the user interface and cannot be manipulated programmatically. So, I tried putting in an penFormCommand within the macro; but then I get this error Message: The Object inal Top 10 Form Aisn open The macro you are running (directly or indirectly) contains a GoToRecord action, but the Object Name arguments names an object that is closed. Use one of the Open Actions or methods to open the object so that you can carry out the desired action Does anyone know how I can simply get 3 separate forms to advance 1 record forward, siumultanously?. This is to save the user pressing 3 separate buttons (1 for each form) The Names of the 3 forms are: Final Top 10 Form A Final Top 10 Form B Final Top 10 Form C
3. Cascading 3 combo boxes help
I mistakenly posted this to the excel programming group. Please excuse this double posting. I have these two cboboxes in my app and the 'cascading' works great. What I need is the coding for ThirdCboBox that would be using both of the first two cboboxes to limit the choices available to the userin the third cbobox , but I don't know how to construct the sql statement to include two 'limit' criterias in one statement. Please help me with this - I sure appreciate your time and expertise, as always. You guys have made this project a fun and successful deal for me. First CboBox Private Sub cboCoName_AfterUpdate() Me!cboLocation.RowSource = "select tblmain.[location] from tblmain where tblmain.[CoName] ='" & Me!cboCoName & "'" Me.cboCoName.Requery End Sub SecondCboBox Private Sub cboLocation_AfterUpdate() Me!cboStreet.RowSource = "select tblmain.[street] from tblmain where tblmain.[Location] ='" & Me!cboLocation & "'" Me.cboStreet.Requery End Sub TIA Joanne

Turn off delete record message using code.

by R3JlZw » Wed, 25 Oct 2006 10:25:02 GMT

I have a button on a form that contains a subform. When I click on the button 
the selected record on the subform is deleted from the underlying bound 
table. Is it possible to stop the message box appearing, advising that a 
record is about to be deleted, using code for this procedure only. Ie I still 
want to be advised if I run other delete queries within the application.

Re: Turn off delete record message using code.

by Gina Whipp » Wed, 25 Oct 2006 10:40:18 GMT

Greg,

                DoCmd.SetWarnings False   'turns off messages
                ***Put your delete sequence in here***
                DoCmd.SetWarnings True   'turns messages back on


-- 
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors 
II

Re: Turn off delete record message using code.

by R3JlZw » Wed, 25 Oct 2006 10:47:01 GMT

Thanks Gina!

Re: Turn off delete record message using code.

by Gina Whipp » Wed, 25 Oct 2006 10:56:22 GMT

Glad to help, thanks for posting back!

-- 
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors 
II

Similar Threads:

1.Delete message - Can is selectively be turned off?

Thanks for take time to read my question!!

I'm using code that will automatically delete rows of data in a field
and of course when you do this Access will prompt you  that you are
about to delete x number of rows.  

Most of the time I want this message be displayed.  Can I use code
that will delete specified rows and not give the message?

Here is the code that I'm currently using:

Dim SQLDelete As String
   
SQLDelete = "delete from Equipment where EquipID = " & Me.List_Device
        
DoCmd.RunSQL SQLDelete

Thanks

N. Graves

2.How do I turn off ALL warning messages-ie table will be delete

3.How to turn off the printing message off?

Hi

Is it possible to turn off the printing message from VBA 
for access?

Thank you

4.Cancelling or deleting entry or How to turn off auto new record

5.Turn on Code and turn off Macros

I recided Access 2007 on my Test laptop. For some reason I can only run 
wizard macros and not Code. I tried writing basic code "docmds" and others 
and none of the code runs. Even if I conver the macros to code. Code does not 
run. Is there a setting for this?

6. Turning off message "Can't Add all the records in the Update or Append Query"

7. Turn filter off and on using code

8. Cancelling or deleting entry or How to turn off auto new recor

4 posts • Page 1 of 1

Return to MS Office Access

Who is online

Users browsing this forum: No registered users and 9 guest