Search results

in the properties you could set the default value to be what you want your label to read. If for instance you have a drop down box and it's blank, but you want it to read "Choose Option". Or you might be able to hide/unhide ongotfocus event if txt.value is null then lblcaption.visible =...

Maybe you could make a new tbl related to the primary key on the main form then add it as a subform and you can have a vertical scroll or horizontal or anything else you can do to a form.

is there a tab control on your form you copied to? If so then the copied info might be behind the tabcontrol.

How do you call a value from a form into a subform. I have a form with a query calculated value of Days. There is a subform on this form with other values that need the days value for other calcs. I'm thinking, *in the subforms footer* *in a textbox* formated to percent* ([subformfield] /...

Thanks!

Sorry about the new thread, but I didn't think you would come back to this one. Anyway, I guess I might have to. The iif statement apparently only holds 9 or 10 conditions, and says its too complex now. I was wondering, since I really like the data in the query where I know a little about...

In a query doing an iif statement, with 11 conditions, it says my expression is too complex. Is there a way around that?

Thanks, I got it now.

IIF([isize]<=0,0+ [iexudate] + [itissue] ,(IIF([isize]>0 and <.3,1+ [iexudate] + [itissue] ,(IIF[isize]=>.3,10+ [iexudate] + [itissue] )))) David maybe I can explain this better in text. if isize is less than or equal to zero then I want to add the value of zero + userdefined entry of the...

IIf(IsDate([enddate]),DateDiff("d",[startdate],[enddate]),DateDiff("d",[startdate],Date())) that worked! Thanks, to both, and David, thanks for answering my other one. This forum is a lifesaver!!!!!!!! And quite educational! much appreciation.

modification worked with this IIf(IsDate([enddate]),DateDiff("d",[enddate],[startdate]),DateDiff("d",[startdate],Date())) and worked if startdate entered and no enddate, but when enddate entered value is correct except that its a negative number?

Rich, Thanks, but what is the "IsDate"? Is that what is checking to see if date is present? I think I might understand the flow! But it didn't work in A2K is what you wrote 97 specific? And is it proper to place in a query?

in a query how do you get a current usage of days if there is a start date and no end date? such as... if enddate is null then date() - beginingdate else enddate - beginingdate endif

I'm trying to multiply a user defined length times a user defined width. That product is then defined a number which is to be added to other user defined numbers. For instance, user entered 5 for length and 5 for width thus query results size of 25. Scale is: <= 25 add 1 >25 and <30 add 2 >30...

thanks steve!

Does anyone know how to close a form if no data is found upon opening?

Thanks for your help!

Does anyone know how to count checkboxes on a report? If I use the basic =count([checkbox]) it counts all checkboxes whether they are checked or not. Is there a way to count only the checked ones?

How do you remove the "Restore Button" on a form when it's maximized and in the properties section you've answered no to control box, min max buttons, and close button?

Thanks that did it!!!