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

Thanks to both of you. Unfortunately I need to keep 12 to 16 months of data active for reports and can't use the archive option due to the nature of the data. I agree this should be in an Oracle type environment, but we don't have the resources to get there (it would take to long through our...

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 couldn't get that to work, but I was able to use the format() function to format my date prior to committing to to the database [dtelapsed] and it now puts the value in the table as expected. Thanks for the post though...

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 have figured my own problem out. It was as simple as defining all my columns in the Access table prior to bringing in my Excel data, it then put each column in per my access definition.

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

Now I'm wondering, is there a way to pass the login and password information from one array to the next in the case of multiple pivot tables that need to be refreshed. I don't want to hard code the user name & password, but I don't want to make the user type it multiple times.

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.

Thanks - that did the trick!

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

Thanks that worked great!

Thanks to all of you who helped me with this. I used the CurrentDb.Execute and found out where some of my type failures were. I also found out I had an issue with some values having an ' in the text, and these records wouldn't append to the Access table. So I wrote code to replace the ' with...

Thanks for the code suggestion, I changed out that code line and came up with the error message: "Microsoft Access can't append all the record in the append query. Microsft Access set 1 field(s) to Null due to a type conversion failure, and it didn't add 0 record(s) to the table due to key...

I decided to just post the whole code, mainly there are approx. 72 columns I'm bringing in, which has created the code to be so long. Sub GetElecRawdata() Dim strLine As String Dim strBudYr As String Dim strDist As String Dim strRegion As String Dim strResZn As String Dim strSerAreaCd As...

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)