Search results

Hey Rural, Same thing it doesn't seem like it is running the code I have it in the On Current of the form so that it should be looping through correct?

Hey Brian , I tried that And it is not giving me the error anymore but it still is not running the code for some reason or at least the Label is not dispalying, any idea's Thanks Don

Hi All, I have a form that I have a textbox that is a calculated field. I also have a label that is set to not visable. What I am trying to do is if the textbox ( Text92 ) has a value of <=-1 the make label visable ( Label27 ) I have tried the following and none of them seem to work it...

Thanks Simon, I will play around with it and make it work. I appreciate all your help......

Thanks Vodafrog, That was the ticket it worked great..................

Hi All, I think I have tried almost every IIF count that I can find on here and I am getting errors on them. What I have is a Form that I have a text box that gets populated by a popup calendar ( txtDate1 ) which is working fine. I have another text box ( txtcnt1 ) that I need to get a value (...

RE: Counting a group of text box valve if not blank Thanks Simon, VB is not my strongest point. Im not sure if I am understanding your code exactly. Is it a function?, and would I repeat the code 10 times 1 for each text box? I think I would call it from the text box that I want the total in...

Hi All, I have a question that I can't seem to get my head around. I have a form that has 10 text boxes ( txtDate1 to txtDate10 ) which get populated by a datepicker. I need a way to count how many of the text boxes have a value in them. I have tried Dcounts and Nz Nulls but cant seem to figure...

RE:Advise - Query Hey Dean, First off you said you are using a drop down to do the query? Are you using a form that has a combo box on it. What you are wanting is pretty simple with a straight query and using a form with a date chooser on it. If you do a group by in your query it should take...

Hi All, I am stuck, and can't get my head around an easy way to do this. I have a table that has an Team_mem,strmonth, and 31 other fields 01 through 31 with valves of D, V, A etc and I need a way to count how many times the letter V shows up in fields 01 through 31 in a given row. Example...

RE: Changing Screenresolution Hey Sven2 I tried to get the code to work in my database as well but have been unable to. I to would really like to get this to work in my database. I am getting a run time error 3270 and have been unable to locate a reason. If anyone knows a fix or why it...

Hey Bob, Thanks I figuered it out, When you said Forms I went back and checked my query which was formatting it as a day field instead of a date. Once I fixed that I was able to use the following and it works great. =Format(DateAdd("d",1,[Day]),"ddd") Thanks Again

Thanks Bob, The only thing is its not in a Form its in a Report I could maybe add a hidden field to the Form and point it that way.

Hi Bob I have tried several differnet things but the one I think is close is =([Text74]+1) I have also tried [Text74] = DateAdd ("ddd",1) I think it has to have a DateAdd in the Source but I know I am just missing how to get there.

Hi everyone, I have a report that I have a text box which shows the first day of the month (IE Fri ) for June 1st and I have box boxes across the top that I need to have populate based off the first box. I have tried several of the date add functions but nothing is working. I need it to look...

RE: WorkForce Scheduling I have searched all of the 287 post on this and have not found anything that is like what I am looking at. I have also searched for 2 days on google to no avail.

HI All.... I have a question which I believe I may already know the answer to but Here it goes. I am trying to create a db that can track and employee shift schedules. I have 28 employees and we work 24X7 so we have 3 shifts, days, evenings and night. I cant seem to get my head around how I...

Thanks DJKARL, That seems to be exactly what I was looking for

DJKarl, sorry Im not seeing the DB

No good still getting incorrect password no matter what I type in