Recent content by Danny Clarke

How can I create charts from a VB procedure? Or even better, edit an existing chart since it's only the data that needs changing. The help file seems to say that you can change the RowSource property which seems the obvious thing to do but there doesn't appear to be such a property for the chart...

You need to show each project type as a separate series. The chart wizard should handle this for you. Any more problems, reply to this message.

Hello everyone! I'm having a bit of a problem getting chart data out of Access into Excel. That is to say, I can't do it... Is there any way to get an Access chart into Excel at all? I've tried (I think!) all the export options and you just end up with blank files. Any suggestions greatly...

I just found this out today, you lucky so-and-so! Put this in an event procedure on your form's OnOpen event; or wherever you want really... Me.[Control Name].Value = Date Works for me!

Well, OK, not steamy exactly but they're moving and I don't want them to! Does anybody know of an easy way of 'freezing' a windows position - I still want it to have a title bar and close box and so on - so I can't just give it no border... Any help greatly appreciated, Cheers, Dan

Thank you very much ListO! For anyone who's had a similar problem - you can automate the process by putting SendKeys "{F4}" in a subroutine attached to the OnEnter event in the combo box(es) required. Once again, thank you very much...

Is there any way to get the arrow keys to work within combo box lists as they do in list box lists? ie: when you tab into the field, using the arrow keys to scroll through the list values.

I'm not sure if this is exactly what you're looking for but you could try this: Private Sub AButtonOnYourForm_Click() Dim dbs As Database, qdf As QueryDef Dim val1, val2, val3 As String, strNewTitle As String, StrFilter As String, bo As String ' Return reference to current...

Hi Michelle! I think I can help you out while all the Americans are still in bed... You need to use something like: Forms![Your Form]![Combo Box].Caption="test" I hope that works for you!

I have a form which acts as a menu for the user (ie: several buttons which take the user to different reports). One of these buttons needs to take the user into the table itself. There's no problem there but since the menu form is a pop-up, you have to close it when opening something else or you...

I'm trying to do something similar at the moment so here's what I've managed to achieve so far (ie: almost nothing): To import the Excel file: DoCmd.TransferSpreadsheet acImport,Excelv,"Your Table",filepath,True Where Excelv is the file version of the Excel sheet (eg: Excel3, Excel7...

I'm trying to write a sort of 'quality control' module which looks for mis-typed data in some text fields and corrects it. I'm assuming I want to use wildcard characters in my criteria expression but I can't seem to get the &%**!##* things to work... The expression I'm using is as below...

Set up a form with your checkboxes and a command button to print the report. The command button will need some code attaching to its OnClick event. it could look something like this: (I have assumed your checkboxes are called 'Box 1', 'Box 2' etc. and that you have a table called 'Labels' with...

Probably the easiest way is: Choose a field in the table (your primary key will do) and use the following formula in a text box in the footer: =Abs(Sum([Your Table].[Your Primary Key])) Works for me!

Thank you! This works perfectly now. Just one more question: If you have to do this by the Sorting and Grouping menu (which works), why bother including the OrderBy stuff (which doesn't work) in the properties toolbox?