Search results

We have a capital budget database that we have used for many years. It is in ACCESS 2003. Our organization is being upgraded to Office 2007, but we are keeping the databases in 2003. There is a report that needs to be landscape in order for all the columns to fit on the page. When the user...

I found the slow down. It's exporting to rtf. Exporting to a snapshot or txt is super fast. Exporting to rtf or html is super slow.

I just changed the SendObject statement to an OutputTo statement. I thought it might be quicker to save the report to rtf and then sending it. The OutputTo statement is just as slow.

Good point. It is two different Outlook clints.

I have a SendObject statement: clssendobject.SendObject acSendReport, "rptPolicyList", accOutputRTF, , , , "Children's Hospital & Health System - Policy and Procedure Report", "Please review the attached report.", True When it is run in ACCESS 2003, it takes about 15 seconds. When it is run...

can anyone describe what goes on behind the scenes when linking Access to SQL? If Access asks me to define a PK and I don't concatenate the proper fields, it will display incorrectly in Access, but will be correct in SQL.

Thanks. I never thought of that. Currently I'm using query criteria rather than Link fields. The values are not on the parent form. They are hidden somewhere else. But it may be easier to take your advice.

For anyone wondering- The reason my subforms showed up blank was the parent form was bound. This confused Access - To dynamically add a bound subform to a bound form. Once I removed the RecordSource from the main form the subform worked.

Refreshing the subform does nothing can't post the db. I'd probably get in a lot of trouble. Its got our security wrapper on it and some other organizational standards that shouldn't be made public. I just looked at another app we have that does something similar. It works. I'll have to...

Yes, I am referring to the control. And the subform control does not support the refresh action. I also tried refreshing the main form. That doesn't work either.

This application tracks our facility's responses to what used to be a survey Child Life magazine used to rank pediatric health care facilities. Each button on the main form will load a different subform containing responses to a different section of the response. Essentially, the syntax in...

I'm pretty stumped here. Hope someone can help. I have a master form that contains one subform control. The master form has a number of buttons that use the following code to change the subform's SourceObject: If Me!SurveySubSection.SourceObject = "frmSurvey120" Then 'do nothing...

Thanks, I'll try it Monday.

DoCmd.OpenQuery stDocName, acNormal, acEdit

Thanks for the quick response, but the ribbons are already created. We just want to use the secure ribbon that cotains no tabs until the queries are opened in datasheet view. Then we want to switch to the export ribbon.

We are converting a charges database from 2003 to 2007. it has few reports. Most of the reporting is done by opening queries in datasheet view and using a toolbar, exporting it to Word, Excel, etc. Now we will be using a ribbon. Is tthere a way to relate a query to a ribbon or change the...

Our organization has been using an Access database to store information about members of the board of directors. a current project involves migrating the tables to SQL Server so they can be accessed on the web. To prevent orphaned records I asked the DBA's to add referential integrity and...

Can a whole drive be defined as a trusted location?

Thanks. I'm not an admin either, but my manager wants me to figure this out. I really don't know what I'm doing. But rather than creating a trusted location, we'd like to globally lower the security.

Hi everyone- When we rolled out Access 2003, we changed a registry key to lower the security level on all machines to allow macros to be run. Now, in preparation for a 2007 rollout, we are finding the security level has been raised again. We have hundreds of users and to have each one do this...