Search results

Does anyone know if it is possible to export a report (which is a chart) into Excel.

Is there anyway of clicking a button on the form to view the subform instead of it being there all the time .

I have a report that shows a graph for each timeslot showing the frequency that an instance has gone wrong and the reason it did. The legend in each graph shows the reasons. I want the legend colour to remain consistent throught the report. ie. for each timeslot a graph is provided, i want the...

I have a patient form that has a subform showing the care plans. At the side of each care plan for that patient i have a button that if clicked will take you to the specific care plan. I need this to open the care plan form based on multiple criteria which is Date (Date Field) Care Plan...

Right, i have a database that creates tables using the make table query. What i want it to do is delete these tables when the exit button is clicked. The Vb i used will delete the tables if they are there, however if they have not been created i get an error message saying it cant find the...

I have a button with this code attached Dim SearchStr2 As String SearchStr = "[PROTECHNIC_NUMBER] = " & "'" & Forms![FRMPATIENT]![Frm_ICP_Select].Form![Protechnic_Number] & "'" _ And "[ICP_Code]" = Forms![FRMPATIENT]![Frm_ICP_Select].Form![ICP_Code] DoCmd.OpenForm "FRMASSESMENTHEAD", acNormal...

I have a form with various details on clients. I have 6 different letters that need to pull off different fields from the client form. Is it possible to have a button (for each letter) that when when clicked will open up the word document for the specific client with the fields on their...

I have a form with a subform on with the visible value set to false. After a value has been selected from a combo box i then want this subform to show. Tried calling the form using me!formname.visible = true in the afterupdate but it says it cant find the form. Any Ideas how

I have a patient form that has the patients age on it. i now want to count the number patients in different age groups by gender. Say 25-35, 26-45 etc. and put this into a report. Is this possible to do in a query or report

I have tried these examples, but every time i go to open the calander i get an error message 2683 saying "There is no object in this control" Does any one know why? :mad:

I have a form where i can enter a clients payroll number and click the search button. This will then give me their details. Is there anyway i can make it show an error message if:- 1. They dont enter a payroll number and click search 2. They enter an invalid Payroll Number and click search.

This may be simple but im new to access. Is there a way for me to only open a form(from a button) if a value from one of the fields in the form to be opened is set to "open"? I know this could be done through a query, but is there any VB that could do the same job.