Replies

Is there a method of forcing Word to maximise at the time of opening the document? It seems to be a bit hit and miss as to how it starts.

Also, how would I open a specific file, rather than creating a new one – I’m going to change the routine so that if the file exists it opens it, otherwise it creates a new file with the specified filename.

Getting there…..
one (hopefully) last question – using objDoc.SaveAs strFileName causes the file to be saved whether it already exists or not. Is there a switch that checks and prompts for a new filename if it already exists?

Getting there…..
one (hopefully) last question – using objDoc.SaveAs strFileName causes the file to be saved whether it already exists or not. Is there a switch that checks and prompts for a new filename if it already exists?

Thanks Hans

Does the As New have any significance in the first line as opposed to just As?

I needed to be able to modify the file once I’d saved it, so used objWord.visible = true

If I do this with the close and quit options left in, it obviously displays the document for a split second, then closes the doc, quits Word and returns to Access. Can I allow it to stay in Word until the changes have been made and word is quit manually before going back to Access?

John

Thanks Hans

Does the As New have any significance in the first line as opposed to just As?

I needed to be able to modify the file once I’d saved it, so used objWord.visible = true

If I do this with the close and quit options left in, it obviously displays the document for a split second, then closes the doc, quits Word and returns to Access. Can I allow it to stay in Word until the changes have been made and word is quit manually before going back to Access?

John

Hans
Thanks – it worked as you suggested.
I know it’s sometime not a good idea to ask “why?” but why?
At what stage is the form available to have all of it’s attributes altered?
Any thought as to why I can set enabled to false for a particular subform but not allow me to set the allowedit option instead at the same point?
I’m getting my head around things slowly, but sometimes it just smashes into that brick wall
John

Hans
Thanks – it worked as you suggested.
I know it’s sometime not a good idea to ask “why?” but why?
At what stage is the form available to have all of it’s attributes altered?
Any thought as to why I can set enabled to false for a particular subform but not allow me to set the allowedit option instead at the same point?
I’m getting my head around things slowly, but sometimes it just smashes into that brick wall
John

How can I then switch them back on Hans?
Is the code I am attempting to use correct?

john

How can I then switch them back on Hans?
Is the code I am attempting to use correct?

john

Thanks Mark
Sometimes I guess it’s best not to ask why – just accept that it just does!

Thanks Mark
Sometimes I guess it’s best not to ask why – just accept that it just does!

Excellent.
I couldn’t think of any use for the on-click event in the page tab headers, so I’d presumed it had to be the tabcontrol event.
Why “on-change” rather than “on-click”? Just curious about this
john

Excellent.
I couldn’t think of any use for the on-click event in the page tab headers, so I’d presumed it had to be the tabcontrol event.
Why “on-change” rather than “on-click”? Just curious about this
john

Excellent!!
I didn’t realise that I could amend the data in this way – I had presumed that the pasteappend would have already saved (or attempted to save) the record.
I’d started working through a long routine to copy the field values to variables, create a blank, then paste the variable back in ……tooooo long
Thanks

Excellent!!
I didn’t realise that I could amend the data in this way – I had presumed that the pasteappend would have already saved (or attempted to save) the record.
I’d started working through a long routine to copy the field values to variables, create a blank, then paste the variable back in ……tooooo long
Thanks