Recordset

Recordset from Functionx

The Type o fRecordset Objects

Characteristics Of recordset (partially from http://www.functionx.com)

Initializing a RecordSet (partially from http://www.functionx.com)

Using a RecordSet (partially from http://www.functionx.com)

Stored Procedures (partially from http://www.functionx.com)

Visual basic and Microsoft Access

Running sql query directly from visual basic super!!

PopUpCalendar for the date field on the forms

ComboBox-Hide 1st field and view the second but write the content of the 1st field in the textbox

Data types- Double, Long integer, Single, Decimal..

Format Function

Example of a function and sql query in  visual basic

Close form - Open form code

Example of 2 different recordsource for the same form

Select Case and exit button/submit button validity analysis

Form filled unfilled control and show it by color to user

Ole object dialog box contolling

common dialog box

Autonumbering

Compact and repair a database while it is open

Record Number

ApplyFilter by form

Test your query for records

Check if form is open

Create your own Icon and Title bar: The title bar and icon options are set from the tools - start up menu item. Just select the icon and type in your Application title

Ado and Access

find replace txt file content

ADO Database Connection

ADO Showing records in a table

ADO Filtering

Subform operations

Subform_on_resetting_all_values

Subform operation

Referencing Subform control on the main form

Extreme VB functions

Instr function

ASCII codes

Windows operations

Deleting a file

Open File Dialog Box

Opening explorer window with VB

Microsoft Word

SiteIndexCreationVisualBasicModule

Microsoft Excel

import from Excel to Access

Auto_load_on_excel

Stop user closing the form from the top right X

Protectlock_excel_vba_code

Hide the active workbook

Excel Links

https://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm ********* EXCEL`lent

http://www.mrexcel.com

http://www.vb123.com

http://www.exceltip.com ************ EXCEL`lent

www.functionx.com :

• Tips 1:

  • 1-Referencing a sheet - Item()

  • 2-To programmatically rename a worksheet

  • 3-To programmatically select a worksheet

  • 4-Move a worksheet,

  • 5-To move worksheet to a new file

  • 6-Add worksheet

  • 7-Delete Worksheet

  • 8-Random number generating

  • 9-Saving a Worksheet as a Web Page

• Tips 2 :

  • 1-Access a column

  • 2-Column Selection

  • 3-ColumnWidth

  • 4-Hide/Unhide Column

  • 5-Rows Selections

  • 6-Row height

  • 7-Hide/Unhide Row

  • 8-Cells

• Tips 3 :

Babam icin bilgisayar

Babam icin bilgisayar