Stack Overflow
Stack Overflow

Questions tagged [ms-access-reports]

80 questions
4
votes
0 answers

How to remove gap between rows in MS Access Report

I have created an MS Access database. I've used a black border colour for the rows/records. In Report View, the report looks exactly as how I designed it in Design View and Layout View, but when I use Print Preview, there is a noticeable gap…
Kellin Strook
  • 487
  • 1
  • 5
  • 18
2
votes
0 answers

'No Current Record' Error when Outputting Report to PDF from Batch File or Task Scheduler

The Problem I'm using a scheduled task to open an MS Access database, run a macro to email a report in PDF format, and then close the database. The report is relatively basic and the macro simply uses the EmailDatabaseObject action to export & email…
Lee Mac
  • 15,615
  • 6
  • 32
  • 80
2
votes
1 answer

How to get hyperlinks dynamically in Microsoft Access Reports?

In a MS Access Report, I am trying to create a hyperlink that would take a user webpage. The URL is dependent on a data field in my database. In my report, I have added the hyperlink control and used the popup to enter the hyperlink. When I use…
psycoperl
  • 121
  • 1
  • 15
2
votes
2 answers

How do I install the function MROUND in MS Access?

This function MRound does not exist in MS Access and you can't just install it. I am trying to use the mround function in an Access report. The function is not listed in the expression builder box of built in functions. When I use the calculation,…
Rebwar CS
  • 21
  • 3
2
votes
1 answer

Query not returning rows on user input MS Access

I am running below query in access in which i need to take argument from end user. Following query is used. However, when i don't ask for user input & put the condition in the query like this (tblApplications.txtApplicant Like "*dac*") it returns…
Maqsood
  • 369
  • 4
  • 17
2
votes
0 answers

MS Access 2013 Report - Bad quality image on Print view, but fine on Layout view

In a MS Access 2013 Report, I import into an Image Control an image as OLE Object from an Oracle DB (from a BLOB column). The images are stored as .jpg to the DB with high resolution. In Report View the image is correctly displayed, but in Print…
Francesco
  • 9,947
  • 7
  • 67
  • 110
1
vote
1 answer

Access report: Get sum of calculated text field

I have created an access report in order to allocate invoice amounts to three entities based on a weighting factor. Example: sample_allocation The invoice amout is stored in a database table while the allocation is calculated during the report…
gmn
  • 13
  • 2
1
vote
1 answer

Change the color of a selected record in an Access REPORT

My Access REPORT has a text box with the Record ID that looks like a button with an on click event to go to a form for that specific record. This works great, but when I return to the report I cannot see which record was clicked. I want to…
user18581468
  • 11
  • 3
1
vote
1 answer

Problem with dynamic image in MS Access report

I have a report for printing labels on a grid of let's say 3 by 6 on A4 paper. These are peel-off labels, which can be printed either full sheet or just 1, depending on needs. The report's record source is a query, which contains always 18 records…
Monardo
  • 23
  • 4
1
vote
1 answer

Sum() using IIF() or Where Clause in MS Access

In my Report: BID is Billing Customer ID a TEXT FIELD. NPROFIT is Net Profit a NUMERIC FIELD. My Query sums NPROFIT for all BID. Using the statement: =Sum([NPROFIT]) I need to sum the NProfit column ONLY for certain BID values ... ACTUALLY, I WANT…
Tom
  • 13
  • 3
1
vote
0 answers

in access when a Report containging tabulated data exported to word all table borders/lines disappears

I made a Report containing rows and column. When Exported it to word document ([EXternal Dat tab->export section-> more->). All the text data exported except border lines of tabulated data. Is there any solution to keep intect the borders of table…
Sunil
  • 11
  • 3
1
vote
1 answer

Opening a Report With a Filter

I have table in Access with budget information I use to generate a report. One of the fields in my table is called "IsActive". It is defined as a Yes/No field in my table properties. I would like to open the report and only show the lines where the…
gdekoker
  • 185
  • 8
1
vote
0 answers

Formatting only First Row of table

I have an MS Access continuous form on onload event i am getting MyTable Record, upto here its fine. But i want to change the color of only first row MyTable Id ¦ Name ¦ Months ¦ Years ------------------ 1 ¦ Ali ¦ 01 ¦ 2020 2 ¦ Umar ¦ 02 ¦…
Usman Saeed
  • 23
  • 5
1
vote
1 answer

Access form with individual record check boxes

I'm trying to have my access reports have check boxes that if you check one box in report view that one will be the only one that is checked. Currently if I add a check box in the design view and click it in the report view all of the check boxes in…
ThatTallGuy88
  • 29
  • 4
1
vote
2 answers

Display Pdf preview in Ms Access Report using pdf file path

I am new in MS Access. I have pdf file location in textbox. I want when access report load then specific pdf file preview in that report (pdf read from file location). How can I achieve it? Please help?
Hunzla Ali
  • 383
  • 2
  • 5
  • 22
1
2 3 4 5 6