Search results

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

    dbs.execute to run action queries

    Much clearer now! I really like that link. Thanks for that too.
  17. M

    dbs.execute to run action queries

    Just to share some of my reading, http://www.office-archive.com/16-ms-access/e39742bcf6536a86.htm was pretty interesting about .execute vs. openquery. Dev Ashish - wasn't sure (in 2001 anyway :) ). Another says, just don't use DoCmd! (For performance.) I gather that there are technical reasons...
  18. M

    dbs.execute to run action queries

    Hello, I've been enjoying and benefiting from your posts. If you don't mind the intrusion, can you explain what you mean by "the line afterwards?" I think you mean the SetWarnings false; just checking. If so I'm getting from this that .execute doesn't inherently stop prompts; just the normal...
  19. M

    Some help with Nz() specifics/specifications?

    No sweat. I'll figure it out on my own. Thanks for the helpful advice.
  20. M

    Some help with Nz() specifics/specifications?

    I'm trying to interpret http://office.microsoft.com/en-us/access-help/nz-function-HA001228890.aspx . I know I could use trial and error to get my own reliable answers about MS matters; 99% of the time that's what I do anyway because there are never, ever, ever enough examples. This time I'm...
Top Bottom