Combo Box within Word .DOC problem becoming a .DOT

1 New Member

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 "Shareholde rs Agreement "
.AddItem "LLP conversions "
.AddItem "LLP agreements "
.AddItem "Reorganisation s "
.AddItem "Distributi on 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 "Constructi on Disputes "
.AddItem "Supply of Goods & Services Disputes "
.AddItem "Purchase of Goods & Services Disputes "
.AddItem "Shareholde r/Business Ownership Disputes "
.AddItem "General Commercial Contract Disputes "
.AddItem "Property Disputes "
.AddItem "Commercial Agency Disputes "
.AddItem "Judicial Review/Public Law "
.AddItem "Insolvency "
.AddItem "Contentiou s Intellectual Property "
.AddItem "Miscellane ous 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 "Confidenti al Information "
.AddItem "Patents "
.AddItem "Design Rights "
.AddItem "Corporate Support "
.AddItem "Domain Names "
.AddItem "Media "
.AddItem "Data Protection "
.AddItem "e-Commerce "
.AddItem "Outsourcin g "
.AddItem "Procuremen t "
.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 - Telecommunicati ons"
.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 Reply

2006

debasisdas

8,127

Recognized Expert Expert

Question moved to Vb forum.

Mar 31 '08 #2

Similar topics

3558

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. In the After Update Event of the combo box field how can I tell if the field value was selected from open combo box or typed in by the user? Thanks, John

Microsoft Access / VBA

1596

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 changing the Row Source to include any changes made in the Customers and Vendors tables to be reflected in the associated fields on the form (frmAccounts). An example would be changing or correcting the spelling of a Customer or Vendor name. Currently...

Microsoft Access / VBA

1239

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 combo box populated from database and selectedindex is set to -1. When the form is loaded the combo box is populated on the 1st tab page. At this point of time if I go to 2nd tab page and come back combo box is set to -1 as it was when the form was...

C# / C Sharp

14833

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 not any suggestions as to where to get one from.

Visual Basic .NET

4976

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 for things like delete, save, edit, cancel buttons - in the footer, or on the form detail section? 2. If in the footer, how do you add them to the tab order?

Microsoft Access / VBA

2871

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 (actually it should open a copy of the template and not the dot file itself) using the OnChange event of my cbo. Is there a way or some code to help me? Thanks

Microsoft Access / VBA

3705

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 just choose the appropriate criterias from the combo boxes to get the results. I also want the query to run even if there is not a value in all the combo boxes ie., i want just all males with income level of over $100,000...Any insights or help...

Microsoft Access / VBA

1854

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 in a different dataset. One combo box is displaying the Employees payroll ID. The other is

Visual Basic .NET

5604

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 how to have it open an excel document (or word, etc.) but do not know how to define which document to open. Dim ExApp As Object Set ExApp = CreateObject("Excel.Application") ExApp.Workbooks.Open FileName:="c:\file.xls",...

Microsoft Access / VBA

10340

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10327

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10085

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7625

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5527

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5663

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4302

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3828

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2999

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General