Compile error:

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I downloaded a sample "Search2K" for searching for people in a DB. It works
fine but not in my database. I'm getting the following error message when I
activate the command button:

"Ambigous name detected: Isloaded"

Below is the Form Open code:

Private Sub Form_Open(Cancel As Integer)
On Error Resume Next
If Isloaded("frmPeople") Then
Me!cmdNewPerson.Visible = False
Else: Me!cmdNewPerson.Visible = True
End If
Exit Sub
End Sub

First line and Isloaded in line 3 are highlighted.

Thanking you for your help.
 
Hi.
"Ambigous name detected: Isloaded"
Click to expand...

You have another procedure of the same name in your database application.
It may be in your form or in a standard module. Search for "IsLoaded" in
your code and delete the version you don't want, then save and compile again.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
 
Camaro,
I have no idea how to do this. Can you explain what the Microsoft Online
Community is, and how to log onto it and how to mark posts as "Answers"?

UpRider
 
It's a "feature" that Microsoft saw fit to include with their web interface,
totally forgetting that these forums are NNTP newsgroups, and that many
posters choose to use proper newsreaders. While you could go to
http://msdn.microsoft.com/newsgroups/ to see the interface, I suspect that
if you didn't use the web interface when you asked the question, you'll be
unable to mark it as "Answered". At least, I hope that's the case!
 
Hi.
I have no idea how to do this. Can you explain what the Microsoft Online
Community is, and how to log onto it and how to mark posts as "Answers"?
Click to expand...

The Microsoft Online Community is the Web-based newsreader that nearly 3/4
of all questions posted to the microsoft.public.* newsgroups for Microsoft
Office and SQL Server are submitted from. Aside from the benefit of getting
one's question answered by volunteer experts on these Microsoft products for
free (which one can get using any newsreader), one may contribute to the
knowledge base of previously answered questions where researchers can
quickly find solutions to problems that others have resolved in the past.
While there are extensive archives of past newsgroup posts elsewhere, one
must weed through those threads (sometimes reading hundreds or thousands of
messages) to find the solution that works, so researching Microsoft's
knowledge base of newsgroup answers can be much faster.

Experts who respond to each question contribute their expertise to the
knowledge base, and people who sign into the Microsoft Online Community to
post a question can also contribute by marking the correct responses to
their question as an answer. The ability to mark any responses is not
available to posters who did not sign on as a Community member before
posting their question.

The Web newsreader can be cumbersome (it's buggy, too) and is not as
feature-rich as desktop application newsreader clients, but the incentive
for experts who answer questions as a Community member is to earn a special
badge that, once earned, will be displayed next to their names in the
Web-based newsreader. There are three levels of badges (bronze, silver, and
gold) for achievement levels (number of questions answered), plus the MVP
badge. (Basically, these badges are "bragging rights," as there's no
monetary compensation involved.)

The incentives for those posting questions are:

1.) Contribute their question and responses to Microsoft's knowledge base
of answered questions.

2.) Rank as high as possible on the list we distribute to our subscribers
seeking badges (and those who are just pressed for time) who target the
questions of those most likely to mark correct responses as answers, thereby
getting themselves "front of the line privileges" when it comes to getting
their questions answered. Questions at the top of our list get answered by
our subscribers first. Most people who receive correct responses to their
questions don't bother marking them, so those who do have the advantage in
getting their questions answered more quickly.

(Our list includes the questioner's name, past history of marking answers,
the question's subject line, number of current responses to the question,
and the newsgroup name. The subject line is a clickable link to open a Web
browser directly to the question, so that the answerer can easily find
questions that haven't been responded to yet and doesn't have to hunt for
suitable questions he knows the answer to. And with statistics on about
100,000 members and about 600,000 newsgroup messages, just like Santa, we
know who's been naughty or nice.)

3.) Keep their question and responses in Microsoft's searchable database of
current newsgroup posts, instead of being removed as an "unanswered
question" after the waiting period expires (currently 13 weeks, but that
fluctuates).

To become a Microsoft Online Community member requires a free .Net passport
(to authenticate with). One must sign in to post questions and responses,
make suggestions to Microsoft, and mark posts as either an answer to their
question or helpful (from someone else's question).

Here are some links that you may be interested in:

Web newsreader for Access (General Questions):

http://www.microsoft.com/communitie...3c3-c10e-4523-9213-cdfd537838f1&lang=en&cr=US

The other Microsoft Office applications' newsgroups are easy to find from
that link, but SQL Server is not, so here's the link to SQL Server (Server
Questions):

http://www.microsoft.com/communitie...16d-c791-4566-8ff8-30114a05db02&lang=en&cr=US

Microsoft's knowledge base of previously answered questions:

Access:
http://www.microsoft.com/office/com...S&guid=&sloc=en-us&dg=microsoft.public.access

Excel:
http://www.microsoft.com/office/com...US&guid=&sloc=en-us&dg=microsoft.public.excel

