473,327 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

The @ sign in MsgBox prompt?

MLH
If MsgBox(sMyCaption & " is already open@" _
& "Do you want to open a second instance of this database?@", _
vbYesNo Or vbQuestion Or vbDefaultButton2) = vbYes Then Exit
Function

What's the purpose behind the @ signs in the above msgbox fn?
Sep 19 '06 #1
11 1992
"MLH" <CR**@NorthState.netwrote in message
<eo********************************@4ax.com>:
If MsgBox(sMyCaption & " is already open@" _
& "Do you want to open a second instance of this database?@", _
vbYesNo Or vbQuestion Or vbDefaultButton2) = vbYes Then Exit
Function

What's the purpose behind the @ signs in the above msgbox fn?
If you run that statement in A97 with and without @, you will see what
function it has. In later version it has no function, except if you
use it through the Eval function.

In A97, at least on the version I'm looking at right now, this is
explained quite good in the help file, in one of the examples.

--
Roy-Vidar
Sep 19 '06 #2
MLH wrote:
What's the purpose behind the @ signs in the above msgbox fn?
Press F1

On the index tab, type in @ into the first text box.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Sep 19 '06 #3
MLH
Will look for HELP on the @-sign itself. I ddn't
see any specific reference to in in the MsgBox
funciton HELP segment.
Sep 19 '06 #4
You spent more time posting useless information than it would have
taken to answer the question.

RoyVidar wrote:
"MLH" <CR**@NorthState.netwrote in message
<eo********************************@4ax.com>:
If MsgBox(sMyCaption & " is already open@" _
& "Do you want to open a second instance of this database?@", _
vbYesNo Or vbQuestion Or vbDefaultButton2) = vbYes Then Exit
Function

What's the purpose behind the @ signs in the above msgbox fn?

If you run that statement in A97 with and without @, you will see what
function it has. In later version it has no function, except if you
use it through the Eval function.

In A97, at least on the version I'm looking at right now, this is
explained quite good in the help file, in one of the examples.

--
Roy-Vidar
Sep 19 '06 #5
ManningFan wrote:
You spent more time posting useless information than it would have
taken to answer the question.
And you've wasted time as well - better get back to those 20 apps a month...
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Sep 19 '06 #6
"ManningFan" <ma********@gmail.comwrote in message
<11**********************@m73g2000cwd.googlegroups .com>:
You spent more time posting useless information than it would have
taken to answer the question.

RoyVidar wrote:
>"MLH" <CR**@NorthState.netwrote in message
<eo********************************@4ax.com>:
>> If MsgBox(sMyCaption & " is already open@" _
& "Do you want to open a second instance of this database?@",
_ vbYesNo Or vbQuestion Or vbDefaultButton2) = vbYes Then
Exit Function

What's the purpose behind the @ signs in the above msgbox fn?

If you run that statement in A97 with and without @, you will see
what function it has. In later version it has no function, except if
you use it through the Eval function.

In A97, at least on the version I'm looking at right now, this is
explained quite good in the help file, in one of the examples.

--
Roy-Vidar
manningfan,
Usually when you provide incorrect advice, which one might say is
documented to occur on regular basis, you are given information about
why or how your advice is incorrect. Usually, also information about
correct/better solutions are offered for the benefit of the OP (and
you). Please extend that courtesy when you critisize.

Without any such, I'm inclined to believe that you again demonstrate
that you do not know what you are talking about.

--
Roy-Vidar
Sep 20 '06 #7
My... have we still got our resident? Greetings Don.

ManningFan schreef:
--
Bas Cost Budde
Holland
Sep 20 '06 #8
"Bas Cost Budde" <b.*********@dev.null.comwrote
My... have we still got our resident? Greetings Don.
I think you have made a mistake... his name is Jagoff the Manning Fan.
<GRIN>

We know that from his signature in an earlier thread. Of course, he claims
it wasn't his signature, but we know he just slipped up and revealed his
secret name.
Sep 20 '06 #9
Lawrence, Lawrence, Lawrence... That reasoning is about as intelligent
as... as.. as one of your code suggestions.
And Tim... Doin't be jealous.

