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!

  • Congratulations Mike Lewis 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: *

  1. capdownlondon

    Module to modify text box on a report

    I know the theory behind what i want to do, but need some help programming this into my report. I have a field that displays a running sum (over group), but what i want is either this same field or a 2nd field to display that same information but i want it to run through a module that does...
  2. capdownlondon

    Module to modify text box on a report

    I know the theory behind what i want to do, but need some help programming this into my report. I have a field that displays a running sum (over group), but what i want is either this same field or a 2nd field to display that same information but i want it to run through a module that does...
  3. capdownlondon

    Code for button on form needs slight tweak

    Im using the following code to duplicate a record varCnt(retrieved from a combo box on the form) many times, and it only duplicates the record with the fields present on the form for that record. The duplicate fields are [childs name] and [target 1] [target 2] (upto target 5) and then it...
  4. capdownlondon

    Duplicate record but exlude 1 field

    actually w doesn't even need to add a week, because its an index number that realtes to a week. so basically i need to know if i can code a button that will say. duplicate x y z and w+1.
  5. capdownlondon

    Duplicate record but exlude 1 field

    basically i would like to maybe hit a button that will run code that says duplicate record for x, y , z fields and duplicate w field + 1 week
  6. capdownlondon

    Duplicate record but exlude 1 field

    Ive made a button on my form to duplicate a record. But i only want it to duplicate certain fields and leave the other fields blank (another form will deal with those values). Is it possible to do this? and also is it possible to do this but also having the duplicate record have, say, 1 week...
  7. capdownlondon

    update a record using previous data

    i am currently self teaching this and don't know what you mean? normalized? how else could i structure it. I have the following tables? Category -CatId -Category Targets -TargetId -Target -Category Week Start -WeekID -Week Start then.... Child details -ChildID -Name -Primary Carer -Address...
  8. capdownlondon

    update a record using previous data

    I have a table that keeps track of targets and points for kids at the school i work at and the table has these fields: -Name -week starting -target 1 -target 2 -target 3 -points 1 -points 2 -points 3 etc...... Okay, now what i need to do: Now lets use little Johnny as an example. I entered...
  9. capdownlondon

    Need help with myAvg module error 6?

    I used this module code to average a number of fields based on a childs points score in a day. This works really well - but if a child is absent for a day and all the values are null then it returns an error 6 message of 'overflow'. Anyhow here is the module used in the query: Public Function...

Part and Inventory Search

Back
Top