Recent content by Sound Steve

If you search on here you should find some code to refresh the chart. I have had this problem too....can;t rememer the code though!...i'll have a look in my files!

Wonder if anyone can help. I have inherretied another legacy.....this time a Timesheet database. I'm trying to cleanit up and iron out the issues....i wonder if anyone knows how to deal with this..... When i try ti preview the timesheet i get the following error... "Run-time error '7794'"...

I have attached a copy of a sample chart i wish my db to create. I have created the sample in Excel(where it was simple!). Does anyone know a way of making Access generate the X-axis in the style shown as it would be ideal fro a set of graphs i require form my db project! It is primarily the...

Does anyone know if this is possible in Access...i know it can be done in vb forms, but am unsure about MS Access form graphs.. I have an access package which produces a series of forms with graphs on them. My client is keen to be able to click on, for example, a bar in a bar chart..and this...

I Found this in another thread..might help answer the Question I Found this in another thread..might help answer the Question..thanks ro SSmithri for the solution.

I think this problem occured due to a service pack 2 issue with windows XP. Updating the Service Pack leads to the problem dissapearing

Thanks...your a Genius..have been puzzling on that one most of the morning!

Does anyone know if it possible to create a command button, which when pressed has an event procedure to bring up the linked table manager window? Am not sure what code i would need to place in the event "on click" property of the button?

thanks Thanks for your help and advice. Am going to recommend to the management we look at sorting out the bigger issue though (i.e the string variable dates). I think it might be as easy to get it right first time...rather than putting off the enevitable with "quick fixes" Your comments and...

Still not working compact and Repair didn;t work :( :confused: the line of code it is failing on is.... Me.txt52 = Format(monthdate, "mmmm yyyy") Where Me.txt52 is a textbox, and monthdate is a variable holding a date in it.

references Am not sure which reference i would have to add in!

format i get a "compile error" "can;t find project or library" message when i try to execute code with the format function. Do i need to enable it in the library menu?

Your telling me i've inherited a nightmare!!!! Where do i place the Format function? This is an outline of the code i'm trying to get to function at present. I want to check if a checkbox has been ticked. If it has i would like to populate a text box with a year and month. these will then be...

Hi there, Am trying to update a databse made by an ex emplyee of our company and am stuck!!! I've created a new form to enable the user to select daily/monthly or weekly reports based on the underlying set of tables/queries. The problem is that i intend using the calendar control to allow the...