Recent content by MadCatmk2

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

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

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

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.

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

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

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

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

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

Hi all I hope someone can help me out with this. I am trying to write a program to return the dependency of a patient at each contact made to them. I have a database to start with that has all contacts made to every patient. I need to check each contact for the patient and see how many other...

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

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.

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

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

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