A few probems...

[jamesWP]

Hi there, probably sounds rude just dumping my database on everyone but I have searched and trialled and errored and gained no results, I know that I should have designed my database differently from the beggining but if I can save this one that would be alot easier, it won't need to be updated in the future so any quick fixes will be appreciated.

Here are my problems with my attached database, firstly open it and load teh form 'Main',

[FIXED]Problem #1: go to the 'Orders Tab', notice how all the labels have mouse over effects, the top right label doesn't seem to work with the mouse over effects.

[FIXED]Problem #2: In the 'Orders Tab' scrolling with the mouse wheel always creates a new record even if its on a new record, any way of fixing this other than disabling the scroll wheel on this form.

[FIXED]Problem #3: On the Companies and orders tabs the invoice and delivery note criterias don't work, I've checked these thoroughly and notice nothing wrong with them, probably just my shuoddy programming =\.

Problem #4: When the reports are empty they always bring up 2 message boxes instead of one, also the cancel = true doesn't work for these reports.


So, not asking you to fix it all for me, or even look at the database, just that if you've had these problems before could you pass a bit of advice please .

Yours,
James Prince

 

[boblarson]

I was looking at your reports and if I took away the data so it wouldn't have any data, I got the message box and got it twice.

But, when I went in and modified the On No Data event for each like this:

Private Sub Report_NoData(Cancel As Integer)
MsgBox "No Matches Found.", vbInformation
Cancel = True
End Sub

it worked just fine - gave me the message (once) and canceled the open of the report.

 

[Pat Hartman]

When the report is opened by a macro, you will get an error and there is no getting around it. When the report is opened by DoCmd.OpenReport, you will get an error that you can trap. It is error #2501 (I think) and you can trap it in the sub that contains the "OpenReport" and just ignore it.

 

[jamesWP]

Thanks for the help guys, got it all working now, I'll have to design it better next time though .