Hi, in access 2003 i have a report that i right click on and export into a text file but on one computer when i look at the text file it has some numbers cut of. It seems to be only exporting ...
I have a report that last 3 pages per customer. So I want to have the page number restarts after every three pages when the group is done. How could we do that.
Thanks
I have a 4 forms in Access that have two buttons each one that will print the single record being viewed on the form and the other that will print the records associated with the records from ...
I need a report in which I have a Terms Page within the Report Footer. The report has a page header and page footer section. The report footer is large enough and fits onto it's own page. D...
I work on an old access application to add some control (radio list) to a form.
When I want the data to be exhibited I cannot find the new value of controls.
When I exhibit the list of the ...
When you click on Print a Report in Access it gives you the option of the page or range of pages you want to print, when I click on email, it emails all the pages in Snap Shot format, is there...
I have a form that has text boxes that you need to put a date in to pass though to query and then to a form. On the form they show up as between dates - a start date and an end date.
They sh...
I am working in an employee database someone else build and I have a request to create a report that displays the employees name and picture. The table storing this information has the picture...
Following the help of
http://office.microsoft.com/en-au/access/HA011170771033.aspx
I have generated a output of a query as reeprt through a form to input the parameters.
However if I run...
Hello Experts,
I am trying to concatenate 2 fields in a report. Typically for simple stuff I can use "= [field1] &" "& [field2]"..... but this is a bit different. I have provided a sample ...
You nailed the percentage as part of the last quesry as aI had cross posted inccorect code which gave percentage. How do I get it to do the same caculation when using MSQL expression builder a...
When I try to run a macro in Microsoft Access, to send a report in Excel format, the following error message appears: "Unknown message recipient(s); the message was not sent." The macro used ...
I have a database in Access with about 6,000 records. I work with testing and examinations and under each record for a student I must list all the courses that the student is taking. I have a ...
Hi everyone,
I have a form that is going to launch a report - the form has many option groups on it. They are from 1-5 and each option obviously means something different. So my question i...
I have a table of names sorted alpabetically. How can I group them in a report so that each section starts on a new page? For example, at the end of the names starting with "A" a new page st...
My Access 2003 database tracks maintenance requests for an area separated into 5 regions. Regional Managers need to be able to view a report specific for their region. They have no other nee...
I have an access report and I am trying to calculate the average of multiple fields under a column. I attached the code I used below. Everytime I run the report I receive an error message that...
We recently underwent an upgrade for our integrated library system, and now I cannot run the canned access reports that are included in our system. Is there somewhere that I need to make a ch...
another simple one I think... but I can't figure it out :-) I have data that is stored as numbers (for the purpose of saving space I selected 1 for the bound column...) but I'd like to create...
I have a few sub areas and i want to make a page break at each sub area. how would I do this?
Ex:
Header
Sub-Header
inf...
I have 2 fields of data type text 50 characters, Last Name and First Name. I would like the name to appear on the report as:
Last Name, First Name
How can I force the comma to be printed imm...
I have a subreport that displays the top 5 values of a certain piece of data for each entity. I used the Top Values field on the tool bar to do this, and the related code reads:
Detail.Vis...
I have a memo field that often contains many, many lines of information, but also often has a few lines or is null
I want to give the user the option of printing 0 lines, 5, 10, 15, 20, or ...
I have a report with lots of fields crammed into it.
On line two I have txtDescription and txtDueDate, both height 0 and CanGrow=Yes.
But if txtDescription has data and txtDueDate also h...
I'm just trying to get widow control on a Microsoft Access Report's GroupFooter -- i.e. trying to make sure that the whole group won't finish with the footer on a single page, it takes at leas...
