Totalling

[raskew]

Hi -

What about the 'minority' of patients that don't fit this mold? What you're suggesting (duplicating the previous month's data) is going to lead to gross errors, guaranteed.

Bob

 

[cymrudesign]

maybee not duplicating the previous months data, but i am at a loss on how to clear the current months dates and insert the next months dates with least amount of input by the user

but of course it would mean still going back through each client and entering their new hours per day at the start of each month ohhhh my head hurts now i know whay im a designer lol

 

[cymrudesign]

ok im going to throw this open as the more i think about it the more difficult this is getting http://gcommercial.co.uk/cymorth2003.zip

if someone could have a go with it the form with the problems is clients1

here the hrs for the month will need to be entered but the report will need to show all dates for the month even if thay have no visit on that day .

the point is to populate the months dates in the date cloumn

anyone pls ?

 

[raskew]

Dan -

The problem i had was that they required to have all of the months dates listed , even if the patient was not visited.

Why, that doesn't make sense. Take a look at your credit card bill. If you don't have any charges in July, you're not going to see a billing set to 0.

...but i am at a loss on how to clear the current months dates and insert the next months dates with least amount of input by the user.

You don't clear a previous month's dates and add the current month's dates. Conversely, you add a new record for the current month (provided there's billing for the current month) and fill it out appropriately. In my experience (and we do it every month) provided you have legible input to work from, you're talking seconds per record. You're creating a historical record of patient billing. In your subform, you need to add a new record or records only if the patient had billing during that month. No billing, no record. If there is billing, then a new record with the default of Day1 thru Day31 set to 0. Then you only need to add the mm/yyyy, caregiver and billing code, then skim across the form adding units only where there were units, the rest of the days are already set to 0.

Once we've got that concept down, then it's a simple matter to add your billed days (the ones > 0) to a normalized table.

Bob

 

[raskew]

Pat-

Rich says:

I'm sure Pat Hartman posted an example here of entering data in a spreadsheet like manner, have a look in the samples forum, it might give you some ideas

Can you give us a hand here?

Best wishes, Bob

p.s.: Rich, with your 13,000+, mostly unhelpful solutions, why don't you point to it?

 

[raskew]

Rich -

Are you there, big guy? You obviously weren't in favor of my solution. So, show us yours, in a little more detail than ' I'm sure Pat Hartman posted an example ...."

Were I a critical person (perish the thought), I'd might be prone to say that's a really wimpy, no-brainer response designed to push-up one's post count without providing any real information.

What do you think, big guy?

Best Wishes - Bob

 

[Rich]

Don't take your frustration out on me Robert, either I'm mad and the example never existed or it got lost when the forum got hacked, but I still swear it was there

 

[raskew]

Rich,

Hmmm?! Nice try. Perhaps if you couldn't find the mysterious post, you could explain it yourself. What do you think, big guy?!

Bob

 

[Jibbadiah]

This might be what Rich is refering to.
I had it in an old directory.
I think there are some credits within the code and forms.
Suspect it is the db originally posted by Pat.

James.

 

[Rich]

Rich,

Hmmm?! Nice try. Perhaps if you couldn't find the mysterious post, you could explain it yourself. What do you think, big guy?!

Bob

Why shoot the messenger Robert? I never said I disagreed with your solution, nor did I say there was a better way, I don't nor ever have entered data in a spreadsheet manner in Access.
I did download an example from somewhere many moons ago but all I remember was that there was a lot of code involved.
I might, and it's a big might, have a copy of it buried somewhere but you'll have to be patient for the while

 

[Jibbadiah]

I am coming back to this post because I found another db with an example of appointments and a good means of displaying them with a calendar form.

It comes from here (named "calendar"):
http://www.utterangel.com/pages/access_downloads.aspx#pagetop

I have zipped and attached the db with updated records so that it doesn't bug-out due to old data.