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 |
#1
|
|||
|
|||
@Prompt(,,,,)
What is the correct answer to this function in MS Access: @Prompt(,,,,)
|
#2
|
|||
|
|||
@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(,,,,) |
#3
|
|||
|
|||
@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] |
#4
|
|||
|
|||
@Prompt(,,,,)
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(,,,,) |
#5
|
|||
|
|||
@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 |
#6
|
|||
|
|||
@Prompt(,,,,)
Uh, answered in the second thread that you created for this?
TC |
Thread Tools | |
Display Modes | |
|
|