Search results

Thanks Graham

Is there a simple guide to creating a pie chart, I have followed the wizard and choosen six fields and dragged them to the data field but all I get is a solid chart for one field. It's late and I'm tired, I usually do all this in excel which is so much easier but I need this to be raised within...

Hi Rich Still no go, I have gone through all my codes and event procedures to see if there is any ADO's and I can't find any. I there an easy way of idetifying them. Paul

Thanks Rich, I have unchecked the ADO Objects Library in references and in A2K my app still works OK, however it will be tomorrow before I can check to see if that was causing the problem. Paul

I have converted it several times and tried it on different computers tyo make sure it isn't referencs etc but no go. Unfotunately it is an all signing dancing form so I will have to persevere. Thanks

I converted a database from 2000 to 97 using previous version. When I open the database I get the following error message: " Microsoft Access cant open the form [Name of Form]. It contains data that Microsoft Access doesn't recognise. Re-create the form or, if you maintain back up copies of your...

Absolutely spot on with the missing reference. Thank you both very much.

Thanks Rich, Your link didn't appear but you pointed me in the right direction, the only problem now is that becasue I used a commancd button to open the report, after I get my Msg Box I get another which is OpenReport Action is cancelled, how do I get rid of this second message ? Thanks Paul

Hi Rich Your link to the reference did not appear can you send it again or let me know which reference is missing. Thanks Paul

If I run a report from a command button and there is no data available the report opens with a blank report. If I run it from the Switchboard it gives a message saying that there is no data available. How do I get it to display this message from a normal command button

I have a query set up to extract info for follow up dates between 6 months and 6 months and 1 week from whatever current date I set it from. The criteria in the query is as follows: Between Date()+180 And Date()+187 this has worked fine until recently when I saved a version in Office 97 for a...

Thank you Fornation that would have taken me forever to find. Paul

I seem to remember going down that root some time ago and without success, not that it's wrong - I'm sure it's the solution. However I have used DoCmd. RunCommand acCmdPrint before which opens the print dialogue box but you then have to select the printer again which is the same as the File...

To stop people entering names and addresses into a Combo Box that are not on the main customer database I have set the properties as below: Set the Limit to List box in properties of the Combo Box to Yes Then on the NotInList box set an Event as follows: Private Sub...

I know how to create a MsgBox and enter it in events, but how do I stop the default system message from appearing. At the moment my error message comes up but when I click OK the systems default message is there and I have to respond to that as well, which defeats the object.

Hi Rich The file menu is Ok but you have to set it each time. I want to have a command button on the report, I had looked at the PrintOut Method but couldn't see where you specify the printer name or path. Paul

I can help with this as someone very patiently sorted it out for me. The Can Shrink is right but you must make sure the rows are touching each other (no spaces)and that there is absolutely nothing else on the same row like another field otherwise it won't work. HTH Paul

If you only want to count the pop up's use = Count (Column Name) instead of Count(*) the first counts rows that are not empty the latter counts all the rows. HTH Paul

Use File Send to Mail Recipient and depending on what your report contains I would suggest as RTF (Rich Text Format). See no VB in sight!! HTH Paul

Can I send a report to another printer that is not the default printer without making it the default printer. Using 2 printers at busy times for different reports would be very useful.