Recent content by SimonPGreen

Scrap the above - just making a hash of the URL - open library in explorer was my saviour here! Again thanks so much for the post it works a treat. Simon

That's fantastic - appreciate you posting as it's just what I am looking for. I've configured it however the only issue I have is with respect to the URL for the document as I can't seem to generate a URL that works! I have a document library called shared documents in a site called QMS (I'm...

Thanks for the post. Sound's like the concept I was thinking of although we dont use (or have any great knowledge of) Infopath. Really appreciate if you could give me a heads up on how you achieved this. Regards, Simon

Hi all, Appreciate if anyone could give me a heads up on how (if?) this sort of thing is best handled using Sharepoint. We have a set of standard organisational document templates that are used for our ISO processes as well as other organisational communications/processes. We would like to...

Really appreciate your post. Thanks. Simon

Hi, New to SP so please bear with me as I am struggling to understand the best way of doing something. We are looking to use SP to host a number of document templates i.e. one repository to go to for to access our organisational forms i.e. standard letter templates, QA forms etc. We would...

Hi, We have Exhange 2003 configured with an SMTP connector to our SMTP relay at the network edge. Does any mechanism exist to allow me to limit the maximum bandwidth that this SMTP connector will use? I appreciate I can limit message size and scedule oversize items but what I actually want to...

Hi, Thanks for the posts. DB I have been testing is restored in a test environment so there won't be any activity and no replication is configured. I presume if the original log file was created at 13GB it can never be reduced? Is it possible to identify the original size? Appreciate the...

Hi, Can anyone explain why I get the error 'cannot shrink log file **** because all virtual log files are in use'. A Full and then log dump has been taken and if I run DBCC SQLPerf (logspace) only 1.2% of the log file is used? I have a server that was set to Full Recovery but no log backups...

Thanks Genomon, Records limited to about 20 so overhead shouldn't be an issue. Regards, Simon

Hi, I have a table and one of the fields is a boolean datatype and i need to ensure that only one record has this set to -1 Access to this field is via a form and I would like to trap the before update event on the tick box bound to the field, iterate through the records to check the flag...

Hi, I have a requirement to have a control on a form that meets the following criteria: 1. Is bound to a table field 2. Has its value automatically calculated based on the value in a related table (Could use dlookup) 3. Can have a manual value overwrite the calculated value Example: Net...

Thanks for the heads up guys - I will check out the alternative solution today. I'm new to this and what I am actually trying to do is create a sum at the report footer of all the values falling under the same date? Regards, Simon

Alex, Apologies - I was using CurrencyFormat() :) Thanks for the post. Simon

Alex, Thanks - unfortunately my first post was wrong - I am displaying the results of a query. Not displaying a form in datasheet view. It appears that formatcurrency is not a function supported in Jet SQL? Regads, Simon