Recent content by stuart_adair

Thanks Mark. Where should I put that code, in the 'After update' of the Priority field ?

Hope you're not fed up with me yet. I've tried this in the 'after update' box on Priority which gives me a type mismatch error after I update the Priority box. Its progress as I'm getting a formula to run but I've obviously got the syntax wrong. This is what I'm using ....=...

Ps: Tried to add the formula you gave me to the 'After update' event box on the Priority drop down but I get a message "Compile error expected ="

Thank you for your replies. Mark you are quite correct in your logic, however as the field already exists and I use if for reports further down the line I'm keen not to change things. Isskint - Alas your suggestion didn't work. I think I know why (Forgive if I'm overstepping the mark)...

Hi, I have a database with fields called: Date Raised (Date which defaults to todays date) Target Closure Date (Date calculated) Priority_2 (Tick box) Currently the Target Closure Date is automatically calculated by an entry in the default value on the form which reads [Date...

Many thanks for the reply. It seems like I'm being overcomplicated and barking-up-the-wrong tree. Lets me post the problem again and try to keep it simple... I've got a table called 'depots' which has a list of depots and their associated regions. I've got another table called 'main' which...

Hello all Could you please help me out with some syntax. I've got a form with 2 fields. Text421 displays a value based upon a lookup on a table and works fine. I want a field called Region to be populated with the value of text 421 after it updates. I've tried being all logical and in...

Hello all, I'll keep this one to the point... 3 fields on a form: MD Door Customer Door Text 400 (Currently unbound) I want to change the properties of the the Text 400 field so its green if MD Door and Customer Door match, and red if not. Thanks as always. Stu

Genius Bob. I can see the logic now and I've got the region populating exactly as I want it on the form. Only hurdle I now need to overcome is to get the region field of each record on my database to match the text box linked that is displaying the region on the form. Thanks once again. Stu

Hello all, I've read some historical answers about my question but I'm still struggling, so apologies if I'm raising an old question... I've got a form with a field called 'Depot' which saves to a table called, Main. I've also got a field called, "Region" in the same table which is currently...

Hi and thanks for the reply. Each region has several locations and each report query just identifies those. Ie:- the query criteria goes something like = "Liverpool" or "London" or "Leeds". I've got 3 queries and 3 reports running which produce 1 for each region. Apart from the different...

Ok, no replies so how about plan B. How can I get access to attach more than one report to an email. The send object function will only allow 1. Thanks

Hi folks I run and Access database that contains performance information at work. Each day a report is run which has a depot name and a performance figure and this gets sent out to all 30 depots as an email attachment using the "Send Object" macro function. I've been asked to regionalise...

Hi Folks Hope everyone is keeping well. I've got a simple form running with a tick-box called field called, "Paid". When the box is ticked I want the form to update another field called, "Expiry" to be 1 calendar month in the future. As usual I'm struggling ;) Stu

Hi Can someone please let me know how I can add column totals to a crosstab report ? Thanks stu