Prev: Forms & Reports Labels on placing the field
Next: Forms - Option for user to leave some text boxes as blank.
From: natfish on 28 Apr 2010 10:48
Ok that worked, but how do I get it into a table or form so that I can track
it?

"Daryl S" wrote:

> Natfish -
>
> Will a message box do what you want? Look up msgbox if you only need to ask
> yes/no questions. You can set the title, the message, and which buttons
> (within those available) are on the dialog box. You can then take the
> response to populate your data. This is a sample, but use whatever parts you
> need.
>
> If MsgBox("Was the radiation completed?", vbYesNo, "Radiation Status") =
> vbYes Then
> 'do what you want to update database to say radiation was completed
> End If
>
>
> --
> Daryl S
>
>
> "natfish" wrote:
>
> > I would like to create pop-ups that respond to options that are chosen. For
> > example, I have a form with a drop down for yes/no. If the answer is yes I
> > want to be able give the user as option to chose whether radiation was
> > completed or not. I know how to connect the main form to a subform and have
> > the subform pop up, but I don't want the whole subform to pop-up -- only one
> > option.
> >
> > Thanks
> >
From: Daryl S on 28 Apr 2010 12:37
Natfish -

You must put this into a table (a form doesn't store data).

It sounds like you don't have a table with the fields you need yet. You
must decide if the new information you are gathering should belong in the
table behind your current form or not. Since you didn't explain your
business, I can't help with that decision. If you decide this new
information belongs with the current information, then you can add fields to
your existing table. In that case, you can add the new field to the form.
If you don't want the user to see this new field (as it won't apply in many
cases), then you can keep it invisible. You would then just set the the
value equal to the results of the msgbox, like this (if RadiationCompleted is
the name of the new control for the new field in the table):

Me.RadiationCompleted = MsgBox("Was the radiation completed?", vbYesNo,
"Radiation Status")

If this won't work, then please explain your business model and where you
think the data should be stored.

--
Daryl S


"natfish" wrote:

> Ok that worked, but how do I get it into a table or form so that I can track
> it?
>
> "Daryl S" wrote:
>
> > Natfish -
> >
> > Will a message box do what you want? Look up msgbox if you only need to ask
> > yes/no questions. You can set the title, the message, and which buttons
> > (within those available) are on the dialog box. You can then take the
> > response to populate your data. This is a sample, but use whatever parts you
> > need.
> >
> > If MsgBox("Was the radiation completed?", vbYesNo, "Radiation Status") =
> > vbYes Then
> > 'do what you want to update database to say radiation was completed
> > End If
> >
> >
> > --
> > Daryl S
> >
> >
> > "natfish" wrote:
> >
> > > I would like to create pop-ups that respond to options that are chosen. For
> > > example, I have a form with a drop down for yes/no. If the answer is yes I
> > > want to be able give the user as option to chose whether radiation was
> > > completed or not. I know how to connect the main form to a subform and have
> > > the subform pop up, but I don't want the whole subform to pop-up -- only one
> > > option.
> > >
> > > Thanks
> > >
From: natfish on 28 Apr 2010 12:58
I have created a database for a medical oncologist. I already have a subform
and table with the information in it -- it is called "case summary". I just
wanted to try to make the form user friendly without adding a new field to
the form.

"Daryl S" wrote:

