Replies

You probably need to wrap each occurence in NZ()

!curFixedAmount = NZ(Me.curPriceShekF) + NZ(Me.curPriceShekM) + (fGetYatzig() * NZ(Me.curPriceDollF)) + (fGetYatzig() * NZ(Me.curPriceDollM))

HTH

Peter

On IE6 W98 it works OK, but it is very sensitive to mouse movement. Using my trackball it worked fine with fingers off the ball but if I kept fingers on the ball then the slight movement on the ball when clicking would fire the mosue over event again and turn the button red.

HTH

Peter

If the report is just a single page then you could just copy all of your controls twice more to make it a 3 page report and add a label at the bottom of each page to show where the page goes. You may need to add page breaks to make break correctly.

HTH

Peter

If you go to tools>add-ins>linked table Manager you will be able to

One thing that might be worth a check is that in Excell as not been set to “Ignore other aplications” in options on the General tab.

HTH

Peter

could you not just build another query using your new criteria for the second list?

Peter

I have the DB split and secured, the managers get the form it opens on and that

I had thought that the company standard was for A97 but it turns out that a few managers have A2k. I have produced a Database that will be used factory wide but only 2 people will have write privileges in the DB, using user-level security.

I have not had a chance to test the DB using A2k but if there is no real speed advantage in conversion then I will try to just open the DB in A2k which will save me problems when I have to change the design yet again!

Peter

Hans
Do you know if there is any difference in efficency between converting or not converting a A97 frontend to A2000 when working with a A97 backend?

Peter

dbPowerAmp is worth checking out as well. The tools to rip and play music files are , there is also a CD burner but that is shareware ($14 USD ) but she should be able to burn quite a collection in the 30 day grace period! There is also a shareware powerPac the gives added functions.

HTH

Peter

This works the same way with my std version of excel set to English (United Kingdom) in the regional options. Looks like another case of Microsoft preferring American dates.

Peter

You could probably use TransferText to export the query as a delimited file.

HTH

Peter

Thanks Mark
This will give me something to go away and paly with for a couple of hours

Peter

Thanks Hans.

I may end up exporting the data to excel when it is all sorted so a query would be best. I may just end up doing it in code but I think that it will be too slow.

Peter

If the option has not been turned off in the startup options then F11 should bring up the database window.

HTH

Peter