Search results

Solved - Problem with grouping reports I have a report (see attached file) on which I have grouped on the Case ID field and all looks fine. Unfortunately, the client wants the Case ID field to appear on the same line as the other fields but without repeating the value for the Case ID. I can do...

With a particular client, they want to display a subform in datasheet mode. They do not want an alternative like continuous forms. If I am displaying the subform in datasheet mode, is there any way to eliminate the header row which contains the names of the columns in the subform? I know how to...

I am running Office 2010 but at one time also had Office 2013 installed on my Windows 7 64 bit OS PC. The first attachment (AccessProblem) shows the error message that I get when it hits the Set olApp = CreateObject("Outlook.Application") line. I get the automation error - library not...

I have a project where I will need to use Access (probably 2010) to interface to SPSS (IBM's statistics package for the social sciences). Besides reading the data, we will need to update the information in SPSS through Access. Does anyone know if there is available out there an ODBC driver that...

I have a complicated report in which there is a main report which contains other reports within it. One of these reports (call it "Number Six") within the main report has several subreports. Within this report, I can successfully cancel the subreports so that they do not print if the data does...

I have a report which has several subreports in it. If a subreport will not fit all on the same page, then I want it to break and start printing on another page. I have tried grouping to keep the whole group together on the same page to do that but it still breaks in the middle of the Immediate...

I have a report in which there is a subreport that prints towards the bottom of the page. I know that I can use grouping to have the subreport print on the next page if the entire subreport cannot print on the current page. However, I want to have the break occur not for the section as a whole...

I have a report which includes several subreports. There will be times when a subreport prints partially on one page and completes on the next. I don't always want to break to a new page with this subreport. However, I would want to break to a new page if the subreport cannot fully print on...

I have an application created using Access 2013. I have clients who only have Access 2010. Can they run my application using the Access 2013 runtime? If so, how exactly do I go about doing this since Microsoft in its "infinite" (yes, I'm being sarcastic) wisdom decided to remove the package...

I have an Access 2010 database which has a table with several fields with the Hyperlink data type. Some of these hyperlinks reference files stored in a SharePoint database. I am relatively new to using hyperlinks. The task is to insert those hyperlinks into an email using VBA so that the...