Search results for query: *

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

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

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

Hi all I have been trying to set up an XP machine and require to set up some inhouse software on the default profile so that any new user has access to it. I have set up a local profile and then installed the software. From that i have copied the profile to the default user profile. The...

Hiya Crystal 9 Access 97 Database Hope someone can help me with this. I have a report showing each visit_date for a patient. Attached to this is a value for the dependency 1,2, or 3. I have tried using the chart wizard to show a graph of all dates in the X axis with the corresponding...

Hi all Using Access 97 Database with Crystal 9. I am writing a report to calculate dependency of a patient. The details section of my report consists of: [Date_Of_Visit] [Time_Of_Visit] [Duration] What i want to know is if the following is possible in the report: For the current...

Hi all This problem is driving me up the wall!!!!! Hopefully someone can help or suggest a reason as to why its happening. I'm using Access 97 to query a table of contact details. Firstly i have this query: SELECT BM_CON.* FROM BM_CON WHERE (((BM_CON.DATE_OF_VISIT)=#4/27/2004#) AND...

Hi all Was wondering if anyone has attempted to do something like this and could give me a starting point to attempt it. I am looking into writing a program which takes a random selection of 6 numbers and generates an equation using all the number only once. I can write the app so that it...

Hi all I have a question regarding combining two queries into one that will do the same job. I have created two access 97 queries: The first (temp contacts) is designed to query a table [Contacts] for all fields where the patient number = a certain value SELECT CONTACTS.*...

Hi all Having a real problem with an access query. I have a table which stores data on contacts made to patients. I want to get a list of patients that have duplicate contactsdetails. The problem with this is that there are a couple of fields which will be different. I want to get all the...

Hi all Crystal 9 Access 97 Database Hope someone will be able to help with this one. I have a report with many page header sections on it. Some of these headers are suppressed depending on the value of {@Report Type}. There is a box object around all of the sections but there is a problem...

Hi all Crystal 9 Access 97 I have a problem with the report i am writing. At present i have details of visits made to patients. i.e. Patient_No, Patient_Referral_key, Referral_Date, Discharge_Date, Last_Contact_Made_Date, Date_Diff i am grouping on the Patient_Referral_Key. This key may...

Hi people Access Ver. Access 97 I have a database table ([Contacts]) relating to contacts made to patients. In this table i have a field called primary_reason_for_care. This field is a three letter code that links to a codes database and to a table which lists the full description given the...

Hi all Quick question to see if it can be done. When using acces it is possible to build a query and then use this query in the query builder when creating a second query. What i want to know is that if it is possible to write a sql query as a string in VB but use a recordset which is...

Hi all I currently have code which out puts the correct data onto a Crystal report viewed with the CRViewer control in vb6. I have one problem however. Once i have added the group in the second if statement i would like to sort the data based on the date of birth field. For some reason the code...

Hi I'm not sure if i am going about this in the correct way but hopefully someone can shed some light on the matter. I have a SELECT query in the program that i am writing which returns a subset of data from an several tables in an Access database. The query is displayed in a true data grid...

Hiya Crystal 9 Access 97 Database I have a question regarding a report i am creating. I'll keep it as simple as i can in the hope that someone will have some idea as to what i need to do. The report is to show the dependency of a patient and bases this on the the amount of visits that the...