Search results for query: *

Just stumbled across this post and thought I'd add my take on it. In my world, being on Citrix also, we have some apps that appear to be installed as if they were local installations but others that are kind of 'virtually' installed (XenApp) - where it appears more akin to running a shortcut to...

Hi, Just a thought but might it be easier to loop through the recordset and assign all the values to an array or collection/dictionary of some sort, and then work on that to find changes?

Hmmm, thanks for the suggestions. I only recently found out about that camera feature, might give that a go! Am I right in thinking that you don't consider it a trivial thing to be able to control the refreshing of the pivot tables?

Hi, I am currently working on a workbook containing many pivot tables; approx. 5 each on 5 separate worksheets. Between them, they all pretty much use one of two ranges as the data source. Each worksheet has code to refresh all the pivottables within it, on the worksheet activate event. I am...

Thanks for all the above. I might just disable the control so that the user does not see the underlying number. I think that may be better than them seeing it to many decimal places (I know, they can just multiply it by one million but IF they don't need to see it, it'll probably avoid any...

Just to add to that, I could change the control source to something like "[textbox]/1000000". I think this would work in the same way. One thing I would definitely lose, however, is the ability for the user to 'click' into the textbox and see the value to it's original accuracy and I'd prefer...

Yes, that's it. Well, divided by one million and rounded to one decimal place.

Apologies, I meant to write "custom format" rather than "customer format"!

Hi, I am trying to add this customer format to a text box - #,##0.0,, . The problem is that the trailing commas get interpreted as a string that gets appended to the number rather than part of the formatting. So, when I enter that format, either manually or via code, the format gets changed to...

I have found an answer to the second question of mine. I can just over-type the row labels in the pivot table that my chart is based on and call them whatever I like. I guess that is likely to be a problem if the order of my pivot table changes or the number of rows in the pivot table grows or...

Hi, I have a pivot chart and I am trying to find a way of ordering each individual stacked bar by value with the largest value at the bottom. Is this possible? Another quick question on the subject of pivot charts if I may. Along the horizontal axis, I have the names of the field that I have...

Good idea, thanks. That is working well for what I'm trying to do

Yes, I could do - but I think I would then lose the ability to add descriptive headings for each of the two sets of data. Well, I could do. I could add in to the query a row that describes the data but then I wouldn't be able to format that row to make it appear any different to the data around...

Good morning, Similar to a recent thread of mine, I have two subforms (continuous forms) that appear one underneath the other in the detail section of the parent form (single form view). The parent form is on a page of a tab control. What I am trying to do is to get the data within each subform...

Yes and yes. However, those who aren't as experienced as you don't necessarily know what is significant and what is not, at the outset of a question. Apologies if I've wasted your time.

Thank you both. I understand now that there is no setting to do this by default and, hoookdm, your code solution works perfectly for what I was trying to explain, when I open my form as a 'pop-up'. However, my form is a sub-form on a tab control page and unfortunately that behaviour gets lost...

Hi AceMan, thanks for your post. I'm sure my understanding *does* need a little tweaking! I haven't used Access for a little while and just starting to feel my way a bit now. I understand what you say about having no vertical spacing to be able to view the most records that I can in the detail...

Hi, I have a (continuous) form bound to a table, so the two textboxes that I have in the detail section appear multiple times depending on how many records I have in my related table. What I am looking to do is to expand the height of the detail section so that, if the user adds new records...

Thank you again - two solutions to choose from!

ok, thanks again