Word:
http://www.microsoft.com/office/com...=US&guid=&sloc=en-us&dg=microsoft.public.word

Outlook:
http://www.microsoft.com/office/com...&guid=&sloc=en-us&dg=microsoft.public.outlook

SQL Server:
http://www.microsoft.com/office/com...uid=&sloc=en-us&dg=microsoft.public.sqlserver

For more information on Microsoft's Online Community and its Web-based
newsreader, please see the following Web page:

http://www.microsoft.com/wn3/locales/help/help_en-us.htm

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
 
The Microsoft Online Community is the Web-based newsreader that nearly 3/4
of all questions posted to the microsoft.public.* newsgroups for Microsoft
Office and SQL Server are submitted from.
Click to expand...

I might point out the one of the problems of using the web based news
interface is that threads, such as this one get lost easily. Most of the
MVPs will not use the web-based interface, no matter what th "reward". Those
of us who answer lots of questions, find using a newsreader (any newsreader)
much faster and much easier to use. One of the better newsreaders is Agent:

http://www.forteinc.com/agent/index.php

and they have a free version as well. I use Outlook Express 6.0 which comes
with Internet Explorer, mostly because I'm used to it and have used it for
so long.

If one expects to either ask or answer lots of questions, use a newsreader
to make the process easier for everyone.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Hi, Arvin.
I might point out the one of the problems of using the web based news
interface is that threads, such as this one get lost easily. .. . .
Those
of us who answer lots of questions, find using a newsreader (any
newsreader)
much faster and much easier to use.
Click to expand...

Therein lies the rub: Why would something so inconvenient become, and
remain, so popular? (Last year at this time only 1/3 of questions were
posted via the Microsoft Online Community Web-based newsreader. By
November, it was nearly 2/3. It's now nearly 3/4.) Because it isn't
inconvenient for people who ask questions. They aren't interested in
following threads. They only want answers to their questions, so they post
a question, sign up for E-mail notification (merely a button click), then
wait for the answers to come to them.

When someone responds, they get an E-mail with a link to the Web page with
the response. They read the response and if it answers their question, they
take that information and forget about the thread, because they are
satisfied. If the response doesn't answer their question or "almost" works,
they sign into the Community from that Web page, post a reply to the
responder, close the Web browser and await the next E-mail with a link to
the Web page with the responder's next reply.

Now, that's convenience.
Most of the
MVPs will not use the web-based interface, no matter what th "reward".
Click to expand...

Almost 3% of questions posted to the newsgroups we track are responded to by
an MVP signing into the Microsoft Online Community to post that response.
That's thousands of postings, yet just a few drops in the bucket. There's
zero incentive for MVP's to "achieve the next contributor level," because
they've already got the MVP award for this year (and likely many more).
Even so, three MVP's, Peo Sjoblom, Mike Epprecht, and Jocelyn Fiorello have
already earned the bronze or silver badges.
If one expects to either ask or answer lots of questions, use a newsreader
to make the process easier for everyone.
Click to expand...

The questioners have very different goals than the answerers, so the use of
different tools to achieve those goals is understandable. And one of the
features we're adding to our subscribers' services is the ability to track
all threads that the subscriber has responded to. (They can already track
threads where any of their responses have ever been marked as answers.) Our
subscribers who ask questions already have the ability to track the threads
of all of their own questions but, not surprisingly, this service is unused.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
 
Hi Gunny,

'69 Camaro said:
There's zero incentive for MVP's to "achieve
the next contributor level," because they've already got the MVP
award for this year
Click to expand...

I think you misunderstand the motivations of many/most MVPs. I don't know a
single one that set out answering questions with the goal of becoming a
MVP.

It's really not in the spirit of the program. We answer questions because
we like helping others, and I'm sure most would continue to answer
questions, whether the award is given the following year or not.

FWIW.
 
Hi, Joan.
I think you misunderstand the motivations of many/most MVPs.
Click to expand...

Perhaps it was a poor choice of words on my part. Arvin pointed out that
most MVP's won't use the Web-based newsreader, and I agree that there aren't
any compelling reasons to do so. In an earlier post I explained the
incentives to use the Web-based newsreader for people who ask questions and
for those who answer questions to get some recognition, but MVP's don't have
any incentives to use it.
We answer questions because we like helping others
Click to expand...

I agree. If we didn't enjoy it, we wouldn't be here.

BTW, on another topic, did you receive the second E-mail from me on Thursday
afternoon regarding the discussion on Access security? You didn't receive
the first E-mail on the first try, and I would be happy to send you a copy
of the second if you didn't receive it.

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
 
'69 Camaro said:
[...]. In an earlier post I
explained the incentives to use the Web-based newsreader for people
who ask questions and for those who answer questions to get some
recognition, but MVP's don't have any incentives to use it.
Click to expand...

For those of us on dial-up connections, at least, there's a strong
disincentive to use it. If I had to wait for the web-based newsreader,
I couldn't answer a tenth as many questions.
 
Good. Did you download the password cracker to see whether or not someone
was pulling your leg?

Gunny
 
By the way, I have to ask.... As a frequent poster here, have you tried a
real newsreader? If so, why are you so attracted to a webbased interface?
 
Someone was telling you that it was a password cracker, when in fact, it
won't give you the password of any other database file besides the one
applied to the demo file. Not much of a password cracker if it can't be
applied universally, huh? His claim is misleading.

Gunny
 
Well, like I said I didn't download it, so.... I don't quite get it.

Fact is, if you have some password cracker thing, then OK - join the
masses; it isn't exactly news that Access Security is "secure"
 
Well, like I said I didn't download it, so.... I don't quite get it.

You won't get it unless you see it with your own eyes. And then you'll
realize the joke is on him -- and anyone else who blindly believes him --
because it doesn't do what he thinks it does.

I'd be happy to E-mail you a copy so that you can see for yourself, but I
have a feeling that you'll decline my offer.

Gunny
 
Hi, Joan.
As a frequent poster here, have you tried a real newsreader?
Click to expand...

Most of the time I use Outlook Express. I've posted thousands of messages
with it. However, I'm a field tester for the Campaign application (the one
that makes the lists for our subscribers), so I get to use it whenever I
want to quickly find all the questions in all of the newsgroups that haven't
been answered yet. Since I'm already on the correct Web page by just
clicking on the subject line in the list, I can quickly answer the question.
If so, why are you so attracted to a webbased interface?
Click to expand...

