Re: GUI for access 2002

Dialog form would fit what we are currently doing. However, I have no idea
how to open a dialog form.

This is what the vba code looks like:

docmd.openform formname,,,stlinkcritera ' have no idea what
stlinkcritera does
while isformopen(formname) then
strtmp=[form]![formname]![text0] & ""
....
doevents
wend

I entered data in the form & then xed it off.
caught some of the assignments between the while & doevents

Spent a lot of time with help trying to find dialog form info. Nothing :-(
Help. TIA

"John Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0qifk258v7mk30hpaq5kg24r96bo1crmtn@xxxxxxxxxx
On Tue, 31 Oct 2006 16:40:15 GMT, "TED MEDIN" <mmaphq@xxxxxxxxxxx>
wrote:

I'd have a command button (or some other appropriate event) on the
Form itself to launch the report, or the code, or whatever action you
want. That is, rather than the code calling the form, you have the
form calling the code.

It that isn't suitable for your needs, you can open a Dialog form from
your code, and have a command button on the form to set its Visible
property to false. This will resume the code, at which time you can
retrieve the value from the form and then close the form.

What do you use for a trigger to know when to read the form from vba? TIA

"John Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:kfevj2donh43u17mhqse7hd8gdlvhvtg4m@xxxxxxxxxx
On Wed, 25 Oct 2006 17:58:20 GMT, "TED MEDIN" <mmaphq@xxxxxxxxxxx>
wrote:

We have a lot of buttons with visual basic programs behind them.
Inputbox
is
used for decisions the user must make. Is there some way we can make a
gui
for decisions the user must make? We are using assistant.newballoon for
some
decisions but that is very limited. Anyone got any ideas? TIA

One very common way is to use an unbound Access Form with textboxes,
combo boxes, etc. into which the user can enter values. Your code can
then refer to [Forms]![MyFormName]![ControlName] to retrieve the
user's input. I've found this to be much simpler (both for me and for
the user) than using the InputBox function.

John W. Vinson[MVP]



John W. Vinson[MVP]


.