MS Access

194K

Solutions

144

Articles & Videos

10K

Experts

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Refine results

I have a form that displays Contacts, and I want the user to be able to select whatever Department(s) the contact works in.  On the Contact form, I have a listbox that lists all Departments available …

6950 views
VBA

Concurrent updates will fail - at least partly
This happens when two (or more) processes tries to update the same record:
 
The first starts editingThe second starts editingOne of them saves the ed…

1271 views
Excel Error Handling Part 3 -- Run and Fix Bugs

This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel.

Part 1 of this series discussed basic error handling code using VBA.
http://www.exp…

067 views

trying to extract just 3 values from an xml file (attached)

-<summaryPage>

<otherIncludedManagersCount>0</otherIncludedManagersCount>*

<tableEntryTotal>98</tableEntryTotal>*

<tableValueTotal>25286…

1122 views
VBA

To enter a date is tricky
The Date Picker is a safe method to always ensure valid dates to be entered without noisy error messages disturbing the user. However, for many scenarios like accounting and…

9443 views
Excel Error Handling Part 1 -- Basic Concepts

This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, t…

369 views

Hi,

Using Access & Outlook 2013.  What I am trying to do is send a task to an exchange shared folder called P/O Tasks under the user admin1.  I can get it to send to my default Tasks folder but that'…

817 views

Citrix is inflexible
This is notorious and for a reason. The environment provides tight security, so no steps altering it will be allowed except for a very good reason - and deploying your Access app…

1385 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…

0479 views

I already have an application that can log into an OWA mailbox, and process all of the inbox items according to rules we have set up. Unfortunately, this application does not allow me to move the proc…

720 views

To enter time is difficult
Entering time in a form in Microsoft Access can be difficult. There is no time picker like the date picker, and if there was, it would be too slow to operate for many users…

2341 views
MS Access – Writing Solid VBA Code

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

0229 views

I have all my files in the cloud of SharePoint Online. I need access to these files, with VBA, to open them from the desktop. How can I browse to these files in the cloud?

730 views

I've been an Access developer since Access 2.0, and having to manually widen my query columns has always annoyed me. This article traces the development of a Sub that saves a lot of clicking and dragg…

1263 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…

0112 views

Hello,
I have a search button that is built based on filtering a form but I want to
modify that to turn the filter on for the unbound box first.  So I am trying
to add:
Me.SearchResults.filter = strWh…

724 views

Rounding should be right at hand

In many areas, rounding that accurately follows specific rules are needed - accounting, statistics, insurance, etc.

Unfortunately, the native functions of VBA th…

2699 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…

0360 views

Hello - title of question pretty much says it all - I need to test a string value to see if it is a field name in a table, using VBA (Access 2003).

Thanks

620 views
VBA

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…

01,934 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:…

01,079 views

I have a form that will allow the user to set some conditions and store those conditions so that a dynamic query can be made that reflects the selections.

I have 12 fields which are represented with …

1418 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 …

31,828 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.

2167 views

I've used Access for many years and want to develop a simple web database (my 1st). It may have dozens of users, each with their own set of data.
1. Is it possible to implement it with Access 2010 wit…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (46,103)
  2. Visual Basic Classic
    (162,824)
  3. MS Applications
    (44,164)
  4. Databases-Other
    (53,010)
  5. MS Excel
    (125,162)
  6. MS Office
    (55,930)
  7. MS SQL Server
    (154,713)
  8. MS Development-Other
    (48,696)
  9. VB Script
    (35,493)
  10. MS SQL Server 2005
    (71,596)