Recent content by TIGREBLANCO

Sure, for some reason the client wants to have the data in XLM format (I believe they'll plug it into their CRM or something from the XML file) but they also need to be able to open the file from Excel. I find this to be an unnecessary step myself but that's what's on the contract. Lets rather...

Is is possible to export an Excel file to XML so I can send it to the client and then have him open it on his Excel without losing the subtotals' outline? I have Excel 2003 and so far have not been able to accomplish this task. Maybe 2007 does the trick? Or am I just missing something here? (I'm...

My guess is that you have a formula that points to values most likely on another file and copied that formula in the whole column (or pretty close anyway), or in the whole row. If that's the case then the solution is obvious: Get rid of the furmula wherever you don't need it.

If they bought the system brand new it does have a restore option, you just have to go to HP web site and find how to activate it. Usually Compact creates an extra partition on the hard drive from where it dumps all the stuff necessary to go back to a factory configuration. Save yourself some...

Old version and newer version have different folder names, I would try to delete the old windows folder from Recovery console started under the newer windows installation. In my experience, that's all you can delete, just the old windows folder. Good Luck

Download and install Netscape navigator latest version, if you can surf normally with Netscape then you have something corrupt on Internet Explorer or the registry sections related to it. If you still get the same problem with Netscape then it's either the winsock2 or a hardware problem (i.e...

I remember that problem on a client's computer (I really hope this is not your case). I had to clean it from adware, spyware and then (what really solve the issue you are talking about) had to rebuild the winsocks suite (winsock2 Which is actually not hard, but keep reading.)...

Yes, you can do it and it can all be automated. Basically you have the right idea (fastest although not most subtle), all it will take is to learn how to use the objects and their properties from each app. Good Luck!!

Ok, at my workplace we have two third-party applications. We hired a temp to transfer data from app A to app B (its out of the question to get app B's provider to import data from app A directly from the database, so all we have is the two interfaces to work with and the data they show). Is...

You should use a subform instead of just a datagrid. Also, check on the way you created your indexes since not allways can you have a one to many relationship and be able to update. For an example see the "Order Entry" example that comes with Access. Good Luck.

Isolate the source of the problem, try opening the files on a different pc with W2K, files may be corrupted.

Well, there it is!!! Nice solution. Too obvious for me to see it. Thanks Geoff, Sorry I didn't have the patience to keep looking till May's threads came up. Regards Sal.

What I'm really trying to do is to count values from a column (for now, later on I would make it a range if necessary). Now, this values have duplicates, those I don't want to count, just single instances of a value without any duplicates. For example: If we have a column with values: 97377...

The only reason I want to make it work as a function (users are using it as a Sub already) is because it's easier for them, value would calculate automatically and passing parameters is more interactive; as a Sub of course, they have to run the macro every time they want the result updated and...

Hi Guys Short story: Why when converting a Sub into a Function, execution of statements will no longer ocurr, even though vb runs through them? Long story: Is there a way to convert a Sub into a Function?. This Sub manipulates (insert, delete, etc) columns and its data, not only variables. I...