Combo Box within Word .DOC problem becoming a .DOT

Good Morning All,

I am having problems turning my Matter_Creation_Form.DOC into a Matter_Creation_Form.DOT.

Now,

Within Word, I have created a document that contains 2 Combo Boxes which, when a .DOC file, the contents of them appears fine.

I then resave the file as a template (with the extension .DOT to change it into a template) and the contents of the Combo Boxes does not appear.

Can you please advise me on where I am going wrong!

Please find my code below;

Now I know the code is very basic, but it works fine for me as a .doc, just not as a .dot! Do i need to insert anything in order to display the contents of the combo boxes within a .DOT successfully?

Private Sub Document_Open() 'When Matter Creation Form is Opened...
With ComboBox1
'Populate Combo box with...
.AddItem " use dropdown or refer to list at doc#201064 "
.AddItem " ---COMMERCIAL--- "
.AddItem "Shareholders Agreement "
.AddItem "LLP conversions "
.AddItem "LLP agreements "
.AddItem "Reorganisations "
.AddItem "Distribution Agreement "
.AddItem "Supply Agreement "
.AddItem "Terms & Conditions of Business "
.AddItem "Secondment "
.AddItem "General Commercial "
.AddItem " ---CORPORATE--- "
.AddItem "Share Purchase "
.AddItem "Share Sale "
.AddItem "Business Purchase "
.AddItem "Business Sale "
.AddItem "Business Recovery "
.AddItem "Banking "
.AddItem "Retail Pharmacy Sale "
.AddItem "Retail Pharmacy Purchase "
.AddItem "Dentist Purchase "
.AddItem "GP Surgery Purchase "
.AddItem " ---DISPUTE RESOLUTION--- "
.AddItem "Construction Disputes "
.AddItem "Supply of Goods & Services Disputes "
.AddItem "Purchase of Goods & Services Disputes "
.AddItem "Shareholder/Business Ownership Disputes "
.AddItem "General Commercial Contract Disputes "
.AddItem "Property Disputes "
.AddItem "Commercial Agency Disputes "
.AddItem "Judicial Review/Public Law "
.AddItem "Insolvency "
.AddItem "Contentious Intellectual Property "
.AddItem "Miscellaneous Litigation "
.AddItem " ---PROPERTY--- "
.AddItem "Commercial Lease - Landlord "
.AddItem "Commercial Lease - Tenant "
.AddItem "Commercial Lease - Licence to Assign "
.AddItem "Commercial - Purchase "
.AddItem "Commercial - Sale "
.AddItem "Commercial - Option "
.AddItem "Commercial - Development Agreement "
.AddItem "Commercial - Financing "
.AddItem "Commercial - Planning s.106 "
.AddItem "House Builder - Purchase "
.AddItem "House Builder - Sale "
.AddItem "House Builder - Plot Sales "
.AddItem "House Builder - Option "
.AddItem "House Builder - Development Agreement "
.AddItem "House Builder - Financing "
.AddItem "House Builder - Planning s.106 "
.AddItem "Public Sector - Purchase "
.AddItem "Public Sector - Sale "
.AddItem "Public Sector - Lease "
.AddItem "Public Sector - Secondment "
.AddItem "Public Sector - Planning s.106 "
.AddItem "Public Sector - Development Agreement "
.AddItem "Planning - Not s.106 "
.AddItem "Secured Lending "
.AddItem " ---TECHNOLOGY--- "
.AddItem "Software "
.AddItem "Trademarks "
.AddItem "Copyright "
.AddItem "Confidential Information "
.AddItem "Patents "
.AddItem "Design Rights "
.AddItem "Corporate Support "
.AddItem "Domain Names "
.AddItem "Media "
.AddItem "Data Protection "
.AddItem "e-Commerce "
.AddItem "Outsourcing "
.AddItem "Procurement "
.AddItem "Technology Agreements "
.AddItem "Dealing with the Press "
.ListIndex = 0
End With
With ComboBox2
'Populate Combo box with...
.AddItem " use dropdown or refer to list at doc#218397 "
.AddItem " --- A - AGRICULTURE, FORESTRY AND FISHING ---"
.AddItem " A01 - Crop and animal production, hunting and related service activities"
.AddItem " A02 - Forestry and logging"
.AddItem " A03 - Fishing and aquaculture"
.AddItem " --- B - MINING AND QUARRYING ---"
.AddItem " B08 - mining and quarrying"
.AddItem " B09 - Mining and quarrying support service activities"
.AddItem " --- C - MANUFACTURING ---"
.AddItem " C10 - Manufacture of food & beverage products"
.AddItem " C13 - Manufacture of textiles, clothing & leather"
.AddItem " C16 - Manufacture of wood, paper and related products"
.AddItem " C28 - Manufacture of machinery and equipment n.e.c."
.AddItem " C29 - Biotech & pharmaceutical"
.AddItem " C32 - Other manufacturing"
.AddItem " C33 - Repair and installation of machinery and equipment"
.AddItem " --- D - ELECTRICITY, GAS, STEAM AND AIR CONDITIONING SUPPLY ---"
.AddItem " D35 - Electricity, gas, steam and air conditioning supply"
.AddItem " --- E - WATER SUPPLY; SEWERAGE, WASTE MANAGEMENT AND REMEDIATION ACTIVITIES ---"
.AddItem " E36 - Water collection, treatment and supply (inc. sewerage)"
.AddItem " E38 - Waste collection activities"
.AddItem " E39 - Remediation activities and other waste management services"
.AddItem " E37 - Recycling & Materials Recovery (metal, paper, timber, plastic, special)"
.AddItem " E40 - Hazardous waste"
.AddItem " E44 - Waste treatment and disposal activities"
.AddItem " --- G - WHOLESALE AND RETAIL TRADE ---"
.AddItem " G46 - Wholesale trade"
.AddItem " G47 - Retail trade"
.AddItem " --- GG - MOTOR INDUSTRY ---"
.AddItem " GG41 - Supply and repair of commercial vehicles"
.AddItem " GG42 - Supply and repair of consumer vehicles"
.AddItem " --- H - TRANSPORTATION AND STORAGE ---"
.AddItem " H49 - Land transport and transport via pipelines (inc haulage and logistics)"
.AddItem " H50 - Water & air transport"
.AddItem " H52 - Warehousing and support activities for transportation"
.AddItem " --- I - ACCOMMODATION AND FOOD SERVICE ACTIVITIES ---"
.AddItem " I51 - Accommodation and food service activities (inc hotel and restaurant)"
.AddItem " --- J - INFORMATION AND COMMUNICATION ---"
.AddItem " J18 - Printing and reproduction of recorded media"
.AddItem " J58 - Publishing activities (other than music/sound)"
.AddItem " J59 - Motion picture, video and television programme production, sound recording and music publishing activities"
.AddItem " J60 - Programming and broadcasting activities"
.AddItem " J61 - Telecommunications"
.AddItem " J62 - Computer programming, consultancy and related activities"
.AddItem " J63 - Information service activities"
.AddItem " J52 - Internet/e-commerce activities"
.AddItem " J53 - Software publishing and distribution"
.AddItem " --- K - FINANCIAL AND INSURANCE ACTIVITIES ---"
.AddItem " K54 - Banking and financing activities"
.AddItem " K64 - Financial service activities, except insurance and pension funding"
.AddItem " K65 - Insurance, reinsurance and pension funding, except compulsory social security"
.AddItem " K66 - Activities auxiliary to financial service and insurance activities"
.AddItem " --- L - REAL ESTATE ACTIVITIES ---"
.AddItem " L68 - Real estate investment"
.AddItem " L55 - Housebuilders"
.AddItem " L56 - surveyors, estate agents"
.AddItem " L41 - Construction of buildings"
.AddItem " L42 - Civil engineering"
.AddItem " L43 - Specialized construction activities"
.AddItem " L57 - Building supplies"
.AddItem " --- M - PROFESSIONAL, SCIENTIFIC AND TECHNICAL ACTIVITIES ---"
.AddItem " M69 - Legal activities"
.AddItem " M05 - accounting activities"
.AddItem " M70 - Activities of head offices; management consultancy activities"
.AddItem " M71 - Architectural and engineering activities; technical testing and analysis"
.AddItem " M72 - Scientific research and development"
.AddItem " M73 - Advertising and market research"
.AddItem " M74 - Other professional, scientific and technical activities"
.AddItem " --- N - ADMINISTRATIVE AND SUPPORT SERVICE ACTIVITIES ---"
.AddItem " N77 - Rental and leasing activities"
.AddItem " N78 - Employment activities"
.AddItem " N79 - Travel agency, tour operator, reservation service and related activities"
.AddItem " N80 - Security and investigation activities"
.AddItem " N81 - Services to buildings and landscape activities"
.AddItem " N82 - Office administrative, office support and other business support activities"
.AddItem " --- O - PUBLIC ADMINISTRATION AND DEFENCE; COMPULSORY SOCIAL SECURITY ---"
.AddItem " O83 - Local authority"
.AddItem " O84 - Other public sector"
.AddItem " --- P - EDUCATION ---"
.AddItem " P85 - Education"
.AddItem " P86 - Childcare"
.AddItem " --- Q - HEALTHCARE ---"
.AddItem " Q87 - Residential care activities"
.AddItem " Q88 - Social work activities without accommodation"
.AddItem " Q75 - Veterinary activities"
.AddItem " Q06 - Dentistry activities"
.AddItem " Q07 - Retail Pharmacy activities"
.AddItem " Q11 - GP Surgeries"
.AddItem " --- R - ARTS, ENTERTAINMENT AND RECREATION ---"
.AddItem " R90 - Creative, arts and entertainment activities"
.AddItem " R91 - Libraries, archives, museums and other cultural activities"
.AddItem " R92 - Gambling and betting activities"
.AddItem " R93 - Sports activities and amusement and recreation activities"
.AddItem " --- S - OTHER SERVICE ACTIVITIES ---"
.AddItem " S94 - Activities of membership organizations"
.AddItem " S95 - Repair of computers and personal and household goods"
.AddItem " S96 - Other personal service activities"
.ListIndex = 0
End With
End Sub

