background preloader

MS Access [English]

Facebook Twitter


MS Access Topics. Microsoft Office UtterAccess Discussion Forums. Microsoft Office UtterAccess. Access Web Apps opens up for custom embedded HTML5/JavaScript solutions!

Microsoft Office UtterAccess

Using the newly released Apps for Office in Access 2013 Web Apps, we now have the ability to create Apps for Office using HTML and JavaScript/jQuery. These Access Apps for Office (AAFOs, as they've been unofficially dubbed) can communicate with your Access App data to provide rich custom controls that were previously unavailable for Access Apps, or to provide web services that your app can make use of. The AAFO, once built, is added to your Access App via an HTML i-frame element on your forms. AAFOs can be published to the Microsoft Store for public facing solutions, or administered on your company's SharePoint site for internal solutions. To develop AAFO, we can use Visual Studio 2013 with the Microsoft Office Developer Tools for Visual Studio 2013 - March 2014 Update (direct download link ) Members of the Access Team recently presented AAFO to the SharePoint Conference.

(IMG:style_emoticons/default/compute.gif) Access Tips: Query and Filter Criteria. When constructing a query or a filter, you need to tell Access what to look for in each field.

Access Tips: Query and Filter Criteria

You do this by defining criteria - typing something (an "expression") into the Criteria cell of the query or filter grid. If you do not define any criteria for a particular field, Access assumes that you are applying no constraints and will display everything it has. This means that you only have to define criteria for those fields you are interested in. Here are some examples of the more common types of criteria. Often Access will complete the expression so that you need only type the text you want to match. The list of examples below is not exhaustive. This tutorial is arranged in the following sections: Matching Text. Microsoft Access. Help using Access visual basic modules and documenting your database. Export an Access query as an HTML Web Page. Sub MakeHTMvacancies() '* Create an HTML page displaying the query: Vacancies Dim MyDB As Database, MySet As Recordset Dim MyFileName As String, MyCurrentGroup As Stringe ' declare variables for running totals of numeric fields Dim Var As Single, Bud As Single, Wkd As Single, Con As Single, Vac As Single DoCmd.Hourglass True Set MyDB = CurrentDb() Set MySet = MyDB.OpenRecordset("vacancies", dbOpenDynaset) MyFileName = "R:\vacancies.htm" Open MyFileName For Output As #1 MySet.MoveFirst MyCurrentGroup = "x" ' on each change of the field MySet!

Export an Access query as an HTML Web Page

Do Until MySet.EOF ' start of loop for each record If MyCurrentGroup <> MySet! Bud = 0 ' reset the temporary running total variables Wkd = 0 Con = 0 Vac = 0 Var = 0 End If MyCurrentGroup = MySet! End If Print #1, "<tr><td>" & MySet! Examples of Access VB Code Modules. Sub RunEmailDist() Dim MyDB As Database, MyRecs As Recordset, MyName As String Set MyDB = CurrentDb() Set MyRecs = MyDB.OpenRecordset("emaildist") MyName = InputBox("Enter your name","RunEmailDist (CiM)", "Chris Mead (Extn 3841)") MyRecs.MoveFirst Do While Not MyRecs.EOF If MyRecs!

Examples of Access VB Code Modules

Distname = Forms("F_ChooseEmail")! DistNameCombo Then DoCmd.SendObject acSendReport, "Your budget report", acFormatRTF, MyRecs! MyRecs.MoveNext Loop.

DATA Pig screen casts

Ms-office - Access 2003 Tutorials. Home MS Access Tutorials The Fundamentals In this tutorial you will learn about exactly what a database is, what it is used for, and how to perform simple database tasks, such as adding and deleting records.

Ms-office - Access 2003 Tutorials

This tutorial also takes you on a basic tour of various parts of a Microsoft Access database: Tables, Forms, Reports, and Queries. Creating and Working with a Database In this tutorial, you will learn to create and modify the major database objects: tables, forms, queries, and reports. You will even learn some basic database management tasks, such as how to delete and rename database objects and how to repair and compress a database. Finding, Filtering, and Formatting Data Microsoft Access is equipped with an arsenal of Find, Sort, and Filter commands that can track down and organize a table's information in record time.

Prompt For Saving a Record with VBA. Prompt For Saving a Record Microsoft Access automatically saves any changes we make to a record, whether we close the form or move to a new record.

Prompt For Saving a Record with VBA

I will show you a way of prompting a user to save the changes. Here is my form before I make any changes to the record. Now I add the word ‘Test’ into the ‘Last Name’ field. I then move to the next record and get the message informing me that the record has changed and do I want to save it. If I answer ‘Yes’ the changes will be saved. If I answer ‘No’ my changes will not be saved. In order to do this I added a bit of VBA code. Go into form design and bring up the form properties. Click on the top part of the form: Go up to the ‘View’ menu and select ‘Properties’: We want to look at the event properties, specifically the ‘Before Update’ event: Click the small button with the dots, the ellipsis (...), to bring up the code window: