Recent content by chacamasur

  1. C

    Option to --> Replace Description - based on user edit

    Good day, I am looking for ideas as to the best approach to achieve the following: History: 1.)I am copy pasting data from an excel to an Access table 2.) tables to queries to report the usual behind the scene stuff 3.) From time to time the data might be replaced with new data ( this will...
  2. C

    "how can I retain the users input" regardless on closing of the form

    guess how do I store it in a table if that combox is pointing to another table that I don't want to update.
  3. C

    "how can I retain the users input" regardless on closing of the form

    Yes... table (not sure is is what I am looking for) but if you could explain a little more: I am not sure if I am thinking the right way (lol) Figured: Cbox - select 150 combo box is looking at a list where I don't want to add or change the list table. form closes --> reopens and 150 is...
  4. C

    "how can I retain the users input" regardless on closing of the form

    I have a combo box on a FORM that is currently linked to a table/pulldown for selection: sort, column1, column2 I have set up the combo box to show Column1, and have a set an invisible textbox that grabs the sort value. I am using the text Box within a Query criteria...
  5. C

    Running Sum (Variation Required)

    No coffee yet, I was able to use the above code and voila, Thanks (going to get coffee Now)
  6. C

    Running Sum (Variation Required)

    I was just double checking the print out... and when it jumps to a new page it goes from Previous page last item " 35 " --> next page starting item is at 37 thoughts? I am looking at printcount...
  7. C

    1.) Report using crosstab query setting criteria's 2.)Form info to remain

    so in the report it goes back to the Query before the Crosstab... and enters in SQL code. I will take this query .. one with the Parameters required and one NO parameters and build the corresponding reports...
  8. C

    1.) Report using crosstab query setting criteria's 2.)Form info to remain

    Thank you ... the link was helpful but might have opened up another can of worms. As in most cases usually happen. I just want to bounce off my findings: I have two reports .... Overall / Area on my area report I entered in the parameter [Select Area] and that worked. I opened up the...
  9. C

    1.) Report using crosstab query setting criteria's 2.)Form info to remain

    I've attached a word doc... (with pictures ...ooooh) :) to try to explain my scenario better: 1.) Form enteries -- I would like to eventually use these entries as criteria’s on a report 2.) but -- The From if closed will reset/ or clear the values I would like the values to remain at all time.
  10. C

    Running Sum (Variation Required)

    After a few head scratches, confused looks and trying to get the computer to mindmeld and do what I was thinking: Went to the design view -- Right clicked on the desired Header/ build event / code builder Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)...
  11. C

    Running Sum (Variation Required)

    A100 is the group one level up... A100 is AREA-NUM (Group) trying to figure what you posted...
  12. C

    Running Sum (Variation Required)

    Would like to thank for your patiences: (I don't see where exact I need to add a group).. I think one already exists. When you say "select that field" I am assuming it is "Group on Category" Just not sure what I am trying out first? sorry
  13. C

    Running Sum (Variation Required)

    K, I haven't done anything yet: Within the sorting and grouping I have: 1: Goup on AREA-NUM - with A on top 2: Sort by MTO REPsort - Smallest to Largest (this is a sort for the Category) 3: Group on CATEGORY 4: Sort by criteria No.1 5: Sort by criteria No.2 6: Sort by criteria No.3...
  14. C

    Running Sum (Variation Required)

    Access 2007
  15. C

    Running Sum (Variation Required)

    but I haven't seen anything as to where I need to make that happen.. in my travels. So, where am I require to set that: (not sure) code??
See more
Back
Top Bottom