Search results

Penis envy?

Not only will he get a few more reasons, but also a bunchload of spam if you keep that e-mail address on the forum. Maybe you want him to get those 'special e-mails' though eg mAkE y0urS 4 InCHeS LOnGeR! but I think not :p

Put the value you want to filter on into the Criteria box in the Query Designer grid (QBE grid) under the field you want to filter. A little more tricky. This Example Should help you along. hth

That should work but how and where are you using it?

Put your messagebox code into the Form_Unload event. It will then fire everytime you want to close the form.

In the message box, you are giving the users a choice of Yes or No. Why then, are you allowing a Cancel button as well? Also, you are firing the event on the Before_Update which will only fire if you have made changes to the record. Why do you need to ask the client if they want to save changes...

I have to say, that is your best yet (although I hate to admit it). For you, an eternity :p

No problem. I knew I'd make sense eventually :cool:

Best way to do this would be with code (+/- query). Use a dcount to count the number of available trees at the size ordered then use a select case / If..then to get the rest of the trees from the next size up/down and adjust the stock levels accordingly. To give the exact code would need the...

No, I get what you mean. Try this. (a bit rough and ready mind you)

You can do this using the aggregate functions in the query eg Group by, Count etc. To display these (if you do not already know) depress the Sigma button on the query toolbar to enable these functons. hth

No problem. Did not realise you needed the second IIf statement.

Between IIf(IsNull([Forms]![frmSearchAll]![StDt]),[tblRecap].[Date],[Forms]![frmSearchAll]![StDt]) And [Forms]![frmSearchAll]![EndtDt]

I would actually change your data storage structure to store the actual game result rather then the points scored. You can then use a lookup table to determine how many points were scored ie tblPointsLookup ResultID (AutoNumber) ResultDesc (Text) ie W, D, L ResultPoints (Number - Integer) ie 3...

Right Click.......Save Picture As... :p

It is possible but a non-efficient way. Start learning VBA then you can use functions such as DCount to do exactly what you want. Access help is not bad at guiding you along. To get to grips with it, look at the code that access creates itself (eg behind your button to open the form). Without...

This is ones of my faves - I use the images as buttons and even (on occasions - create rollovers with 2 of the images) http://www.prodraw.net/button/

This post may give you some ideas http://www.access-programmers.co.uk/forums/showthread.php?p=249418#post249418

I hope not. I once tried converting a Db from Paradox to Access - took me 8 months :( This company has a £6m turnover per year, making construction and insulation panels in the North Shields area - at least I'll get some insulation for my loft for it (oh and a lollipop) :D

Error in the code I gave you. (oops) Should be if not isdate(dteTime) then 'I've used not isdate rather than isnull as it picks up null dates better TimeConversion = Null goto Exit_TimeConversion end if