Diễn đàn game zombie

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

#1 2020-09-14 03:43:15

Registered: 2020-09-14
Posts: 1

Access Relational Database program created by Microsoft

Word Definition   Access Data Project An  Access database  project that uses SQL Server as a back-end and Access as the front-end.
Access  Relational Data base program created by Microsoft.
Data Macro A special macro in Access 2010 which uses new table events to be able to perform  action s on, or with, data.

Dirty Dirty refers to a recordset that has pending updates or changes

A form can be “dirty” if someone adds a new record (not just goes to the new record area, but starts entering data), deletes something, or changes some existing data.
A bound form can be “dirty” but an unbound form is never dirty, even if controls get changed there.
As stated, it is the recordset which really is dirty, and so an unbound form does not have a recordset and therefore can’t be dirty.
The code      If Me.
Dirty Then Me.
Dirty = False      1    If  Me Dirty  Then  Me Dirty = False            forces a form to save the record.

This is good code to use instead of      DoCmd

RunCommand acCmdSaveRecord      1    DoCmd RunCommand  acCmdSaveRecord            because the one that refers to Dirty, will ONLY attempt a save if the form is dirty and needs a save.

The DoCmd one will attempt a save regardless and that can cause errors

if certain things exist – including default values.
Form Module A form module is a Visual Basic for  Application s (VBA) module that is part of the form class in Access.
It manages the events on a specific form to which it is attached.
Its scope is the form and users should not try to add form events to the module manually.
Access manages events on the forms and users adding their own events will cause errors to occur.
Lookup Field Lookup fields are fields in tables that utilize a built-in combo box to look up one value from another table so that it can display one thing while storing the ID.

This is NOT a good thing to use at Table level

Please read here for more  information : The Evils of Lookup Fields in Tables   MDB File The access database file that allows someone to edit all of the objects within it, if they have a full-version of Microsoft Access (if it isn’t restricted by Access security).
The mdb file is the main file type that is created, normally.

When you create a new database in Access 1.0

up to Access 2007 (although in Access 2007 it is not the default format unless you set the option for it to be the default).
MDE File A file that is compiled so that the Visual Basic for  Applications  code and Macros are not able to be viewed and Forms and Reports are not able to be modified.
This file type is typically used when you don’t want people to access your code, or macros and don’t want your forms and reports to have changes made to their design.

It is also typically used with the runtime version of Microsoft Access

IMPORTANT NOTE: Users with  full version s of Access can still modify the design of tables and queries within an MDE file.
MDW File The WORKGROUP security file that houses the security  information  for a secured database.

The default workgroup installed is System.mdw

ME This is a  programming  shortcut which lets the programmer refer to the current CLASS object.
Most of the time, in Access, you would be referring to a form or report using this.
It can also apply to custom classes as well, but is less prevalent unless custom classes are being used.
Let’s say you have a form named “frmMain” and you have a text box there called “txtEntry” and you wanted to refer to that text box in code.
A fully-qualified reference would be Forms!frmMain.txtEntry but you could also refer to it using the shortcut (as long as the code is ON frmMain): Me.txtEntry   Normalization Normalization is  the process  of organizing data in a database.
This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
(courtesy Microsoft – http://support.microsoft.com/kb/283878)   Reserved Word A special word that Access uses either as a name of an object or it can be a property or method or even a function.

You should NOT use these as field or object names

Reserved Words – Access 2002+ http://support.microsoft.com/kb/q286335/   Reserved Words – Jet 4.0 http://support.microsoft.com/?id=321266    Reserved Words List (comprehensive) http://allenbrowne.com/AppIssueBadWord.html   Special Characters to Avoid These are special characters you should NOT use in field, or object names: http://support.microsoft.com/?id=826763   Standard Module This module is the one that is created when you go to the database window and select MODULES and then click NEW.
It is where global (PUBLIC) variables should be declared for use within the entire project and it where user defined functions are normally declared and written.
Subform Control The subform control is the control on the main form that houses the subform.
Its name is the name to reference in code and not the subform name.
If the subform control, and the subform have the same name, that is okay but it isn’t necessary.
If the subform control and the subform have different names then you must remember to refer to the subform control, and not the subform itself, within your code.
For example, if you have a subform control named subform1 on a main form named frmMain and your subform within the control is named sfrm_test your code to refer to a text box named txtTest on the subform would be:      Forms!frmMain.subform1.

Form.txtTest = "Whatever"      1    Forms
FrmMain subform1 Form txtTest = "Whatever"


Copyright ©  • Powered by  • Web Development by


Board footer

Powered by FluxBB