I'm losing it! Help needed.

R

raskew

AWF VIP
Local time
Today, 13:03
Joined
Jun 2, 2001
Messages
2,734
Hi -

Within the past couple of days (today is 22 Aug 08) there was a post wherein the OP had Fiscal Year (FY) records from 1975 thru current date.
The FY requirements changed mid-stream (started off with 10/1/75 thru 9/30/76).

It was an interesting problem and I developed a solution. Problem being, I can't find the thread. I've done every type of search I can think of with 0 results. Checked the other forum I regularly particpate in, just in case Alzheimer's was really kicking in. Again, 0 results.

If you partipated in that thread, would you please point me in the right direction.

Thanks - Bob
 
Also, just in case you didn't know:

You can search all posts made by any members by clicking on the member's name, going to their profile page, and clicking tab "Statistics" then "Search all posts made by the member".

Here's your posts... As it's recent, it may be easier to find it?
http://www.access-programmers.co.uk/forums/search.php?searchid=2425159&pp=25
 
Bob / Banana:

Appreciate your responses, but neither are it!

In the posting, the OP went on to explain how the desired dates changed 10/1/1999, going first to a six-month fiscal year then moving to a different set of dates after the six-month switch.

I'm quite aware of the capability to search by member name and, if I have the OP's name recorded, I'd have done it.

Anyway, as the title indicates, have to think I'm losing it (or somehow the thread was removed).

Best Wishes - Bob
 
raskew said:
I'm quite aware of the capability to search by member name and, if I have the OP's name recorded, I'd have done it.
Click to expand...

To clarify, I was thinking of searching your own posts as if it was recent, it'd be easy to scroll through the last couple posts. I had tried to look through your posts, but couldn't find anything that touched on fiscal year, though.

Sorry I couldn't be of any further help.
 
Any chance you're thinking of the wrong forum? Do you moonlight over at UA perhaps?
 
Banana / Craig:

Thanks for your responses.

Craig: I entertained the thought that I was looking at the wrong forum (I only participate in one other) and checked that out with the same determination as I've done here. No responses!

Banana: As of yesterday, I had not submitted any response to the thread in question. As a result, searching on my name doesn't return any useful info (believe me, I've tried it -- numerous time!).

The frustrating part is the thread I'm looking for is not a figment of my imagination. I addressed it numerous times, copy/pasting the date requirements to my computer, so that I could further address them.

Oh well, guess I'm going to have to chalk it off to old age.

Thanks again - Bob
 
raskew said:
Hi -

Within the past couple of days (today is 22 Aug 08) there was a post wherein the OP had Fiscal Year (FY) records from 1975 thru current date.
The FY requirements changed mid-stream (started off with 10/1/75 thru 9/30/76).

It was an interesting problem and I developed a solution. Problem being, I can't find the thread. I've done every type of search I can think of with 0 results. Checked the other forum I regularly particpate in, just in case Alzheimer's was really kicking in. Again, 0 results.

If you partipated in that thread, would you please point me in the right direction.

Thanks - Bob
Click to expand...

Maybe this one :

http://www.access-programmers.co.uk/forums/showthread.php?t=153523&highlight=fiscal+year
 
Ron -

Nope, unfortunately that's not it. What I'm after was very recent, less than a week old.

Thanks for your response - Bob
 
Hi Ron -

Thanks for that! Unfortunately, that's not it.

Thanks again - Bob
 
Bob,

I looked all over here and other places. No luck.

I noticed that you sad the requirements changed "mid-thread". That means
there were responder(s)?

Then the OP probably didn't delete the thread.

Wayne
 
WayneRyan said:
Bob,

I looked all over here and other places. No luck.

I noticed that you sad the requirements changed "mid-thread". That means
there were responder(s)?

Then the OP probably didn't delete the thread.

Wayne
Click to expand...

Wayne:

It doesn't matter if there are responses to a thread. If there are responses and the OP deletes the very first post in the thread, it will delete the entire thread.
 
Bob,

I wasn't aware of that. I thought that when someone responded, the thread
was "public" and the OP couldn't delete it.

