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)

I don't have an answer as to why Microsoft has done this - but I do have a work around that I use in a similar situation. For occational use this is probably not worth the effort, but I use it frequently so it does save me time. Save a search that finds the files you want. It your case use the...

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

You can run an Access macro from a simple Windows script file. Edit this script with your database/macro 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...

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

Or you can run an Access macro from a simple Windows script file. Edit this script with your database/macro 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...

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