Search results

Hi All I have a form with a date/time field called "Date". I have created a label within this form called "Mth" I want to be able to put an iif function into the After Update properties of my field "Date" so that it returns a value in my "Mth" field dependant on the field "Date" results. i.e...

Namliam Thanks this has worked. I tried using the # but I used it in between the day, month, year i.e #01#01#03. Didn't think of placing the # at the beginning and the end. Cheers.

Hi All I am having trouble with an iif function in a form I have created. I have a field called Date and I have created a label called Mth. I want the Mth field to return a value 1 if the date is in month 1 or 2 etc based on the date that is entered in the date field. Just to test whether it...

IMO Morning. I have added the above and brilliant it works a treat. Thank v much. Speak to you soon. Sharon

Morning IMO I have tried what you have said above but I don't have Microsoft Outlook 9.0 Object Library in my list, however I do have the following:- 1) - Microsoft Outlook 8.0 Object Model 2) - Microsfot Outlook Express 5.0 type library. When I try ticking the first it comes up with a...

IMO Sorry I'm a bit new to this - how do I do this?

Cheers AncientOne IMO Can you advise on the above? Thanks.

Ancient One This would be brilliant if it worked and is exactly what i am looking for. However, when I click on any of the items in the Choose outlook form, there is a problem with the coding. It displays a message as follows: - Public function StartOutlook() is highlighted in yellow, then...

IMO Good to hear from you again, however I can't open your attachement. Once it has been downloaded and I try to open it, it comes up with a message saying that it is an unrecognized database format and then the path. Any advice what to do. Thanks Sharon

Laxing 22 Thanks for you reply. Quick question - can this be used for for internal e-mailing - not external?

AncientOne Thanks for your reply. This does work through the wizrd but I want it to automatically open the calendar or a new mail message with out me having to select i.e Inbox then create new mail message or Calendar from the left hand side. Is this not possible? Please advise.

Hi All Is it possible to create a command button in a form to open Outlook Express Calendar and another to open my inbox to create new mail? Please advise. Thanks Sharon

Hi All I have created a query from 3 tables. I have a main table 'Employee Details' (Tbl 1) another table 'Absence Details' (Tbl 2) and a third 'Holiday Entitlement' (Tbl 3) Employee Details is my main db with a primary key set to Employee Initials. In Relationships I have joined my...

Hi All Is there any way to set "auto date" in a form? I have a table with 3 fields - Date, Initials & Overtime which has all our employee overtime listed. I have created a query based on this table sorted in date ascending order and entered a parameter field [Enter Initials] so that it shows...

subform entry problem Hi I have the same problem as Trish but can't seem to rectify mine from the notes. Can anybody please help? I have attached my file. Thanks

Waltang Thanks for your reply I have tried to tick the box Microsoft DAO 3.0 Object Library but unfortuantely when I try to tick the box it comes up with a message "DAO version 3.0 is not compatible with this version of Microsoft Access" and won't save the tick in the box. However it does let...

Waltang - Or anybody else Another idea is to have another set of navigation buttons on the table above,next to the date to flick through and see all the entries. Is this possible? Please advise.

Waltang Thanks for your reply. What you are saying is understandable and sounds like it would solve my problem but when I try and change the date on the TblDate form it comes up with a message as follows: - Compile error: Can't find project or library. When you press Ok, the error is on...

Hi Tim Thanks for your reply but still no good. I have attached my database for you to see what is happening. When you type over the date at the top it lists the initials of the employee and the amt of overtime they have done for that day in the subform part. I want to be able to change an...

Hi Rich Thanks for your reply. Unfortunately still no good. I changed the name of my "Date" Table to "TblDate" and the date field in here to 'Entry Date' then in my "overtime" table I changed the Date field to 'Overtime date'. I then created a new subform the same way as before and now I get...