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 Rhinorhino 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: *

  1. cbs604

    Missing Access queries when mail merging

    I have a large Access db originally created in MSO 2000 and now updated to MSO 2007. Using MS Word for a mail merge, I use a query within the db as my recipients list. However, when I get to the "select recipients" bit, I point to the db which shows a list of tables and queries to choose from...
  2. cbs604

    Can receive new, but not forwarded attachments

    A friend can send new emails with attachments to a variety of receivers OK, but cannot forward messages with attachments. All receivers, including me, receive the message with a box where the picture should be, and no paper clip. Her Sent Items box is the same. So something is stripping the...
  3. cbs604

    What to do with old tapes?

    If you want to dispose of them, then make sure they are destroyed first. They still contain sensitive data. Leave it to your imagination how to do that. Cheers, Brodie
  4. cbs604

    How to have the text word wrapped in Excel

    Sounds like you are using Excel in database mode. If so, why not import your text file into a Word table, where you will have much more control of text formatting. Cheers, Brodie
  5. cbs604

    Power coming from somewhere

    Not sure I understand your scenario here. When you say "screen connector" I assume you mean the video cable to the monitor. Surely then, this was unplugged while you pulled the old card and installed the new one. You say you got a shock when inserting the new card, but could not touch the...
  6. cbs604

    Counting data - sorta!

    A star for you Yogi. That worked brilliantly first time. Many thanks Cheers, Brodie
  7. cbs604

    Counting data - sorta!

    Thanks Skip and Yogia, some good stuff to try here. Yogia, in your example:- J2 should be 2, J5 should be 1, J6 should be 5, all the others should be 8. Cheers, Brodie
  8. cbs604

    Counting data - sorta!

    I have a SS of 8 columns and over 50,000 rows with a mixture of blank spaces and numerical data. I need to count cells with data in them starting from column A, and stop counting when the first blank cell is reached. In other words, if cells A1 to H1 have data in them EXCEPT C1 and F1, then I...
  9. cbs604

    Split Field

    That worked a treat, Roel. I only used the first example to test it, however, I cannot figure out why it returns a null when there is only one name in the GivenNames field. This field BTW, contrains up to 4 names, but I am only interested in the 1st and 2nd. Cheers, Brodie
  10. cbs604

    Split Field

    I have inherited a database that contains a couple of fields labelled LastName and GivenNames. The data in the GivenNames fields contains one or two names. It is now time to split this field into FirstName and MidName. How can I do this? I know it is simple in Excel, and I thought of...
  11. cbs604

    Apparent loss of profile

    Thanks Captain. No, nothing like that. The pc has been isolated since the incident so I can investigate further. I ran a undelete program, and apart from a few files outside of the profile, the folders look just like they do now - empty. The dates and times of the folders (my docs, my...
  12. cbs604

    Apparent loss of profile

    This is a doozy. W2K SP4 User shuts down and restarts the next day to be confronted with a vanilla desktop with basic set of icons. My documents, My pictures etc all empty. All folders created under this user are gone. Everything in local settings gone. It looks just like it would if the...
  13. cbs604

    OE will not download from mailbox

    Sorry 'bout the long delay. Nil errors - just acts as though there was nothing to download. Cheers, Brodie
  14. cbs604

    OE will not download from mailbox

    Trend Micro 2007, and it's turned off while troubleshooting. Cheers, Brodie
  15. cbs604

    OE will not download from mailbox

    Hi all, OE today decided to stop downloading messages from the server. I can see waiting messages there using webmail; I can send and receive via webmail; I can send via OE to myself and see the message, via webmail, arrive in the mailbox; But when Receiving in OE it goes through...
  16. cbs604

    Transferring Access objects

    Is there a way to copy objects via removeable media (cd,floppy,thumb drive etc). At the moment I have a copy of a database at home where I am updating its objects (queries, reports etc). I then go to the customers site where the live database is, and manually update the objects there. There...
  17. cbs604

    Weird merge problem

    I have since found that if I use a .doc instead of a .dot it promps just once. Cheers, Brodie
  18. cbs604

    Weird merge problem

    I have a Word merge template, that points to a MS Access query, that requires a Start and End date to be entered. When running the merge it promps for the Start and End dates TWICE. Running the query on its own within Access works fine. Using MS Office 2000 (I know it's old but, hey) Any...
  19. cbs604

    Jumpy cursor...flies all over the screen

    Some meeces can be very touchy with what material they are used on, colourful mouse pads or glass table tops, for example. Have you tried different surfaces? Cheers, Brodie
  20. cbs604

    Two dhcp server?

    Many thanks for that. Cheers, Brodie

Part and Inventory Search

Back
Top