Search results for query: *

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.

How does GotFOcus work? Wouldn't it be the same as OnClick? It doesn't have focus until you click on it does it? There is not going to be any inputting or anywhere for a user to mess up because the help is just buttons, when selected open a screen, which they can close if it is the wrong one...

Wow, Wemeier snuck one in on me. I completely missed that CoachDan. Thanks. I think I was reading the one above his when he wrote and then I replied and I did not go back through all the windows again, just to the bottom. As long as the explanation is below 250 words I actually think that...

Thanks FancyPrairie. I will go download that right now. Have a wonderful day, JL

The reason why there are so many help buttons is because I do everything from shipping to financials. This involves Access, Word, Excel, and Quickbooks. So I wouldn't necessasrily be able to use the Help on the form (although I love that idea). How did you do the click-open, click-close...

Thanks Tom, I will try and look up the ActiveX balloon. I think I have done that before and it doesn't work in Access, but will see. Appreciate any help you can pass along. JL