Ivan’s Technical Blog

This article shows you how to switch the view of a subform from Datasheet view to Form view while the main form is open in Form view.

1. Open the sample database Northwind.
2. Open the Orders form in Design view.
3. Add a command button to the main form. If the Command Button Wizard appears, click Cancel.
4. Set the following properties for the command button:

      Name: cmdChangeView
      Caption: Change View
      OnClick: [Event Procedure]

5. Set the OnClick property of the command button to the following event procedure:

   Private Sub cmdChangeView_Click()
       Me![Orders Subform].SetFocus
       DoCmd.RunCommand acCmdSubformDatasheet
   End Sub

6. Close the Visual Basic Editor, and then open the Orders form in Form view.
7. Click the Change View button to switch the subform from Datasheet view to Form view. Note that the button toggles the subform view. In other words, each time that you click the button, the subform changes either from Datasheet view to Form view, or vice versa.

I want to keep a consistent data between my VTiger CRM & Outlook & Pocket PC. It turns out to be a very difficult task to do. I’ve tried a few methods to solve the problem below

Vtiger CRM returns  “Invalid return value from vTiger CRM”

At the beginning, I thought it was due to invalid name data as discussed in vtigercrm’s forum. The rule is

• There can be only one word for “last name”, no space, no ‘, no -

However, after taking the painful steps to correct all my 900 contacts, I still get the same problem. Thus, I have to do it one by one. Trust me, you will never want to do that again. And guess what, I realised after sync about 450 contacts successfully, i got the same error message again.

Therefore, I suspected that there might be some limits set somewhere. Eventually, I discover this is because my shared server gives me 64M php memory limit! That’s how much 450 contacts used to sync!

Thus, I have to separate the contacts into two categories: business & personal. and sync them by two vtiger accounts. as a result, now I have two folders of contacts. and now it creates another problem.

Pocket PC can only sync with the default contact folder

This problem can be solved by Outlook 2002 Add-in: Pocket Contact Synchronizer 1.2 Here is an introduction of how to use PCS. However, here comes the next problem. That is

PCS is a one-way synchronization feature only.

That is if you update the Contact information on your Pocket PC and synchronize then you will need to move the Contact back to its sub folder manually. (I haven’t found a solution for this yet)

• Outlook PCS does not modify any of the items that you place in the default contacts folder.
• Outlook PCS also does not modify any of the actual items in the folders you specify to be synchronized.
• Outlook PCS inserts the original folder name in the Categories field of the new items so you can sort or group by the items in Outlook. This lets you filter the items in Pocket Outlook once they are synchronized to your Pocket PC or Windows CE device.
• You don?t need to run ActiveSync after running Outlook PCS — you can see if Outlook PCS worked correctly by checking your default contacts folder for new items synchronized from your specified folder(s). Each synchronized contact should also have the name of the original folder as a category for that item as well.

And it seems the birthday is not sync from the sub folder to the default folder

There is duplicated birthday reminder created by outlook 2003

(not solved yet)

Docx is the new file format of Word 2007 and this is the default format of Word 2007. This format cannot be opened in previous versions of Word unless you have the office compatibility pack installed. Incase you do not wish to install the compatibility pack, there are
online converters to do the job of converting to .doc format. Here is the list of top 3
online converters.

1. Zamzar: Zamzar can
convert variety of file formats and
Docx is one of them. Select the file and format to be converted and enter your email id, the file will be converted and a link will be sent to your email ID for download.

2. Docx2Doc: As the name indicated, this service converts
docx formats into doc files so that it can be viewed in Word 2003 or lower. The major disadvantage with this service its that there is a one hour delay in downloading the converted files to reduce website bandwidth.

3. Docx Converter:  This is again a
good service to
convert
Docx file and the output file is in html format so that it can be read in all systems. There is also a desktop widget for converting.

In case you just want to view a
docx file, then there is a simpler way for this. Rename the extension of file from .
docx to .zip and then extract the contents.
Docx is basically a set of xml files. When you unzip the file, you get a folder named Word and inside that you can see a file named document.xml. To view the contents of the document, open document.xml.

The Microsoft Access Order Entry form you created contains all the information that your customer reps need to take a phone order. But every now and then the customer rep needs to access another form that has information that isn’t on the order form.

Instead of adding a subform to the order form, you can add a command button that let’s your rep pop open the desired form when needed. For example, a customer may need to change their e-mail address, which may be kept on the Customer E-mail Address form.

To create a command button that, when clicked, will pop open the necessary form, follow these steps:

1. Open the Order Entry form in design mode.
2. Click the Command Button tool on the toolbox and click and drag it to insert the command button control on the Order Entry form.
3. Right-click the command button and select Properties.
4. Under the Format tab, change the caption to E-mail Address.
5. Select the Event tab, click the On-Click Property’s drop-down menu, and then select Event Procedure.
6. Click the On-Click Property’s Build button.
7. Enter the following command at the prompt:

DoCmd.OpenForm "Customer E-mail Addresses"

1. Press [Alt][Q].

Now when your reps’ customers need to update their e-mail addresses, the rep can click the command button to access the correct form and make the necessary changes.