Search results for query: *

Still having problems with a mailmerge document, but now for different reasons. If I use word to create a mailmerge with absolute addresses to the datasource (db and table) then save it, everything runs fine. As soon as I remove all links in the word doc, just add fields, then in the VBA code...

hi, thanks for the reply Lightning, yeah I have tried the warnings off in access - made no difference. Have to admit, I still haven't quite worked out how to do this breakpoint thing and have it work - always seems to go wrong when I try! Couldn't possibly give some examples in the above code...

I've managed (after a fashion!) to get access 97 and word 97 to communicate and do what I want them to do (sort of!!!) BUT there is a minor problem. Sometimes (for reasons which I am yet to fathom) it runs REALLY slowly. Frankly I dont care about that - I think the whole thing that I am having...

Hey thanks Lupins46 - from the "look" of the code that would appear to be the sort of thing I'm after!! I'll give it a thorough going over and see what I can do with it! Many thanks - I'll let you know how it turns out!

lupins - the mailmerges themselves are not writing to the database, but some code that is run immediately after the mailmerges are completed do. The comment on damaging the "real" data was more at the fact that many seem to like happy clicking while learing, changing radio buttons and the like...

Hi, Many thanks for coming back to me. I see where you are coming from, but the only problem is the people I work with wouldn't be able to do that (seriously - they all still struggle with the difference between the left and right mouse buttons....) and I need to find a solution that is...

Hi, having a small problem and was suggested I come ask you guys. In brief.... I have an Access 97 database and several mailmerged Word files that all reside in one directory on a PC sort of set up as a server. All users on the network can access this etc. OK, now the boss wants me to make it...

LOL Shaddow - it would be very surprising if I couldn't learn something new each time I come here - only really been doing ASP for a month or so and it's all a bit confusing ;)

does that apply to xp home edition as well?

Many thanks! A combination of that and one other modification has made it work perfectly! On the second modification I had to make, The database was designed using access, and that field was assigned the type "memo". with it set at memo, although the if statement would write the...

Hi, I have my asp page running OK, now I am trying to refine it. What I would like to do is only include a certain table row if there is any information in the corresponding field in the recordset. I'd also like to format any text to ensure line breaks are included. here's the code I was...

nice idea - thanks foxbox. I dont think it can be changing as the scheme"ratetype" is taken directly from a single record, and the variable it compares it to is passed to the page by the previous page, but it's worth checking!

No one?! OK, how about using a case statement instead? Just read a bit on them but not sure how to implement them in this..ermm.. case!

OK, tried that, but no joy. Still disappears when Discount is chosen. Any other ideas people?

In my recordset is a field scheme(&quot;ratedesc&quot;) This is displayed at the top of the page in an area using the following code: <% If scheme(&quot;ratetype&quot;) = &quot;Fixed&quot; then %> <td><%=(scheme.Fields.Item(&quot;rate&quot;).Value)%>%<br> </td> <% Else %>...

ermm - sorry, late at night, was supposed to say: <% =replace(scheme.Fields.Item(&quot;inforeq&quot;).Value , chr (13) , &quot;<br>&quot;)%> which is what would not work, however <% =replace(scheme.Fields.Item(&quot;inforeq&quot;).Value , vbCrLf , &quot;<br>&quot;)%> (changing the chr (13)...

thanks for the replies guys! Davejam - you actually came up with something similar to what I had originally tried - I had <%=(rsRecordset.Fields.Item(&quot;Column&quot;).Value,chr(13),&quot;<br>&quot;)%> but it wouldn't work, tried all sorts of combinations. maybe that vbCRLf will do the...

Having a minor problem with the displaying of text pulled from a database. In the db it has carriage returns in so that it is in a certain structure (numerically highlighted, i.e 1: do this 2: do that etc) only when it gets pulled into the page, it ends up as 1: do this2: do that3: etc any...

thanks katixa - very helpful! given me a whole new area to explore! medic - I am pleased that they are so security conscious, but feel it rediculous that they would not provide simple help to a customer. The code they claimed to have written to access the database would have been of no use to...

hmmm - hadn't thought of that. might be worth a try in the morning! by parental pathing they simply mean that you cannot use &quot;..&quot; - e.g ../data/data.mdb , you'd have to have &quot;asptest/data/data.mdb which is what they (the ISP) told me to do, only that does not work either. What...