If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
If you're not calling the routines anywhere, then yes, delete them.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "pm" wrote in message ... Oh, by the way...I don't have any commands or macros entitled "Update_Retail", nor any similar for "Distr". This all started because I wanted to refresh the list box entries and see the most recent contact ID. I would be happy now if I can just get these records entered. Shall I take out all these "Update" references? "Joan Wild" wrote: You have two copies of Private Sub Update_Retail_Click(). Delete the lines as indicated below (via a 'X') "pm" wrote in message ... I am getting "Ambiguous name Detected" error for a command that no longer exists on my form. The following is a copy of what is in the module behind the form, but I don't know what to take out or leave in. ------------------------------ X Private Sub Update_Retail_Click() X On Error GoTo Err_Update_Retail_Click X X Dim stDocName As String X X stDocName = "Last Retail ID" X DoCmd.OpenQuery stDocName, acNormal, acEdit X X Exit_Update_Retail_Click: X Exit Sub X X Err_Update_Retail_Click: X MsgBox Err.Description X Resume Exit_Update_Retail_Click X X End Sub Private Sub Update_Retail_Click() On Error GoTo Err_Update_Retail_Click Dim stDocName As String stDocName = "Last Retail ID" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_Update_Retail_Click: Exit Sub Err_Update_Retail_Click: MsgBox Err.Description Resume Exit_Update_Retail_Click End Sub Private Sub Update_Distr_Click() On Error GoTo Err_Update_Distr_Click Dim stDocName As String stDocName = "Last Distr ID" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_Update_Distr_Click: Exit Sub Err_Update_Distr_Click: MsgBox Err.Description Resume Exit_Update_Distr_Click End Sub ----------------------- Would appreciated simple steps to resolve this. I have to finish a project TODAY and need help ASAP! -- Joan Wild Microsoft Access MVP |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Backing Database | GOL | General Discussion | 4 | January 28th, 2005 03:32 PM |
Error message different in MDB and MDE | david epsom dot com dot au | General Discussion | 1 | September 21st, 2004 12:47 AM |
Help, i'm gettiing error: Access has encountered a problem and needs to close... | betsy | General Discussion | 0 | September 14th, 2004 08:20 PM |
Expression - calculating running total | Kathy | Running & Setting Up Queries | 26 | June 22nd, 2004 10:14 PM |
Custom Error Messages | DMc2004 | Database Design | 4 | June 11th, 2004 11:16 PM |