Thank you for taking a look, any help will be gratefully recieved!
Kind Regards,

Andi

Mar 28 '08 #1

Subscribe Post Reply

1980

debasisdas

8,127

Expert 4TB

Question moved to Vb forum.

Mar 31 '08 #2

Similar topics

Selected From Combo Box or Typed In?

by: Support4John | last post by:

a2k (9.0.6926) SP-3 Jet 4.0 SP-7 I have a form with combo box field that allows the user to select from the combo box or type in the field value that may or maynot be in the combo box field. ...

Microsoft Access / VBA

Problems with Structuring a Combo Box Row Source

by: Dalan | last post by:

Sometime ago I had inserted two Combo Boxes on a form (cboCustomers) and (cboVendors) to lookup values in separate tables. They have worked fine except now I want to increase their usage by...

Microsoft Access / VBA

Query abt Combo box

by: Raj | last post by:

My name is Raj. I am working on C#. I am facing a problem in Combo box SelectedIndex property... The problem is... On a form I have a tab control of 2 tab pages. On the 1st tab page I have a...

C# / C Sharp

Is there a drop down combo with multi check box

by: Aussie Rules | last post by:

Hi, I want to have a single line combo box dropdown, but where i can selected multiple items in the drop down via a check box... I can see one in the standard tool box... is there one ? If...

Visual Basic .NET

Combo box, command button placement questions

by: Kevin | last post by:

A couple of easy questions here hopefully. I've been working on two different database projects which make use of multiple forms. 1. Where's the best/recommended placement for command buttons...

Microsoft Access / VBA

Open word files using combo

by: jpr | last post by:

Hello, I have a form with a cbo which get's its data from a table. This combo returns names of MS Word files in the following path: C:\shares\files\*.dot I would like to open these files...

Microsoft Access / VBA

Combo Box as Criteria for Select Query

by: jjyconsulting | last post by:

Newbie needing some help. I have a tblParticipants. The fields include gender, education_level, income, occupation etc., I'm trying to create a form where a user can run a query from the form and...

Microsoft Access / VBA

Combo Boxes in Datagrids

by: Ausclad | last post by:

Ok, ill try again..... It seems fairly simple. I have two combo boxes in a datagrid. The datagrid is bound to a a table in a dataset. The two combo boxes are bound to a single data table...

Visual Basic .NET

Open a given document based on selection within combo box

by: blyxx86 | last post by:

Alright, I'm trying to create a form that would allow certain documents to be opened by selecting an option within a combo box and then having a single button to open the pertaining file. I know...

Microsoft Access / VBA

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General