Recent content by ptaylor-west

Definitely not me - I don't know anything about FTP servers

The comments made by Paul Taylor-West on this thread is not me, someone has hijacked my name!!!!!!!!!!!!!!!!!! or the system is corrupted

Thanks to JANR - ideal for my empty database, although the other replies were also useful.

I have cleansed all records from my database and starting with fresh data but the ID key starts at 338 which is the next number after amount of records I deleted - how can I zero this?

Thanks for the updated file.

Excellent advice and the updating utility is really good, I also found in another post that under the Netware properties there is an attributes section with the option to make the file Sharable. Once I clicked it should let my users to access the file at the same time, but I can't check on that...

My new DB is shared by several users and although I had no intial problems I'm now having problems with more than one person opening and using the DB which is on a network drive. I know the simplest way round this is to split the DB but I don't want to put FE's onto each users computer because...

Absolutely spot on, works like a charm, I'm very impressed I thought I had got really stuck with this. Cheers Paul

Thanks I used the help for the other parts and it works fine. I moved on since then to try and use a number of querys to filter the totals and then made a query of queries (if you see what I mean) I then created the report on the final query which was much easier as I also needed to select by a...

Just to pad this out a bit - if you use the Now function in a date range form as the beginning date and then use Now + 5 as the ending date, what it does is it calcluates 5 days exactly from the current time that set off the function, so say I do it at 10am the results will show bettwen down and...

Found the solution on another site Set the Format Property of the control to: #;-#;""

Did you ever get this sorted as I am having the same problem

Does anyone have any suggestions please

Tried your suggestions but none of them work - I presume the ..., is the field name - but it doesn't recognise it, maybe I am using the wrong format. The Iif says it not the correct parameters. Priority has a range of 1 to 5 so I thought I could put five textboxes to count the number for each...

I am really brain dead with this one - I want to create a report from a query which has 3 fields - One is the Job No the next is the priority and the last is Completed. The first should be simple I have used the Count function in the cointrolsouce of a text box on the report to add up how many...