Using Access To Create Document From Multiple Choice Options

Mar 23, 2013

I currently write (very long) reports for work, which have a lot of standard text in them - but the standard text varies according to the client's history.

I want to create a report-writing application for myself, composed of series of yes/no/maybe buttons
and depending on whether I click yes/no/maybe in each section, a different segment of text is inserted into the report.

Ideally the application would be able to insert, or create, formatted text - such as headings, bullet point lists etc - I would need to be able to export this report into Word

I started out by making a table, with each section being a different field, and the various paragraph options as different cells in the field, but I am stuck at present on the basic functionality of "click button , insert text"...

View Replies


ADVERTISEMENT

Use Access To Open Word, Create A NEW Document, And Then Edit The Doc

Dec 11, 2004

I want to create a new word doc, do a saveas to a specific path and file name, allow the user to edit the new doc, and then close it and return to the Access app. I can create the doc but Word opens without opening the New Savedas Doc. using this code

Dim oApp As Word.Application
Dim WordDoc As Word.Document
Set oApp = CreateObject("Word.Application")
Set WordDoc = CreateObject("Word.document")
oApp.Visible = True
WordDoc.SaveAs ("TS-" & Me.Scriptnum & ".Doc")

Your help is appreciated.

View 1 Replies View Related

Forms :: Build Up A Database For Multiple Choice Questions Quiz In MS Access 2010

Aug 23, 2014

I'm trying to build up a database for Multiple choice questions quiz in MS access 2010.My requirement are as follows

My quiz consist of 15 questions. Each questions carry some weightage. Suppose a question carries a weightage of 5 and there are two correct options like A & C. If user selects option A then he gets half marks.Multiple users can access the test at the same time.

View 1 Replies View Related

How Do I Create Mutiple Choice Questions

Apr 21, 2007

I'm making a project in VB, and I need it to link to a Database,I already know how to do this
the project is a bit like who wants to be a millionaire with all the questions in an access table,
I know I need the following fields;

the auto number
the question
Answer A
answer B
answer C

the problem is I need to be able to select which answer is correct ?

View 1 Replies View Related

Create Recordset From Combo Choice

Jun 2, 2005

I have a table called Contacts and a form with two combo boxes for searching for records either by name or property name. The following code works fine for finding the first record, but I want to be able to show on the form all (and only) those records which match the combo box entry. Currently rowsource for name box is:
************************************************** *
SELECT [Last Name1] FROM Contacts UNION SELECT [Last Name2] FROM Contacts
ORDER BY Contacts.[Last Name1];
************************************************** *
and code is:
************************************************** *
Private Sub Combo214_AfterUpdate()
' Find the record that matches the control for Last Name search
Dim rs As DAO.Recordset

Set rs = Me.Recordset.Clone
rs.FindFirst "[Last Name1]= '" & Me.[Combo214] & "' OR [Last Name2]= '" & Me.[Combo214] & "'"
rs.FindNext "[Last Name1]= '" & Me.[Combo214] & "' OR [Last Name2]= '" & Me.[Combo214] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Combo214.Value = ""
txtFirstName1.SetFocus
End Sub
************************************************** *
Rowsource for property box is:
************************************************** *
SELECT Contacts.PropertyID, Contacts.PropertyName
FROM Contacts
ORDER BY Contacts.PropertyName;
************************************************** *
and code is:
************************************************** *
Private Sub Combo212_AfterUpdate()
' Find the record that matches the control for Property Name search
Dim rs As dao.Recordset

Set rs = Me.Recordset.Clone
rs.FindFirst "[PropertyID] = " & Str(Nz(Me![Combo212], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Combo212.Value = ""
cboPropertyName.SetFocus
End Sub
************************************************** **

Any help is appreciated!

View 7 Replies View Related

Multiple Choice

Feb 14, 2008

I have a query which check assignement of vehicles.
Is it possible to have combo box with all employee names ,and acording to that choice to execute query.
So when i open my report I want to be asked to pick name of 1 employee in drop down menu and then get his records.
If its doable please be gentle cause i am new in all this
thx

View 3 Replies View Related

Multiple Choice Parameters???

Apr 22, 2008

I'm trying to setup a parameter that has a multiple choice so to speak. Rather then the user being able to enter whatever data they want.. I would like them to have a choice between two items.

Is it possible? if so.. how do I do it?

Thanks!

View 14 Replies View Related

Test: Multiple Choice Template

Feb 18, 2006

Can any one do this i need it real fast let me know!!

View 5 Replies View Related

Multiple Choice In A Single Field

May 20, 2013

I have question regarding multiple choices fields. I would like to store constrained but multiple values in a single field. I used the assistant to create the multiple choice field in the table, but I'd like to have it displayed in my form with check boxes (more readable in my tabular form) instead of drop down list. Is it possible ...

View 6 Replies View Related

Create Relationships Within Document Distribution List

Sep 9, 2011

I am brand new to using access databases but I am in the midst of trying to set one up for controlled distributions of controlled documents.Essentially, I have three tables:

1) Listing of all our controlled documents and their properties (doc number, doc title, doc revision, doc type, doc status, effective date),
2) Listing of all our copyholders (name, location, phone number),
3) Document Distribution List which lists copy numbers, quantities, and medium to deliverable (paper, electronic, size, etc)

