Recent content by Dazzla

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

I could try that, As i say the filter above does work however for some of the dates it does not like and throws back blank records when i know there is stuff there. These dates always seem to start with a zero. for example 03/01/2004. Dont know if this is a bug in Access or the way the...

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

I have tried this code linked to a button that seems to work, however i am now getting records that i know are in the database but for some reason it doesnt seem to like the date field and just brings back a blank screen. When i go into design view on the form and theck the filter through...

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

Thanks, sorry for being so simple but i am learning. Your a genious

Im sorry if im coming accross as not being to bright, but VB has never been my strong point. I did as you said, found something that i vaguely understood and put this in. Function ObjectExists(strObjectType As String, strObjectName As String) As Boolean Dim db As Database Dim tbl As...

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

Just noticed i missed the 2 of the second SearchStr but still get the same error.

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

Its ok it works now so thanks for that, Just needed to know how to open a template rather than a document. Should of really read the message further up :cool:

Thats great and does the job thanks, but just to be awkward would the same code work for opening a document template or would it be different. Problem is that if users open it up in word and then save it. They overwrite the bookmarks.

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

Thanks for that, my silly mistake