Recent content by cbs604

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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