General :: How To Make MCQs Paper Query And Report
Dec 1, 2012i have made table to store mcq questions. i need to know how can i select random mcqs from table and print using reports to take tests..
View Replies
ADVERTISEMENT
Paper Size On A Report
Feb 8, 2013My Access 2010 application has many reports. On almost every report, the user can select a new paper size. This paper size is remembered, so the next time the user selects the same report, he no longer have to set the paper size (I guess this is the default behavior for Access programs).One report does not behave properly. This report is a LEGAL size report. EVERY times the user selects this report, it prints on LETTER size, so the form is split in two pages. If the user selects teh LEGAL size paper, it works, but the next time the report defaults back to LETTER size paper.
I checked everywhere in the code, nowhere the paper size is set. In development, I selected the report, I changed the paper size to LEGAL, I ran the report. The next time I check the paper size of the report, it is back as LETTER size.After my OpenReport statement, I tried manally setting the paper size with "Reports(xxx).Printer.PaperSize = acPRPSLegal" but my report still defaults to LETTER size paper.
Reports :: How To Specify Paper Size By Page In A Report
Aug 8, 2013I need to have the last page of a report in access print to an 8.5x11 instead of 11x17 (the rest of the report has to print 11x17). No clue how to set it up so it's automatic...
View 2 Replies View RelatedGeneral :: How To Make A Report Using Crystal Report Direct From MS Access Form
Jun 3, 2014I'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
Printing A Two Page Report On Both Sides Of A Piece Of Paper
May 11, 2005Hi,
I have a two page report (it is formatted to always be exactly two pages) and I need to print it on the front (page one of the report) and on the back (page two of the report) of the same piece of paper. The less user input the better.
Is this an Access thing or a printer thing (We have a HP 6P).
Anyone doing this ???
Thanks
Mike
General :: Access To Display Paper Clip Icon
Dec 21, 2012I am using the attachment field in my form in Access 2010. I downloaded a picture (a picture of paper clip) from the web to use it as the display image for the attachment field. When using the form, the paper clip picture is displayed so long as there is no attachment. When a file is attached, the display image changes to the type of file (in my case pdf). However, I want Access to display the paper clip icon.
View 1 Replies View RelatedGeneral :: Setting Printer Paper Size To User Defined
Feb 18, 2014I want to set my paper size to user defined, but it not working,
<<<<<<<<<<<<<<<<<<<<<<<<<<
Set Application.Printer = Application.Printers("P1121E")
Application.Printer.PaperSize = acPRPSUser
Application.Printer.ItemSizeHeight = 9.35 Application.Printer.ItemSizeWidth = 26.9
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Showing "Run time error "2595"
"Cannot set this property when defaultsize property is set to true"
I try add "Application.Printer.Defaultsize = true or false" also not working
Make Table Query In A Report
Oct 31, 2005How can I get a make-table query to run in a report?
View 6 Replies View RelatedUse Query Results From Report To Make Table
Aug 2, 2006Hello,
I have a query that prompts the user for input to generate a report.
I would like to in essence copy that same record set and append it to a different table (archive table).
Not quite sure how to go about it.
Thank you
Queries :: Validating A Query To Make A Report
Feb 20, 2014I am making a football database for my sixth form project. It consists of 6 teams and i need to make a top scorers report for each team. I am attempting to make a query for each report which will consist of the fields needed, under the field 'Team Name' i need to validate it for each team so that each query only shows their specific team, then i can make it into a report. But i do NOT know how to validate it. In human words i want it to say something like this " Only include this player if value of the team name if it is equal to 'St.Albans city east' (one of my teams)".
View 1 Replies View RelatedReports :: How To Make Report Autoupdate With Crosstab Query
Mar 26, 2013I made a report with following crosstab query.
TRANSFORM Workersdetail.workername AS CountOfedate
SELECT Workersdetail.[attendance], Count(Workersdetail.[edate]) AS [Total Of edate]
FROM Workersdetail
GROUP BY Workersdetail.[Workername], Workersdetail.[attendance], Workersdetail.[workerhourenter]
PIVOT site+Cstr([workerhourenter])
I wanted to know that, is there any option through which my report gets autoupdate or refresh incase of addition in SITE field (as mentioned with PIVOT)?
General :: Counting In Access On A Make Table Query
Apr 25, 2013counting in access on a make table query.I work for a recruitment company, and have a table for the vacancies we raise. I then have a table linking to this where you can record the candidates submitted for each role. The 'CVSubmitted' and '1stInterview' are a check box yes/no. I now want to run a query where I have a sum of the total number of CV's and 1st Interviews for each role.
View 1 Replies View RelatedGeneral :: Records Using A Select Query That Is Sending To A Make Table
Feb 25, 2015I have records using a select query that I am sending to a make table. I would like to have those records excluded from being used again for 180 days, at which point they can be used again. Essentially, I have an ID and an email address which gets stored in the Make Table. I would need to ensure that if we send an email out in Week 1, we do not send an email again for another 180 days if there is activity from that same ID. On day 181, the ID/email address can then be resent.
View 6 Replies View RelatedPaper File Tracking DB
May 30, 2007Hi there,
I知 new here so don稚 shoot me if I知 asking something that is inappropriate. I知 looking to make a DB for paper file tracking simular as you would expect in a law firm.
I don稚 want to reinvent the wheel so I知 asking if someone has built something like this before. I知 also looking at barcode ID which I have no experience with at all.
Is there someone out there that can put me on the right path?
Cheers,
Renoir
Populate A Database Via Scanning In A Paper Form?
May 18, 2005Hi folks,
Just wondering if it is possible to populate a database by scanning in a form into a scanner? For instance, if I had a standard paper form with typed data inside of the paper form's fields, to place that form into a scanner and have a program extract the characters in each one of the fields and place them into the appropriate fields in a database. I have heard of some agencies doing this, but don't know the names of software packages that would make this possible. Can anyone suggest some software packages or methods of doing this?
Thank you,
Joe
Reports :: Labels Printing On Half Used Label Paper?
Jun 10, 2013I have a report that should print on labels ready to be stick on a book, but how can I tell the report to start from 3th row 2nd column so I do not waste any labels?
View 4 Replies View RelatedGeneral :: Make A Copy Of BE File Rather Than To Make A Copy Via Code
Nov 26, 2012Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code?The user can then just paste over the original if it becomes corrupt.
View 4 Replies View RelatedGeneral :: Search Query To A Report?
Jul 25, 2012I was wondering how do you get the the search results of a query to display on a pre set report, by clicking on a button on a form?
View 3 Replies View RelatedGeneral :: Creating Report Or Query
Nov 9, 2014I am quite new to MS access and started to develop a small database for my practice. I have made four tables that are for Patient details, their doctor detail, their problem and their treatment. I have successfully created form to enter the data.However I an unable to proceed, now I want to create a discharge letter which will be addressed to the doctor (based on the tables described above)
I want to make this in a way that if I enter the patient details i-e date of birth, ID and / or name a letter is created based on the tables above. I also want this letter to be saved for future use. how to design that letter and should it be a query or report.
General :: Create Query Or Report With Macros Or VBA?
Mar 21, 2014I want to create either a Macro or VBA that will automatically create a report or a query.
View 4 Replies View RelatedGeneral :: Report That Displays Results Of A Query
Mar 16, 2013I have a report that displays the results of a query. The query and the report are both run from a submit button on a form. I use DoCmd.OpenQuery "name", followed by DoCmd.OpenReport "name". Due to slow network connection the query shows up before the form is displayed. I would like the query to be hidden or minimised. In other words, I do not want the user to see the results of the query, only the report.
View 3 Replies View RelatedGeneral :: Sum Time Fields In Query Or Report
Aug 13, 2013Currently using Access 2007-2010. I have a text file that I am trying to import into Access. I am having issues with the time fields. I need to be able to sum them in a query or report. When I import it in, Access is put the 12:00:00 am as default and adding numbers to achieve the 11 character field. I need to be able to sum these fields later in the database. The file looks like this:
ACD Calls Avg ACD Time Avg ACW Time ACD Time
Totals 103 3:49 1:07 6:33:45
2 1:25 :00 :02:49
8 2:02 :00 :16:15
2 3:17 3:06 :06:34
17 4:49 6:06 1:21:53
General :: Export A Query Of 14 Items To A Word Report?
Jun 17, 2013Is 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 RelatedGeneral :: Parameter Query / Report With Related Tables
Jun 13, 2013I have a parameter query for looking up a specific lot number in my database. The lot number table has 4 related material tables that deal with material issued, reworked, and rejected for that lot number. They lot number table is in a one to many relationship with the related tables.
I have a report based on this parameter query with 4 subreports. I want the report to display the lot number data and sub reports to display the related data in the material tables (all linked by the lot number defined in the parameter)
General :: Microsoft Access Report With Query With Some Data Duplicate
May 5, 2014so i had created query using query design wizard for which i i needed to enter year of the data everytime the query is being made all my data are correct when just using the query.however when i turning it into report where the query will still be runing and with adding in another field from my original table to get on the montly rearrangement that's where the some record are shown duplicate on the report
View 2 Replies View RelatedGeneral :: Export Query Or Report To A Delimited Text File
Aug 29, 2012A little background. I need to export the results of a query I use to build a report. For Print Master software I need the "Field Names" in the text file as well as the data for a Mail Merge in Print Master (PM).
"The field name information in the file you have specified is missing or not correctly formatted. The first line of the file must contain the database field names. Make sure the "Export Field Names" (or similar) option is selected in the program from which you are exporting data."
Trouble is, when trying to export the report or query, Access has no "Export Field Names" option. It works if I first export to Excel and then from Excel to "txt" then to Printmaster. I would like to eliminate the Excel step. Therefore, how do or can I get Access Export to transfer the "Field Names" along with the field data?