Prev: 6 cases from a textbox control that needs to be validated.
Next: Printing selected Record
From: Marsh on 20 Jun 2008 13:17
A database we use in Access 2003 has a form named frmJobInfo. It is a large
form, with many fields, date and time picker contros, unbound controls with
formulas built-in, etc. This form contains fields necessary for our customer
service reps to be able enter a width and depth to calculate cost factors, in
the form. These functions work perfectly. Several of the fields are
TrackingNum, ReqName, DateSubmit, DateDue, and others that completely define
and describe the job, including the width and depth.
I would like to create a form in Datasheet view that displays all active
jobs, with fields TrackingNum, ReqName, DateSubmit, DateDue so that a user
can pick out a job that needs attention. That I can do. What I would then
like to do is have some sort of clickable control so that when clicked, it
will open the form, frmJobInf, with the desired job data displayed in the
form. In a perfect world, making the TrackingNum field in the datasheet form
a clickable “action or command button” would be a perfect solution. In that
way, the correct job is displayed in frmJobInfo without the necessity of
typing the tracking number.
Thank you for any aid.
From: Dirk Goldgar on 20 Jun 2008 14:06
"Marsh" <Marsh(a)discussions.microsoft.com> wrote in message
news:F3720E88-139E-43DD-8BCF-16B682D4E489(a)microsoft.com...
>A database we use in Access 2003 has a form named frmJobInfo. It is a
>large
> form, with many fields, date and time picker contros, unbound controls
> with
> formulas built-in, etc. This form contains fields necessary for our
> customer
> service reps to be able enter a width and depth to calculate cost factors,
> in
> the form. These functions work perfectly. Several of the fields are
> TrackingNum, ReqName, DateSubmit, DateDue, and others that completely
> define
> and describe the job, including the width and depth.
> I would like to create a form in Datasheet view that displays all active
> jobs, with fields TrackingNum, ReqName, DateSubmit, DateDue so that a user
> can pick out a job that needs attention. That I can do. What I would
> then
> like to do is have some sort of clickable control so that when clicked, it
> will open the form, frmJobInf, with the desired job data displayed in the
> form. In a perfect world, making the TrackingNum field in the datasheet
> form
> a clickable “action or command button” would be a perfect solution. In
> that
> way, the correct job is displayed in frmJobInfo without the necessity of
> typing the tracking number.
> Thank you for any aid.


Normally I'd use the DblClick event for this sort of thing, but if your
datasheet form is used only to choose the job, never to edit it, you might
use the Click event as you were thinking. So your code for the Click event
of the TrackingNum text box might look like this:

'----- start of example code -----
Private Sub TrackingNum_Click()

If Not IsNull(Me.TrackingNum) Then
DoCmd.OpenForm "frmJobInf", _
WhereCondition:="TrackingNum=" & Me.TrackingNum
End If

End Sub
'----- end of example code -----

That assumes that TrackingNum is a numeric field. If it's text, but won't
ever contain the single-quote (or apostrophe) character, then you'd modify
the WhereCondition argument accordingly:

WhereCondition:="TrackingNum='" & Me.TrackingNum & "'"

If it might contain the single-quote character, there are other forms for
the argument. Let me know.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

From: Marsh on 20 Jun 2008 15:35
Thank you Dirk.
The datasheet will be only to choose the record, single click will suffice.
I will let you know how I make out.

"Dirk Goldgar" wrote:

