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 derfloh 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: MadCatmk2
  • Order by date
  1. MadCatmk2

    Access update text box problem

    Sorry. yes, i seen the example in your post. I got myself confused but i get the idea now. Your help is much appreciated. Thanks and Merry Christmas
  2. MadCatmk2

    Access update text box problem

    OK. Sorry to ask yet another Dsum question (Brains not working this close to the holidays) I'm using I've got this so far: Dsum("[Amount Paid]", "payment" Presumably this will sum all [amount paid]'s in the table "payment". I now need to narrow down what is summed. I have a another three...
  3. MadCatmk2

    Access update text box problem

    Thanks for that. The "not storing it in a table" idea sounds like a good one. If i went with that approach, would i just create a textbox and set the control source to a DSum formula? Cheers
  4. MadCatmk2

    Access update text box problem

    I don't like macros either but i'm sticking with how it was initially started and just trying to get this one problem sorted. How would i go about using the DSum function? i need to update the value in the field as a new record is added. WHere would the DSum be used? Thanks for the reply.
  5. MadCatmk2

    Access update text box problem

    Hi All I have a question regardin and access application i am helping to build. I have a subform with a number of text fields in the details section as follows: Date Paid - Bound to field in payment table Weeks Elapsed - shown as result of calculation (works fine) Fee Due - shown as result of...
  6. MadCatmk2

    VB6 Designer problem

    Hi all. Hopefully someone has experienced this problem and can give me a little help in solving it. I have an application that a user can use to view various reports. This program was done using crystal reports 9 and VB6. I have since upgraded to crystal 10 and kept 9 on my PC for older...
  7. MadCatmk2

    Problem Deploying Application Using CR Viewer in VB 6

    Hi all Not to sure if this is the correct forum to be posting on for this or not but here goes. I have an application that lets a user select the specific type of report they want. It then prompts them to click on different options and then goes and creates the report through a Crystal Viewer...
  8. MadCatmk2

    Optimising Program

    Hi Mark I've been trying to get round the example that you posted. Its a great start but i don't think it quite does what the original code does (Please correct me as i may be wrong). In my original program the idea is as follows: It takes a record, then checks the patient_number. From that...
  9. MadCatmk2

    Optimising Program

    Thanks for that. I'll look into adding it into my project and see if it speeds things up. Your help is much appreciated.
  10. MadCatmk2

    Optimising Program

    ...= Array(0, 0, 0, 0, 0, 0, 0) 'array to store duration sums for each of the 7 seven day periods sqlGetContactsForPatientNumber = "SELECT * FROM LHCC_CONTACTS WHERE LHCC_CONTACTS.Patient_No = '" & CurrentPatient & "'" rsReducedContacts.CursorLocation = adUseClient rsReducedContacts.Open...
  11. MadCatmk2

    text box size

    Brian, LB Thanks so much for your help. Both of your suggestions worked great. I am going to go with Brian's suggestion (no offence to your suggestion LB), only as it is not specific to font choice and i'm not yet sure what the final font will be. Thanks to the both of you. Cheers
  12. MadCatmk2

    text box size

    Hi LBass Thanks for that suggestion. Sounds like a really good idea, i'm going to go try that just now. Thanks for your help.
  13. MadCatmk2

    Current Date Formula

    Hi Croaks Not to sure if this is what your looking for but: you may be able to use ({Operatives.TARGETTURNOVER}) / month(currentdate) the month() formula should return the month number. HTH
  14. MadCatmk2

    text box size

    hi all Crystal 9 with Access 97 database I would like to know if something like this is possible: At present i have a report which just has some data shown on the details section. There is a text box which has its coulour set depending on the value of a formula. This text box is the full...
  15. MadCatmk2

    Problem with running total evaluate function

    I got the problem resolved. I ended up splitting the large formula into three smaller ones. One for Interventions, one for Primary_Reason_For_Care and one for Other_Reason_For_Care. like so: if instr({CONTACTS.INTERVENTIONS}, "BLM")<> 0 or instr({CONTACTS.INTERVENTIONS}, "BLW")<> 0 or...
  16. MadCatmk2

    Problem with running total evaluate function

    Thanks for your suggestion. I've changed part of the code to what you have posted. Upon checking each part individualy against the database the seperate formulae seem to work. The problem occurs when they are joined together. I also tried a method of counting the relevent details according to...
  17. MadCatmk2

    Problem with running total evaluate function

    Hiya Crystal Version: 9.0 Database: Access 97 I have a number of running totals in my report but i am having particular problems with one of them. The running total counts the number of visits to a patient and is evaluated using the following function: ( {CONTACTS.PRIMARY_REASON_CARE} =...
  18. MadCatmk2

    Graph for each date

    I've realised what is causing the problem. The dependency changes for each contact, so when it comes to out putting the graph, it only shows the last value that dependency has taken. Would anyone be able to suggest a way of getting round this so that the dependency value is stored for each...
  19. MadCatmk2

    Graph for each date

    Thanks for the response. I've tried what you said, and unfortunately it returns the same chart. The dependency value which is shown on the Y access (which can only have the values 1, 2 or 3) always reads 1 for each date. I can't help but think that this happens because the dependency value is...
  20. MadCatmk2

    having problems with default user profile

    Bcastner: Thanks for the reply. Could you let me know how i should be doing this as i'm a newbie with XP. Thanks

Part and Inventory Search

Back
Top