Search results

Hi I have a continous form, and i am constantly right clicking and finding the "contains..." filter. is there a way of having a box on my form, into which i can type a few letters and depending on which field my cursor was in, it does a "contains..." filter? many thanks i.

You are a tweak God. I am honoured to add to your reputation! Ian

one problem has arisen though. previously if the ticket price was £0, it didn't dispaly at all, which is what i wanted. however now we have converted it to a text field is does appear as £0. Is there a tweak that could be performed to make the field blank when there is a £0 ticket price...

Hey, I got it and it worked!!! Thanks so much. Really appreciate it. Ian artsalive.co.uk

OK Thanks, I think I get it. So the line "£" & Iif([fieldname]-Int([fieldname])=0, Format([fieldname],"0"), Format([fieldname],"Fixed")) doesn't look like a normal line of code, i can just about see what it is trying to do, but i cant put this is an event procedure can I? I have tried...

Hi sorry if i am dense, i didnt understand your reply Galax. Is that the solution or did you find another problem?! ian:)

Hi I have a ticket printing report. On some events tickets are £4.50, but on others it is £4.00. I want the latter one to read £4 - losing the trailing zeros. I assume it is an OnFormat event, but is there a command to lose trailing spaces? It is a currency field. Thanks ian

Re: Bizarre form behaviour Well it worked! Thanks very much. It was bizarre though that my copy of the database had "no color" and worked ok. andtheir didn't! anyhow, really appreciate your answer. Ian

thanks very much, i'll give it a go... and report back. ian

Re: Bizarre form behaviour Hi GTH Thanks for reply. no it isn't in the header but in the detail section. Though interestingly there are tab controls on the page and the combo in question (along with 3 others which dont have this problem interestingly), is not on the tab - so it is viewable...

Hi I am working on a database for a local charity. On my computer everything works well and I cannot replicate the problem they are having with the database. It isnt a serious problem just very inconvenient and i cant think why it might be happening. It concerns onwe control on one of the...

Hi thanks for your reply. Interesting logic. Whilst trying it, i disocered that there must be something else going wrong, as there is a 7 may date and a 6 may date (which is what dtmBestdate was returning). here is the rest of my code: Dim dtmBestDate As Date dtmBestDate = date...

Hi Aubrey Is the form based on a query? If so (and mine are) just add a line on the query, under the [authorised] field saying <> "authorised" this assumes the field is a text box and has the word authorised in it! I would probably want to make this field a tick box. do this help? Ian

Hi I have a continuous form with 600 records with dates in it, some past dates some future dates. When the form loads I want it to go to todays date, or the nearest date before today if there isnt a todays date. The code i use at the moment is: dtmBestDate = DMin("[DateField]"...

Thanks Simon, will give that a go. Appreciate your time. Ian

hi simon, thanks for responding. A few more details would be appreciated. I know how to do a query, but a query in a recordset i dont think i have done and as for looping through it - sounds fun, but not sure where to start. a couple of pointers would be grand. cheers ian

you'll need to provide a little more info than that. i couldnt get your database to work at all - it is linked to a datbase on another path y:\. also there were missing references when i tried to run it. where exacty are you getting the error message - and when? ian

hi i can get access to send an email, even with some data from the form in the email(thanks to this forum). However what i would like to do is this: i am on a form with date records of film events i organise for a variety of venues. i want to click a button and email a particular venue with...

Re: getting rid of filter i love this forum!

Re: getting rid of filter you're the man. it worked a treat. thanks so much for helping out. really appreciate the time and thought you have put into it. best wishes ian p.s. thanks to the others too for trying! :D