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
>
Tidak ada komentar:
Posting Komentar