wordpress statistics
  • Today is Monday, February 6, 2012

Rounding Function MRound of Excel

Rounding Function MRound of Excel
Posted On 06 Dec 2008 By . Under Functions.
Normally we round numbers in calculations when the fractional part is 0.5 or more to 1 (next highest integer) or truncate it altogether. But, there are times that this fractional ... Continue Reading
2 Comments

Sum Min Max Avg ParamArray

Sum Min Max Avg ParamArray
Posted On 07 Nov 2008 By . Under Functions.
I know your immediate response after looking at the Title will be, "I know all those things, tell me something that I don't know". Well, if you haven't come across ... Continue Reading
No Comments

MICROSOFT ACCESS HOW TOS

MICROSOFT ACCESS HOW TOS
Posted On 06 Dec 2006 By . Under How Tos.
IMPLEMENTING MICROSOFT ACCESS SECURITY MICROSOFT ACCESS SECURITY OVERVIEWCreating a User Account Creating a Group Account Add Users to Security Groups Remove Users from Security Groups Deleting a User-Account Deleting ... Continue Reading
4 Comments

DISPLAY PATH AND FILE INFO

DISPLAY PATH AND FILE INFO
Posted On 06 Dec 2006 By . Under How Tos.
Displaying Path & File InfoSub ShowFileAccessInfo2() Dim fs, d, f, s On Error Goto ShowFileAccessInfo2_Err Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.Getfile("C:\mytext.txt") s = UCase(f.Path) & vbCrLf s ... Continue Reading
No Comments

RENAME FILE USING FILESYSTEMOBJECT

RENAME FILE USING FILESYSTEMOBJECT
Posted On 06 Dec 2006 By . Under How Tos.
Renaming a file and displaying Drive & File Information   Sub ShowFileAccessInfo() Dim fs, f, s On Error GoTo ShowFileAccessInfo_Err Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.Getfile("C:\mytext.txt") s ... Continue Reading
No Comments

CREATE TEXT FILE FROM MSACCESS

CREATE TEXT FILE FROM MSACCESS
Posted On 06 Dec 2006 By . Under How Tos.
HOW TO CREATE A TEXT FILE FROM MICROSOFT ACCESS  The FileSystemObject Object provides access to a the computer's file system.The following code illustrates how the FileSystemObject is used to return a ... Continue Reading
5 Comments

CREATE EXCEL WORD FILE FROM ACCESS

CREATE EXCEL WORD FILE FROM ACCESS
Posted On 04 Dec 2006 By . Under How Tos.
CREATE EXCEL OR WORD FILE FROM ACCESS   Create Excel File or Word Document from Microsoft Access and write information into them. Every application that supports Automation provides at ... Continue Reading
1 Comments

IMPORT OBJECTS WITH VBCODE

IMPORT OBJECTS WITH VBCODE
Posted On 03 Dec 2006 By . Under How Tos.
IMPORT OBJECTS WITH VISUAL BASIC CODE   Normally, Tables, Queries or other objects from another database can be imported manually by selecting Import from Get External Data option ... Continue Reading
1 Comments