Search results

A number of people in my office have had their Automatic calculation in Excel turn itself off. We are aware of how to fix the problem but I would be interested in knowing what causes it. If anyone has insight I would appreciate being able to explain the phenomenon.

Thanks, I will see what I can get

Thank you for your responses. I may be making a mountain out of a mole hill but I'm a bit intimidated. I don't want to end up with egg on my face by ordering the wrong product or not being able to deploy the finished product appropriatly.

I am developing an Access (2000) database to provide reporting data gathered from SAP and make it easily accessable for 12 analysts. The data set is HUGE, 5 months nearly a gig and will need at least 2 years worth, so I don't see any option other than using SQL as a back end. I have experiance...

A lot of you have been reading this but no help.:eek: Did I use a poor title? I have used SQL as a back end but really need to know how to produce one out of thin air. I ordered SQL 2005 off my company's IT store but when reading further it needs a special operating system, I think. Is this...

I am developing an Access (2000) database to provide reporting data gathered from SAP and make it easily accessable for 12 analysts. The data set is HUGE, 5 months nearly a gig and will need at least 2 years worth, so I don't see any option other than using SQL as a back end. I have experiance...

I have a text file that has double carriage returns and need to clean these out before importing the file into Access 2002. These returns happen in the middle of a field not at the end of a line. Is there a way through VBA to write a routine that will look at the .txt file and remove all...

Well I tried the unicode option on my import spec, it took 1.5 hours and no data came in. With out unicode it runs in < 30 seconds.

Thanks RV, I'll give it a shot in the am and let you know.

http://www.tushar-mehta.com/excel/software/ Has quite a few addins TM does table of contents, also a feature available in ASAP

This post was as close as I could come searching for help with multiple languages in Access. I am using Access 2002 to develop some data manipulation and reporting tools . The source data is a report run from SAP. In reviewing the downloaded data I discovered that Vendor names are being...

No, what you posted is in Data Entry mode. Each market area has multiple sites and I want to survey each site but this will be done by a Market area representative. The idea is to have them answer the set of questions for each of their sites, I don't want them to be able to add or delete any...

Here is a copy, I have the Child and Master fields linked but still, the subform shows no detail but if opened separately it is fine. Thanks in advance to anyone who solves the mystery.

I have a form with an unbound subform that was working quite nicely. The only change I made was changing the data source for the main form from a query to a static table; name of table same as the prior query. Now the subform appears but the data doesn't. The buttons in the subform header are...

Thank you for your help, it works nicely!

I have an Excel sheet to collect data from various users. There is code in the workbook to email the file back to me. I want to have the file save using the value of a specific cell (Location number) prior to being sent. I get Runtime error 1004 saying the couldn't be accessed with the code...

I have a database that contains more than 80 tables. Is there a way to tell the size of each table without having to run individual querries? One of them is growing abnormally during the daily update process and I'm having trouble identifying which one it is. I was hoping size information...

go into a module and click on tools, references and scroll down to Microsoft scripting runtime. click the check box and then ok.

A testament to the search function It took a little more than an hour but this post gave me the information I was looking for. It was posted in July of 2003 but it does exactly what I need it to do. Thanks ghudson!

Thanks, that does it