Recent content by Leco

Yep that works. Very many thanks for all your help. (:I Leco

Thanks once again Ken (and Tony) I like to have as much info as possible in order to expand my knowledge. I've found that the array formula only works with actual numbers (i.e. not cells that contain a SUM) but I'm o.k. with that. By the way I'm a she not a he! (:I Leco

Thanks Ken, that makes things very clear and understandable. However, what did you mean by "array entered CTRL+SHIFT+ENTER" ? (:I Leco

Ah I'd forgotten about increased budget balance! Thanks Ken. Would you please explain the formula as I'm not used to arrays (the cells in question are now in row 5 just so's I don't get confused) (:I Leco

I knew it would be something simple. Thanks to both for your help. I get #NUM errors using the LARGE function but thanks anyway, I'll no doubt find a use for that in another workbook. I've used Tony's second formula, which works a treat, as it is likely that I will have empty cells. Thanks once...

I have a feeling that this is really easy but I can't figure it out! I have a budget in cell B2 with (money spent up to a quarter date) in cells C2, D2, E2 and F2. Balance left in G2 What I want is the formula for G2. A simple formula would obviously be G2=B2-F2 but if it's only part the way...

I'm trying to use a Word document that has merge fields. The document was originally created when I had Office 2000, now I have XP. When I first open any of my merge docs I have to reconnect to the relevant Access database. I then have to recall which query or table the .doc was connected to and...

Variables have to be declared before using them - in the case of this piece of code look at: Dim WSHShell, RegKey Set WSHShell = CreateObject("WScript.Shell") After the "Dim" you can "Set" the variable to something or other. Now look at the next bit: ' vb script...

Do you need to DIM 0net? If that's the case then you'll also need to DIM WshNetwork else you may get another error. (:I Leco

That certainly makes sense. Thanks a bunch - I'll give it a try. (:I Leco

I'm OK with octals now I've seen what you're doing (something like setting sub net masks) though it may be 'using a sledgehammer to crack a walnut' How would the loop code look? (:I Leco

Now you've lost me! Where do I put that and how is it attached to the table? Sorry if I'm being stupid, I've had a long day. (:I Leco

That's a neat way of making the check boxes - but then how do you "gather" the info from individual boxes? Say I want to find out who has ticked box A, do I have to have a query with all 42 fields or 42 separate queries? Many thanks for the code so far. (:I Leco

Read this thread with great interest, it's all helped a lot with a small database I'm working on. I have a question - can I send an email to a filtered set of records? I've managed to email a report based on the filtered set but I can't figure out how to combine that piece of coding (using...

I just wondered if anyone else has had this problem. When I'm logged onto my server I can reach the proxy but can get no further i.e. no web access. When I'm logged onto any of the workstations internet access works fine (if a tad slow). The problem only started when we changed from Freeserve...