And I was just trying to gather some more info. I'd like to help Bob find that
thread. It's an interesting puzzle trying to find something that has just
vanished. Just need some key words.

Does VBulletin track deletions? What if the FBI wanted to find the thread?

Just kidding,
Wayne
 
Let's stop sugar coating things and come clean. Bob has lost it.
 
If it got off-topic could it have been moved under a different title?

-dK
 
Let's stop sugar coating things and come clean. Bob has lost it.
Click to expand...

I agree, I give up! Obviously the mysterious OP doesn't need my solution.

Thanks to all for your help. -- Bob
 
OK -

For what it's worth. The OP was attempting to categorize records by Fiscal Year.

Starting 10/1/1975 thru 9/30/1999, the FY period ran 10/1 thru 9/30. A PolicyYear field was included, which was always the year of FY start date.

Then, in order to facilitate a switch to new FY periods, a shortened 6-month FY was created (don't ask me, I didn't come up with it). So, the shortened FY ran 10/1/1999 thru 3/31/2000.

Then, starting 4/1/2000 thru the current FY, the periods ran 4/1 - 3/31.

The OP needed to create/populate a table with the above info. So, my solution: a single sub which created table FYCalendar, in the process deleting previous versions, then populated it as requested.

If you want to give it a try, you can just copy/paste to a module and run it from the debug (immediate) window with: Call TableMake2x()

Code: 
Public Sub TableMake2x()
'*******************************************
'Purpose:   Creates/populate table FYCalendar
'           with fiscal year data for the years
'           1976 - 2008
'Coded by:  raskew
'Written in: A97
'Tested in: A2003
'Inputs:    Call TableMake2x()
'Output:    Table FYCalendar
'*******************************************

Dim db      As Database
Dim td      As TableDef
Dim fld     As Field
Dim n       As Integer
Dim x       As Date
Dim strSQL  As String
Dim strSQL2 As String
Dim tName   As String

    Set db = CurrentDb
    On Error Resume Next

    tName = "FYCalendar"
    'remove table -- if it exists in the database
    db.Execute "DROP TABLE " & tName & ";"
    
    'create new table
    strSQL = "CREATE TABLE " & tName & " (FYID Counter, FYStart DateTime, FYEnd DateTime, PolicyYear Text(4));"
    db.Execute strSQL
       Set td = db.TableDefs(tName)
       db.TableDefs.Append td
       db.TableDefs.Refresh

    'Populate table
    For n = 1 To 3
 
       x = Choose(n, #10/1/1975#, #10/1/1999#, #4/1/2000#)

       Do Until x = Choose(n, #10/1/1999#, #4/1/2000#, #4/1/2009#)

          strSQL = " INSERT INTO " & tName _
                 & "(FYStart,FYEnd, PolicyYear) VALUES " _
                 & "(#" & x & "#, #"
          strSQL2 = "#, '" & year(x) & "');"

          strSQL = strSQL & Switch(n = 1 Or n = 3, DateAdd("yyyy", 1, x) - 1, True, DateAdd("m", 6, x) - 1) _
                  & strSQL2
          db.Execute strSQL

          x = Switch(n = 1 Or n = 3, DateAdd("yyyy", 1, x), True, DateAdd("m", 6, x))

        Loop

    Next n
    db.Close
    Set db = Nothing

End Sub

Thanks everyone for bearing with me on the fruitless search. Promise I won't try that again.

Best Wishes - Bob
 
Last edited:
You must log in or register to reply here.

Similar threads

Uncle Gizmo
Custom chat interface DEMO using two LLM's - Ollama Mistral and open AI GPT4
Replies
1
Views
739
Uncle Gizmo
Uncle Gizmo
mike60smart
Calculated Total Days Vacation taken
Replies
7
Views
1,636
theDBguy
theDBguy
AC5FF
Grouping Data by Month/Year Formatting issue
Replies
8
Views
1,428
MarkK
MarkK
C
ASP/Javascript and ACCESS DB
Replies
0
Views
1,825
craigprice
C
Solo712
Are Global Variables Really that bad ?
2 3 4
Replies
65
Views
14,652
gemma-the-husky
gemma-the-husky

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom