General :: Word Report Controlled By Form
Jun 17, 2013
I have a word 2010 reports that is linked to an access 2010 form. SQL is used to populate the report with some of the fields from the form. Is it possible to create a combo-box with two selections (Mike, Paul) in it. And then have two other fields populate based on the selection in that combo-box? For example, if Mike is selected then an Address: and Phone Number: fields are filled in with his information. And if Paul is selected his information fills in.
View Replies
ADVERTISEMENT
Sep 5, 2013
I am having an issue with a database application I created. I needed to add another query that could be controlled from combo box on a nested form.
The combo box is for dates for entries in a table. Which then filters the query based on the combo box selection. Easy enough stuff.
The problem I am having is that when I try to use the combo box as a criteria for the query using;
[Forms]![MasterForm]![NavigationSubform].[Form].[comboBox]
Access closes and wont let me use the reference to the combo box.
What has happened? Corrupt database? How do I fix it?
View 9 Replies
View Related
Apr 20, 2014
I have a company logo that has 2 colours to its name
I want to put that logo onto me report. I have tried but I am unable to do this
company name APICAPACITORS, API IN RED CAPACITORS BLUE ,is it possible without making 2 words
View 1 Replies
View Related
Jun 17, 2013
Is there a way to export a query of 14 items to a word report. I have a table of 14 items in that I use as a query but it only exports 1 item to the report.
View 2 Replies
View Related
Jul 10, 2014
How do I export report or table to word document with check box so people can check them and send to me back. I can change my records.
For example
Delete ITEM
5540 (Chick box goes here, they can tick)
View 5 Replies
View Related
Oct 3, 2007
Hi
I have been trying to set up this query via VBA code but, with no luck, have gone back to the query in design view. Basically the parameters of the query are determined by combo boxes in a form. This is fine if one combo box indicates one criteria but a problem arisis when multiple combo boxes are possible parameters for one field.
i.e. Field 1 = combo box one
field 2= combo box two
field three = combo box three, four or five.
i have found it difficult running this, especially in terms of a returning all if a combo is left blank. the problem with setting this up on field three would be that if i run combo box four and five to return all if left blank it overides the other command to set a specific parameter. Also, for some reason i can tdecide whether this is an AND or OR command, its actually both i.e. Field three parameter = combo box three and/or combo box4 etc...
please help this is driving me crazy.
Thanks
Shapman
View 14 Replies
View Related
Nov 5, 2004
I have created a report in MS Access. When I choose the option to Publish to MS Word, I loose all of the background colors. Is this correct or am I doing something wrong? Is there a way to maintain all of the Format features when I publish?
View 1 Replies
View Related
Aug 2, 2013
I'm trying to add the information from a form and subforms to a report. This would be a medication mar sheet and needs to be in the format of the attached word document. I'm happy to do it in a report and change the formatting if that will work better. The personal info needs to go at the top and the medication needs to be listed on each sheet.
The form is called FrmMarSheet. It basically needs the info from that like the "sample mar sheet.doc". I can only get one medication per page to work at the moment.
View 1 Replies
View Related
Jul 9, 2013
I want to have information on a form tab. Is it possible to insert a Word document in the tab? This will consist of a set of instructions for the user.
View 4 Replies
View Related
Mar 3, 2013
I have an access form that fills an access table (MS Access 2003). Also, I have a Word (2010) document/template with some template text and empty fields which should be filled with data from access. Is it possible to insert a button in access form which would open a word document and populate appropriate fields with data from that form?
View 4 Replies
View Related
Jul 10, 2013
I am trying to open a word document with corresponding data filled from the text field of a form. I managed to get the word document but I don't know how to give a variable in word document.
View 2 Replies
View Related
Jun 3, 2014
I'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "
how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error
Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work
View 2 Replies
View Related
Jul 15, 2005
Hi all im new to this and im trying to make a from that will display a sub from containg infomation that can be changed by altering a combo box.
im not sure if its possible but i want to have the combo box containing names of people and then the sub form to display records that relate just to the selected person. and when the combobox's selection changes so does the displayed data.
i don't know if its possible to make a dynamic query that will take the text value in the combo box and use it in a query to query the data i have. and then produce just the data corisponding to one person. :eek: :confused:
ANY HELP on this would be greatly appreaceated. i have a feeling thatis simple but i have been pulling my hair out trying to find out how to do it. :confused:
View 14 Replies
View Related
Jul 29, 2005
sorry for the repeating of a previous thread but i have looked at all of the replys on the first combo box controlled query and have followed what was reccomended but i still have some problems. :(
i have three combo boxes and i want to query a single table with the selected combo options.
atm i am using the criteria part of a query to filter the results by the combo box
[forms]![Form1]![cboStaff]
this works well for one thing but when i want two i have put them in line which means AND so both combo boxes have to have a value in and then the query looks for combo box ones value with combobox 2's value.
is there any way i can make the value in the second combo box mean any result. which would effectivly turn the query into a search for just the first criteria set by the combo box???
please help i have been going round in circles trying to figure out how i am going to do this :confused:
View 4 Replies
View Related
Apr 11, 2008
I've created a rather simple Access program that I use to import an employee's cookie summary txt file. I then sort the cookies for 1) time of day, and 2) appropriateness.
I found a way to create the queries - in simple design mode using criteria - but I want system administrators in other offices to be able to enter the time of day variables particular to their offices. Same with appropriate words. So I want a form they can use to do that - eg, list their office's break times. In essence, a setup page. Then the resulting queries (time of day and word list) will be customized to the particulars of that office rather than to mine.
Would appreciate some ideas on how to do this. Should I read up on SQL? Should I learn VBA? I'm trying to get around having to tell the other system administrators to go into each query and change the criteria manually.
Thanks!
View 6 Replies
View Related
Sep 21, 2004
is there a way to output a crosstab query to some kind of report, either a built in report or a Word doc.
i have searched for ages but just want a simple tool to do this.
View 1 Replies
View Related
Apr 10, 2014
I have a Report that contains, among other things, Pictures & Check Boxes. When I try to export into a Word (.rtf) document,the Data exports just fine, but the pictures & check boxes are lost. Is there a way to export the Report into Word keeping all formatting intact?
View 3 Replies
View Related
Jan 15, 2007
First, thanks to all that have helped me with out even knowing it! This forum is a lifesaver.
Problem:
I have a control button that, through macro commands that seem to be working, changes a field value from locked=no to locked=yes. This macro control also changes the enabled setting to = false.
When I save and exit the form, upon reopening, the above cell value is not saved. Is there a simple fix for a simple-minded person?
Thanks in advance
View 5 Replies
View Related
Apr 6, 2005
Currently, I have a button on my form that users can click on to generate a report based on the info from the form. Once the report has opened, they publish the form with MS Word for further edit if needed.
How do I set up the button so that it opens the report then automatically publishes the report with MS Word?
View 1 Replies
View Related
Feb 27, 2014
Is there a way to export a report from Access into Word so that it keeps all its formatting etc. The only option shown is in RTF format.
View 2 Replies
View Related
Jan 11, 2014
I want to insert access report in a word document, for this, I use this code:
DoCmd.OutputTo acReport, "rptName", acFormatRTF, "C:ReportFileName.rtf"
But, when that output word file is empty, don't have any chart that was in access report.
View 6 Replies
View Related
Sep 23, 2013
I need to create a form that automatically populates Dealer_ID in my Customers table when a user selects Dealership from a dropdown box.
The form is updating all of the user controlled fields in the Customer table as the user inputs the information. I have a separate Dealership table who's Primary Key is Dealer_ID where dealership information (including the dealer name) is stored. A one to many relationship is in place that connects Dealer_ID from the Dealership table to the same field in the Customer table. The user inputting the information will know what the dealership name is but will not know their ID. I need a solution that will allow the user to select a dealership name in the form and auto-populate the Dealer_ID field in the Customer table with the appropriate ID from the Dealership table.
View 1 Replies
View Related
Oct 30, 2014
I want to attach a pdf file at the end of my word document by clicking a button from form.
View 3 Replies
View Related
Jul 16, 2012
Iv added a 'subform/subreport' to one of my forms.I wanted to use this to display a report. Therefore i assumed that i would simply set the source object to my desired report and hey presto! But no, when i look in the source object drop down list, my report doesnt appear.how i can display a report within a form??
View 1 Replies
View Related
Apr 10, 2015
I have a report that groups by a project name and then a repeating field to list all associated detail having to do with the project. Then the projects loop to the next.Each project row is the same height as the combined detail rows. And to be able to print guidelines just as you would with a word table.
+-------+-----------------+---------+
| Project |.-detail row 1......| Open.....|
|...........|.-detail row 2......|.............|
|...........|.-detail row 3......|.............|
+-------+-----------------+---------+
This is what currently happens.
+-------+-----------------+---------+
| Project.|.-detail row 1......| Open.....|
+-------+-----------------+---------+
............|.-detail row 2......|
............+-----------------+
............|.- detail row 3......|
............+-----------------+
I'm thinking I need to do it with vba putting each into a variable then set the field to be the value of the variable. but i'm also not sure how to do that as it repeats like that.
View 8 Replies
View Related
Jun 26, 2014
I want to open a simple report (restricted to the current record) but I need it as a editable MS Word file, (not printed or pdf, etc.)
Quote:
Private Sub MyReport_Click()
Dim stDocName As String
Dim strWhere As String
[code]....
I've tried several combinations of vba..I'm using Microsoft Access 2007
View 3 Replies
View Related
