Problem: I am using LibreOffice version 4.4, currently I use “drag down method” to automatically increase the number, e.g. LT1, LT2, LT3, …., LT100

How do I achieve the same result using LirbreOffice Basic (VBA)?

Solution:

REM ***** BASIC *****
Sub Main

rem define variables
dim document as object
dim dispatcher as object

rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

dim args1(0) as new com.sun.star.beans.PropertyValue
dim args2(0) as new com.sun.star.beans.PropertyValue
dim i as integer 
dim iLT as integer
 rem goto cell "A1"
 args1(0).Name = "ToPoint"
 args1(0).Value = "$A$1"
 dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())
 
 rem loop and insert suffix for "LT" of the item code
 For iLT = 401 to 500
 
 rem loop and insert suffix from "00" until "99" into the item code
 For i = 0 to 99
 
 
 args2(0).Name = "StringName"
 if len(i) = 1 then
 args2(0).Value = "06-st-0888-LT" & iLT & "-0" & i
 else
 args2(0).Value = "06-st-0888-LT" & iLT & "-" & i
 end if
 
 rem to enter the item code into the cell
 dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args2())
 
 rem move down one cell
 dispatcher.executeDispatch(document, ".uno:GoDown", "", 0, args1())
 
 Next i
 
 Next iLT
End Sub

Problem: my PC’s partition C drive is full, I need to increase the size or volume of the C drive. I have a lot of space in D drive. I do not have any 3rd party software like Paragon Partition Manager, EaseUS Partition Manager, etc. How do move or allocate free space in D drive to C drive?

Solution: you do not need any 3rd party software, Windows 7 and above should able to allocate free space from 1 partition to another (provided both partitions are on the same hard disk). Refer to the steps below …

1. goto Disk Management
2. if you wish to increase of the C drive volume, then right click on the partition next to C drive (in this case it is D drive)
3. right click on D drive, select “Shrink Volume… ” to reduce the size of D drive:-
4. right click on C drive, select “Extend Volume…” to increase the size of C drive
   

Problem: I have an application in VMWare that needs to connect to MySQL database server in host machine. Both host machine and virtual machine are on the same server. How do I do it?

Solution: refer to the steps below …

1. In host machine, one has to create a new MySQL User and assign privileges as below in Query prompt via phpMyAdmin or SQL editor:-

   CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
   GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
   CREATE USER 'username'@'%' IDENTIFIED BY 'password';
   GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
   FLUSH PRIVILEGES;

2. Once done with all four queries, the virtual machine should able to connect with IP address, user name and password of database’s host machine, e.g.:-
   IP address: 192.168.0.59
   Port: 3306
   User: (username)
   Password: (Password)

Source: http://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server

Here is a list of manuals or guides that were revised or recently published:-

• MOBITEK SMS API version 9 — Manual for Software Developer
• How to Use MOBITEK SMS API version 7 in Visual Basic .Net
• How to Send and Read SMS By Using Command Line
• How to Send and Read SMS Using PHP with MOBITEK SMS Engine Basic Edition
• How to Send and Read SMS in Java with MOBITEK SMS API v. 9
• How to Establish a GPRS Connection Using MOBITEK Q24 Modem

Applies To: PHP web application that requires connection to both SQL Lite and and MySQL database servers.

Continue reading →