MS Access

192K

Solutions

137

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 an Access 2010 database.  I have two forms, FormA and FormB in the database which each point to the same table.  

Scenario...  UserA is editing FormA.  UserB opens FormB, makes changes and c…

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

241 views
Executing a Windows API Function from Access

As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the W…

312 views

Please offer if there is a way for me to include a Grand Total for the column field in a crosstab quert - Access 2013.

I am able to calculate totals (based on counts) for rows, but not columns.

7

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…

805 views
Using a Criteria Form with an Access Report

Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way t…

372 views

I have the tab order set on form fields, but I have about 100 records that need to be completed, starting at halfway into the form. Instead of mouse clicking each time, how can I create a shortcut key…

1

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 …

21,207 views

Hi,

I'm selling childrenbooks to a few primary schools and wanted some help in managing my inventory.

I've setup a spreadsheet and EE have helped in making some improvements but I'm struggling w…

1638 views

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…

31,034 views

Thank you for looking at my question,

I am trying to run a report in MS Access that was originally falling over with the error message in the title - "multi-level group by clause is not allowed in …

2

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 …

963 views

Hi EE

How do I get the on click event to work on a TAB Form. As a test I entered msgbox("Something"). but when I click the tab I don't get the message. Looking at some E.E questions & answers, "On …

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

1580 views

hi
i would like to see "within specific folder & its sub folders" all excell files names and their sheets names
is it possible ?

4

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…

31,236 views

hi
referring to this question
http://www.experts-exchange.com/questions/28709664/how-to-search-from-windows-7-an-excell-sheet.html#a40953052
i have too many excell sheets , and really fail to find …

1014 views

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

660 views

Has anyone seen this error before. See attached error screenshot. It occurred after installing windows updates and I can't reinstall.

Thanks

311 views

I am using a query to insert record from a combination of two tables into a third table.

One of the fields in the query is 'Comment' which is defined as 'Memo' in the table it is being pulled from …

31 views

I have a 2007 DB that I'm moving into the 2013 environment and some of the old command codes don't work.

I have a form named "Course". I would like to combine two events into one expression that 1)…

517 views

I have a table with boolean fields

[ItemID] as  text
[Qty] as number
[InStock] as boolean
[Call_Back] as boolean

How do I build a query to show how many times the Item is in stock and not in…

412 views

Hi,  in MS Excel I have 10,000 rows of data in 35 columns in Worksheet A, the unique identifier for each row is contained in Column C called the SaleID which is alphanumeric (sometimes an Integer or s…

934 views

Please offer why when I specify in a query to sort on one or more fields, the sorting does not happen in the output table?

I set the sorting specifications in query design.

Thank you.

610 views

After performing various operations, my access database has many duplicate tables.
such as
InformationTable
Information Table1
Information Table2
Information Table3

I am looking for VBA code …

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (45,486)
  2. Visual Basic Classic
    (162,160)
  3. MS Applications
    (43,686)
  4. Databases
    (52,093)
  5. MS Excel
    (123,137)
  6. MS Office
    (55,120)
  7. MS Development
    (48,486)
  8. MS SQL Server
    (152,759)
  9. VB Script
    (34,882)
  10. MS SQL Server 2005
    (71,300)