Search results

Hi Liam, I will try this today/tomorrow and post back. Thanks J

Hi Rain Lover, I cannot download the attachment, it saves as a php file? It won't save as a mdb file? Any suggestions. I have Access on my PC so not sure why its not recognising it. J

Apologies, been on my hols. I'm going to give these a try today and see if I can get ti to work. I'll report back soon! Thank you both. J

Hello! Is there a way of finding out who is turning18 years old in the next 6 months on a set day. Specifically, I want to minus a date of birth from todays date (DateDiff?) and then for it to show those people who will be turning 18 in the next 6 months. I've tried a range of...

Actually, I've fixed it. We had the autocalender setting ticked so it was forcing us to bring up a calendar. Apologies for not thinking! Jim

Hello, We are setting up a table and are trying to get a field to be a "time" field. I've changed the field to "date/time" and have chosen 'short time' in the background but when I open the table it keeps giving me a calendar to choose from then turns it into a time. Not sure what I'm doing...

Thank you for this, I changed the font to something mopre standard and it has fixed the problem. Jim

Hello, For some reason when my colleague prints an Access report, she gets a range of dollar signs etc. on the report. After she has printed, what is displayed on the screen has also changed to these symbols. It works fine for me however. Any ideas how to fix this please? I was thinking it...

Thanks PBaldy, I'll have a go at making one this weekend and i'll ask any problems I have here. Thanks for the useful link too! Jamie

Hi everyone, I've made a query and designed a report for it. Simply it includes: Area code, customer name, other customer details. I want other people, when they click on the report to be given a drop down box which allows them to choose a specific area code before it generate the...

This worked! Thank you Plog. I have now informed my boss that DLast doesn't do what people think. Thanks to all you guys for help suggested...I'm in my 4th week of using Access so struggling with some simple stuff. Jamie

Hi Plog, the Review Date is a time/date field. If I use: Last review: DMax("[ReviewDate]","[Tbl_OutcomeHistory]") when I run the query it brings me a huge list of records. When I add <#01/12/2013# it returns no records. I know there are employees who's review date is less than...

Thanks Ken, I tired that before but it returns no values when I add that to the criteria. (I meant <2013, not 2014) Thanks again.

Hi, I'm trying to generate a list of employees who haven't had a review since Dec 2013.I'm using this expression in my query: Last review: DLast("[ReviewDate]","[Tbl_OutcomeHistory]") which brings up the last date the employee had a review.(I tried using DMax but it didn't seem to...

Hi, I am wanting to get an expression that will return the difference in years and months between 2 dates. Specifically, I want to know peoples ages in years and months based on a person's D.O.B and todays date. I have managed to do it in years: Expr1...

Thank you!

Hi again! PR2_eugin, The Nz function was really useful, thank you. Out of interest, if these an expression that does the opposite to Nz (i.e. lets you return a value when a variant is not null) Gemma, I couldn't get the "=iif(is null([confirmedfield],"N/A",[confirmedfield]) " expression...

Thanks for the welcome pr2-eugin! I'm currently learning Access so some of my Qs might seem obvious. I run a report each week and the manager has asked that in the report for any blanks "N/A" be added. I'll have a read up on unbound controls as I've never heard of them! Thanks again!

Hello, Apologies if this is in the wrong thread, I'm relatively new to Access 2010 and not sure if this is a table question. I want Access to look in one table for a certain condition, and if it is true to autofill text in a different column but I've never done this before...