Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PeteG
  • Order by date
  1. PeteG

    Set Sess0 = System.activesession

    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...
  2. PeteG

    compare previous row with next

    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?
  3. PeteG

    Trying to refresh just one pivot table

    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?
  4. PeteG

    Trying to refresh just one pivot table

    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...
  5. PeteG

    Textbox format including commas

    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...
  6. PeteG

    Textbox format including commas

    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...
  7. PeteG

    Textbox format including commas

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

    Textbox format including commas

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

    Textbox format including commas

    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...
  10. PeteG

    Order of stacked bar chart values in Excel

    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...
  11. PeteG

    Order of stacked bar chart values in Excel

    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...
  12. PeteG

    Display two subforms without gap/overlap

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

    Display two subforms without gap/overlap

    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...
  14. PeteG

    Display two subforms without gap/overlap

    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...
  15. PeteG

    Detail section expands on new record?

    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.
  16. PeteG

    Detail section expands on new record?

    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...
  17. PeteG

    Detail section expands on new record?

    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...
  18. PeteG

    Detail section expands on new record?

    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...
  19. PeteG

    Referencing unbound control values on a continuous form

    Thank you again - two solutions to choose from!
  20. PeteG

    Referencing unbound control values on a continuous form

    ok, thanks again

Part and Inventory Search

Back
Top