Recent content by janetlyn

Yep, Bob's a genius. Gave him a pink star and would have given him more if Tek-Tips would let me. JL

Bob, thank you for your suggestion in the third box down. I went to check and see if my stuff was setup correctly and I had the [Forms]![FRM].... under the wrong column in the query. I have had two or three people look at this and could not find the problem. I have been working on this...

If it is so easy in Excel, why not do it in Excel and then import the worksheet data into a table? JL

bbbum, Since PHV got me rolling I not going to break his hard work. However, now that I look at it again, I did screw up a name. It is ProjectNo not Project#, which is how I had it when I first started this DB. When I looked at the Help in VB it said "a Where condition without having to use...

PHV, you have just helped me tremendously today. It worked. I really appreciate all your help. If I could give you more than one star I would. Have a wonderful day, JL

I have a form (frm-ParentMainForm), with a subform (frm-ChildPLHours) holding a label (Label9). I would like to click on Label9, which would open a report in print preview. The report is based on a query (QRY-ProjectHrsSearch) which has a parameter asking for "What project number would you...

Way beyond my capabilities. Hopefully, though the smarties will understand more of what you want and can answer your questions now. I will continue to look around but I don't think I have ever seen anything do that before. JL

I looked at your formula and thought to myself, I have already tried that, but I put it in anyway and I got the correct results. I think I put what you did but added and extra Sum( ) around the whole thing. Thank you so much. You are excellent. JL

PHV. As told above, individually, the answers come up right. But, with the formula as I have it (like the one you showed me), it is only adding up UseHoursTrips which is (50). The TtlAllow is only one number of 42. The answer should be (8). It is showing up as (50). Any ideas please? JL

Thank you. I knew it had to be simple. The answer is not right, but at least it is not #Error. Thanks a bunch, JL

Xmad4, I put this is in the Form_Open event and it did not work. JL

I'm pretty sure this is a simple and stupid problem but I can't solve it so please help. I have a form, the form has a box (Text181) with: =Sum([UseHoursTrips+TtlAllow] as the formula to get data. This Text181 is in the header. If I just have the UsehoursTrips and take out the TtlAllow and...

If you are talking about carrying data over from one record to the next, read: 702-554402; or go to http://www.allenbrowne.com/tips.html Good luck, JL

Thanks PHV. Didn't think about tabbing. JL

I take that back. Actually I bought a simple ActiveX Balloon program from someone. Just haven't been able to get it to work yet.