I have a report, I want to add some code behind it but I need to know the value of a field of the current record. How do I get this information?
i.e. for a form, it is simply
me.recordset(...
I'm writing a report in Access 2003. I have a field [esstatuste] that will contain one of three options: supervised, unsupervised or null. I'm trying to create a text box that will show eith...
I have been asked to create a project management database in Access. My PC at home is running Access 2007, and one of the Microsoft Online Access 2007 Templates is called 'Tasks.accdb' and i...
Hello i have a table with 2 dates (format d-m-yyyy h:mm:s, example: 3-12-2007 9:05:03)
Is it possible to get the days between those dates?
I have the following table:
date1 ...
Hello All- I have a VBA program that creates a Graph Report in Access. I would like to see some code that will export this Report to a PDF and place it in a folder. Thank you for your help ...
I have an Access 2003 database which is used to print an Invoice into a pre-printed 8.5 x 14 form in the printer.
The report design uses an Ole (Unbound Ole Frame) of Microsoft Word.
The u...
I am creating a PDF from access 2007 using DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, strPath, , , , acExportQualityPrint
I am using microsofts office 2007 pdf generator and wor...
Hi there,
I'm very new to using MS Access, and am creating a report for a batch of employees - basically a form letter with employee-specific data. In particular, I'd like to make a nice s...
Hello, I am a new user of Access 2007 using databases I have developed off of templates, but now need more functionality. I am not familiar with VB or macros, so please treat me as though I'm...
Hello, I'm trying to make a pie chart that shows currency and the percentage. The problem I'm running into is that when I add the percentage in. In takes away the currency formatting. Then ...
I have a report COMMUNICATION BY LOCATION that uses the query CommLine, which is based on the dialog box SelComTypeLoc.
The criteria for the query is [Forms]![SelComTypeLoc]![cLoc]
When ...
I've been creating reports in Access for 6 years, and only now, in Access 2007, I can not do some simple things. I'm trying to create a report in Access 2007 running on XP. Using the report ...
I am trying to figure out the elapsed time for two date/time fields I am keeping track of. The process works well when I do this:
ElapsedTime =[delivered]-[released]
The field format is se...
One of the fields in an Access 2007 database (which is actually a link to an Excel CSV file, the CSV file being exported from an accounting program) contains text which can be a variable lengt...
I need help with the vba loop to produce an individual report for each record in a query.
I have a report named rptMissingReports based on a query named qry_rpt_MissingReports. The report ...
Hi EE,
I need to save report to pdf, and name the pdf based on the student's name.....
found this post on EE
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Repor...
i have a report that i would like to sort by selecting a value from a combobox
the combo box needs to be bound to unique records from a table (there are only 5 differet choices)
the repo...
In a report, I added the bound controls (fields) I need in the detail section. I added unbounded controls to round the value of the original controls. How to I create a sum of the new unbounde...
My database is a tracking database for a manufacturing facility. I need a query to return data based on dates. For example: when an employee completes a task for a job my database records the ...
Hello Experts,
Okay, need a little help with this one.
I want to concatenate the firstname and lastname fields on my report to display the following format:
Lastname, Firstname
I co...
I have a text box on a MS Access report.
The source is a memo field in a table that I have imported from a SQL Server database.
When I display the field in a report none of the formatting ...
I am working on a database in Access 2007 and have managed to do everything that I've wanted so far without having to make any macros or do any coding... since I've never done either, I'm rat...
In DesignView, report properties shows me Name, Force New Page, etc... How I can make my title appear on every page of the Report? "All Pages"? but where do I type that in?
I have built an Access database and I need assistance on creating a report. My database is a Product Price catalogue. I have tables for Items, and two separate tables for related itme ( supp...
As i am working with crystal reports i need to set the page width as my web page design.
