Edgar-
The name of the procedure tells you it's the DoubleClick event for the Interval
text box. Open your form in Design view, select the control displaying the
Interval, open the Properties window, select the On Double Click property, and
then click the Build (...) button next to the property. That should take you to
skeleton code where you can add my code.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
rivera_vazquez_edgar
Sent: Sunday, June 26, 2011 2:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] How do I make the query I need?
Ok, cool, but where exacly should I place this code?
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Edgar-
>
> Private Sub Interval_DoubleClick(Cancel As Integer)
> If Me.Interval = 12 Then
> Me.Interval = 6
> Else
> Me.Interval = 12
> End If
> End If
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> rivera_vazquez_edgar
> Sent: Sunday, June 26, 2011 2:11 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] How do I make the query I need?
>
> Excelent John, it worked great.
>
> Now, I'm gonna set the defautl value of the Interval field to 12, but I want
to
> set the 6 month option to change when I double click the 12 in the field
instead
> of typing the number 6. What should be the event procedure for it to work this
> way?
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Edgar-
> >
> > If the user is entering the interval, 183 isn't intuitive. If the interval
is
> > always a number of months, have them enter months instead (in this case, 6
> > instead of 183), then use:
> >
> > DateAdd("m", [Interval], [ServDate])
> >
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> > xtintores@
> > Sent: Sunday, June 26, 2011 5:14 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] How do I make the query I need?
> >
> > Hey Walter, I got an idea out of your sugestion... You see, a year actually
> has
> > 365.25 days, that's why every 4 years feb has an extra day, so 365.25
divided
> by
> > 2 is 182.625, meaning I can round it of to 183 and it should work as you
said.
> >
> >
> >
> > Thanks for the light on the matter
> >
> > Edgar
> >
> > Sent from my BlackBerryR smartphone
> >
> >
> >
> > -----Original Message-----
> >
> > From: "nkpberk" <wgriffin48@>
> >
> > Sender: MS_Access_Professionals@yahoogroups.com
> >
> > Date: Sat, 25 Jun 2011 23:04:58
> >
> > To: <MS_Access_Professionals@yahoogroups.com>
> >
> > Reply-To: MS_Access_Professionals@yahoogroups.com
> >
> > Subject: Re: [MS_AccessPros] How do I make the query I need?
> >
> >
> >
> > Edgar;
> >
> > 6 months is (on a non leap year) is 182.5 days based on the average month
> being
> > 30.466666 days long. Use 182 or 183 days for your interval,run some tests to
> see
> > which is most accurate and test a few leap year dates as well, This should
be
> a
> > bunch more accurate.
> >
> > Walter Griffin
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "rivera_vazquez_edgar"
> > <xtintores@> wrote:
> >
> > >
> >
> > > John,
> >
> > > I tried it and here is what i get...
> >
> > > I put the service date as febuary 1st, and the nest service date should be
> six
> > months latter (august), I used the 180 as interval but it tells me that the
> next
> > service date is in july (31st)to be excact. I figured that its adding 180
> days
> > to febuary first, but the thing is that since febuary has 28 days, it takes
me
> > to the end of july and not august, wich is realy the date needed (six months
> > latter).
> >
> > >
> >
> > > Any advice?
> >
> > >
> >
> > > Edgar
> >
> > >
> >
> > >
> >
> > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
> wrote:
> >
> > > >
> >
> > > > Edgar-
> >
> > > >
> >
> > > > If the underlying field is Date/Time, adding a number of days *will*
give
> > you
> >
> > > > the correct month in the future. The month display using Format has no
> > bearing
> >
> > > > on what's actually stored.
> >
> > > >
> >
> > > > John Viescas, author
> >
> > > > Microsoft Office Access 2010 Inside Out
> >
> > > > Microsoft Office Access 2007 Inside Out
> >
> > > > Building Microsoft Access Applications
> >
> > > > Microsoft Office Access 2003 Inside Out
> >
> > > > SQL Queries for Mere Mortals
> >
> > > > http://www.viescas.com/
> >
> > > > (Paris, France)
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > -----Original Message-----
> >
> > > > From: MS_Access_Professionals@yahoogroups.com
> >
> > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> >
> > > > xtintores@
> >
> > > > Sent: Saturday, June 25, 2011 1:53 PM
> >
> > > > To: MS_Access_Professionals@yahoogroups.com
> >
> > > > Subject: Re: [MS_AccessPros] How do I make the query I need?
> >
> > > >
> >
> > > > Ok John, but the problem I see doing it that way is for example, if the
> > service
> >
> > > > was done in febuary 1st, and the next service is 6 months latter, and
the
> >
> > > > interval says 180 days, than it would realy show up to be july for the
> next
> >
> > > > service date. Keep in mind that both the service date and the next
service
> > date
> >
> > > > are both formated to "mmm" to show only the month of service scince the
> > service
> >
> > > > can be done at any time during that month. This is because the NFPA code
> > says
> >
> > > > service should be done every so many months, sometimes monthly. The
thing
> is
> >
> > > > adding days to a date won't allways give me the right month for text
> > service.
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > Any sugestions?
> >
> > > >
> >
> > > > Sent from my BlackBerryR smartphone
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > -----Original Message-----
> >
> > > >
> >
> > > > From: "John Viescas" <john@>
> >
> > > >
> >
> > > > Sender: MS_Access_Professionals@yahoogroups.com
> >
> > > >
> >
> > > > Date: Sat, 25 Jun 2011 08:11:02
> >
> > > >
> >
> > > > To: <MS_Access_Professionals@yahoogroups.com>
> >
> > > >
> >
> > > > Reply-To: MS_Access_Professionals@yahoogroups.com
> >
> > > >
> >
> > > > Subject: RE: [MS_AccessPros] How do I make the query I need?
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > Edgar-
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > That is correct as long as Interval contains a number of days. You can
> > always
> >
> > > >
> >
> > > > add an integer value to a date/time to get another date/time value - a
> date
> >
> > > >
> >
> > > > either in the future (add a positive interval) or a date in the past (a
> > negative
> >
> > > >
> >
> > > > interval).
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > John Viescas, author
> >
> > > >
> >
> > > > Microsoft Office Access 2010 Inside Out
> >
> > > >
> >
> > > > Microsoft Office Access 2007 Inside Out
> >
> > > >
> >
> > > > Building Microsoft Access Applications
> >
> > > >
> >
> > > > Microsoft Office Access 2003 Inside Out
> >
> > > >
> >
> > > > SQL Queries for Mere Mortals
> >
> > > >
> >
> > > > http://www.viescas.com/
> >
> > > >
> >
> > > > (Paris, France)
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > -----Original Message-----
> >
> > > >
> >
> > > > From: MS_Access_Professionals@yahoogroups.com
> >
> > > >
> >
> > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> >
> > > >
> >
> > > > rivera_vazquez_edgar
> >
> > > >
> >
> > > > Sent: Saturday, June 25, 2011 12:33 AM
> >
> > > >
> >
> > > > To: MS_Access_Professionals@yahoogroups.com
> >
> > > >
> >
> > > > Subject: [MS_AccessPros] How do I make the query I need?
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > Hello to all.
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > I'm working with my main form but need a little help. The form is called
> >
> > > >
> >
> > > > frmCustomerDetail. In this form I have a few tabs: General Info,
Contacts,
> > and
> >
> > > >
> >
> > > > Addresses. In the Address tab I have a sub-form using my
'tblInventory',
> > wich
> >
> > > >
> >
> > > > has the inventory found in that specific address, so far so good.
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > Now I need a sub-form within the 'frmInventory subform' using the
> > 'tblServices'.
> >
> > > >
> >
> > > > The catch is that the 'tblServices' has the following fields:
> IdService(PK),
> >
> > > >
> >
> > > > IdInventory(FK), ServDate (formated as NOW() ), Service (to identify the
> > service
> >
> > > >
> >
> > > > done to that specific item), Interval (to state how often that item
should
> >
> > > >
> >
> > > > recieve service, expressed in days), and now I need to make another
field
> > wich
> >
> > > >
> >
> > > > takes the ServDate value and adds the Interval value to get the
> NxtServDate
> >
> > > >
> >
> > > > (next service date for that item).
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > Here is what I think I should do:
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > Make a query with all the fields in tblService and add a field in that
> query
> > for
> >
> > > >
> >
> > > > the next service date. For example: NxtServDate: [ServDate] + [Interval]
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > Is this correct, or is there a better way to do this?
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > As always, Edgar
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > ------------------------------------
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > Yahoo! Groups Links
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > [Non-text portions of this message have been removed]
> >
> > > >
> >
> > > >
> >
> > > >
> >
> > > > ------------------------------------
> >
> > > >
> >
> > > > Yahoo! Groups Links
> >
> > > >
> >
> > >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar