Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dongledell

    Opendatasource causing problem?!

    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...
  2. dongledell

    turning off word 97 warnings re slow running during mailmerge?

    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...
  3. dongledell

    turning off word 97 warnings re slow running during mailmerge?

    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...
  4. dongledell

    Use VBA to control Word from Access?

    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!
  5. dongledell

    Use VBA to control Word from Access?

    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...
  6. dongledell

    Use VBA to control Word from Access?

    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...
  7. dongledell

    Use VBA to control Word from Access?

    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...
  8. dongledell

    Working with Null Fields

    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 ;)
  9. dongledell

    Windows XP and IIS

    does that apply to xp home edition as well?
  10. dongledell

    Working with Null Fields

    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...
  11. dongledell

    Working with Null Fields

    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...
  12. dongledell

    Disappearing Field on page?

    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!
  13. dongledell

    Disappearing Field on page?

    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!
  14. dongledell

    Disappearing Field on page?

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

    Disappearing Field on page?

    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 %>...
  16. dongledell

    Formatting Dynamic Text

    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)...
  17. dongledell

    Formatting Dynamic Text

    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...
  18. dongledell

    Formatting Dynamic Text

    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...
  19. dongledell

    DSN less connection file problems on ISP

    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...
  20. dongledell

    DSN less connection file problems on ISP

    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...

Part and Inventory Search

Back
Top