Search results

Can a form be coded to produce a Word document that is almost always the same, but for the change of 3 or 4 fields (which are on the form), please, SuperCraftsmen? For example, congratulations, or good luck, or a dismissal even (though in fact the message is almost always the same) to be...

SJ, First: I have five queries that filter five fields. Next: I then have five queries to count up these queries. Finally: I have a query that collects the totals together to be bound to a form. Does this sound a very long-winded way round to you? Cheers

Thanks, Vince. Yes, I'll have to think another way round it. Cheers

Really good of you to offer to look. Unfortunately, it's restricted. If I can't find an answer soon, I'll just delete all associated with the form and try again. Many thanks, MoP, er SJ.

Hi, SJ. No, though it did. It's complicated by the query being fed by queries, but only two deep. (I've been trying to discover why the query that feeds the form does not return values.) But I would have expected the textboxes to be visible - just showing a fault. Cheers

The form contains some text boxes with totals from queries and a command button or two. The form worked well. Access to the database is restricted, but some 'comedian' has been busy. In normal mode, the form appears to be empty. In design view, everything is there. 'Visible' is yes for each...

Brilliant, SJ. (You're not the twin of the genius Mile-O-Phile, the main subject of a biography I'm writing about Wonder Kids? There's much of the brilliance - and dare I say, native charm of the Scots foothills if not exactly the Highlands - about you too.) Much appreciated. Cheers

Is there a simple way to put the Count of the total of records in a report into the head of a report, please, gentle Experts?

Didn't realise that. Very sorry. Cheers

SJ, It's not to open a form in the current db, but - please, guv - open a form in ANOTHER database. Do you know that command, please? (I've done it several times before, but I can't recall the process ... and I can't find anything about it in the books.) Cheers

Search produces 3 entries and a search on your answers from your profile, after 7 pages, doesn't find it either. Just a hint, SJ, will be fine if Friday has numbed your alertness too. Cheers

I want to open a form in a different database - and (it's Friday) I've forgotten how. Be grateful for a hint please.

Yes, that's a good point. I'll follow you. Cheers

Putting the date variation into the DateDiff function works fine, like DateDiff("d",[OneDate], Date() - 14) But I don't doubt really I should include SJ's DateAdd. Or .. perhaps there's some unwritten rule that says if it works, leave it alone. (?) Thanks, Ken, SJ.

My mistake. I was overlooking a function in the form's query that does some of the work. Thanks very much, Ken, and SJ McAbney. (I've kept your suggestions for incorporation.) Cheers

Hi Ken It works sometimes and then not in another place. I haven't understood why yet. But I think SJ may have the answer, which I will try.

It works, but it doesn't seem to work correctly, so I thought there may be some obvious fault. Thanks and cheers, Ken.

Can I add another clause to a DateDiff function, making the second date minus 14 days. Rather like DateDiff("d",[OneDate], Date - 14) please Experts?

That looks very good, SJ. Many thanks for working that out. Most grateful

Really good of you to go to that trouble, Ken. Thanks very much. Cheers