Recent content by pcca

I have several questions about my clients that are yes/no answers e.g. Was the client referred by a hospital? Was the client referred by a physician? etc. I want to be able to count the number of records for each yes/no question. i.e. 5 clients were referred from a hospital, 3 clients were...

If not hyperlink than How pbaldy, I understand what you are saying about creating a report. But I want the button in the patient's record to pull up their specific survey. Sorry I'm so dumb.

If not hyperlink than How No, the survey is in Access in a table separate from the table of patient demographics. The patient takes the survey and it is then entered into access using a form and goes into a table of survey data which has the patient's identification number as the primary key...

No, the survey results are in a table in the same access project. The primary key is the same as it is in the patient data table (patient's identification number is the primary key). The patient takes the survey on paper and then someone else enters it into access through a form. I want a button...

No Record found message I'm using a form to run the query. So the event for the button on the switchboard is as follows: Private Sub Command9_Click() On Error GoTo Err_Command9_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Find a Client Record"...

I have 2 tables - one for the names and data of patients and the other for satisfaction surveys they have completed. At the end of the form that contains all of the patient's data, is a check box indicating that they have completed the survey. If they have, I'd like a way for the user to have a...

No Record found message Sorry Kidrobot - I don't understand at all. I'm new to Access.

No Record found message I created a select query where the user is asked for the patient's last name.

I created a query to find records by patient's last name. If one isn't found, the blank form comes up. How can I create it so that if there is no such record, the user gets a message box with that message rather than the blank form?

Thanks RuralGuy.

I've created a form to enter new client data into a database. I put a button on the switchboard to bring up that form but it comes up with the data from the first client showing. How can I make the form open up blank? Thanks.

Can't print form The form isn't from a query. Its just a form to be used to enter data. The form was created from a table. When I print the form by doing file - print, the only thing that prints is the date - same thing if I put a print button on the form. There is no data yet in the form (as...

Can't print form I tried doing a report but there are many fields and it loses its formatting. I was able to create and print a form once before (last year) and can't remember how I did it :o

I created a form for data entry that I'd like to print out so it can be completed by hand if necessary. When I print it, the only thing that prints is today's date. I added a "print" button to the form but same thing happens. :confused: