Recent content by MS$DesignersRCretins

  1. M

    "Network name cannot be found" installing 2003

    Thanks for your efforts. Rebooting was no help. Repair is a Control Panel add/remove program option, but I'm hesitant to do that or reinstall because it would be all of Office, and I would be suicidal if I lost and couldn't reinstall Excel 2003. So unless there's something else I guess I'll do...
  2. M

    "Network name cannot be found" installing 2003

    For what it's worth, Excel 2003 already runs completely smoothly; Word 2003 had been goes "preparing to install" says a file is missing every single time I start it, but it WOULD start and run; and starting today (after starting to install Access), now starting Word generates the same error...
  3. M

    "Network name cannot be found" installing 2003

    Thanks very much. ROUTE PRINT * does not show the 192.168.0.4 address anywhere. It does show 0.1 for gateway and 0.3 for interface. I don't still have the box, but I do recall making a phone call with the 30 or so character product key when activating it in the past.
  4. M

    "Network name cannot be found" installing 2003

    I'm reinstalling on XP (SP3) (at home). I have the Office 2003 Professional CD which I inserted when the installer said it needed it. But then it aborted, throwing up a system window: "\\192.168.0.4\users is not accessible. You might not have permission to use this network resource. Contact...
  5. M

    Set description on table fields in code

    I covered that emphatically in the second thread post. Thanks for your question, but I'm marking the thread solved now and going on to other challenges. Thanks for your help!
  6. M

    Set description on table fields in code

    Sorry, I thought that the original post was so simple and laid out step by step that this would take about 45 seconds for an object expert to solve, but I was mistaken, and this is devolving. So I hope no offense was taken by the loyal and unwavering MS-loving community; I retract any legitimate...
  7. M

    Set description on table fields in code

    Thank you for the suggestion. The statement does not error. At the same instant:?tdf.Fields.Count 3 ?tdf.Fields(0).Name fld_1 ?tdf.Fields("fld_1").Name fld_1 And as noted in earlier code, tdf.Fields(0) does things that tdf.Fields("fld_1") does not (though not obvious from the Immediate window...
  8. M

    Set description on table fields in code

    Maybe the reason that you suggest fld_1 doesn't exist is that you all thought I was building a new table, rather than [what I interpreted as] setting a "pointer" to an existing one? 99% of web discussions and articles (yes, I put in a few hours researching and experimenting) seem to involve...
  9. M

    Set description on table fields in code

    Thank you solo and jdraw and gamma for responding. I know that newbies sometimes scream "what is wrong with stupid Microsoft" so my harsh tone just begs for a "relax, it's all fine, you just need to learn" response, so your polite advice is accepted :) However right in the very first lines of...
  10. M

    Set description on table fields in code

    Thank you for answering but there was just too much there. After hours and hours and hours of trial and error I devised the following, which you did hint to. I'm not blaming you because for all you know I should have been able to interpret your code and got what I needed. The solution was...
  11. M

    Set description on table fields in code

    I am unable to set a table's Description property in code UNLESS it already exists! I have taken effort to build an an extremely easy-to-follow demonstration. Create MyTable Add 3 text fields fld_1 fld_2 fld_3 Create one record with anything at all in it, or 1 record with nothing at all...
  12. M

    Pulling Field Information from Another DB

    You say "in the database that now has the linked table" (the issues database) but your question sounds like you're asking about the sign-in tool database. If so, your answers depend on how you will enter new "customer issues" : 1. If that is managed separately than the sign-in DB - by a...
  13. M

    Adapt search code to require entry?

    You got it right. Here's a twist that I sometimes add that may not apply to you: occasionally instead of going for exact matches I search for asterisk-string-asterisk and use LIKE anyway, like if I want "Smith" I search for "*Smith*" and use LIKE. Maybe I'm not sure that someone is Beth or...
  14. M

    dbs.execute to run action queries

    Here's a shell to test the methods if it encourages anyone to experiment. It times measuring tenths of a second.Sub Timethis() 'time .Execute vs. openquery vs. runsql, and maybe observe bloat '1. Create a Query1. Maybe start with a select query; maybe a make table query (to check bloating?)...
  15. M

    Greetings

    Background: machine language(briefly), ASM, Fortran, BASIC (MS-, Turbo, Quick), PL-I (and ROSCOE and a few other mainframe interfaces), C (weren't TC 2.01 and Turbo Debugger screaming beauts?), and in recent times Excel, Excel, and Excel. I am here to help and be helped, though because of my...
Top Bottom