Go Back   Access World Forums > Search Forums

 
Showing results 1 to 18 of 18
Search took 0.00 seconds.
Search: Posts Made By: Spooky
Forum: Word 07-06-2017, 03:53 PM
Replies: 2
Views: 972
Posted By Spooky
Re: Using vba to open existing template, close previous

The template itself is a method of creating many different documents, so its a complicated arrangement of user forms. Im frequently upgrading and adding more functionality, hence the need to edit or...
Forum: Word 07-06-2017, 02:33 PM
Replies: 2
Views: 972
Posted By Spooky
Using vba to open existing template, close previous

Can anyone point me in the right direction to use a .dot file to open another .dot file and close the first one?
The background is Im trying to work around an existing problem.
In a network...
Forum: Modules & VBA 02-19-2017, 04:01 PM
Replies: 5
Views: 201
Posted By Spooky
Re: Modifying listbox values

Sorry, Im not that flash with the terminology.
So, I would need to rebuild the listbox from the source and cant change individual items (as they are read only?) within that record with...
Forum: Modules & VBA 02-19-2017, 01:17 PM
Replies: 5
Views: 201
Posted By Spooky
Modifying listbox values

[brief]
Userform / vba / word
I have a listbox in a userform that I wish to modify one item.

Basically the list contains data relating to an individual. There are 30 items per record.
There can...
Forum: Word 03-10-2016, 06:34 PM
Replies: 2
Views: 2,409
Posted By Spooky
Re: Printing from VBA with Word

Thanks, Ill try recording a macro like suggested to see if it gives some more hints.
The unfortunate problem is the project may be used in any one of many remote locations where I have no input into...
Forum: Word 03-04-2016, 12:39 PM
Replies: 3
Views: 2,305
Posted By Spooky
Re: Capture left / Right click of listbox

Thats why I find it weird - it is reselected in Userform1.
The only difference is whether button 1 (left) or 2 (right) is pressed to get there
Forum: Word 03-03-2016, 05:22 PM
Replies: 3
Views: 2,305
Posted By Spooky
Capture left / Right click of listbox

Is there a was to send a left click selection of a listbox to a form?

Using the code below, a user right clicks on listbox1 and is presented with a form to add/remove (and further options) the...
Forum: Word 02-27-2016, 12:43 PM
Replies: 2
Views: 2,409
Posted By Spooky
Printing from VBA with Word

I have a Word VBA project that outputs multiple word documents and I wish to print (x) number of docs to the default printer of which I have no control

Im using this basic code to do so:

...
Forum: Modules & VBA 02-23-2016, 06:46 PM
Replies: 5
Views: 424
Posted By Spooky
Re: Printing from VBA with Word

Ahhh, sorry - clicked the wrong forum :)
Forum: Modules & VBA 02-23-2016, 09:08 AM
Replies: 5
Views: 424
Posted By Spooky
Re: Printing from VBA with Word

Thanks for the link, not available under Word VBA though?
Forum: Modules & VBA 02-22-2016, 03:49 PM
Replies: 5
Views: 424
Posted By Spooky
Printing from VBA with Word

I have a Word VBA project that outputs multiple word documents and I wish to print (x) number of docs to the default printer (which could be any number of printers)

Im using this basic code to do...
Forum: Word 06-06-2015, 12:19 AM
Replies: 1
Views: 2,550
Posted By Spooky
Re: Spell checking VBA text box.

I think I have found my own solution.
Using Application.ScreenUpdating = true whilst in the function fixes the problem
Forum: Word 06-05-2015, 09:06 PM
Replies: 1
Views: 2,550
Posted By Spooky
Spell checking VBA text box.

Im trying to get a spell check into a word Userform application.It works just fine apart from one thing - there is no preview of the text being spell checked as below.

...
Forum: Word 02-27-2015, 01:11 PM
Replies: 1
Views: 1,705
Posted By Spooky
Programatically joining templates?

To cut a long story short, is there a way to join a template from a VBA loop?

eg - for a simple doc, I do:

for a = 0 to x
Documents.Add Template:=sName + "file.dot"
With ActiveDocument
' add...
Forum: Word 01-22-2015, 05:06 PM
Replies: 2
Views: 1,912
Posted By Spooky
Re: Populating list boxes from Excel

Ahh. That makes sense.

Thanks!
Forum: Word 01-22-2015, 03:44 PM
Replies: 2
Views: 1,912
Posted By Spooky
Populating list boxes from Excel

Currently I pull all my listbox data from a word document. I would like to pull it directly from a (source) excel spreadsheet as Im assuming its more efficient and would save me a couple of steps.
...
Forum: Word 06-12-2012, 03:07 PM
Replies: 2
Views: 1,713
Posted By Spooky
Re: Troubleshooting VBA between word versions

Thanks for that - Ill do some more work on it.
One thing I have discovered, is that one of the document templates (created in W2000) when run in 2007 seems to crash - but actually just looses focus...
Forum: Word 06-11-2012, 02:34 PM
Replies: 2
Views: 1,713
Posted By Spooky
Troubleshooting VBA between word versions

Greetings,
I have a word document / application that uses a UserForm to create multiple pre-populated word documents based on user input.

It all works fine in Word 2000 however, randomly crashes...
Showing results 1 to 18 of 18

 
Forum Jump



All times are GMT -8. The time now is 11:23 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World