Larry Linson wrote:
"Bas Cost Budde" <b.*********@dev.null.comwrote
My... have we still got our resident? Greetings Don.

I think you have made a mistake... his name is Jagoff the Manning Fan.
<GRIN>

We know that from his signature in an earlier thread. Of course, he claims
it wasn't his signature, but we know he just slipped up and revealed his
secret name.
Sep 20 '06 #10
Well, if it isn't Jagoff the Manning Fan, presuming upon our good nature to
call us by name when he should be saying "Sir" (if not "Sire"). Looks like
he's back spreading misinformation once again, and trying fruitlessly to
promote his standing in the newsgroup, after equally fruitlessly trying to
spread dissension and discontent.

Larry Linson

"ManningFan" <ma********@gmail.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...
Lawrence, Lawrence, Lawrence... That reasoning is about as intelligent
as... as.. as one of your code suggestions.
And Tim... Doin't be jealous.

Larry Linson wrote:
>"Bas Cost Budde" <b.*********@dev.null.comwrote
> My... have we still got our resident? Greetings Don.

I think you have made a mistake... his name is Jagoff the Manning Fan.
<GRIN>

We know that from his signature in an earlier thread. Of course, he
claims
it wasn't his signature, but we know he just slipped up and revealed his
secret name.

Sep 21 '06 #11
I was gonna call you "assclown" but I thought it too positive a word
for you, so Lawrence seemed to fit the bill...

Larry Linson wrote:
Well, if it isn't Jagoff the Manning Fan, presuming upon our good nature to
call us by name when he should be saying "Sir" (if not "Sire"). Looks like
he's back spreading misinformation once again, and trying fruitlessly to
promote his standing in the newsgroup, after equally fruitlessly trying to
spread dissension and discontent.

Larry Linson

"ManningFan" <ma********@gmail.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...
Lawrence, Lawrence, Lawrence... That reasoning is about as intelligent
as... as.. as one of your code suggestions.
And Tim... Doin't be jealous.

Larry Linson wrote:
"Bas Cost Budde" <b.*********@dev.null.comwrote

My... have we still got our resident? Greetings Don.

I think you have made a mistake... his name is Jagoff the Manning Fan.
<GRIN>

We know that from his signature in an earlier thread. Of course, he
claims
it wasn't his signature, but we know he just slipped up and revealed his
secret name.
Sep 21 '06 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Bob Dydd | last post by:
Hi Everybody Is there any way to write a piece of code something like this: If Me.txtFrom = Like ""*""" then do this End if If Me.txtFrom <> Like ""*""" then
7
by: Anne Richmond | last post by:
I have just returned to my first vb.net project after a few weeks and find I have a problem with Msgbox. The commands I added earlier work OK but any new ones fail to show the prompt value...
10
by: z | last post by:
I just installed Visual Studio .Net with Framework 1.1. I already had VB6 SP6 installed. I wanted to do a quick "hello world" example in VB.Net. The code is here: Private Sub...
4
by: Mrozu | last post by:
Hi I need function which can show me value of string only TO seted sign. For example i have string x="Hello, people" and i need function which show me string to ",", in this situation...
6
by: fripper | last post by:
Is it possible to display a message box (using the MSGBOX function) without the beep? Thanks.
4
by: James | last post by:
What does this mean? 'To specify more than the first argument, you must use the MsgBox function in an expression' I'd love to see an example. Thanks!
2
by: Screaming Eagles 101 | last post by:
Hi, I looked and found a lot of different code regarding send/receiving input/output to a command window, but none helped me so far. I would like to start a process with telnet a bit like this...
5
by: win | last post by:
I'm using ASP.Net 2.0 MsgBox("Are you sure to delete?", MsgBoxStyle.Question + MsgBoxStyle.OkCancel, Page.Title.ToString) The message box sometimes does not pop up on the top of the screen....
1
by: JohnCramp | last post by:
Can any one help me whit this msgbox "Prompt",vbCritical,"MSGBOX",, - syntax error any help ???
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.