Search results

Hi, I have a report that takes data from two different IT systems and highlights where there are differences. Most of the data is dates. This works OK where there are two dates i.e. if they're different it highlights both and if they're the same it doesn't. But if one date is missing, then...

Brilliant - that got rid of them. Turns out that Japanese had been included as an enabled language. I'd never have worked that out! Odd though, that I had to INSTALL Office 2003 language settings before I could remove it again. I don't see how she enabled it in the first place. Thanks so...

Use the conditional formatting button and change the dropdown from 'Field Value Is' to 'Expression Is'. Then enter the formula DateDiff("d",Date(),[WorkDeadline])<=7 and set your required formatting e.g. red text or red shading. Next add another condition, select 'Expression Is' again. Paste...

I never knew about that one. Great tip. I wonder if that's why so many of my reports seem to have a blank page at the end

OK, I see what you mean. You'll still need a table of dates, because the date you enter will need to refer to that table to get the week number. See the attached sample database. Take a look at the green box when you open Form1 in design view

You don't need VBA for this. Use the Grouping and sorting function in Report design mode and specify that you want to keep the whole group together. Select the group footer and put a page-break there. Attached jpeg shows example in Access 2003, I believe it's pretty similar in newer versions

View the "tab order". Scroll down the lsit until you find the field that lies closest to the top left of your form. Drag that field to the top of your tab order list. Save and close the form. That should do it. The tab order is the default order that your cursor will use to jump around the...

This is how I do it. Start in Excel, with two columns, WeekNo and WeekCommencing. In col A, inssert the numbers 1-52 (or possibly 53). In B2 insert 01/04/2013, under it, enter =B2+7. Copy that formula all the way down. You now have two columns with week numbers and dates. Save and close...

Hi, I'm using Word 2003 and suddenly some weird L-shaped marks are visible, that seem to coincide with the margins. See attached jpeg. Someone else was using this PC yesterday and must have been messing with settings. They're annoying me and despite hunting through various options and...

Thanks Dave - I did mention in the first post that I plan to have similar code on the AfterUpdate event...but I needed help to get the code right first! ...so I will get round to that. As for someone taking out a date they have previously entered, that also occurred to me. I haven't coded...

You, sir, are a diamond! The first one worked perfectly. As for the second, I'll admit I've never quite got the distinction between NULL and zero-length string (I assume you mean "") and I know this is something i ought to get to grips with. Manana! :) Thank you.

Hi, I have two date fields on my form, for when a particular process is suspended and then unsuspended. Some processes will never be suspended, so in these cases I want to disable accidental input to the Unsuspended field. I thought I could do it like this If Me.Study_wide_suspension.Value...

Hi, I wasn't able to get that working, though I'm sure it's my fault and not yours. Several of my columns are text and I suspect I'm getting the placement of commas wrong. However, I tried this at home using Access 2007 with a brand new database and linked excel file and it worked. It just...

Hi, I know you can't store text in a numeric field but I always thought you could store numbers in a text field - provided you didn't need to do any calculations on them. My problem is as follows: I receive an Excel 2003 spreadsheet once a month, which I save to a specific filename/location...

You're welcome. It's nice for me to be the one answering a question for a change. I'm always asking!!

Hi Paul, As I said in the the first post, I'll *always* use the same filename and location. For now it's the desktop path specified in my original code but I'll change that once I get it working. This is for a monthly report that I need to send to a specific person outside of our...

I'm not good at reading SQL like this, but try this Open your query in design view On the criteria line under ccolamt enter >0 On the criteria line under CAPPDATE enter >#1/1/2013# Make sure these are both on the SAME criteria line (which results in AND) I *think* that should work

Thanks plog. That's pretty much the conclusion I was coming to as well. I was hoping there was some way the existing running total expression could be altered to allow for this, but I do understand your point and the more I think about it, the more I'm sure you're right!

The PDF is created by these lines Set Application.Printer = Application.Printers("CutePDF Writer") DoCmd.OpenReport "rptMH" CutePDF writer is what's known (I think) as a virtual printer i.e. it's installed as a printer and uses print settings. But instead of producing a hard copy, it opens the...

Thanks Paul, So the email part would be a module by itself and then you would include Call EmailMH in the code for the existing button? I tried that and I got exactly the same result as before i.e. the cmdMHReport sub outputs to PDF and displays the dialog box but the error message pops up...