And... I was just stepping thru the insert module one at a time to see what's happening in the assignments table. The code works correctly until only one person can...

Ok, well I've been running around and around with this and I've come a bit closer with the following code, which doesn't use recordsets 😀

I have enough problems understanding the...

hmmmm.... lemme work on this and I'll let you know what I got!

Thanks sir!

well I'm all for taking any help I can get 😀

Every employee has until the 15th of each month to put in their requests for the upcoming month. They submit...

I think I had another thread running that dealt with this, still haven't accomplished this task though. I did get a great deal of help from another user and that...

just a side note to grovelli:

The popup works for me on more.... maybe a javascript setting issue?

yup, failed to reference the library 😀

Code ran ok. Names repeat throughout the months tho, and it looks like the DOW 2 or 3 is affecting the number of people...

It's mostly fantastic one way 😉

I really don't have much to contribute except my mistakes or lack of knowledge!

But, I gotta admit, RK has the patience of an elementary school...

There's always next weekend to look forward to I guess 🙂

Hey, I thank you for any time you've spent with someone else's dilema... it's more time spent doing something for...

Decided to burden the network and external database for the personal information at report time. Revised the requests table, contains only EMP_NO, REQ_DATE, REQTIME. Seniority and Birth can be obtained...

sorry to hear you got home early 😀

I didn't understand why a connection was needed when operating inside the same database application, I just assumed that part was taken care...

Since I obviously didn't know what a connection object was for let me ask another possibly pointless question:

After re-reading the comments and related code I'm wondering where in the code...

ok.... I recopied the edited code, added Requests.STAR back in 🙂 and ran it again.

Still leaves out one employee, BELL, even though he's not the lowest in seniority.

I've attached a...

yep.... no matter how you change seniority dates, the last person never gets assigned a day.

It looks correct otherwise... I'll have better info after I go through a real set...

Morning RainboFfolly,

OK... changed dmax to max, got same error number but:

Wrong number of arguments used with function in query expression "REQDATE>Nz(Max('REQDATE',Assignments')

Clicked compile and got no response. Never tried it before...