Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Macros > Ambiguous Name
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 5617 of 5947
Post > Topic >>

Ambiguous Name

by =?Utf-8?B?SmVubmlmZXI=?= <Jennifer@[EMAIL PROTECTED] > Jul 10, 2008 at 11:04 AM

I have two separate databases, that perform exactly the same way, except
one 
is pulling CR and the other is pulling  CB. I combined the databases
because 
I want the person to press one button and it run the whole thing for her.
But 
once in the same database, it will not run the module part because:

The expression contains ambiguous name.
You may have two or more functions with the same name in different
modules. 
Rename the functions so that each one has a unique name. 

Here is how the CR module looks:
Public Function DoSQL()
    Dim SQL As String
    SQL = "UPDATE Code " & _
          "SET code.number1 = '1'"
    DoCmd.RunSQL SQL
    DoCmd.OpenQuery "make final CR tbl", acViewNormal, acEdit
    
Here is how the CB module looks:

Public Function DoSQL()
    Dim SQL As String
    SQL = "UPDATE Code " & _
          "SET code.number1 = '1'"
    DoCmd.RunSQL SQL
    DoCmd.OpenQuery "make final CB tbl", acViewNormal, acEdit

I think it has something to do with the DoSQL()  but I'm not too sure. Can

anyone help? 
Thanks,
Jennifer
 




 3 Posts in Topic:
Ambiguous Name
=?Utf-8?B?SmVubmlmZXI=?=   2008-07-10 11:04:18 
Re: Ambiguous Name
"Jeff Boyce" &l  2008-07-10 11:43:35 
Re: Ambiguous Name
=?Utf-8?B?SmVubmlmZXI=?=   2008-07-10 12:45:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 10:04:02 CST 2008.