@Prompt(,,,,)

What is the correct answer to this function in MS Access: @Prompt(,,,,)

What is the function supposed to do?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"@Prompt" wrote in message
...
What is the correct answer to this function in MS Access: @Prompt(,,,,)

On Wed, 21 Dec 2005 06:16:06 -0800, "@Prompt"
wrote:

What is the correct answer to this function in MS Access: @Prompt(,,,,)

Since this is not an Access function, the answer is Nothing.

John W. Vinson[MVP]

Are you talking about what's in the MsgBox() function?

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"@Prompt" wrote in message
...
What is the correct answer to this function in MS Access: @Prompt(,,,,)

Sorry for the very short question. Here is the situation:

I am using BusinessObjects (version 6), which requires the mid-layer namely
Universe. The Universe is a middle layer between database and BusinessObjects
(BO). I am thus designing a Universe for that purpose. However, for some
reasons I cannot deploy it in Oracle, MS SQL, Sybase, Informix, etc. I can
only use MS Access as database layer to deploy Universe.

In the Universe Designer there is a function: @Prompt. It forces a user to
enter a
value for a restriction when that object is used in a query. When the user
runs the
query, a prompt box appears asking for a value to be entered. The syntax of
the function is as follows:

@Prompt(‘message’,‘type’,[lov],[MONO|MULTI],[FREE|CONSTRAINED])

Whe

- ’message’: Text of the prompt message. The text must be enclosed between
single quotes, for example, ‘Choose a Region’, ‘Pick a time
period’, or ’Choose a showroom’. The text appears in the prompt
box when the query is run.

- ’type’: Data type returned by the function. It can be one of the following:
• ’A’ for alphanumeric
• ‘N’ for number
• D’ for date
The specified data type must be enclosed in single quotes.

- lov: List of values (optional). You can specify two types of list of
values:
• Hard coded list. Each value is separately enclosed in single
quotes and separated by a comma. The whole list is enclosed
in curly brackets. For example, {'Australia', 'France', 'Japan',
'United Kingdom', 'USA'}.
• Pointer to a List of Values from an existing object. You invoke
the target lov by double clicking on the object containing the
lov that you want to use in the Classes and Objects panel.
This gives the Class name and the Object name, separated
by a backslash. It must be enclosed in single quotes. For
example: 'Client\Country

- MONO: User can only select only one value from the list of values
(optional).

- MULTI: User can select multiple values from the list of values (optional).

- FREE: User can enter a value of their choice, or select one from the list
of values.

-CONSTRAINED: User must select a value from the list of values.
Syntax Description

Example:
@prompt('What is the Current Year?', 'N', {'2003', '2004','2005'}, MONO,
CONSTRAINED)

My consultant confirmed it works well in Oracle (and maybe in MS SQL), but
not in MS Access.

My question is that how to translate this syntax into MS Access's

Many thanks in advance
Best regards

Uh, answered in the second thread that you created for this?

TC