Replies

Thank you.

The work around I used was to use a common keyboard character (asterisk) and used the same code method you suggested. However, I know there is a way to include a character number should I need to display a symbol of some sort. I tried using the character map but could not get the symbol to insert into the label.

Thanks to you both for the suggestions.

Thanks John.

You know I’ve tried to copy and paste the symbol into a label and text box but it copies as a square and not the symbol.

Also, the check box is checked on another form in another part of the application – – the use here is only for display on the report.

Hans,

It worked perfectly! Thank you. Jenn

Try this:
– Press Alt+F11 to activate the Visual Basic Editor.
– Press Ctrl+G to activate the Immediate window.
– Type the following line then press Enter:

ActiveDocument.ConvertNumbersToText

– This will replace ALL bullets and numbering with literal characters.

Hmmm… I have limited experience with using styles beyond needing them to creat TOC’s. I think I need to read some more on the subject before I can implement your first solution but it’s something I’d like to explore even if only academically.

Option #2 – The datasource is excel so it’s conceivable to manipulate the records. My preference is to get the word doc set up properly so the merge can be run easily and by someone who isn’t me. However, for now, I’ll figure out how to manipulate the records.

Option 3 is viable too…

I’m still shocked that merging on the backside of a document isn’t a “feature” you’d think lots of people would do it. A moment such as this only reinforces that Microsoft logic and Jenn logic are two very different things…

Thank you. They are all good suggestions… gotta love lateral thinkers…

Hans, this is great and simple enough for the small application it will be used in.

Thank you.

Here’s a sample database that uses expressions only in a query, no VBA.

I’m not sure who macropod is but I sure hope he/she will have some insight. This is one of those projects that irk me to no end. I’ve tried every trick I know of and have had to compromise on the finished product because I can’t find a viable solution…

P.S. I’m also open to a suggestion that takes an entirely different approach… so long as it doesn’t include printer/paper tray manipulation.

Thanks again Hans… If you have any additional info on my recent Access data manipulation question, perhaps you can flex some muscle over in the Access forum. Thanks. Jenn

Perhaps our field and merge expert macropod will have a suggestion.

If the document was a letter that would be acceptable. Since the document is a 4-up post card template and has 4 records per page, any 2nd page would begin using data from the “next” record which is record #5.

I’ve attached a pdf of the layout I need but of course it’s a non working version. This is difficult to describe accurately so please take a look and hopefully I’ve illustrated what I need. Records 1-4 on page one need to be the same records 1-4 on page 2.

Simply create a two-page main merge document. You can use the same merge field more than once without problems, so you can use the same set of merge fields on page 1 and on page 2.

Thanks Hans. I’m going to start working with this and see how far I get… Appreciate your guidance. I’ll probably be back!

I don’t have time for a complete solution right now, but I’d use some VBA to split the string. It would be possible to do it using expressions only, but it’d get hairy.
Here is some pseudo code. In reality, you’d supply CardField1 from the table, not as a variable.

Dim CardField1 As String
‘ Example
CardField1 = “%B123456789101112^SMITH/JOHN ^12061010000000000”
Dim a As Integer
Dim b As Integer
Dim c As Integer
Dim CardNum As String
Dim LastName As String
Dim FirstName As String
Dim ExpMonth As Integer
Dim ExpYear As Integer
a = InStr(CardField1, “^”)
CardNum = Mid(CardField1, 3, a – 3)
b = InStr(CardField1, “/”)
LastName = Mid(CardField1, a + 1, b – a – 1)
c = InStr(b + 1, CardField1, “^”)
FirstName = Trim(Mid(CardField1, b + 1, c – b – 1))
ExpMonth = Mid(CardField1, c + 1, 2)
ExpYear = Mid(CardField1, c + 3, 2)

I hope you can use this as a starting point.

Argus,

Thanks much for your response… I will give the utility a try… I was hoping not to have to do a registry edit for something that should be easily changed…

Take care…

Be glad It’s not your eyes Hans!

Here’s the accurate relationship view.

Again, I’ll take any suggestions…

Jenn

Best I could do for right now is a printscreen of the relationships…

Hold onto this Hans… I’m sure I’ll be posting other questions…

Thanks…

I apologize… County ID is not the primary key… I didn’t include the primary key in the post as it’s an autonumber and irrelevant to the point. I was looking primarily for a counter reason to my approach, which you provided! I thought I would try and store the calculated field in a table rather than setting up a qry and rpt to pull the data when I need it. But I suppose I will have to. I built a qry which sums the discretionaryamt field by grouping on countyID and yields an accurate result.

Anyway, You can view the relationships in the attachment… This is the first stage of a complete overhaul and redesign of a database that was used for years… We are adding new features and capabilities and ironing out some limitations that were built into previous versions. Any suggestions are welcome.

Thanks much for your response.

Thanks Hans…

This code goes a long way but doesn’t help me with looping through the subform recordset to get the to: information. Any ideas on that?

Worked like a charm! Thank you

Thank you Charolette and Wendell… I appreciate the input… I look forward to attending…