Search results for query: *

Personally, after taking some meds after looking at your expression, I would convert this to a CASE statement in my underlying query and not put it in the report itself. If it must be in the report, as far as I know, the expression is going to be a real mess. The CASE statement is going to...

I think you want the SSIS forum for this. Gary gwinn7

I have the same problem and we are not alone. It appears to be yet another bug in this reporting system. What seems to trigger the problem in most cases is when we delete an unneeded column, but it may not be true in all cases. Sorry, the only workaround to this seems to be, instead of...

I have been looking for a way to display details of my data source in my report on the report. I figured it would involve placing some code into the report code section, but my every attempt to do this has failed. It would be nice to be able to display any aspect of the report as the report...

Ok, where is the question?

RESOLVED! The problem was caused by a particular Windows Update. Apparently, this is a common problem affecting a lot of users. Here are the details and how to bypass this issue... Name of the Update… “Windows Live Essentials 2011 (KB2434419)” Symptom Automatic Updates Hangs at 50%...

Thanks! Good suggestions. I will try and get back to this thread. Gary gwinn7

Does anyone know why Windows 7 Professional 32-bit would hang during an automatic update? I have... - Disabled Anti-virus - Disabled the Firewall The Windows Update says it is "Preparing to Install", but has been stuck there with the progress indicator cycling for over 3 hours. Any ideas...

PROBLEM RESOLVED! No, no images in the file, just about 100K of rows and about 30 columns. No, I don't think Excel was fooled into using 1million rows. RESOLUTION Increase the system paging file size manually. EXPLANATION Apparently, the operating system was not effectively estimating the...

Thank you for responding. Here are your answers... Workbook file size? 26.1MB Many Formulas? 2 column unique formulas + subtotals External File links? No, none. Even with the subtotals removed, the file is still intolerably slow. Gary

We have a machine running Excel 2010 on a Windows 7 Professional 64-bit Intel i7 Processor running about 3GB of RAM. When my user opens a local native version of .xlsx document it takes over 30seconds to load and when doing some of the most basic alterations to the spreadsheet, the changes...

Did you try add/remove programs and select the uninstaller? gwinn7

You are welcome! OK, I am going to take a quick shot at what AceMan might have thought were issues with my code.... #1 Parameters - I strongly advise against using form control references in your back end functions. Instead adding parameters gives you much more control and usabliity for...

ok, here is another look. Why not just call the dam# thing directly???? set rst = currentdb.openrecordset( "SELECT tblAccountSchemesActivity.ActivityID, Sum(tblAccountSchemesActivity.TCO2) AS TCO2Delivered, Sum(tblAccountSchemesActivity.Delivered) AS ElectricalDelivered...

Cneil, I would stick to the example I gave and pass the function the parameter as defined. Isn't the ActivityID field in your query a numerical value? If not, then you need to enclose with quotations like... ...[ActivityID = '" & ActivityID & "'"... During Run-time, grab the SELECT query...

cneil, I built a working example for you with an updated function. Would you be comfortable putting an e-mail alias out so I can send it to you? Please keep in mind, I am not fully aware of your project and what you are specifically attempting to accomplish. It is very likely that my working...

AceMan, relax!!! I know it was an example. I am curious to know what flaws you seem to find. cneil, The code I wrote was off the cuff without testing, but I have written numerous functions like this without experiencing issues. You may have to debug and customize to fit your needs. That...

Good input Aceman, here is a new version... Even Faster, less complex, and more re-usable.... Changes... 1. Added Parameter to function 2. Removed unnecessary Currentdb variable assignment 3. Changed recordset to dbforwardonly (faster!) 4. Removed "FindFirst" Approach (it was slower!) 5. Added...

Copy and Paste? Yikes! Why not just run an Update query like this... update mytable set mynewcol = myfunc([myoldcol]) Where myfunc(strtext as text) as long is a function to process and return your clean unique numerical id. Does that help? Gary gwinn7

I did. Gary gwinn7