It's not really an attraction. More like "immersion." We were challenged
to a contest. (It's a long story, but we used to kid the Excel guys who
thought they were experts (okay, we still do), because the amount of skills
it takes to be good at a spreadsheet application are but a fraction of the
skills necessary to be good at a relational database management system.
They challenged us to a battle of skills in our respective areas of
expertise and the official scores were each player's number of questions
answered in Microsoft Online Community's Web-based newsreader. The winning
team would be the one with the first player to reach silver badge level (101
answers), but only after every other team member had reached bronze badge
(51 answers) level. That way all had to do well, not just one member.)

Eventually, they were beating the pants off us, even though we were
answering more questions than they were. We analyzed the situation and
discovered their advantage: better visibility. They were using the
Web-based newsreader (yeah, "You've _got_ to be kidding!"), which tallied
their score of answers in their user profiles and gave them enough
credibility that the questioner was confident enough in their responses to
mark many of them as answers. The same phenomenon had happened with the
MVP's. MVP's are more credible than non-MVP's in the eyes of the
questioners and, at one time, the MVP's posts were marked as answers three
times as frequently as non-MVP's posts (although this ratio has improved
considerably since then). We were using Outlook Express to post our
replies, so our scores weren't visible when questioners looked at our
profiles, and we weren't MVP's, either. Questioners weren't confident
enough in our answers to mark them as such so they didn't, even when an MVP
gave an identical answer to their question (which earned their green check
mark of approval, but ignored us).

We changed tactics. We started using the Web-based newsreader too, and
built a database application that would find the questions from the people
who were most likely to mark correct answers. We used it to catch up to,
and pass, the other team. As soon as each of us had a high enough number of
posts marked as answers (as revealed in our user profiles), we, too, started
getting a much higher rate of our responses marked as answers. Our answers
had always been the same quality when we used Outlook Express, but it was
the "visibility" of the score that made the difference to questioners.

Our database application turned out to be a pretty useful tool. On average,
the chances of any question being marked as an answer are only 1 in 8, but
by using our lists, we found our replies being marked as answers more than
1/3 of the time. The lists that Campaign generates greatly increase the
odds of getting one's responses marked and can greatly reduce the amount of
time it takes to earn the badges. Matching up people who want to get
correct answers to their questions as quickly as possible with experts who
want to correctly answer their questions as quickly as possible is a win-win
situation. That's why we publish these lists to our subscribers.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
 
Since I'm already on the correct Web page by just
clicking on the subject line in the list, I can quickly answer the
Click to expand...
question.

Maybe so, but unless you are on a T3, you can't begin to *get* the question
as fast as someone with a newsreader, any newsreader, and dialup.

You cannot follow threads that are lost or disconnected, nor can you easily
see multiple answers in the same thread.

You also cannot flip back and forth between newsgroups.

You cannot quickly sort through thousands of headers, or even see thousands
of headers.

You cannot easily see posts several years old or search through the text on
them without going through Google groups.

There are no incentives at all for anyone whose goal it is to actually help
as many people as they can.

Microsoft would like us all to believe that a Web interface is the perfect
tool for everything that pertains to a computer. The fact is that it isn't.
It is the perfect tool for quickly changing static information that requires
a graphical interface, and for certain interactions involving the wide-area
collection and disemination of information. For specialized applications, I
have never once found a Web interface superior to a dedicated application.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top