> "Marsh" <Marsh(a)discussions.microsoft.com> wrote in message
> news:F3720E88-139E-43DD-8BCF-16B682D4E489(a)microsoft.com...
> >A database we use in Access 2003 has a form named frmJobInfo. It is a
> >large
> > form, with many fields, date and time picker contros, unbound controls
> > with
> > formulas built-in, etc. This form contains fields necessary for our
> > customer
> > service reps to be able enter a width and depth to calculate cost factors,
> > in
> > the form. These functions work perfectly. Several of the fields are
> > TrackingNum, ReqName, DateSubmit, DateDue, and others that completely
> > define
> > and describe the job, including the width and depth.
> > I would like to create a form in Datasheet view that displays all active
> > jobs, with fields TrackingNum, ReqName, DateSubmit, DateDue so that a user
> > can pick out a job that needs attention. That I can do. What I would
> > then
> > like to do is have some sort of clickable control so that when clicked, it
> > will open the form, frmJobInf, with the desired job data displayed in the
> > form. In a perfect world, making the TrackingNum field in the datasheet
> > form
> > a clickable “action or command button” would be a perfect solution. In
> > that
> > way, the correct job is displayed in frmJobInfo without the necessity of
> > typing the tracking number.
> > Thank you for any aid.
>
>
> Normally I'd use the DblClick event for this sort of thing, but if your
> datasheet form is used only to choose the job, never to edit it, you might
> use the Click event as you were thinking. So your code for the Click event
> of the TrackingNum text box might look like this:
>
> '----- start of example code -----
> Private Sub TrackingNum_Click()
>
> If Not IsNull(Me.TrackingNum) Then
> DoCmd.OpenForm "frmJobInf", _
> WhereCondition:="TrackingNum=" & Me.TrackingNum
> End If
>
> End Sub
> '----- end of example code -----
>
> That assumes that TrackingNum is a numeric field. If it's text, but won't
> ever contain the single-quote (or apostrophe) character, then you'd modify
> the WhereCondition argument accordingly:
>
> WhereCondition:="TrackingNum='" & Me.TrackingNum & "'"
>
> If it might contain the single-quote character, there are other forms for
> the argument. Let me know.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
From: Marsh on 3 Jul 2008 13:39
I was out of work, ill, so I just got back to this project.

Worked perfectly, thank you very much.

"Dirk Goldgar" wrote:

> "Marsh" <Marsh(a)discussions.microsoft.com> wrote in message
> news:F3720E88-139E-43DD-8BCF-16B682D4E489(a)microsoft.com...
> >A database we use in Access 2003 has a form named frmJobInfo. It is a
> >large
> > form, with many fields, date and time picker contros, unbound controls
> > with
> > formulas built-in, etc. This form contains fields necessary for our
> > customer
> > service reps to be able enter a width and depth to calculate cost factors,
> > in
> > the form. These functions work perfectly. Several of the fields are
> > TrackingNum, ReqName, DateSubmit, DateDue, and others that completely
> > define
> > and describe the job, including the width and depth.
> > I would like to create a form in Datasheet view that displays all active
> > jobs, with fields TrackingNum, ReqName, DateSubmit, DateDue so that a user
> > can pick out a job that needs attention. That I can do. What I would
> > then
> > like to do is have some sort of clickable control so that when clicked, it
> > will open the form, frmJobInf, with the desired job data displayed in the
> > form. In a perfect world, making the TrackingNum field in the datasheet
> > form
> > a clickable “action or command button” would be a perfect solution. In
> > that
> > way, the correct job is displayed in frmJobInfo without the necessity of
> > typing the tracking number.
> > Thank you for any aid.
>
>
> Normally I'd use the DblClick event for this sort of thing, but if your
> datasheet form is used only to choose the job, never to edit it, you might
> use the Click event as you were thinking. So your code for the Click event
> of the TrackingNum text box might look like this:
>
> '----- start of example code -----
> Private Sub TrackingNum_Click()
>
> If Not IsNull(Me.TrackingNum) Then
> DoCmd.OpenForm "frmJobInf", _
> WhereCondition:="TrackingNum=" & Me.TrackingNum
> End If
>
> End Sub
> '----- end of example code -----
>
> That assumes that TrackingNum is a numeric field. If it's text, but won't
> ever contain the single-quote (or apostrophe) character, then you'd modify
> the WhereCondition argument accordingly:
>
> WhereCondition:="TrackingNum='" & Me.TrackingNum & "'"
>
> If it might contain the single-quote character, there are other forms for
> the argument. Let me know.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
 | 
Pages: 1
Prev: 6 cases from a textbox control that needs to be validated.
Next: Printing selected Record