Recent content by paulmcdonnell

Thanks darbid, Your right and it's a little odd. I target you referal on the outlook forum. Thankyou for your very helpful reply. Paul

Hi guys, Anyone got any ideas on this one. I have an access 97 (i know!) database which updates appointment in outlook calendars for various different mailboxes. This all works fine when using outlook 2003. Having upgraded to outlook 2007 and changed the references for microsoft 12 and DAO...

Hi guys. Have a strange one. When I put a date in a form field (UK) like 10/03/2009 the form field immediately switches the date to be 03/10/2009. No idea what's going on here. All other software doesnt do this. using Access 97 in this oldie. Anyone have any ideas why this might be...

Hi, Does anyone have any advice on how to change the label colour ('color' for ur US friends :o) when you add calendar appoinments in outlook. I need different appointment types to show as differently It's not as simple as With outappt .label = xxxx (which ould be nice) as...

Hi Guys, I have two versions of access that for the time being I need to use on the same machine. Access 97 and Access XP (2000?) Everytime I use the XP version the 97 version needs to be reinstalled. I'm assuming that This may be just an installation issue, but before I remove them both...

Thanks Paul I'm such a thicky. Paul :rolleyes:

Hi Guys, Hope yoou can help with this really simple one, cos it's driving me mad. I have a control on a form which shows a date from a table e.g. 07/01/2009 I want the control to show this date, but only for the day and month (the year is irrelevant for the display.) so i want the control to...

Hi Guys, and happy christmas...:) I need to create a table (or query) for a month (say jan) which shows all the work days within it. I then need to drag info from my other query chowing how many appointments are booked in for that day. This part I'm ok with but its creating a table or query...

Thanks God sometimes you can feel like such an amature.. I blame the booze. Paul

Hi huys, this should be so simple but its driving me mad. My code inspects a query to see how many entries there are. If there are non and the query is empty I need it to ignore this and move on. as my code is this works by causing an error and i'm using the On Error Goto (i know this is not...

Possibly...? Type mismatches are usually from this kind of thing... stLinkCriteria = "[job_no]=" & Me![job_no] Check that your Job_no field is an integer and that your Me![job_no] (the control) has a datasource which is also the same type - 'integer'. HTH Paul

Status HEllo... The Status field is a STRING field. VBA CODE changes the STATUS field to be whatever text string it needs to be at specific times throughout the use of the data base. Depending on the how close the deadline date is the code updates the string field to be the appropriate...

Hello guys, Hope you're all well. I need some help with a form filter I need the form to filter out those records with a STATUS that is "OVERDUE" and a date that is < date(). I've tried... Me.Filter = "[Status]='Overdue' AND [deadline] < date()" Me.FilterOn = True type mismatch .... I'm...

Outlook and Access Hello, There are many ways of doing this.. Can you tell me what system that you use... Exchange server? etc and how many calendars you have access rights to? An idea of how far you have got so far would be useful Paul :)

Hello guys, I have a reportwhich contains 3 subreports. I can view the report as normal,but when I go to print I get a message box asking for a form ref (which it already knows, otherwise it wouldn't be able to display anything) why does it ask for this only on printing and not on displaying...