What I want to do is create relationships within the Document Distribution List (using 'add from existing fields') from the other two tables so when a request for a new controlled copy comes along, I don't have so much data redundancy.

For example, in Table 1, I have listed Document XYZ and copyholder Jane Doe from Table 2 wants to receive 1 copy of Document XYZ. I would like to have Table 3 have an added field from Table 1 where I can pull down the applicable document number, which when selected auto fills out it's corresponding details of title, revision, doct type, status and effective date in this Table 3. In addition, after I select the document Jane wants, I want to have another field added to Table 3 from Table 2 which lets me pull down Jane's name to assign her a copy number.

View 1 Replies View Related

Forms :: How To Create Custom Menu Options In 2010

Sep 15, 2014

How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.

View 3 Replies View Related

How To Create A Report Imported From Word Document And Email It As PDF

Nov 12, 2014

I have a template letter in Word that I want to import into Access, so when I choose from a combo box an employee's ID, it automatically displays a report using the Word document template and filled with all related information of that employee (name, nationality, etc.) + it shows today's date. Then I can Save&Email to an Outlook contact.

View 2 Replies View Related

How To Create Multiple Records In Access

Jan 5, 2012

I am relatively new to Access and have a simple database which I use to generate Publication numbers for our new publications. I would like to have a text box and button on a form that will generate duplicate records of the current record the same number of times as specified in the text box.

E.g. If I need 6 copies of a record I would like to enter 6 in a text box, click a command button that will generate 6 duplicates of that record.

The code in order to do this 'on click'.

Table = Publications
Form = Publicationsfrm
Text Box = Lines
Command Button = Submit
Primary Key = PublicationNo

I have tried the following code but it is not working.....

Dim i as Long, myRS as Recordset
Set myRS = CurrentDB.OpenRecordset("Publications")
For i = 1 to Me![Lines]
With myRS
.AddNew
![PublicationNo] = Me![PublicationNo]
.Update
End With
Next

Alternatively if I have a duplicate record button that uses a macro is there a way to run that macro the specified number of times in the 'Lines' text box.

View 14 Replies View Related

Use Access To Create Email To Multiple Recipients

Dec 18, 2007

Hi,

I'm not sure which Form topic this post should go under ...

I have an Access Database which contains contact information including email addresses in a number of tables. Each table is a reference group of individuals interested in a particular topic and has three fields (contactID, name and Email). All tables relate back to a master address list.

This allows me to have different (or multiple) people from within the same master address as contact persons for different reference groups. When I am doing labels, or printed reports for labelling I simply combine the address from the master list with the conact from the reference group list.

I would like to be able to replicate this approach for e-mail messages.

Ideally the databse would create distribution lists and export these to outlook global address list where they would be available to all users.

Alternately, I would write a module that automatically generates a new email message with all the Email Address entries from a user selected table in the To: field. The user would then edit the email message and press send.

It seems to me that eitehr way I will need to somehow concatenate all emails addresses in a table into a list separated by semi-colons.

View 1 Replies View Related

Using Multiple Search Options

May 14, 2006

Hi guys,

I made a form to search some values in a table and print them in a report.
The form looks like this:
http://www.minezone.nl/jamie/search.bmp

When clicking the "show report" button a macro is executed. In this macro I have the following code:

OpenReport -->
Report name: main
View: print preview
Where condition: [name]=[Forms]![searchfeedback]![namebox] And [week]=[Forms]![searchfeedback]![week]

Now what I want is a bit difficult.
I want to give users the ability to search by each option and by using multiple options.
i.e.
- When filling in the name and click the show button it gives all reports for that person.
- When filling in the name and selecting the weeknumber it gives all reports for that person in a particular week.

and so on with the id field, the date field and the supervisor field.

How do I create something like that?

View 3 Replies View Related

Multiple Options To Find Criteria

Jan 19, 2006

I'm building a database with supplier information. Some users prefer to use the supplier names, but it is sometimes hard know how foreign suppliers are spelled, therefore some users prefer to use supplier numbers.

I want my form to show all supplier data based on either the supplier number or the supplier name, which can both be chosen from 2 comboboxes.

In addition, and here's the catch, I would also like the two comboboxes to update eachother. So if I choose supplier 2 in the first box, the other box should automatically show me the name of vendor 2 and vice versa.

I think the example form shows my problem best ..

View 4 Replies View Related

Modules & VBA :: Filter By Form With Multiple Options

Jul 23, 2014

I am using Select Case to filter a form on open and it works fine when I have this:

Code:

Case Is = 2
Forms![Open Opportunities List].Form.Filter = "[Employee] = 4"
Forms![Open Opportunities List].Form.FilterOn = True

But if I want the form to open filtering multiple employee records, like this:

