Search results for query: *

Dear All, I'm having a very strange problem exporting to Excel. I have the following code (shown below this email) which will work perfectly the first time that I run it, but if I want to export it again, I need to close the program (not only the form) and run it again. If I don't do this...

Dear John, Look what I've found!! It worked perfectly! .DataFormat.Type = fmtGeneral .DataFormat.Format = "#0.00 \%" Hernan

Thank you very much anyway. I have been trying to find a way to modify the textbox to Custom during run-time for several days and forgot that I still was able to make it at design time. I will have to add 9 extra textboxes to my report... but that isn't that bad anyway... Hernan

Dear Johnwm, Now, I have one more question. Do you know if there is any way that I can change the DataFormat during run time and not at design time? Thanks in advance, Hernan

Thank you very very much! I can go to bed with a smile in my face now... ;) Hernan

Dear friends, If I have "94,000785" as the answer from a sum and want to express it as a percentage number, is there any operation that I can make IN THE QUERY to have the final result showed as "94,07 %"?? Thanks in advance, Hernan

Thank you both but the problem is that the report -textboxes are different from the regular ones. They don´t have the Format method (or at least I didn´t find out the correct way of using it...) I´m going to paste a part of my code to see if I can help anyone to understand my problem... Here...

Dear friends, I'm having the following problem and had tried to find an answer unsuccesfully for the last week. I have a Data Report that contains one percentage value. The query that I made sends me "94,0073844" as answer. PLEASE, can someone help and tell me how can I format this...

Dear people, I have a the following problem: I have a form with 2 progress bars. The first one shows a value for each table that I´m importing (from 15). The second one shows (or is moved) by the absoluteposition compared to the recordcount. The problem is that at some point, usually around...

Thank you very much. It worked perfect!! Hernan

Thank you very much for your prompt reply. Actually, I´m doing the following: If CLng(Excel.Application.Version) < 90 Then MsgBox &quot; Yo need Excel 2000 or later...&quot;, vbExclamation, &quot;Alerta&quot; End If This isn´t working correctly in almost any computer I tried it but it worked...

I´m creating an application that needs Excel 9.0 or later to work properly. The question is &quot;how do I check which version is the user using?, is there any way to check this?&quot; Thank you very much in advance, Hernan