Search results

  1. J

    Printing issue

    Hi, When I print a report from Access, it prints fine. When a colleague does it to the same printer, it misses out lots of letters. Another colleague does it, and it prints fine. The font is standard (Calibri). My IT dept. say it isn't the printers fault. Is it something wrong with my report...
  2. J

    What do i need to change to stop crashing?

    Hi, The code below is working well, it opens an Excel spreadsheet version of the query I want to run and it saves fine. However, if I click "cancel" instead of choosing to save the spreadsheet, Access crashes out. Any ideas what I need to change please? Thank, Jim (p.s., not sure if you need...
  3. J

    How to run a report while just entering parameters once?

    Hi, I've made a report on a blank report template. I've dropped in 5 sub reports. I have entered into the criteria for each of the queries based on [forms]![ClientForm]!CleintID. to run the report. It wortks but I have to enter the ClientID 5 times. Usually, when I create a button to...
  4. J

    Filtering a report made directly from a table?

    HI, I've created a report which has 4 subreports linked to it via a ClientID. The problem is it prints 2000 reports for the 2000 different ClientIDs. I want, went the button is pressed, for it to ask what ClientID the users wants to print the report for. I know how to do this in a query...
  5. J

    Bigger check boxes?

    Hi, I see that I can't make the tick/check bigger in properties. Is there a way of getting a bigger one on the report at all? I have about 30 to do on a report so I'm praying its not a lot of work each time. I saw on Google that someone suggested using Wingdings tick but not sure how to do...
  6. J

    Is there a size limit to detail section of a report?

    Hi, We are creating a report and for some reason we can no longer extend the detail section of the report. It has stopped at 2 A4 pages length and won't let us extend it further. We have about 7 pages of the report, I didn't think this was too much? Anyone know how to change this please...
  7. J

    Ticks/Checks in reports?

    HI there, I am creating a report and am struggling to use ticks/checks in it. I have a query that looks for a date in a field and if there is a date, return "True", Else "False" in a separate field. I am wanting on my report to show the date, and next to it a tick if there is a date in the...
  8. J

    linking Excel to Access to Word 0.o

    Hello, Due to the complexity/time it takes to run of a query, I had to break it up into smaller queries and run them individually. From this, I pasted it into 1 spreadsheet. My boss now wants to do a kind of mail merge (not addresses etc, dates of courses etc) from the spreadsheet into a...
  9. J

    All records with 12 months of Date()?

    :) Hi, We have a field (tbl_Enrolment.CourseCompletedOn) which holds the date a colleague completed a course. I want to bring through all courses completed within 12 months of todays date ( Date() ) from our database. Is there an easy way of doing this? I checked google and it...
  10. J

    Question Stripping out unnecessary Access functions?

    Hi there, Our Access database is getting a bit sluggish when loading/running reports. My mate said to me that the Access database that our 100+ users at work use to run reports should be "stripped back" to speed things up and to stop unnecessary actions running when they aren't needed. He...
  11. J

    Return max date of multiple columns

    Hi there, How do you return the most recent date of multiple columns. I have a table (tbl_courses) that has a list of training courses. We want to know when a client completed the course most recently. The problem is, for one course there has been up to 4/5 different variations of...
  12. J

    Can't get distince values to show in Combo Box

    Hi there, I've used this guide http://www.techonthenet.com/access/comboboxes/unique_values2010.php to only show unique values in a combo box. I can't get it to work, it just shows a load of blank values. If I run the expression builder part from the background, it works but it doesn't work...
  13. J

    Exporting queries into multiple Excel worksheets

    Hi guys, Work have asked for a lot of information to be run from Access and exported into Excel. The info they require will need to be exported into 4 Excel worksheets in the same workbook. Is it possible to tell Access that when they click on the report button on the form, it will...
  14. J

    Query to show DOB that are at a certain age by NOW()

    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...
  15. J

    "Time" field keeps turning into a calender

    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...
  16. J

    Symbols appear on printed Access reports?

    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...
  17. J

    Drop down boxes before opening report?

    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...
  18. J

    Using DLast with criteria

    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...
  19. J

    Expression to show years and month difference between 2 dates

    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...
  20. J

    How to get Access to check for a condition in a table

    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...
Top Bottom