VisualBasic Script Access 481 codes

  1. Home
  2. VisualBasic Script
  3. Access
1 A Basic Example Using ADOMD
2 A Recordset That Does Not Support the RecordCount Property
3 A Recordset That Supports the RecordCount Property
4 A Simple Connection Example
5 Accessing Data with the Fields Collection and Field Objects
6 AcImportDelim
7 AcImportFixed
8 Activate toolbar with DoCmd ShowToolbar
9 AdAsyncExecute - The source is executed asynchronously
10 AdAsyncFetch - The initial quantity specified in the Initial Fetch Size property is fetched
11 AdAsyncFetchNonBlocking - The main thread never blocks when fetching
12 AdCmdFile - The source is evaluated as a persisted recordset
13 AdCmdStoredProc - The provider evaluates the source as a stored procedure
14 AdCmdTable - A SQL query is generated to return all rows from the table named in the source
15 AdCmdTableDirect - The provider returns all rows in the table named in the source
16 AdCmdUnknown - The type of command in the source is unknown
17 Add a new user
18 Add Edit Range
19 Add group
20 Add new a row to recordset
21 Add new property to TableDef
22 Add or delete users
23 Add user to group
24 Add where clause to the select statement
25 Adding a Field with SQL command
26 Adding a Multiple-Field Index to an Existing Table
27 Adding a New Field to a Table
28 Adding a New Money type Field to an Existing Table
29 Adding a New Record to a Recordset
30 Adding a New Record to a Table
31 Adding a Primary Key to a Table with SQL command
32 Adding a Single-Field Index to an Existing Table (Intrinsic constants for the IndexNulls property of the ADOX Index object)
33 Adding a Single-Field Index to an Existing Table with SQL command
34 Adding a Unique Index Based on Two Fields to an Existing Table
35 Adding a User to a New Group
36 Adding Controls to the Report
37 AdInteger and adWChar
38 ADO Equivalents to Access Data Types
39 Alter table to delete an Index with SQL command
40 Append new columns to new table
41 Arrow key, page up, page down key
42 Assigning Recordsets Dynamically to a form
43 Auto-Generate an Index Using VBA
44 Build a string text from result set
45 Build the SQL statement dynamically
46 Build user list
47 Building a New Web Query with VBA
48 Call delete method in Recordset
49 Call store procedure
50 Call update method from Recordset
51 Change column data case
52 Change the password of the database from smith to jones
53 Changing a User Password
54 Changing a User Password with SQL command
55 Changing Options
56 Changing the Access Environment
57 Changing the Field Data Type with SQL command
58 Changing the Size of a Field with SQL command
59 Changing the Start (Seed) Value of the AutoNumber Field with SQL command
60 Check after using the MoveNext method whether the end of the file has been reached
61 Check table definition
62 Check the keycode
63 Check the Recordset affected
64 Checking for Existence of a Field
65 Checking for Existence of Tables
66 Checking Permissions for a Specific Object
67 Close form without saving
68 Closes the Workspace
69 Closing a Database
70 Command Execute method
71 Compacting a Database
72 Configuration of LockType as a Property of the Recordset Object
73 Connect to current database
74 Connect to database with user name and password
75 Connect to databse through URL
76 Connect to JET
77 Connect to Oracle
78 Connecting to an SQL Server Database
79 Connecting to an SQL Server Using a DSN-less Connection
80 Connecting with Microsoft Access with ADODB Connection
81 Connection error handler
82 Connection String to Access database
83 Connection to database
84 Controlling Autonumber Fields
85 Converting the Recordset to a String
86 Copy Records to a Text File
87 Copying Records to a Word Document (Example 1)
88 Copying Records to an Excel Spreadsheet
89 Counting the Number of Returned Records
90 Creat a SQL statement and append parameter as ceriteria
91 Create a named report
92 Create a new database
93 Create a primary key
94 Create a relation
95 Create a stored procedure
96 Create a table with ADOX Table and ADO data type
97 Create a table with validation rule
98 Create an index
99 Create new database
100 Create new field with validation rule
101 Create Query by using the Database CreateQueryDef
102 Create Relation
103 Create user for Access database
104 Create view
105 Creates a QueryTable object on the active worksheet and sets its data source to a single table from a Web page at the designated lo
106 Creating a Connection Object
107 Creating a Custom Recordset
108 Creating a Design Master
109 Creating a Disconnected Recordset
110 Creating a Full Replica
111 Creating a Group Account
112 Creating a Group Account with SQL command
113 Creating a Link to an Access Table Stored in Another Database
114 Creating a List of Database Tables(Types of tables in the ADOX Tables collection)
115 Creating a New Microsoft Access Database Using ADO
116 Creating a One-to-Many Relationship
117 Creating a Parameter Query
118 Creating a Pass-Through Query with ADOX
119 Creating a Password Programmatically with SQL command
120 Creating a Primary Key
121 Creating a Primary Key Index with Restrictions with SQL command
122 Creating a Query Using Code
123 Creating a Recordset Using a Connection Object
124 Creating a Recordset Using a Connection String
125 Creating a Recordset Using the ActiveConnection Property
126 Creating a Select Query with ActiveX Data Objects
127 Creating a Single-Field Primary Key with SQL command
128 Creating a SQL Server Connection Object with Integrated Security
129 Creating a SQL Server Connection Object with SQL Server Security
130 Creating a Stored Procedure that Accepts Parameters
131 Creating a Table (ADOX data types vs Microsoft Access data types)
132 Creating a Table in a New Database with AUTOINCREMENT column
133 Creating a Table in the Current Database with SQL statement
134 Creating a Table with a Single-Field Index with SQL command
135 Creating a Table with a Validation Rule Referencing a Column in Another Table
136 Creating a User Account
137 Creating a User Account with SQL command
138 Creating a View Based on a Table with SQL command
139 Creating an Empty Report
140 Creating an Index Based on Two Fields with SQL command
141 Creating an Index that Disallows Null Values in the Key with SQL command
142 Creating an Index with the Ignore Null Option with SQL command
143 Creating an XML Document from ADO
144 Creating Check Constraints
145 CurrentProject Connection
146 Database properties
147 Database relations
148 Deactivate toolbar DoCmd ShowToolbar
149 Declares a Variant variable named myBookmark and then assigns to it a bookmark representing the current record in an ADO recordset.
150 Default Column value
151 Default Record Locking
152 Delete a column
153 Delete a query
154 Delete backup tables
155 Delete row for a certain criteria
156 Delete user list
157 Deleting a Database File
158 Deleting a Database Password with SQL command
159 Deleting a Field from a Table with SQL command
160 Deleting a Field that is a Part of an Index with SQL command
161 Deleting a Group Account
162 Deleting a Group Account with SQL command
163 Deleting a Record
164 Deleting a Stored Procedure
165 Deleting a Stored Query
166 Deleting a Table from a Database
167 Deleting a Table with SQL command
168 Deleting a User Account
169 Deleting a User Account with SQL command
170 Deleting a View with SQL command
171 Deleting an Existing Record from Recordset
172 Deleting an Index with SQL command
173 Deleting Indexes from a Table
174 Deleting Records via ADO
175 Designating the Cursor Location
176 Does it support bookmark
177 Does Recordset support Bookmark(adBookmark)
178 Does Recordset support Move Previous (adMovePrevious)
179 Does Recordset support Seek (adSeek)
180 Does Recordset support Update Batch (adUpdateBatch)
181 DSN-less connection using the SQLOLEDB provider
182 Dynamic Recordset
183 Embedding a Database Password in Code
184 Emport table as XML file
185 Encrypting a Database
186 Enumerate group and users
187 Enumerate groups and users
188 Enumerate the properties of current database
189 Establishing a Connection to the Current Access Database
190 Establishing a Link to an External Table
191 Establishing Relationships Using Code
192 Execuate query
193 Execute the view
194 Executing a Parameterized Stored Procedure
195 Executing a Pass-Through Query Saved in Access
196 Executing a Select Query
197 Executing a SQL Statement Containing Parameters
198 Executing a Stored Procedure Containing Parameters
199 Executing an Update Query
200 Executing an Update Query using the Command Object
201 Export database
202 Export table as html page
203 Export table as htx file
204 Export table as rtf file
205 Export table as txt file
206 Export table as xls file
207 Export table to asp page
208 Export table to html file
209 Export to a Comma Separated File
210 Export to a Fixed Width File
211 Export to an XML file
212 Exporting to a Database
213 Exporting to a Spreadsheet
214 Filling a Combo Box with a Disconnected Recordset
215 Filtering a Recordset
216 Filtering a Recordset by using the Date type field
217 Filtering Records Using the Filter Property
218 Filtering Records with an SQL Clause
219 Find record by using Recordset FindFirst
220 Finding a Record Based on Multiple Criteria
221 Finding a Specific Record in a Recordset
222 Finding Records Using the Find Method
223 Finding Records Using the Seek Method (Seek constants)
224 Finding the Record Position
225 Generating a List of Saved Views
226 Get all report history
227 Get current project from Application object
228 Get database from Workspace
229 Get DISTINCT records
230 Get DISTINCTROW
231 Get field properties
232 Get more than one column
233 Get only one column
234 Get Recordset content by calling Recordset GetString
235 Get result set by column name
236 Get rows from Recordset
237 Get Table documents
238 Get the created query name
239 Get the number of recorders which meet the criteria
240 Get the Number of Returned Records
241 Get the top 10 percent
242 Get the top 5 percent
243 Get the updated record count
244 Get Workspaces count and name
245 Granting Permissions for Tables to an Existing Group with SQL command
246 Import an XML file
247 Import database
248 Import XML file
249 Importing from a Comma Separated File
250 Importing from a Fixed Width File
251 Importing Spreadsheet Data Using Code
252 Importing Text Data Using Code
253 Include the database version information with the JetOLEDB
254 Inner Join
255 Iterate through all modules located in the database referenced by the CurrentProject object
256 Iterates the AllTables collection looking for a table whose name includes the substring Backup
257 Iterates the AllTables collection to determine if a table is open If it is, it prompts the user to close it
258 Iterates the AllTables collection, opens each nonsystem table, prints its structure, and then closes the open table
259 Iterates through the AllForms collection of the CurrentProject, printing the name of each form
260 Linking to an External Table
261 List group user
262 List table properties
263 List table types
264 Listing All Group Accounts
265 Listing All Saved Queries in a Database
266 Listing All User Accounts
267 Listing Field Properties
268 Listing Indexes in a Table
269 Listing Table Properties
270 Listing Tables and Their Fields Using the OpenSchema Method
271 Listing Users in Groups
272 Lists the tables in the LIBRARY database
273 Loop through all forms
274 Loop through all queries in the database referenced by the CurrentData object
275 Loop through all used range
276 Loop through each table in the database by the CurrentData object
277 Loop through each table in the database referenced by the CurrentData object
278 Loop through the ResultSet after executing select statement
279 Looping Through a Recordset
280 Makes the admin account the owner of the new workspace
281 Making a Copy of a Table
282 Making a User Account a Member of a Group with SQL command
283 Making Bulk Changes
284 Marking Records with a Bookmark
285 Modifying a Record
286 Modifying a Select Query
287 Modifying One Record at a Time
288 Modifying Table Data Using ADO Code
289 Move cursor in a Recordset with MoveNext
290 Move cursor in result set
291 Move the resultset cursor with MoveNext method
292 Moves 5 records backward from the current record in a DAO recordset
293 Moving Around in a Recordset
294 Moving Through the Records in a Recordset
295 Navigate through a recordset
296 NoMatch property in Recordset
297 Open a table and read data by column
298 Open a worksheet through OLEDB
299 Open an Access database on the server
300 Open dBase file and query data
301 Open report
302 Open the recordset, designating that the source is a SQL statement based on more than one table
303 Open up a schema with a provider to look at all the database objects
304 Opening a DAO Recordset Using a SQL SELECT Statement
305 Opening a DAO Recordset Using a Table
306 Opening a Database in Read-Only Mode
307 Opening a Database in ReadWrite Mode
308 Opening a Database Secured at the User Level
309 Opening a dBASE file with ADO
310 Opening a Microsoft Jet Database in ReadWrite Mode
311 Opening a Password-Protected Database
312 Opening a Recordset
313 Opening a Recordset Based on a Table or Query
314 Opening a Recordset Based on a Table or Query with SQL command
315 Opening a Recordset Based on an SQL Statement
316 Opening a Recordset Based on Criteria
317 Opening a Recordset Directly
318 Opening a Recordset with Inconsistent Updates
319 Opening a Text File with ADO
320 Opens Database in exclusive mode with readwrite access
321 Options of Open Method
322 Order by two fields
323 Order record in a decscending order
324 Order the resultset with Order by clause
325 Output table to asp file
326 Pass parameter to a query
327 Performing Batch Updates
328 Print preview Report
329 Prompting the User for the Database Path and Name
330 Protect from mark
331 Read record in recordset by referening the field name with !
332 Read specific columns from Recordset
333 Read table schema
334 Reading a Persisted Recordset
335 Recordset Open method
336 Reference column name from TableDefs
337 Reference database from DBEngine
338 Reference recordset and table with DBEngine
339 Reference TableDefs from DBEngine
340 Refreshing a Link
341 Refreshing Recordset Data
342 Relating Two Tables and Setting up Cascading Referential Integrity Rules
343 Remove Edit Ranges
344 Remove extraneous rows and columns and reset the last cell
345 Removing a Field from a Table
346 Removing a Table Using Code
347 Removing a User Account from a Group with SQL command
348 Report Error Event
349 Report Open event
350 Requiring Password Validation
351 Reset any values you set
352 Retrieve data from Recordset by table column name
353 Retrieve the last-assigned autonumber value
354 Retrieving Field Values
355 Retrieving the Name of the Object Owner
356 Revoking Security Permissions with SQL command
357 Rollback a transaction
358 Row order in Dynamic Recordset
359 Run a command through current project
360 Running Parameter Queries
361 Save Bookmark to an array
362 Save Recordset to a file
363 Save table to a collection
364 Save the recordset as an XML file
365 Saving Records to a Disk File
366 Select all columns
367 Select specific column in select statement
368 Set and get the lock type
369 Set column properties by using ADOX Table
370 Set Cursor Location to adUseClient
371 Set CursorLocation to adUseServer
372 Set CursorType to adOpenDynamic
373 Set CursorType to adOpenForwardOnly
374 Set CursorType to adOpenKeyset
375 Set CursorType to adOpenStatic
376 Set Index and seek the recordset
377 Set Lock Type to adLockOptimistic
378 Set new property to database
379 Set recordset to form
380 Sets the locking type in the call to the Open method
381 Setting a Database Password
382 Setting a Database Password with SQL command
383 Setting a Default Value for a Field with SQL command
384 Setting User Permissions for a Database
385 Setting User Permissions for an Object
386 Setting User Permissions for Containers
387 Shift key, alt key and control key mask
388 Show all foreign tables from a relation
389 Show all permissions
390 Show delete permission
391 Show Edit Ranges
392 Show field name, type and value data type
393 Simple Select statement
394 Snapshot Recordset
395 Sorting Records
396 SQL with where clause
397 Sub addJetSqlUser()
398 Sub KeepEmOut()
399 Sub Report_Close()
400 Sub Report_NoData(Cancel As Integer)
401 Sub Report_Open(Cancel As Integer)
402 Supplying the CursorType as a Parameter of the Open Method
403 Supplying the CursorType as a Property of the Recordset Object
404 Table documents
405 The AllMacros collection allows you to iterate through all macros stored in the current project
406 The AllReports collection allows you to loop through all reports in the current project
407 The Errors Collection
408 The Page event gives you the opportunity to do something immediately before the formatted page is sent to the printer
409 The RecordCount Property Is Not Supported with a Forward-Only Recordset
410 The Sort Property of the Recordset Object
411 The Supports Method of the Recordset Object
412 The VerifyLink Routine
413 To create a new group account in the current database
414 To show that the CurrentDb function adds to the Databases collection
415 Transaction Processing in Access 2007 Using BeginTrans, Logging, CommitTrans, and RollbackTrans
416 Transfer database acExport
417 Transfer database through ODBC
418 Transfer SQLServer database
419 Unlock Edit Range
420 Update a table
421 Update a table with QueryDef
422 Update Recordset
423 Use ! to reference column in a recordset
424 Use Access Special Keys
425 Use AddNew and specify the field information
426 Use AddNew method from Recordset and two arrays to add a new row
427 Use ADODB Command to create a view
428 Use and to combine conditions
429 Use Between And
430 Use between and with number type column
431 Use Date function in where clause
432 Use DBEngine to reference tables and its columns
433 Use dbOpenSnapshot when opening an recordset
434 Use Do while to loop through until EOF
435 Use IN and like in where clause
436 Use IN in select statement
437 Use Is not null
438 Use Is NULL to check if a column is null
439 Use Not In
440 Use OLEDB to connect with mdb file
441 Use optimictic lock to open recordset
442 Use parameter name connection string
443 Use Recordset filter
444 Use Recordset Support to check the supported features
445 Use Row Level Locking
446 Use seek method in Recordset
447 Use Select all
448 Use SUM in sql statement
449 Use the CompactRepair method of the Application object to compact and repair the database
450 Use the EXECUTE statement to execute the stored procedure
451 Use the report object variable to point at each report in the Reports collection
452 Use transaction
453 Use where clause and order by clause together
454 Use wild card character in link
455 Use With statement with CurrentProject
456 User Defined Property
457 User InputBox to read SQL statement parameter
458 Using a CHECK Constraint to Specify a Condition for All Values Entered for the Column
459 Using a Command Object to query table
460 Using a Database Transaction to Insert Records
461 Using a Stored Procedure to Make Bulk Changes to Data in a SQL Server Database
462 Using Bookmarks to Filter Records
463 Using CreateParameter to delete a company record
464 Using Date field type in select statement
465 Using the AbsolutePosition Property
466 Using the Areas Collection to Return a Noncontiguous Range
467 Using the Bookmark Property
468 Using the EOF Property to Determine the Bounds of a Recordset
469 Using the Open Database Method
470 Using the OpenSchema Method to List Database Tables
471 Using the Recordset Movements() Methods on a Recordset Object
472 Using the SpecialCells method to select all the blanks in this range is one way to quickly fill in all the blank region cells with
473 Using the TransferDatabase Method
474 Using the VBA Err Object and ADO Errors Collection
475 Using VBA to Update an Existing Web Query
476 Whether Records Are Returned in a Recordset
477 Working with the Used Range
478 Writing the Form_KeyDown Event Procedure
479 Writing the Form_KeyPress Event Procedure
480 Writing the Form_KeyUp Event Procedure
481 You must use a pound symbol (#) when delimiting dates for Microsoft Access, like this