- Prompt For Saving a Record with VBA
- Microsoft Access automatically saves any changes we make to a record, whether we close the form or move to a new record. This article will show you a way of prompting a user to save the changes using VBA.....
- Product Review - Microsoft Access 2007 Training Course
- Learn Microsoft Access 2007: The MS Access Power Mastery course uses the power of video to expertly explain concepts. It literally takes you by the hand and in easy steps breaks apart each topic so that you quickly gain an understanding. Not only does it use video, but there are also PDF cheat sheets available to reinforce the concepts.....
- Control Structures in VBA
- Control Structures in VBA: As with any programming language VBA has over four control structures. Without these structures a programming language is basically useless. Because it wont be able to make intelligent decisions on its own. In this article we discuss some of the control structures that are available in VBA.....
- Why And How To Create A Many-To-Many Relationship
- Why And How To Create A Many-To-Many Relationship: To create a many-to-many relationship between the Orders and Products tables, we need to create a join table between them like the Products_Orders table in this example. The primary key of the join table is the combination of the primary keys of the tables that we would like to join in a many-to-many relationship.....
- Conditional concatenation with the iif() function
- Microsoft Access 2007 Pure SQL: Conditional concatenation with the iif() function. Sometimes, we might not want to apply the same concatenation rules for all of the records in the query. We can absolutely do this by using conditional statements and the iif() function in particular......
- Access 2007 Pure SQL
- This book provides the database professional and power user with
more than 300 working solutions for daily business tasks. The goal
has been to reduce needless writing and concentrate on the daily needs
of database usage and development. Download the Free Sample Chapter.....
- Exporting a table from Microsoft Access to EnterpriseDB
- Exporting a table from Microsoft Access to EnterpriseDB: Postgres is the well known and most used Open Source OLTP database available today which is claimed to be as good as or even better than MySQL. EnterpriseDB is Postgres packaged differently to provide enterprise capabilities to Postgres users. EnterpriseDB is available for Windows platform as well.....
- Introducing the Microsoft Sync Framework
- Introducing the Microsoft Sync Framework: Data synchronization is a great feature - it ensures that the data at the source and destination is in sync to each other. The Sync Framework is a Microsoft technology that can deal with the dilemma of occasionally connected systems. It is a comprehensive synchronization platform that enables collaboration and offline and online access for applications, services, and devices.....
- Using Text Files with Microsoft Access
- Using Text Files with Microsoft Access: Microsoft Access through VBA makes it easy for us to interact with the system files. In this article we will explore how to manipulate text files through Microsoft Access. To use files with Access we will have to use the file system object or FSO. The File System Object is basically a class that contains properties, methods and attributes that all relate to manipulating files.....
- Dashboard Builder for Microsoft Access
- Product Review: Dashboard Builder for Microsoft Access
Dashboard Builder is one of several Microsoft Access tools OpenGate Software offers.
Aimed at anyone that needs to summarize and visualize their Access data,
Dashboard Builder helps users to create metrics and graphs and
combine them into compact dashboards.....
- Using the DoCmd Object in Microsoft Access
- Using the DoCmd object: The DoCmd object is one of many objects that is offered by the Access environment. It's parent is the Application object. One of the common uses of the DoCmd object is with Macros. ....
- Product Review: Iron Speed Designer - Generate Web 2.0 applications straight from your database
- Iron Speed Designer generates standard .NET code in C# and Visual
Basic .NET. You enjoy unrestricted access to 100% of the code. In
addition, there are no run-time license fees or special server software
requirements for applications built with Iron Speed Designer. The
tool supports four databases: Microsoft SQL Server, Oracle, MySQL
and Microsoft Access. ....
- Creating Hyperlinks With Microsoft Access
- Creating Hyperlinks With Microsoft Access: Since Microsoft Access 2003, Microsoft has introduced hyperlinks in Access. What is a hyperlink? It is basically a textual representation of a location or object such as a file.....
- Database recovery - how to repair a Microsoft Access file
- Database recovery - how to repair a Microsoft Access file: There are many things that can go wrong with an Access database that will corrupt it and render it useless. An invalid procedure call or argument, out of memory errors, an array that is temporarily locked or fixed, there are literally hundreds of errors that can corrupt a Microsoft database.....
- Collect data by using e-mail messages in Microsoft Access 2007
- Collect data by using e-mail messages in Microsoft Access 2007: This tutorial deals with a new feature introduced to Access 2007. The new Access 2007 feature allows you to gather information in the email form based on two main approaches: HTML or InfoPath....
- Backing up a Microsoft Access 2007 Database
- Backing up a Microsoft Access 2007 Database: One of the rules of protecting your work and data is backing it up. You should consider doing the backup before you run an active query which will delete or change records because Undo cannot fix any change done by that manner. In general, it's advisable to back-up the database right after you populated the tables and before you run any query.....
- Understanding ADO.NET Entity Framework
- This article takes a look at the upcoming ADO.NET Entity
Framework, its features and benefits. It also discusses why it promises
to be the technology of choice for the next generation of data access
using ADO.NET. The primary objective of the ADO.NET Entity Framework
is to objectify your application?s data - add a level of abstraction
on top of the relational model. In raising this level of abstraction,
you can isolate the logical model of your application's data from the
relational model.....
- Working with the New Data Source Controls in ASP.NET (Part II)
- Working with the New Data Source Controls in ASP.NET (Part
II): In the earlier part in this series, Working with the New Data Source
Controls in ASP.NET (Part I), we discussed the ObjectDataSource, AccessDataSource
and SqlDataSource controls. In this concluding part in this series of
articles on data source controls, we will discuss the XmlDataSource,
LinqDataSource and the newly added EntityDataSource controls.....
- Working with the New Data Source Controls in ASP.NET (Part I)
- Working with the New Data Source Controls in ASP.NET (Part
I): With ASP.NET 2.0 and after, you are introduced to a bunch of new
data source controls, i.e., LinqDataSource, ObjectDataSource, XmlDataSource,
SqlDataSource, etc. You can use the newly added data source controls
of ASP.NET 2.0 to implement CRUD (Create, Read, Update, and Delete)
operations in your applications without having to write much code.....
© 2003-2010.
Directory-Base.