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 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.

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...

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...

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...

Currently, in Access 2003, we use a common ChangeProperty module to lock down our databases. Does anyone know how I can set the application's ribbon in 2007 by using this type of module?

I recently was asked to find out what it would take to migrate our applications from Access 2002-2003 to Access 2007. We use a fairly sophisticated custom built secuity wrapper. I think once we get used to ribbon customization, it will be quite useful. But one thing I am concerned about is...

I am using the OutputTo method to output a report to Excel. But the dates on the spreadsheet display as Julian, rather than Gregorian. Can I use a template to control the date format?

We have always used the Calendar control provided by Microsoft. Since we have gone to XP it no longer works. There is a missing reference. I have found the MonthView control works fine. I would like to hear some opinions on MSCAL vs MonthView.

Lately I've been doing a lot of importing and exporting of data to text files using stored specs. To see what fields and sizes a spec contatins I have been going to the File menu of Tables, click on Get External Data/Import. When the Open menu comes up, I click on any random text file. Then...

Does anyone know what would cause records in a table to change their sequence? I have a table that I clear out. Then I append a header record. Then I append the detail records. The table always is populated correctly. But sometimes, when exported to a text file, the header ends up down...

Does anyone know of an expression I could use in a query to parse a full name field into last name, first name and middle initial?

Hi- Im importing 80,000 records into a table and then using a query to reformat the records and append them to a second table. The import works, but the append quits after about 6500 records. Is there a limit to the number of records an ACCESS query can handle?

We have SPEED Ferret 4.1, but we've upgraded ACCESS 2003 which 4.1 does not support. Does anyone know if a new version's coming out? Does 2003 have its own enhanced find and replace functionality?

I hope this is a simple question. I have linked my front-end to a rather lengthy textfile (over 700 characters) using the wizard. I would like to change some field defintions. Can I do this in ACCESS 2000 without redefining the whole record?

I have a form with a rather long subform. The subform has various data entry controls. Tabbing through the subform works fine unless focus leaves a checkbox and is set to another. When that happens, the subform is repositioned to the top (kind of like it's been requeried). The user then has...

I have some rather long subforms that I load onto a form with a click of a button (OnClick: Me!SubfrmSurvey.SourceObject=.....). As the user tabs through the form, the cursor continues down without repositioning the subform. Is there any way to keep the cursor visible without manually scrolling?

I'm stumped and spinning my wheels like so many Milwaukee drivers after yesterday's snowfall. I have a series of forms named Survey1, Survey2, Survey3, etc. I also have a form for recording notes. When I close the notes form it is meant to post the notes into a hidden memo field on the survey...