Replies

Where do I put the SQL string? I have tried putting it in the ‘Control Source’ property of the blank text box, but all I can ever get for results are #NAME?

I run into the same problem when copying an entire worksheet, however, I have found that if you copy the individual cells or a range of cells you can bypass the 255 character limitation. Formatting will be a problem unless your destination and source worksheets use the same design.

Hope this helps.

Thanks much Legare. Exactly what I was looking for. Worked like a charm.

Can’t explain what is happening with Excel, but anytime I needed to take information from Excel to Access, I start in Access and do a File | Get External Data | Import. This brings up a dialog box so you can navigate to your file (make sure to change the “Files of Type” box to Microsoft Excel).

Don’t know the Word answer, but for Excel 97, whenever I have recorded a maco and assigned a keyboard shortcut, the shortcut shows up in the comments section of the code.

This looks like a cool utility, went to download and found this.

the pop.mail.yahoo.com should work as the incoming mail server for yahoo. I tried this with my OE program and was able to pull my yahoo messages into OE with no problems.

Did you go to Tools | Accounts, click the mail tab, then select the Add button? If you do this, then follow all the prompts, you should be OK.

Also, you might want to try connecting to Yahoo! through OE again, in the past I have had connection problems, that were resolved several hours later. Go figure.

BTW, yes that is/was Jack Lord (a.k.a. ‘Steve McGarrett’, hence the tie-in to my user name).

Here is the information on Yahoo mail server names:

Incoming Mail (POP3) Server: pop.mail.yahoo.com
Outgoing Mail (SMTP) Server: smtp.mail.yahoo.com
Account Name/Login Name: your Yahoo! Mail name (your address without the “@yahoo.com”)
Email address: your Yahoo! Mail address (i.e., user@yahoo.com)
Password: your Yahoo! Mail password

You will also need to make sure the POP3 forwarding option is set. This can be found by going to your Yahoo! mail account and selecting Options from the menu on the left side of the screen. Then select POP Access & Forwarding from the list of available options. The next page will give you the option of setting your account for POP3 access or forwarding to another account.

Good Luck!

Add to Zip opens a dialog box where you can specify the name of the Zip file you want to create. For example you have a file called test.txt, but you want to zip it to a file called help.zip. This is where you could do that.

Add to filename.zip is a one click, create a zip. When you choose this item you will create a zip file named, filename.zip, with contents of whatever file you right clicked on. Basically a onestep, quickie zip option.

Sounds like a shortcut method of what I am learning in my VB class. We use int for integer, lng for long, str for string. I understand.

Thanks for the quick tutorial.

Thank you Andrew, that worked very well. I had an idea it was something that simple, I just didn’t know how to get there.

Also, your previous post causes me to ask two additional questions (just so I can learn). 1) any significance in using the lower case ‘o’ in front of the word ‘cell’? I have seen you do it several times as well as Legare use oRange or oSheets. and 2) what does ‘Application.ScreenUpdating” do? why does it need to be set false before the modifications, then back to true after? Just curious.

Thanks again.

Thanks to both Andrew and Legare,

Once I recovered from my bout of typing stupidity, I got both pieces of code to work.

Legare,

#1 – No
#2 – Part A – Yes, I will use a predetermined list of department numbers. I would need to either hardcode the list into the procedure or store them in another file.
#2 – Part B – Yes, I would like to delete every row whose value in column G is equal to one of the values on the predetermined list.
#3 – The file is not currently sorted on column G, but I know how to code the sort so that would be fairly easy to do if necessary.

Thanks.

Thank you very much.

I was searching the forums looking for information on parsing last name and first name from a string. My string was in one cell in Excel and I needed to get it broken out into two cells for later input to Access. I had been copying the entire range to Word, then doing a column-to-text then a text-to-column switch and then pasting back into Excel.

This quick tip, has saved me alot of time, several times during the month. Again Thanks and keep up the good posting.

Sammy, just an FYI but Excel 97 does have 65,536 rows.