Recent content by MrSmith

scratch the last comment - So i use the following expression to get the end date of a contract: Support End Date: IIf([Support Start Date] Is Null Or [Support Contract Length] Is Null,"N/A",DateAdd("m",[Support Contract Length],[Support Start Date])) This is based upon a start date + a set...

sorry been tied up with other work stuff - ok if i use the >0 and <365 i get an error saying data type mismatch

anyone? someone?

bump... any help appreciated thanks :)

So now in my column of days remaining - I have a number of days How do I add criteria for reports - I.e all those with greater than 0 and less than 30 days remaining all those with greater than 0 and less than 365 days remaing thanks

Keith , Thanks I changed it to the following to give me remaining days, Days Remaining: IIf([Support Start Date] Is Null Or [Support Contract Length] Is Null,"N/A",DateDiff('d',Now(),[Support End Date]))

I currently have a query that takes info from an asset support table. I have a Support Contract Start Date in the table (Date time) I have a Support Contract Length In months field in the tabel (numeric) i am calculating the end date of the query using the following expression. Support End...

there is and will only be a total of 5 users and splitting it doesnt solve why opening the database from any other computer (the file is stored on a NAS) other than mine why they cant use the calendar

Hi, the database is not a front and backend, Error is : Compile Error Cant find project or library then shows the code for the calendar

Hi, I'm currently using Allen Browns pop up calander in an access database. http://allenbrowne.com/ser-51.html The calender allows the user to choose and add a date into a field. When I run the access project i can see the pop up calander on my form, and use and interact with it to add in a...

Great I got it working now with the before insert thank you so much for your help

So which event occurs once a new record is created ? as i assume i need to add the code to that event in order for it to enter the record number straight away. thanks for your time

ok followed your instructions whats weird is that when i add a new record the number doesnt appear however when i use the back record button i get the pop up message box that tells me the new po number and if i now go forward to the record i created i can now see the number....

[PO] = DMax("[PO]","PO2006") + 1 Is this right? i add it to the Before update of the form in code build.

Rural - Im not entirely sure how to write the code to test for is null - so i am getting just a blank return as opposed to a number. The field is definatly set to number/long interger any surgestions?