Recent content by SkyhiKeeper

How do you get an IP Address assigned to the internal interface on the VPN setup under IP Routing/General The interface is showing not available

I have a view which consists of 4 tabme with 2 outer joins on these tables, however this view takes a very long time to open the main parent table has 1.6 million records in it, the view takes 10 to 15 mins to open, any suggestion that I can use to improve the performace on the view opening...

I have a cross tab report, on which I want the average of something, I have calculated the average in a formula however the crosstab has 10 lines in which there is only a culculated average in one, however the total average is determined on the average of the 10 lines how do I supress tha the...

Thanks It is such a pity that they have creaded the functions and a simple change of allowing the printdate to be changed ,you have to now build what these functions literally do. Thanks once again SkyhiKeeper

Hi Gary It is actually not a filter that I want to use it for we, need to change the printdate so that the age functions (age0to30) work properly otherwise the aging functions change daily and we would like to run the aging on any day byt backdated. Terence

How do I set the print date dynamically I do not want to have to go into the set print date and time menu oprion , i want to prime the value from a parameter, How is this possible Terence

Thought as much just wanted verification, Thanks

I need to be able to susspend the building of the indexes during an insert into a table, how can this be done?

Yes the camera on the server worked fine, It seems that there is no way actually to say to the camera driver which usb port to use, I would asume that if this wa possible then you could use a redirected port.

Have tried to test this and if I look at the printers setup it idicates the new USB Shared port, however I cannot get the local camera working in the terminal server session.....

Just one more point would this be executed in the terminal server session or on the machine connectiong to the terminal server prior to connection ?

That looks good, I am not to ofay with vbscript but it loos like it is just a matter of editing a registry key or am I incorrect, following this if it is just the reg key would I be able to edit it through regedt32 ?

I understand that this will work for a printer will it work for a USB Web Cam?

The problem occurs is that the gateway is proberly the router, either you have to bridge the cards or enter a static route into the windows routes.

Is it possible to use the local resource USB ports on a terminal server session ? I can get serial and printers and drives