Archive | Access RSS feed for this section

Input and Output Keyword Summary

8 May

To: belajar-access@yahoogroups.com
From: “Sofyan Efendi”
Date: Thu, 31 Aug 2006 07:59:22 +0700

Action | Keywords
Access or create a file -> Open
Close files -> Close, Reset
Control output appearance -> Format, Print, Print #, Spc, Tab, Width #
Copy a file -> FileCopy
Get information about a file -> EOF, FileAttr, FileDateTime, FileLen, FreeFile, GetAttr, Loc, LOF, Seek
Manage files -> Dir, Kill, Lock, Unlock, Name
Read from a file -> Get, Input, Input #, Line Input #
Return length of a file -> FileLen
Set or get file attributes -> FileAttr, GetAttr, SetAttr
Set read-write position in a file -> Seek
Write to a file -> Print #, Put, Write #

Wassalaamu’alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
- AccessWeb
- OPI-Homepage

Math Keyword Summary

8 May

To: belajar-access@yahoogroups.com
From: “Sofyan Efendi”
Date: Thu, 31 Aug 2006 08:10:12 +0700

Action | Keywords
Derive trigonometric functions -> Atn, Cos, Sin, Tan
General calculations -> Exp, Log, Sqr
Generate random numbers -> Randomize, Rnd
Get absolute value -> Abs
Get the sign of an expression -> Sgn
Perform numeric conversions -> Fix, Int

Wassalaamu’alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
- AccessWeb
- OPI-Homepage

Miscellaneous Keyword Summary

8 May

To:    belajar-access@yahoogroups.com
From:    “Sofyan Efendi” <sofyan@madinah.cc>
Date:    Thu, 31 Aug 2006 13:33:05 +0700

Action | Keywords
Process pending events -> DoEvents
Run other programs -> AppActivate, Shell
Send keystrokes to an application -> SendKeys
Sound a beep from computer -> Beep
System -> Environ
Provide a command-line string -> Command
Automation -> CreateObject, GetObject
Color -> QBColor, RGB

Wassalaamu’alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
- AccessWeb <http://www35.websamba.com/accessweb&gt;
- OPI-Homepage <http://www.geocities.com/opi1978&gt;

Operators Keyword Summary

8 May

To:    belajar-access@yahoogroups.com
From:    “Sofyan Efendi” <sofyan@madinah.cc>
Date:    Thu, 31 Aug 2006 13:33:27 +0700

Action | Keywords
Arithmetic -> ^, -, *, /, \, Mod, +, &, =
Comparison -> =, <>, <, >, <=, >=, Like, Is
Logical operations -> Not, And, Or, Xor, Eqv, Imp

Wassalaamu’alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
- AccessWeb <http://www35.websamba.com/accessweb&gt;
- OPI-Homepage <http://www.geocities.com/opi1978&gt;

Registry Keyword Summary

8 May

To:    belajar-access@yahoogroups.com
From:    “Sofyan Efendi” <sofyan@madinah.cc>
Date:    Thu, 31 Aug 2006 13:33:48 +0700

Action | Keywords
Delete program settings -> DeleteSetting
Read program settings -> GetSetting, GetAllSettings
Save program settings -> SaveSetting

Wassalaamu’alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
- AccessWeb <http://www35.websamba.com/accessweb&gt;
- OPI-Homepage <http://www.geocities.com/opi1978&gt;

String Manipulation Keyword Summary

8 May

To:    belajar-access@yahoogroups.com
From:    “Sofyan Efendi” <sofyan@madinah.cc>
Date:    Thu, 31 Aug 2006 15:51:57 +0700

Action | Keywords
Compare two strings -> StrComp
Convert strings -> StrConv
Convert to lowercase or uppercase -> Format, Lcase, Ucase
Create string of repeating character -> Space, String
Find length of a string -> Len
Format a string -> Format
Justify a string -> LSet, Rset
Manipulate strings -> InStr, Left, LTrim, Mid, Right, RTrim, Trim
Set string comparison rules -> Option Compare
Work with ASCII and ANSI values -> Asc, Chr

Wassalaamu’alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
- AccessWeb <http://www35.websamba.com/accessweb&gt;
- OPI-Homepage <http://www.geocities.com/opi1978&gt;

Variables and Constants Keyword Summary

8 May

To:    belajar-access@yahoogroups.com
From:    “Sofyan Efendi” <sofyan@madinah.cc>
Date:    Thu, 31 Aug 2006 15:52:39 +0700

Variables and Constants Keyword Summary

Action | Keywords
Assign value -> Let
Declare variables or constants -> Const, Dim, Private, Public, New, Static
Declare module as private -> Option Private Module
Get information about a variant -> IsArray, IsDate, IsEmpty, IsError, IsMissing, IsNull, IsNumeric, IsObject, TypeName, VarType
Refer to current object -> Me
Require explicit variable declarations -> Option Explicit
Set default data type -> Deftype

Wassalaamu’alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
- AccessWeb <http://www35.websamba.com/accessweb&gt;
- OPI-Homepage <http://www.geocities.com/opi1978&gt;

Menjalankan Query Paramater di Dalam VBA

8 May

To:    belajar-access@yahoogroups.com
From:    “Sofyan Efendi” <sofyan@madinah.cc>
Date:    Thu, 7 Sep 2006 09:47:33 +0700

Pada FAQ hari kemarin (tanggal 06 September 2006 11:18) dengan judul “FAQ Hari Ini: Too few parameter” telah dibahas mengenai penggunaan query paramater. Adapun untuk menjalankan query parameter langsung di dalam VBA, dimana criteria untuk parameter tersebut berasal dari dalam control pada suatu form, maka kita harus mendefinisikan parameternya secara langsung di dalam VBA. Marilah kita bahas sama-sama caranya.

CONTOH MENDEFINISIKAN PARAMETER DI DALAM VBA DENGAN PARAMETER DARI DALAM CONTROL PADA SUATU FORM

Dim dbSample As Database
Dim qdfSample As QueryDef
Set dbSample = CurrentDB()
Set qdfSample = dbSample .QueryDefs(” qryParameterQuer y”)
‘Disinilah parameter tersebut didefinisikan:
qdfSample![Forms! FormName! ControlName] = _
Forms![FormName] ![ControlName]

CONTOH MENDEFINISIKAN PARAMETER DI DALAM VBA DENGAN PARAMETER DARI DALAM INPUT BOX

Dim dbSample As Database, qdfSample As QueryDef
Set dbSample = CurrentDb()
Set qdfSample = dbSample.QueryDefs( “qryParameterQue ry”)
‘Disinilah parameter tersebut didefinisikan:
qdfSample![Tolong input Tgl:] = #7/9/2006#

CONTOH FILE (LENGKAP):

http://www.filelodge.com/files/hdd8/194664/samples/QueryParameterVBA.rar

Wassalaamu’alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
- AccessWeb <http://www35.websamba.com/accessweb&gt;
- OPI-Homepage <http://www.geocities.com/opi1978&gt;

Follow

Get every new post delivered to your Inbox.

Join 65 other followers