Search results

I keep getting errors on trying to hide the 4th sub report. I think it's the way I'm trying to address the nested subreport. I'm putting this code in the main report "On Open"): ----------------------------------------------------- Private Sub Report_Open(Cancel As Integer) Dim msg As String...

Based upon a value in the DETAIL section, the footer section will either display 3 signature lines or just one. I got that part coded okay and it works, but the problem is the EXTRA SPACE left behind when there's only one signature line displayed (the footer still uses the same amount of space...

I am developing a customized ribbon for an Access 2007 project. The ribbon is designed but am not sure how to get the same commands that Access offers behind it's regular buttons. For example, if you customize the Quick Access toolbar and add the button for the "Filter By Form", I need to do...

I have an Access 2007 application I'm going to distribute with a SQL Server 2005/2008 database as the back end. When I distribute it, the Access ACCDE file has a DSNless connection. However, the server name may vary by client, though the database will be the same. I'll also use an Application...

I am trying to open an ACCDR (Access application with runtime extension) from within another ACCDR file. The situation is this: Some users may have the full version of Access 2007 and some may have the runtime version only). I want the ACCDR file to open with either version. The ACCDR file...

I know the Access 2007 ACCDE and ACCDB's no longer can use workgroup administrator for security and boy, has it been a nightmare without the WG administrator capabilities. I've put code in to hide objects, set database options to hide objects, make ribbons unaccessible, make an accde, and...

When a regular Access application is converted to a Web database in Access 2010, what happens to the code (vba)? I've heard that with Access 2010 and Sharepoint 2010, that a developer can create Web databases and have them used in Sharepoint. So if I have an Access 2007 database, and I go to...

In Access 2003, I could test the emails and either get an error message or the email went through. In Access 2007 and Outlook 2007, I get no error message and the email appears to have gone through. Here is the code: ------------------------------- Function SendEmailNotice(EmailTo As String...

From one Access 2007 database, I'm using automation to open another Access 2007 database. I want the first database to close after the 2nd one opens. I cannot use followhyperlink or Shell command to open the 2nd database because it is password protected. Because it's automation, I cannot drop...