Search results

Not sure if what I'm trying to do is possible, but it's worth a try. I currently have the following code, which works fine: Private Sub Closed_AfterUpdate() Me.Status = "Closed" If Me.[Closed] <= (Me.[Received] + 1) Then Me.[24Hour] = "Yes" Else If Me.[Closed] > (Me.[Received] + 1) Then...

I'll take your word for that. I have to enter my dates in US format then have access convert them back to the "proper" UK format. I work for a US company and my PC has to be set up as US regional so I can access some of their systems even though I'm in the UK. It causes some strange results...

Thanks. Was giving me a type mismatch error but changed it to <=DateAdd("w",12,Now)and it worked fine. Cheers, T

OK, Very quick one. I have a report that lists the expiry dates of certain items. Control name = [ExpiryDate]. At present, my report works fine but lists the expiry date of every item in the database. What I want it to do is only return entries where the expiry date is 12 weeks or less from...

Actually, ignore that, the caffeine has kicked in and I've managed to fix the row source setting myself. Thanks again. T

OK, I get that. Next question I guess is, how do I make it stick? I have other forms where a similar approach with a single filter criteria works.

Turns out my thanks were premature, when I reopen the "Rules" Form, the Rule Book field has been reset back to blank...

Thanks. It was the " between the & and AND that was throwing me... :banghead:

I have three linked tables [Regulator], [RuleBook] and [Rules] (each has a corresponding form for data entry). In the "Rules" form, when you select name of the regulator, the rule books dropdown down is filtered to show only the rulebooks for that regulator. the code I use is: Private Sub...

I possibly could, but pbaldy's one was easier as I'm familiar with the syntax of IIF but I've never used a DCount. Cheers anyway, T

You've come to my rescue yet again. Many thanks.

This should be (and probably is) fairly simple, but for some reason my brain has gone into meltdown and I can't figure it out. I have a fairly simple database (A2007) for recording accidents. I have built a report that, for a given date range, lists all the incidents within that time span. In...

Actually, ignore that last question, I just remembered £#,##0.00. All works fine now. Thanks for all your help. T

I tried it again today and it worked. Strange! Still can't get the comma thousands seperator though.

Odd, it works for me now. Any idea how to get the comm seperator?

That almost works, but it rounds everything to a whole number of pounds, eg 2125.17 displays as £2125.00 and not £2,125.17 as I would want it.

Thanks Simon, That may end up being the solution I opt for. My problem isn't that I'm in a multi currency environment, all the users are here in the UK and the only currency that will be used is UK £. The problem is that even though we are here in the UK, our regional settings have to be set...

Thanks, although sadly I'm not much the wiser. Where do I put this? When I put it in the format box, the results in my report are gibberish.

By virtue of my work PC being required to talk "American" despite me being in the UK, my regional settings have to be set to English - United States. It's a pain in the you-know-where, but it can't be avoided as I work for a US company and I have to access their databases and applications. I...

Worked a treat. Thanks a lot. T