> Natfish -
>
> You must put this into a table (a form doesn't store data).
>
> It sounds like you don't have a table with the fields you need yet. You
> must decide if the new information you are gathering should belong in the
> table behind your current form or not. Since you didn't explain your
> business, I can't help with that decision. If you decide this new
> information belongs with the current information, then you can add fields to
> your existing table. In that case, you can add the new field to the form.
> If you don't want the user to see this new field (as it won't apply in many
> cases), then you can keep it invisible. You would then just set the the
> value equal to the results of the msgbox, like this (if RadiationCompleted is
> the name of the new control for the new field in the table):
>
> Me.RadiationCompleted = MsgBox("Was the radiation completed?", vbYesNo,
> "Radiation Status")
>
> If this won't work, then please explain your business model and where you
> think the data should be stored.
>
> --
> Daryl S
>
>
> "natfish" wrote:
>
> > Ok that worked, but how do I get it into a table or form so that I can track
> > it?
> >
> > "Daryl S" wrote:
> >
> > > Natfish -
> > >
> > > Will a message box do what you want? Look up msgbox if you only need to ask
> > > yes/no questions. You can set the title, the message, and which buttons
> > > (within those available) are on the dialog box. You can then take the
> > > response to populate your data. This is a sample, but use whatever parts you
> > > need.
> > >
> > > If MsgBox("Was the radiation completed?", vbYesNo, "Radiation Status") =
> > > vbYes Then
> > > 'do what you want to update database to say radiation was completed
> > > End If
> > >
> > >
> > > --
> > > Daryl S
> > >
> > >
> > > "natfish" wrote:
> > >
> > > > I would like to create pop-ups that respond to options that are chosen. For
> > > > example, I have a form with a drop down for yes/no. If the answer is yes I
> > > > want to be able give the user as option to chose whether radiation was
> > > > completed or not. I know how to connect the main form to a subform and have
> > > > the subform pop up, but I don't want the whole subform to pop-up -- only one
> > > > option.
> > > >
> > > > Thanks
> > > >
From: John W. Vinson on 28 Apr 2010 13:51
On Wed, 28 Apr 2010 09:58:08 -0700, natfish
<natfish(a)discussions.microsoft.com> wrote:

>I have created a database for a medical oncologist. I already have a subform
>and table with the information in it -- it is called "case summary". I just
>wanted to try to make the form user friendly without adding a new field to
>the form.

I do hope you're aware of, and in compliance, with the (rather stringent and
demanding) HIPAA patient medical information laws. Many have argued that
Access databases are inherently not secure enough to comply with those laws.

--

John W. Vinson [MVP]
From: Daryl S on 28 Apr 2010 15:08
That means my last posting should work for you, right? Add the field (make
it invisible), and then update it with the results of the msgbox.

--
Daryl S


"natfish" wrote:

> I have created a database for a medical oncologist. I already have a subform
> and table with the information in it -- it is called "case summary". I just
> wanted to try to make the form user friendly without adding a new field to
> the form.
>
> "Daryl S" wrote:
>
> > Natfish -
> >
> > You must put this into a table (a form doesn't store data).
> >
> > It sounds like you don't have a table with the fields you need yet. You
> > must decide if the new information you are gathering should belong in the
> > table behind your current form or not. Since you didn't explain your
> > business, I can't help with that decision. If you decide this new
> > information belongs with the current information, then you can add fields to
> > your existing table. In that case, you can add the new field to the form.
> > If you don't want the user to see this new field (as it won't apply in many
> > cases), then you can keep it invisible. You would then just set the the
> > value equal to the results of the msgbox, like this (if RadiationCompleted is
> > the name of the new control for the new field in the table):
> >
> > Me.RadiationCompleted = MsgBox("Was the radiation completed?", vbYesNo,
> > "Radiation Status")
> >
> > If this won't work, then please explain your business model and where you
> > think the data should be stored.
> >
> > --
> > Daryl S
> >
> >
> > "natfish" wrote:
> >
> > > Ok that worked, but how do I get it into a table or form so that I can track
> > > it?
> > >
> > > "Daryl S" wrote:
> > >
> > > > Natfish -
> > > >
> > > > Will a message box do what you want? Look up msgbox if you only need to ask
> > > > yes/no questions. You can set the title, the message, and which buttons
> > > > (within those available) are on the dialog box. You can then take the
> > > > response to populate your data. This is a sample, but use whatever parts you
> > > > need.
> > > >
> > > > If MsgBox("Was the radiation completed?", vbYesNo, "Radiation Status") =
> > > > vbYes Then
> > > > 'do what you want to update database to say radiation was completed
> > > > End If
> > > >
> > > >
> > > > --
> > > > Daryl S
> > > >
> > > >
> > > > "natfish" wrote:
> > > >
> > > > > I would like to create pop-ups that respond to options that are chosen. For
> > > > > example, I have a form with a drop down for yes/no. If the answer is yes I
> > > > > want to be able give the user as option to chose whether radiation was
> > > > > completed or not. I know how to connect the main form to a subform and have
> > > > > the subform pop up, but I don't want the whole subform to pop-up -- only one
> > > > > option.
> > > > >
> > > > > Thanks
> > > > >
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Forms & Reports Labels on placing the field
Next: Forms - Option for user to leave some text boxes as blank.