Recent content by skiphooper

Hi Newman, Thank You That fixed my problem. Skip Hooper

HI Everyone, I have a small form that displays some of my users codes and options. I added a command button which calls a function called testpassword. Testpassword takes the first Initial of First name and First Initial of last name, and then add to that a 4 position alpha numeric code to...

Hi Drevlin, Thank you very much. It works fine now. Thanks Again Skip

HI Drevlin, Thanks for the reply. Here is the code I now have, with the following error. Too few parameters. Expected 2. I've looked at it but still can't get the statement right. Public Function GetRangedays() Dim strSQL Dim frm As Form Dim db As Database Dim rs As...

HI Everyone. I changed the following function, and can't get it to work at all. Public Function GetRangedays() Dim strSQL Dim frm As Form Dim db As Database Dim rs As Recordset Set frm = Forms!frmCalender Set db = CurrentDb ' Vacation ' The next line was...

Hi, Just copy your SNAPVIEW.exe from your machine and try it on 1 machine. If that works, just download it to all the machines. That seems like an easy solution. HTH Skip ______

HI Thank You Both Skip _________

Hayley, So what was the solution ? Skip _____

Hi Hayley, I'm probably all wrong, but =DCount("[CategoryID]","tblProspects","[CategoryID] = " & "Newscorp") Skip _____

Hi Everyone, Anyone have any idea's about this one. Thanks Skip ______

Hi Rich, Only because I don't know what to use in it's place. Even so, what would cause it not to print on pages higher than 1. Thanks Skip ______

Hi Everyone, I have a strange problem with my report. I am using a Dcount statement in a textbox in the Report footer section, to give me a total for the number of records printed on the report. This works fine when the report is limited to only 1 page. As soon as the report spans more...

Hi RichM, Thanks for all your help. Skip _________

Hi Everyone, At first I thought it might be because of Access/2002. but it does the same thing on Assess/2000. I ran it again this morning, with the same results when it went to the 2nd page. When the report is only 1 page there is no problem. Skip ________

Hi Rich, Yes, I'm using the Dcount in a text box of a report. It is in the report footer section. As far as the report expanding, some people have accumulated hundred's of days, either vacation, or sick. We get 17 or 18 holiday's, 22 vacation days, 10 sick days, and 5 personal days. When...