MS Access

192K

Answers

136

Articles & Videos

10K

Experts

Microsoft Access is RAD (Rapid Application Development) with a built-in RDBMS (Relational Database Management System) produced by Microsoft. Access can be used to write both desktop and web-based applications. It is considered a RAD tool because of its ease of use, built-in features, and graphical wizards. Access uses VBA (Visual Basic for Applications) as its coding language. This area deals with all aspects of its use.

Hi Experts,

I have this:


Just checking if this is correct for the Control Source, it comes from SSMS Stored Procedure?

Thanks for any help...

5

Background
What I'm presenting in this article is the result of 2 conditions in my work area:
We have a SQL Server production environment but no development or test environment; andWe have an MS Acc…

302 views
MS Access – Different Ways to Start Up a Database

With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form t…

285 views

How do I convert the following Access crosstab query to T-SQL?
TRANSFORM Sum(qryAgingProjects03.SumOfTotal) AS SumOfSumOfTotal
SELECT qryAgingProjects03.BU5Digit, qryAgingProjects03.PSPROJ, qryAging…

175 views

Introduction:
Have you ever been given the advice NOT to use domain functions inside queries?  I have, and I have repeated that advice over and over again; why?  The main reason is that this process …

2897 views
MS Access – Writing Solid VBA Code

In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

157 views

Hello

I wont to get a Symbol Dialog like Word to select Symbols from any installed charset.

Has anyone an Idea how can i get this Dialog?

Thanx

Talki

2

Preface:
When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the st…

3692 views
MS Access – Working with Relationships

With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referen…

83 views

I keep getting an error on:

Food: IIF ([Event] In (“Orange”,“Apple Slice”,“Pineapple Slice”), “Fruit Group”)

15

Dates are popular criteria in queries.  Date ranges ("between #1/1/2015# and #1/31/2015#", for instance)  are useful when you want to see everything that happened in January of 2015.  But if you want …

632 views
MS Access – Using DLookup

In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to b…

261 views

hello, i want to assign the year in a variable when my project opens and then use that throughout the entire project.
for example:
dim dPresentYear as date = 2015
dim dPreviousYear as date = 2014

2219 views

Oh no! Did you forget to:

1. Set up QuickBooks Payroll for Job Costing?
2. Check Payroll Items to Track Expenses By Job?
3. Assign Overhead to expenses not belonging to a particular job?

Not s…

1420 views
MS Access – Repeating Sub-Report Headings on Each Page

In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:…

657 views

I have a 2010 Access front end with a SQL backend.

I have three views and a table that users can select from to view a list of records - Customers (table), ActiveCustomers (view; default), Inactive…

5

Background
If you need to edit a table with many fields, the form may be far too wide to be displayed in full on a normal screen. You will then have to limit the width of the form, leaving the user t…

3948 views
MS Access – Passing a String Value within a String Argument

In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

2121 views

Hi EE,

a) What features of A2010 do you love

b) How have you made A2010 easier to work with?
    for example:  I put the design and vba buttons in the tool bar
           yet if I go to my us…

2

This article explains how to consolidate QuickBoooks transaction types in a database so only one form or report can be used to view multiple transaction types. This article uses the tables:

     1.…

497 views
Access Desktop Databases – A Quick Tour

What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

69 views

Hi Experts

On my main form (frmMain) I have an unbound combo box (cboSelectClient) where a user can select a record and details about that client appear in a subform. On the main form I also have a…

813 views

Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013.


Background
The native message box of Microsoft Access 2013 is boring and …

2834 views
MS Access – Basics of Designing Tables

Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things …

52 views

Hi Experts,

I have an Access app linked 60% to SQL and 40% to MS Access BE.

Now I have some queries that join tables from both sources, and I am wondering which way would be better for performan…

1420 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all

  1. Query Syntax(45,302)
  2. Visual Basic Classic(161,959)
  3. MS Applications(43,528)
  4. Databases(51,855)
  5. MS Excel(122,626)
  6. MS Office(54,868)
  7. MS Development(48,436)
  8. MS SQL Server(152,347)
  9. VB Script(34,748)
  10. MS SQL Server 2005(71,218)