Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mekon
  • Order by date
  1. mekon

    IP500v2 and Microsoft Exchange

    thanks, both, for the replies
  2. mekon

    IP500v2 and Microsoft Exchange

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

    Sendmail - how to stop/block a secondary domain

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

    Sendmail - how to stop/block a secondary domain

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

    looking for recommended 'ping tools'

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

    Access 2000 multiple update queries

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

    SELECT INTO from multiple tables

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

    SELECT INTO from multiple tables

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

    resolving IIS website internally

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

    Access 2000 Compact and Repair/security issue

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

    Access 2000 Compact and Repair/security issue

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

    copying a table and specifying the name

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

    IE6: changing secure site timeout?

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

    ALTER TABLE query: decimal places

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

    ALTER TABLE query: decimal places

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

    HELP!: calculating percentages in a query

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

    HELP!: calculating percentages in a query

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

    help on an update query

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

    help on an update query

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

    help on an update query

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

Part and Inventory Search

Back
Top