Code:
Case Is = 6
Forms![Open Opportunities List].Form.Filter = "[Employee] = 2 & " And 9 & " And 10 & " And 11
Forms![Open Opportunities List].Form.FilterOn = True

I get a type mismatch error and I am stumped as to why and how to overcome.

View 14 Replies View Related

Tables :: Autofill Fields - Multiple Options

Nov 6, 2012

I am creating an access database for my employer which handles blood donating at different venues. I have come unstuck with a particular request.

They would like to create 3 autofill fields for "dates", which are dependent on the previous field "Venues"

There are different venues, which are visited 3/4 times per year. This data is stored in a separate "Venues" table.

On the main user form, they would like to see the dates available to donate, when the Venue field is selected (this is an autofill box, from the Venue table). So if the London venue is visited on 1/1/13, 2/2/13 and 4/4/13. When the user types London into the "Venue" field then the next 3 cells auto fill with 1/1/13, 2/2/13 and 4/4/13.

View 6 Replies View Related

Opening A Word Document Within Access

Sep 14, 2006

I've used the Outputto method to archive reports creted in Access to Word in .rtf.

I now want to have an option to view these archives from Access. How?

Thanks,

Richard

View 2 Replies View Related

How To Open A Word Document From Within Access

Jan 4, 2007

I am creating a database for someone which includes a mail merged document with some data from the database.
Is it possible to allow the user to open the document by clicking on a button that will be on the Switchboard in the database, so that they do not have manually open the document?
Hope this makes sense!

View 5 Replies View Related

Program That Document Access Applications

Jul 3, 2007

I have seen advertised a number of programs whose developers claim the program will document an application for you.

They're relatively expensive - several hundred $ as I recall. But if they work, it could save many days of headaches.

I was wondering if anyone had used them, if you'd recommend them etc.

View 3 Replies View Related

Calling A Word Document From Access

Aug 26, 2004

When I click a button, I am creating a table for a mailmerge and then calling the document that merge is in so I can write letters.

Everything works properly except the line for calling a document. I've messed with it in several ways but right now it tells me I need an equal sign. Can someone who actually knows VB (I'm just pretending! ) look at this and tell me what might be wrong?

Shell("C:Program FilesMicrosoft OfficeOffice10WINWORD.EXE", "\documentsOfficesJudicial & Court ServicesJudicial CollegeShared Project FoldersTemplatesLetters & AccessoriesConf Letter Mail Merge.doc")

Thanks!

View 14 Replies View Related

General :: Access Document Tabs

Nov 9, 2012

I have a problem with the way my forms are opening.The problem is with the document tabs, not the in form tabs.Basically the database will open the login screen (Modal & Popup) on load, after a successful login the user is redirected to a diary events page and the login form closes, then a user can select an ID (hyperlinked) which will open up a popup/modal form for more details and then if they want they can click a button within the popup which will view all client details.

I use VBA to close any popup/modal forms and open the Main Client Screen, at this point there are only 2 forms open in Single Form format, which is the diary events page and main client screen.The problem is once you click "view client" and the form opens, it defaults to the diary events tab, so the client screen is opening behind the diary events form, you then have to click the document tab for "client screen" to be able to view the form, which is a minor issue but annoying still.

View 1 Replies View Related

Modules & VBA :: Format PDF Document Sent From MS Access

Sep 23, 2013

Is it possible to format a PDF document created in MS Access i.e. set the document to landscape instead of portrait as in the following code;

DoCmd.OutputTo acOutputQuery, "Query Name", acFormatPDF, "Document Name", False

This PDF document is attached to an MS Outlook e-mail and sent without any intervention from the user. This is accomplished using further VBA code. This code is working at the moment sending both Excel spread sheets and PDF documents but the PDF's require the page formatting before sending. I want to be able to accomplish this without having to open another application such as Adobe Acrobat.

View 3 Replies View Related

Merging Word Document With Access Query

Feb 7, 2006

Apologies ... but I am quite new to Access. My database contains about 1000 peoples' addresses.

The problem I have is that I need to merge, say, 20 of these addresses into a word document. In the word document I can select records using the "Surname" field but it will not give me the option to select more than 6.
I am sure there must be a way that I can select more than 6: I have tried separating the surnames with a "," or "or" but nothing seems to work!

Help, please!

Thank you,

Emma

View 3 Replies View Related

Looking For Advice About Using Access As A Document Retrieval Tool

Mar 1, 2006

Our organization (a University) has been engaged in becoming "paperless."

As part of that initiative, we have spent the past several months scanning several hundred thousand pages of documents relating to building systems (HVAC, e.g.) as well a a massive quantity of detailed lead and asbestos surveys and abatement records.

The initiative is indeed reducing the quanity of paper stored in binders and file cabinets, however now it is becomming evident that retrieving some of that information is a real problem for some folks.

At a meeting this morning a question arose about whether we could develop an Access application to retrieve the documents (which are very logically filed on a network share, but it seems to be beyond the compreshension of some staff how to actually navigate through the maze).

My question is this: has anyone in this forum ever tried to implement such a solution with Access?

Any advice or insight would be very much appreciated.

Thanks in advance.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved