Search results for query: *

I had wondered about that but was reluctant to change something which XP had setup itself during the install. I'll give it a go and keep the name short! tks

You are right - my typo - late night working! I have the slashes the right way in the macros.

My color printer (USB Epson 980) sits on my file storage PC (WinXP sp2) and was named by XP automatically when during a recent upgrade from Win2K. The new name appeares as "Auto Epson color 980 ESC/2 P" On this (my own desktop PC - Win XP sp2 also) I deleted the 'old' Win2k supplied network...

Driving InlineShapes is truly weird! If you want real fun then try resizing a mixture of portrait and landscape pictures in your document with VBA... I wanted to be able to resize inserted photos by scaling them by a fixed factor. No matter what I tried there was no consistency with the...

Aside from the drop down issue: If you populate your document with one or more bookmarks named *exactly* as your fields in the recordset, you could try this: Sub WdInsertData() For Each bkm In WdDocument.Bookmarks With Selection For Each fld In rst.Fields If fld.NAME = bkm.NAME Then...

I spoke too soon about the TabTag SQL stuff. Their unique IDs are GUIDs... and thus almost impossible to use in criteria statements where you want to tack on something like "Select XYZ from QWERTY where SomeField = " & " 'variable'" . All that apostrophe double quote ampersand malarkey is a real...

I'm no expert by any means but what if someone keeps notes or tasks in their contacts folder? Neil

ChaZ - I think I would still need to deal with grabbing the new record from the user in either situation. THe problem is dealing with the msgbox popup which stays active (after hitting 'yes') when the code returns to the form. So, the user says "yes" - adds the new contact and saves/closes the...

I battled with this problem for a long time and was about to give up when I discovered "TabTag" (www.tabtag.com)- It is free for single user. It exposes (?) an SQLview set of tables which you can link to Access (and any other SQL-system). The tables are hot-wired into Outlook and expose every...

Closing msgbox before a function fires The folllowing is a Not_in_List event procedure in Access 2002 The form has a combo linked to an SQLview of my contacts in OL. The essence of the code is: If not in list, open new contact form in OL, save it (in OL), come back to Access form, save...

Thanks for the link - it is disconcerting to see no references in the KB to Win2K - it's all XP oriented. THere are many referecnes in MSconfig to McAfee so I may uninstall McAfee everything (firewall has been off but VScan is on). More soon

I spoke too soon about the success. The Winsockfix utility did fix the problem but only temporarily. I went to install SSH Sentinel for my VPN and it flunked. Said there was a fault with TCP/IP stack. When it exited my contact with internet had gone. Ran Winsockfix again and got it back. I...

Wizard! - the winsockfix program has succesfully dragged me back from the brink of despair... Thanks Jlong for passing on bacastner's hot tip. Superb - Hoorah for Tek-Tips. Pre and post fix notes:- 1. After having uninstalled TCP/IP I went to re-install before using the Winsockfix program...

SoHo network; Peer to Peer; ADSL Router and VPN Router; Mix of Win2k and Win98 machines. Win2K SP4. Problem: All machines but laptop can access Internet. My Win2K Dell C840 laptop shows all machines on network. Laptop can successfully ping all others by IP address and machine name. Pinging to...

I have searched for in vain for links/faqs dealing with connecting Access02 to OL2002. They all assume I have Exchange... The 'link table' wizard for OL is not very helpful as it doesn't expose the useful unique ID fields needed for relationship building (combo boxes/lookups etc) (I use OSAsync...

With a current job record in Access I use VBA code to do a FileOpen operation in Word (eg show all myjobnumber*.doc). All the documents are on a network drive. No matter what I do with hard coding the required directory in VBA, the wdDialogFileOpen operation always pops up in the last directory...

By massaging earlier code for creating new OL items I put the following together. The aim is to hit a command button to display the appropriate OL contact item using the 'Fullname' field entry as stored in the record as OLID (linked to GCCGContacts folder to Access database). I am now stuck...

By massaging earlier code for creating new OL items I put the following together. The aim is to hit a command button to display the appropriate OL contact item using the 'Fullname' field entry as stored in the record as OLID (linked to GCCGContacts folder to Access database). I am now stuck...

A lengthy post - apologies... I am a consultant and have a job database in Acc2002. It was created before I had OL2002. There are 5 fields each with its own category for which I used lookup wizards to link to the various parties involved (ie companies, person, phone etc). I was a VBA newbie...