Search results

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?

Hi, Thanks for the responses however i must be doing something wrong as neither seems to work. The data is enetered onto a Form - the form gets its data from POQuery which is a query from 2 seperate tables. All the data on the form works fine - however i cannot seem to get the POnumber to...

So I have a table tblPO2006 with a field PO that contains a number. Currently I have 100 records and the curent number in this field is 10804 What i want to do is when a new record is created the field updates with a +1 increment to the previous records number. Thus the new record would be...

thankyou for the help - So Let me get this right so i have a general understanding - all i needed to do with create a 2nd query from the vendors table and then reference that query for the combo box? I have a general understanding of normilization etc - Problem is id love to have more...

Ok Attached File - Maybe you can tell me whats wrong with it - thanks

Ok so I added in all the vendorIDs to the table. which was fine however when i open up relationships i can join them but i cant give it referential integrity. If I then create the query anyway and run it ,I get my List with all the addresses per PO, which seems great..... Now If I then use the...