Search results

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

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

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

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

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

Hello guys, how's Tuesday... I have a wierdo problem. I get a compile error which give me the following error message... "Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic" I need to use DAO 3.6 and the solutions I've looked at...

Hi guys... I am using the week number to find which week entries fall into... eg. 12 13 14 15 etc if the week number of the date is = to the week number in the query then the data is selected. I'm projecting 4 weeks ahead by simply adding 1,2,3 to the current week number. i.e. if the...

HI guys.. I have this error message that appears many times (30+) after I've entered new records or move through the record set I have a main form with many subforms including text and number data with objects (pdf) linked through an object control. I can't work out why this is happening...

Hi Guys, I have a problems that I don't quite understand. I have a database that sits on a server as an MDB file. We're having some server problems at the moment so I moved the database to a shared folder on my pc and everyone opens the mdb file from here. However, after some time the...

Hi guys, I have a master report made up of several subreports. If one of the subreports has no data in it I want a label named "No data in Database." to display (.visible = true). Where can I set the condition and/or whats the code? Hope you can help Cheers Paul :)

Hi guys, I starting to do a lo of exporting to word now. problem is i've forgotten how i did i before. I can open a word doc and export items i need through code. but I kow that I can export full reports to word using DoCmd.OutputTo acOutputReport, lettersource, acFormatRTF but the...

Hi guys, I need a new installation copy of Access 97. Does anyone know a good place where i can get one from that isn't expensive ... Thanks Paul :cool:

Query is too Complex! Error message : "Query is too Complex" what does this mean ??? I've been given it a couple of times can i get around it ? Cheers Paul

Guys I know one way that i can do this through code using recordsets but is there an easier way... I have a table which is passive and stores settings for various operations. SO it has one record only and the various fields store with different parameters. I would like to pull the value from...

Hi guys I have a code module which declares public variables when the database opens… Option Compare Database 'set variables 'set public variable Public OffersDataSource As Variant Public SetPropertyID As Integer 'For OUTLOOK AUTOMATION OF APPOINTMENTS Public ASTARTDATE...

Hi Guys!!! :D I'm using a form (A) which checks information from a settings page (B) which is a subform on A. This all works fine. I then created a report (C) and want conditional formating to use the same subFORM (B) as the report (A). I have the subform (B) inserted into the report (C) but...