Recent content by DH

Try this link as well http://www.mvps.org/access/queries/qry0018.htm

The "No 1" site member has replied to your first post!!!!! http://www.access-programmers.co.uk/ubb/Forum3/HTML/003505.html

Mike, This link should give you a start. http://www.access-programmers.co.uk/ubb/Forum1/HTML/003291.html

GMT, In either the Form or Label Input mask try; >A0A 0A0 just leave a space between the 3rd and 4th characters. It works for me on forms although the table remains without the space. ? you may not need > if that is in the table input mask HTH David [This message has been edited by DH...

Louise, try this link David

This link shows how to print a certain number of reports although it would need adding to if filtering. http://www.athree.com/cgi-bin/discussion/showthreaded.pl?Cat=&Board=access_97&Number=59518&page=&view=&sb=&vc=1#Post59518 David [This message has been edited by DH (edited 05-12-2001).]

Rob, Try dddd d/m/yy The help files Format Property-Date/Time Data Type shows different examples. David [This message has been edited by DH (edited 05-09-2001).]

I use mine on the GotFocus Event. Me.Yourcbo.Dropdown David You may need to change the table design depending on how many rows/size you want to view in the form

Gram, A quick thought try this link. http://www.mvps.org/access/datetime/index.htm It has various date/time functions. David May well help until you receive further replies!!!!

Going back to the function, This link should have a function at the end of it which will remove all weekends & holidays. http://www.athree.com use the search facilty in the Access97 forum & look for Networkdays in the last 3 months and copy the attachment. HTH David [This message has been...

Thank you for the quick response Just a couple of questions, If I already have code in the AfterUpdate can I add this code to it. Also,how to I write the code in order to go from the Formsheader to Formsdetail. David

More than likely a simple question. I have a combo box in Form header.When I press enter the details are shown in Form detail.On press enter how to I have the focus automatically change to a field in Form detail. Thanks in advance David

Thanks Pat & Richie, I've tried the running sum in the report previousily and this is what I arrive at; The totals add up until the end of the year and does not average. April 14.00 14.00 May 27.61 38.33 June 34.00 72.33 July 39.25 111.58 It doesn't show 1st column Individual month 2nd...

Any suggestions please for the following problem I have. I currently average the No of Days taken per month after remove certain people(not literally). Example Avg Month 14.00 April 27.61 May 34.00 June...

Thanks,both suggestions work fine. David.