Search results for query: *

Thanks I gave up on Acrobat and used MS Word. It worked perfectly on all versions of Word and I got 100% return on the survey (after a bit of nagging :)

Hi I have created a form that users will fill in to do a survey over a large multi-site organization. Some of the users have previous versions of acrobat reader installed (5.0 and up) and they do not have administrative rights to upgrade. If I send out a form that requires a software upgrade...

Skip I don't think the top of sheet approach will work. Individual users may change to legal size paper and/or switch between potrait & landscape. I need the headers & footers to remain correctly formatted (left, center & right) through this entire set of options. These workbooks have...

I am setting up templates for an audit function's workpapers. I have developed a template in Excel that includes headers and footers that are populated with key infomation via an input form and vba. I have not been able to find any way to left align multiple lines of text within a center or...

thread705-79802 covers this topic very well

http://support.microsoft.com/default.aspx?scid=kb;en-us;182760

I believe you can do this with the COUNTIF function: COUNTIF(B3:B36,&quot;<>0&quot;)

This applications seems to be screaming to be made into a database. Is there a reason it needs to stay in Excel? Susan

See faq181-261

There's a program that appears to do what you need that sells for about $30. You can use it for an evaluation period before purchasing. I have not used this program, but found it it some reviews when I thought I might need something like this too. http://www.vknoware.com/afr/

See faq705-2010 in the Access Modules forum for all your questions (including the auto-update-install which is possible)

...time. Save a search that finds the files you want. It your case use the menu selection; File, Get External Data, Import. Set up your search using *.prn in the &quot;File Name&quot; box and choose text files in &quot;Files of type:&quot; Click the &quot;Advanced&quot; button and then click...

You could use a query to convert the field to text using str(). Set output all fileds to yes and just use the query instead of the table.

I learned (the hard way) that Outlook isn't always able to attach files with long file names if they are on network drives. In my case I can make temporary copies of the files onto my desktop and then I can send then just fine (no out of memory errors). I've never seen the garbled files so this...

I did use Notepad, but any text editor will do.

It looks like a useful link which would help someone to come up with their own answers. Thanks

...information and save with the extension .vbs. You can now run it through the Task Scheduler. (You should test run it separately first). ************************************* Dim objAccess Dim strPathToMDB Dim strTableName Dim strFilePath Dim strMsg ' EDIT with your path and database name...

I have a couple of similar applications. In one I send the data from Access to a named range on a hidden worksheet and then have the report on a separate worksheet which links to the named range. The report worksheet maintains the formatting I set because I don't overwrite anything on that...

...information and save with the extension .vbs. You can now run it through the Task Scheduler. (You should test run it separately first). ************************************* Dim objAccess Dim strPathToMDB Dim strTableName Dim strFilePath Dim strMsg ' EDIT with your path and database name...

The user that Access will indicate the message is from may grant the permissions. Within Outlook this user selects &quot;Options&quot; from the &quot;Tools&quot; menu and then selects the &quot;Delegates&quot; tab. Click &quot;Add&quot; and add as many names as you want who may send messages on...