Search results for query: *

Our company converted from GroupWise to Outlook last Friday afternoon. My database worked fine before and since the conversion it won't run properly now. The database opens to a splash screen with navigation buttons to get you through the database. Whenever you push one of those buttons the...

I have a database that imports daily records from our meter reading department. The system our meter reading data is loaded to is a mainframe system and the only way to extract data is through Crystal Reports & SAS. I'm using the extracted data to load into the database (approx. 42,000 records...

I've created some code to add calculated fields to my table. I have one field that subtracts dttime2 from dttime1 to come up with the elapsed time. When I first wrote this it was working correctly, however when I added in the calculation for the columns breaks and readings my elapsed column...

I am importing multiple Excel files into a table in an Access database, all my columns define themselves properly except for one. I have a column called "Breaks" that should define itself as a Date/Time field, but since there is not any values in the first row, Access defines it as Text when it...

Is there a way to protect a user from modifying fields in your spreadsheet, while still allowing the user to use the group/ungroup feature in Excel? When I set the worksheet protection on it won't let the user collapse/uncollapse the +/- button for the grouping feature.

I'm trying to find out if there's a way to code the user name and password that needs to be entered when trying to refresh a pivot table that is built from an ODBC datasource? I've written some code to refresh my pivot table, but I get an error when I try to refresh & I suspect it's becuase it...

I'm trying to import a text file using a textstream in VBA and when my codes hits the currentdb.execute command it is randomly skipping records of the text stream for no obvious reason. However, when I count the records, it does count all records in the text file, but doesn't execute on all...

Does anyone know of a fix for the labels not coming in when you open an Excel report created through PowerPlay? When I open my reports, none of my labels come in on my source tab until I change a filter or refresh the data.

When trying to open approximately 17 linked files in Excel I run into an Out of Memory error. Is there any file compressions or tricks available to make these file work together with getting an Out of Memory message?

Is there a way to export a Crystal Report to the Web with interactivity for the user? (ie: paramater values)