Replies

Thanks Peter,

I have the reply address set to the required address but the client wanted the from address to appear the same.

Thanks Hans,

I suspected that there would not be a method to allow it but clung to the possibility that I may just be missing something.

Hopefully using the SentOnBehalfOfName method will be okay – the reply to address is correct to this shouldn’t be a major issue.

Thanks again.

I’d be interested to know if my analysis of the styles is correct – this drove me slightly mad for a while, having to replace and then delete the duplicate entries for styles every time I re-attached the template, without any other modifications taking place.

Good luck with your investigations – I’ll keep this thread under observation!

Tony

(Edited by HansV to activate link – see Help 19)

HI Andrew,

I’ve seen pretty much the same behaviour in a document that I set up to be used by other members of staff for manual writing. I wanted to create a toolbar that would apply certain styles and run some macros. The documents were based on a template that had to be re-attached whenever the file was moved/e-mailed and I thought that it was this that was causing the runaway styles to be generated – almost as if the style existing in the document as e-mailed, but also existed in the template and re-attaching it caused duplicates to be created. This occurred, if I remember rightly, just as a result of re-attaching the template to the document, without making any other changes.

I also experienced the same crashing problem when having the styles task pane open but avoided it by closing it before closing the document!

I haven’t tweaked this file recently but, after reading the thread about Word Templates at

http://www.addbalance.com/usersguide/templates.htm%5B/url%5D

which I think I got from the Lounge somewhere, I created a Global Template for the macros/toolbars etc. and a document template for the styles. This certainly made the process a whole lot more stable but I can’t remember whether it got rid of all of the problems – it’s been some time since I looked at it!

I know there aren’t necessarily any great solutions here but sometimes it helps to know that someone else has encountered exactly the same circumstances. Try the Global Template route if you haven’t already as this seemed to help when files were being moved/e-mailed/copied etc. although you may still have to re-attach the document template. The link shows how to do all of this.

HTH

Tony Simmons

Thanks Drew – the hardest thing about a new area is sometimes the first step. When I think of some of the procedures I’ve created in VBA, having seen your article ASP seems less daunting.

Back on topic tomorrow when I’ve got in touch with the office

I’ll try that tomorrow – thanks.

Meanwhile back to your Intro to ASP page….(and about time I got around to it! )

mmm….I think that I’ll have to check this one out.

I spoke to someone in the office and they said that there was a macro attached to the AfterUpdate event of one of the controls causing the problem but without knowing what the macro does it’s difficult to assess it.

Next time I’m in….

Thanks

Thanks for those suggestions – unfortunately I haven’t got direct access to the database at the moment but I’ll see if any of those options help. As far as I remember there is no code attached to the controls and, in any case, it would have to be attached to the OnClick event as tabbing into the control does not cause the problem and the problem occurs before any changes are made.

I didn’t create the database so I’m not sure that there isn’t something attached to the OnClick property. This problems happens on text boxes so I would be suprised if there was (but, hey, you never know!)

I think that maybe the graphics card drivers would be a good place to start – at least that eliminates any strange ‘incompatability features’ that may be going on.

Thanks again.

Off the top of my head you may not get what you expect because of the order in which the infromation in a sub report/report is generated.

You could try using a domain aggregate function (DSum) that totals the related records using the link master field e.g. in the text box type (all on one line) something like

=DSum(“[EnterSubFormTableNameHere]”,”[PaymentAmount]”,”[EnterLinkChildFieldNameHere] = ” & [EnterLinkMasterFieldNameHere])

This assumes that the linkmasterfield is a numeric field

if it is a text field then you may need something like…

=DSum(“[EnterSubFormTableNameHere]”,”[PaymentAmount]”,”[EnterLinkChildFieldNameHere] = ‘ ” & [EnterLinkMasterFieldNameHere] & “‘ “)

notice that there are no spaces between the “, the ‘ and the second ”

they are included here only for clarity.

Let me know if this helps…

Thanks to you both – the second method also worked. I used Right Click – Edit Field to add the switch via the dialog in the end because I couldn’t get it to work initially. I ended up with…

{ TOC t “ModuleTitle,1,SectionHeading,2” n “1-1” }

by adding the switch on the end using the dialog box.

I think that the double quotes are important around the level numbers “1-1”. I also couldn’t get it to work if the switch appeared immediately after the t.

Thank you both once again for your help

Thanks Anne – found the switch and I will try it tomorrow (it’s a bit late here now…). Took a bit of time finding the post though. It didn’t find the post number for some reason.

An excellent piece of lateral thinking . The page numbers are now sitting way off the edge of the page, invisible to the eye and, I would guess, the printer.

Solutions like this are sometimes more satisfying than finding out that there is a built in feature

Thanks Andrew!

Yes – I noticed that when I posted it – see my (twice) edited reply!

Time to rest, I think!

I’ve just penned a fine explanation of how to create your own splash screen then actually read your post properly! (it’s late here!).

I don’t have Access 2K available but in 97…Tools – Options – removing the tick from the ‘Start up dialog box’ removed the start up splash screen. I can’t find the option in Access 2002!

Tools – ‘Startup’ has many options that run on startup including Application Icon. Click the adjacent browse button (the one with … on it) to select the required icon file.

If you ever need to create your own splash screen I’m just who you need!!

Hope this helps.

There’s nothing in particular to remember except that, if you select the whole row in the table design view, then all of the properties set in the original field will come over with the field when it is pasted into the new table. The data will not come with the field. If you want the data to come over you could try copying the field rather than cutting it and then copying the data from the original table and paste it separately (although copying and pasting data in this way will paste the data in the same order as it was in the original table).

This will work between any tables, whether they are linked or not. If you are looking to ensure that data in the pasted field links in some way to the records in the new table then you may have to start looking at an update query to ensure that the link is correct.