I have a number that has 8 decimal places (0.12345678). When I use the toolbar "decrease decimal" button to hide decimals places it works fine. But then when I use the "increase decimal" button it rounds the number and shows zeros. i.e 0.12345678 --> decrease twice to 0.123457 --> increase...
Geoff, Thanks for taking a look at it and confirming that I am not an idiot, at least not in this case. It is frustrating to have a problem that you cannot trace back to the cause.
I will have to resort to the Save As code as a type of band-aid to the problem. Thanks for the suggestion. Do you...
Geoff, I just sent the file to you. It is zipped so I hope you can open it.
I guess if it works on your computer that means that something must have been installed incorrectly.
Thanks for your help.
Trust me, I understand your feelings, this does not make sense. My office is slowly getting pushed Office 2003, so some people have Office 2003 and some still have Office 2000. I have e-mailed the file (the one that will not work on my computer) to a co-worker with Office 2000 and it worked fine...
Yep, and just to reiterate, the data in that range is not what is being plotted on the graph.
Again, this is working fine in Office 2000 but not in Office 2003.
Source data is referencing the correct range. The odd part is that the range has the numbers I want plotted, but the graphs are plotting the data that used to be there.
Tools>Options>Calculation Tab is set to Automatic already. I pushed F9 just because I was desperate to try anything and...
The issue I am having is getting the graphs to update when I run a macro that redefines the range. Everything works fine in Office 2000 but not in Office 2003.
I have a file that contains multiple sheets:
Data sheets = there are many of these which all contain the same rows and columns but...
Okay, it was not bringing in first and last. I just forgot to add the function that clears the box before I add more to it. (I was seeing the first and last from previous runs)
However, it is still not doing exactly what I need it to do. It is bringing in the sheets before and after "first"...
This does not seem to work for a couple of reasons:
1--The worksheets first and last are not the first and last worksheets in the file. For example, there are 20 worksheets and first is the 3rd worksheet and last is the 15th. I want the names of worksheets 4-14 in a dropdown box. Due to...
I have an Excel file with about 20 worksheets in it. Two of the worksheets are named first and last. What I want to do is pull all of the workbook names between first and last into a drop down box. I know this has to be a simple For Loop but I am struggling with pulling the names without...
I have two MS Access databases. One retrieves data, the second is the user front end. The front end calls the first database to run specific queries.
One of the users - at a separate location - can run the queries from the first database manually. But when using the front end the macro dies...
That you so much for your explanation. I finally understand what it was trying to do. I apologize for picking up on this quicker.
I appreciate all of the time you have given to help me with this problem. It is so nice to finally have this working.
You also deserve a star!!!
ekim,
I think I figured out what you were doing so there is no need for you to send me your code.
Referring back to the initial thread that you posted, you said that you need the results of the query to be exported by the TransferSpreadsheet function. Did you ever get that part working and...
Yes, I just fixed that right before you wrote back. Now the code is running without error, only now nothing happens when it runs.
I really am clueless as to what this line does:
CurrentDb.QueryDefs("MASTER RELIABILITY").Sql = strSQL
Can you explain it to me?? Is there anyway I can actually...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.