Search results for query: *

thanks, both, for the replies

Hi All, I'm looking at sourcing an IP500v2 for our organisation, and would like to find out its limitations in interacting with MS Exchange. I'm having issues with conflicting answers from suppliers, and limited on-line documentation that is clear - so I thought I would come here and ask you...

the Access file appears to have done the trick. many thanks for this M

hi all. apologies in advance for my lack of knowledge here, all i have to offer is good feedback ;) i've trawled the net, but thought i would try here first I have inherited a hosted server running Sendmail 8.11.6. it has always handled emails sent to COMPANY.COM at the start of the year, the...

hi all looking for some advice, hope this is the most appropriate forum.. i'm looking for a good application to monitor the uptime of a VPN. in a nutshell, we have a very basic Watchguard SOHO with several IPsec VPN tunnels. We are having issues with one of them. the Watchguard does not...

hi all. hope you can help I'm trying to clean an address table I have inherited. The column shop_name has lots of similar values e.g: "Cinema 2712 (London)" "Post Office 253 (York)" "Cinema 513 (Essex)" I've created a column called shop_type, because I need to categorise these. I could create...

Thanks for the pointer. need to do some serious reading up, but I've been meaning to start doing procedures using VBA for a long time..

hi all. not sure if anyone can help with this.. running MS Access 2000, SP3 I have a database with hundreds of identical tables, all named ordersYYYYMMDD is there any way I can create one 'master' table, other than running an INSERT INTO query hundreds of times, changing the table name on...

hi all I think this is more of a DNS issue, than IIS.. We have a client that has two servers, DC and WEB DC is the PDC/DNS/WINS/AD server, running Windows Server 2003. the AD domain name is DOMAIN.LOCAL WEB is the webserver, running Windows Server 2003, and IIS V6.0 that contains the company...

yes silly me. had tried this but had not been thorough. thanks for the heads up, and apologies for the delay in response M

greetings (I'm running Access 2000 (9.0.6926 SP3)) I have several dozen local databases which although exclusively used by myself, occasionally need to be viewed by other users I set this on the databases using windows explorer, right-clicking on each database file and adding domain users to...

hello all using bog-standard SQL/Macros in Access 2000, I need to copy a number of tables into another database, and rename them tablename<todays date>? I could of course do this manually everytime, but is there anyway I could automate this by means of macros/queries? many thanks in advance...

hi all, I'm running IE6 SP1 on windows 2000. when downloading from secure sites, I frequently get an error window saying &quot;this page contains both secure and non secure items. do you want to view the contents now?&quot; which I believe is due to ie6 timing out. are there settings I can...

thanks for your response. I'm still getting a &quot;Syntax error in ALTER TABLE statement&quot; error message though M

hi all I'm having problems with an ALTER TABLE query. I'm using the basic Access 2000/sql query window setup.. as well as dozens of text fields, I need to add a double integer column with a fixed number of decimal places. (I can do this in the table design view of course, but am looking at...

many thanks for this. I'll have a play with the queries and see how I do M ----------

hi all. this may be a long shot, but.. I have a table arranged as followed: CUSTOMER PRODUCT PRODUCT_CATEGORY UNITS SALES customer1 product1 category1 value value customer1 product2 category2 value value etc.. customer2 product1 category1 value...

excellent. many thanks one final question: is there any way to specify all the fields to be updated except, for example, a field called name, or do all the fields have to be manually inputted into the query? thanks again

thanks is there any way to specify more than one field to be updated, or would a seperate query have to be made for each field update? cheers m

hi all I have two unrelated tables with identical fields, called products_now and products_next the products are identified by the field sku_code for all the products that are in BOTH tables ONLY, I need to update several fields in the products_now table with the equivalent data in...