Search results

Thanks Raman256, that's an excellent 101 suggestion. However, my data source is batches in the Raiser's Edge database, and there is no opportunity in that medium to create user-defined calculated fields. Any other suggestions to answer the question I asked?

I'm struggling to successfully create a calculation in MSWord based upon a value in a merge field. The problem may be because the merge files are stored in and run from the Donor Contact Management Database The Raiser's Edge, or because the version used is 2007. I used instructions for Word...

Hi all: I'm using Word2003. I want to be able to toggle field codes ([ALT+F9]) and then work with the result as plain text. I've tried several things: 1. Toggle to reveal the field codes then select/copy/paste special (paste as plain text) 2. Toggle to show the field codes then unlink fields...

AccessMSSQL, thanks for the info, I'll try that when I have time. It's an .MDB

Anyone? Still trying to track down the developer.

Thanks, but it didn't work unfortunately. Wish it were that easy LOL.

I work in an office with Office2000. One branch of our non-profit organisation had a volunteer design a database in Access to track the usage of rented storage bins. The database works great for its intended purpose, however the volunteer is not available and the front-end is so locked down...

Actually, I prefer to solve this problem in a way that kills two birds with one stone. In my actions table (which is for all types of contact), I have a field for the due date for the action (the 'do by' date that you're using), and also a field for the actual completed date (to indicate that...

Are you substituting your actual form name for the placeholder [yourformnamehere]?

In the criteria field, type <Now()

So it doesn't matter who gets what records? You just have a 'staff' field or something, and you want it to update X records to "Julie", and X records to "Matt", etc? I'm not an Access programmer, but I'd do it one name at a time using a range of numbers in your ID field (assuming you have one...

Hi aml5171: 1. Create a new query and select the fields you want from the parent table. 2. Add the 'group' function by clicking the Sigma symbol (like the autosum in Excel). 3. In a new column in the query, in the top row create the following expression: TITLE: Sum([TABLENAME]![FIELDNAME])...

The sticky thread at the top of the Queries forum tells you how to do exactly that.

Check my thread just below yours - Bob Larson answered my question and I'm sure it's pretty much the same for you! E2A: Duh, I am dumb. E2A2: Also, the more interesting and specific you can make your thread title, the quicker you'll get replies from the busy techs on the site who don't have...

Hi, boblarson: That's perfect! Thank you so very much!! I hope my question and your answer may be of use to others, as well!

Using the "DMin" function that I just read about in a different thread, LOL, would the following work: Dim dteNextDue as Date NextDue = DMin (“[DueDate]”, “[T Communication and activity log]”, “[CompleteDate] = Is Null”] If so, where would I put it? In the criteria line for a new field, or...

HI Boblarson: Thanks for the reply. So if the query were filtered to exclude all the completed actions, wouldn't the 'due date' field enable one to find the oldest item in the to-do list? Maybe I'm mis-understanding your question, or perhaps I expressed myself poorly. For instance: If I run the...

Want Multi-table query to return only stalest record in child table E2A: This question has been answered to my satisfaction - thank you to user boblarson! ________________________________ Hi: long time no post. For anyone who remembers me, I changed job 16 months ago and now work for a...

It could also be the type of grammar check that is being used - you can use different types: I think formal, student, informal, professional, etc. If you right-click on the spelling or grammar problem (underlined in red or green), it will open the spelling/grammar dialog. You can just turn off...

I'm using Word2003, embedded in the fundraising database Raiser's Edge (I know, I know - ::shudders::). I am trying to formulate a field (I tried with a Word If...then...else field but I couldn't get it to work) that would conditionally insert a mail merge field (email address) if one of the...