Search results for query: *

sepArate.

sepArate.

Did you try removing the module completely ?

Is that the actual wording you see for that error or is it Error 3014 - Can't Open Any More Tables.

Ken, At least I can understand what a charm does, I'm not sure what a treat does. It also isn't phrased as "worked like a treat". That, for me would almost be ok, since as you indicate, I could mentally replace treat with charm. I'll take the purple stars though.

worked a treat" kinda bugs me when people on the forums use it, since it means nothing to me and also sounds silly to me. I think "worked great" would be more effective in relating to an international crowd that one's suggestion was helpful. Is "worked a treat" the opposite of "played a trick"...

Either cheap should have a period following it, or Typically should not be capitalized. For example a simple site comprising a home page and one or two other pages with a low level of complexity, can be quite cheap, Typically, this can be achieved for around five hundred dollars. $100 for a...

dominiopt hyperlink with a "y" .

BillyRay, Thanks for the clarification. The way I read these sentences seemed like you were suggesting getting away from name and going to getElementById because (name) was hacky and clucky. "Remove the name "slide" from the image, and reference the image using getElementById, instead of...

BillyRay, Just curious, why is using "name" hacky and clunky ? It works with IE and Netscape for image references. I only do programming for personal usage, but haven't found a problem. In fact sometimes remembering which letters are capitalized in getElementById has got me more than "name"...

DaleWatson123321, Alt printscreen does exactly what squiggs12 wants at no charge. Printscreen alone captures the whole screen. Dave.

Alt-PrintScreen buttons. Hold down Alt and hit Print Screen. That will capture it, then you can paste into word or photo program as a jpeg. Dave.

For j = j To 2 Step -1 Reasigning j to j seems a rather odd way to do it. For debugging purposes using another variable for storage of the last row could be a better practice unless I'm missing some trick you're trying to accomplish.

I don't understand either, but have you tried saving it first before going into design mode and returning into view mode ?

Try this... Sub namerange() Dim myvar As Integer Range("A5").Select myvar = [f50] ActiveWorkbook.Names.Add Name:="keys", RefersToR1C1:="=KEYS!R" & myvar & "C1:R6C19" End Sub

This works in excel =IF((F5-TRUNC(F5))<0.125,TRUNC(F5),IF((F5-TRUNC(F5))<0.375,TRUNC(F5)+0.25,IF((F5-TRUNC(F5))<0.625,TRUNC(F5)+0.5,IF((F5-TRUNC(F5))<0.875,TRUNC(F5)+0.75,TRUNC(F5)+1))))

An easy way to win...... New Game Start Game Click on a square Click again on the same square Congrats you won ! Just kidding, good job. thanks for the entertainment.

How about this.. SELECT tblA.A into tblC FROM tblA LEFT JOIN tblB ON tblA.A = tblB.B WHERE tblB.B Is Null;

Tony, Your "Before you ask a question" link doesn't seem to work. Tek-Tips - Page Not Found

You say "duplicate" (as in creating a new table) but reference the "rename" command, so I'm not sure what you want. This should make a copy of a table ....... strsql = "select * into tblCopy from tblExisting" Docmd.RunSQL(strsql)