Recent content by paullem

Many thanks for your post. Thats really useful.

Thanks for your reply. I'll have a look at the links in your post.

Hi, I am trying to extract the Title, Subject and Comment details from a number of JPEG files in a particular folder and write the details to a text file. Any help much appreciated.

Thanks for all your posts. That gives me a much better idea of the Call Park facility.

Thanks for your reply. We are in initial discussions with suppliers and trying to get some of them to understand how we work is easier said than done. They tend to concentrate on Direct dialing. We currently have eight lines coming in and users pickup a call from one of the lines after a Page...

Hi, we are moving over to a Avaya phone system and need to understand how the Call Park procedure works. Does the system come predefined with the number of Call Park Slots or can you set them yourself through the Admin Console? If you setup 8 Call Park Slots then how do you access them on a...

Excellent! Thanks for the help. I can now see I missed that reference when comparing the two versions.

Hi, I have an Access 2003 DB which I am migrating to Access 2010. The database has a TreeView and keeps giving a compile error 'User-Defined type not defined' on line: 'Dim nodObject as Node' Any help appreciated with this problem.

Hi, Does anyone know how to run winrar from a vbscript. I have a folder containing a number of large files which i want zipped into one '.rar' file. I've tried some examples I found but they don't seem to work. Any help much appreciated, Thanks

Thanks for that suggestion, I'll give it a try.

Hi, I am trying to duplicate the layout of an existing Excel 2007 spreadsheet in an Access 2007 report. The spreadsheet contains Data Bars which I can find reference to in Access 2010 reporting but not in Access 2007. Have I just missed it or are they only available in Access 2010? If this is...

Hi, Does anyone know of a way of locking down an Access 2003 database so the end user only has access to the report designer? Many Thanks

Hi MazeWorx, I'm not quite sure what you mean? Thanks

Hi, I'm importing data from an excel spreadsheet to an MS Access (2003) table. One of the fields in the table is a memo field as the excel cell contains more than 255 characters. But when the data is imported from the excel cell into the memo field it is truncated after 255 chars. Is there a...

Hi, Answered my own question using: Call Shell("C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe C:\TestSelect1\Test0910.mde", 1)