Search results

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

I'm using the common date range form where you can set the beginning date and end date using the Now function. Not a problem except I want to set the default ending date and time to be 5pm on a given date - the format I have used is the general date so that it gives me the date and tiem and I...

In addition you can split an existing database into a front and back end, but keep a copy of the origional while you test this out.

Basically yes - it allows you to change the forms etc without distrubing the data, works really well.

Spot on Absolutely ideal! - the link you gave me was perfect for what I was looking for. Excellent site.

That sounds useful but couldn't the date just simply be changed by anyone worth their salt?