Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...
I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...
Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to...
I am using MS Access 2007. I am trying to modify a report and I want to delete the label in the page header section but not the detail field. I cannot find a way to detach the label from the detail field
Where can I get instructions on using Microsoft Access to create reports from Macola?
I have a number of records that each have multiple attachments (pictures)> I have created a report and only the 1st attachment of each record prints on the report. Is the a way to have all the attachments print on the report for each record?
Access reports, Microsoft Access, Access Database Attachments
Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie
I have a table with an NVarChar field that contains left aligned numeric values. I've tried using the VAL function to return the integer values, but I'm getting back Short Date results. What can I do to get integer results? Thanks, Arlin
Hi, I have a report built in Microsoft Access that has a page header and a header for one of my fields named JobNo. Well, I wanted to know if there is a way to not display the page header with the jobno header? I know there is a way to not show the page header with the report header but I...
Dear Sir, I have put one memo field in Ms-Accees report. I want it to be printed like this : |.....................................| |.....................................| |.....................................| |..................| Please reply, Thanks, Sandip
I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & " " & [First Name] & " " & [Last Name] but in 2007 I am getting an error. Any...
Is it possible to get a "new user" report when the only date is used also for date they used services? The only fields in the table are Student ID, First Name, Last Name, Date of service and hours used.
Microsoft Access, Database programming, Database reporting
How to send a report in MS Access to the body of an email in MS Outlook.
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61...
I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on...


