Search results

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...

Hi Everyone, I'm sorry it took so long to reply, but a family emergency took me out of state for a while. First of all, I'd like to thank Rich Morrison and Alexandre for their reply's. Without your help, I'd still be experimenting. Below is the code I used. ' Monthly Report Count...

Hi Everone, I have yet another Dcount question ? My problem is I haven't been able to format the the criteria correctly. Rather than someone doing this for me, I'd just like to know where or what to look at to accomplish this. I,ve tried it at least 50 different times with no success. I dont...

David Stephen, My form is an unbound form, and yes Multi Row is set to YES. Anything else I can do. Thanks Skip

Hi Everyone, I have created a form with a TabControl on it, which has 11 Tabs. After the 7th tab Access will not allow me to add any more controls to it. I went to the following site, which said that total controls on a form or report could not exceed 754...

Hi , If Option Explicit is not being entered by default. open a module click tools, go to options under editor there is a line which says: Require Variable Declaration Make sure the ckeckbox is checked Option Explicit will then be the default HTH Skip [This message has been edited by...