Search:

Hi All, We have a form that contains a long list of records. The form allows us to select either individual records or many records based on our requirements. Once the records are selected, we...

Hi Everyone,

We recently replaced an old NT server with a new Windows 2003 server for our manufacturing floor. This server provides an Intranet which serves up drawings, specifications, etc. using...

I knew it!! I knew there had to be a simple solution!! Gee, do I feel stupid!! http://windowssecrets.com/forums/images/smilies/rolleyes.gif

THANKS!!

By the way, I'll have a look at the...

Hi,

I was given a worksheet to continue development on and the worksheet contains tons of named ranges (i.e. many, many cells have defined names) which I'd like to simply report out or summarize....

Hi Howard,

I have been using Linux off and on for several years. I think it was around 1995 or 1996 when I first tried it. I have maintained a Linux desktop for daily use now since 2005. Over the...

<span style="background-color: #FFFF00; color: #000000; font-weight: bold">Thanks again for the tips Hans!</span hi>

I did try just copying the required OCX and DLL files from a Windows 2000...

We are experiencing problems with some VBA code that was originally developed within Access 2000 on Windows 2000 Professional. We have a database that makes use of images in reports. The references...

Hans!

You're my hero! You've come to the rescue several times. Thanks again!!!

Drew

This should be a simple solution, but I am not yet familiar enough with VBA to figure this one out.

I have a table that contains addresses for a mailing list. I have a toggle field (a checkbox)...

Hans!

You've got to be kidding! That was it?!?!?! WOW! THANKS!!! I still have no idea why that would have suddenly become enabled, but removing the check boxes definitely fixed the problem!
...

Hi,

A very strange situation has just cropped up. Yesterday, a spreadsheet I was working on worked fine. I enter a date in a column as 6/27 and I get a date. Today, Excel insists on prepending an...

HI Nancy,

Glad it worked out for you. I'm sorry about that extra line of code in there for the size. That is a step that I had to perform manually each time. I use this macro for placing Excel...

Edited by Phil Rabichow to reduce size of pretagged code to prevent scrolling
Hans,

Here's what ended up working for me!!!

<pre>Sub PasteAsMetafile()
Selection.PasteSpecial...

Edited by Phil Rabichow to make the screen with narrower & to make the link clickable - see Help #19
Hi Nancy,

I noticed that back in July you posted a request for Pasting Metafiles. I too just...

Hi Hans,

What's really odd is that the wdPasteEnhancedMetafile method is in fact listed in Word 2000 as a viable option. However, when that method was used, the other options (re: wdInline, etc. )...

Hi Hans,

I get the following error:

<pre>Run-time error '5941':

The requested member of the selection does not exist.
</pre>

Hi All,

I regularly create reports in Word which contain several charts from Excel. My preferred method of putting the charts into the reports is as follows:

1) First, I always create each...

Thank you Hans and Steve for your assistance. Turns out, I apparently solved the 'riddle' before I got your answers. First time that's ever happened. Here is what I came up with on my own before I...

I am attemping to create a textbox on a chart in an Excel worksheet. I can manage to create the rectangle and define the position, size, border, foreground fill colour and text so far, but I can't...

Thanks for your assistance Hans. I did finally get the task accomplished. The problems occured where the reports that were being opened had associated events tied to them "On Open". I had to...

Edited by HansV to break very long lines that caused horizontal scrolling

Hans,

Thanks for taking a look at my problem. I had, by the way, already read through the other posting by CaptainKen...

Thanks for all your help. I did actually look at the reply above and fit it into our database and it worked great!! Sorry for not thanking you earlier, I just got swamped and neglected to go back to...

I have been asked by a colleague to provide some help in automating a large, repetitive task. The job required is to output a large number of Access reports to snapshot format.

BACKGROUND: We use...

DOH!!!!!! (as I smack my forehead) <img src=/S/doh.gif border=0 alt=doh width=15 height=15> You are brilliant!! Thanks!! That was the issue. I checked the macro that was assigned to one menu item...

Hi All,

I recently received a 'new' PC from my IT department. It is running Windows 2000 Professional with Office 2000 professional (same as my previous PC). I have for ages maintained a...