Microsoft Access

216K

Solutions

173

Articles & Videos

51K

Contributors

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.

Related Topics

  1. Query Syntax
  2. Visual Basic Classic
  3. Microsoft Applications
  4. Databases
  5. Microsoft Excel
  6. Microsoft Office
  7. Microsoft SQL Server
  8. Microsoft Development
  9. VBA
  10. VB Script
Refine results

In previous versions of Access i.e. 2003 and earlier, I was able to set via VBA the screen size for each of my forms without using a popup. In 2016 I am not able to apply the screen size vba. Now all …

36 views
Announcing the Most Valuable Experts of 2016
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

I have a procedure that needs to check a control field in a subform (subfrm_Orders). The field is a Boolean yes/no in the subform for the field Select_Order.

Currently I am using:
    Dim …

916 views

I am upgrading an Access 2003 application to Access 2013.  Most of it's going very smoothly, the exception being the export options in the shortcut menu that displays when a report is previewed on the…

1538 views

Hi Experts,

I was assigned to set up passwords to our users in a way that

1- Each user/department has their own password.
2- It should auto get changed every 3 months.

I was thinking of the …

1339 views

I have a table with 2 fields - Charge and Order. There may be multiple dupes of Order, but I want to keep them all unless Charge is the same. So, if order 12345 is in the table twice and the Charge …

1718 views

I have a form where the user selects combo boxes and presses a button.  I would like to code the button so that it takes what's been selected in the combo boxes and uses that to append a row in an …

49 views

Scenario: An MS Access 2013 database that is a compilation table of research studies from other sources primarily Excel. In the database we have some scientific response data and we have some fields …

527 views

Monthly, I do a mail merge from an existing Access database to create and print envelopes.  This month, it suddenly did not work.  I'd select Mailings... Select Recipients... Use an Existing List... …

1323 views

I am working on an Access 2013 application.  I have routines to generate an RTF or PDF file from the report in preview at the time.

(CODE)

The user has requested that the application also opens …

38 views

Using Access 2010.
The following query displays several records with NULL 'detQuan' values in BOTH Period1 and Period2.
I'm looking for a way to display only records with NON-NULL 'detQuan' values …

622 views
Online Training Solution
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Hi, may I know is there a way to find the average by using Access Query?

Example:
Date1 = 1 May 2017
Date2 = 31 May 2017

Query to find average, result should be something like 15 May 2017
Tq.

316 views

I have a tabbed form in access. Right now if someone begins to enter data then realizes they are on the wrong form for example they will click the correct form tab but the data will get added into the…

517 views

Hello,

Can I reference a table by the ID and use column 2

BgRg1 = [tblVGBadgeNumRange].[ID](1).[column](2)
BgRg2 = [tblVGBadgeNumRange].[ID](2).[column](2)

319 views

Hello all:

I have a form (frmUnions) that has a combobox control cboUnion and subform on it (subfrmUnions).  When frmUnions load, cboUnion is blank and subfrmUnions recordsource is set to 'SELECT *…

414 views

I understand the concept of Late Binding but have never actually done it.  I want to revise this routine in my MS Access front end to late binding so it doesn't require a specific version of Excel.

622 views

I have two forms that a embedded in a main form detail section.
Sub Form 1 has budget rows.  Usually just one row can be a many as three
Sub Form 2 has transaction.  Many rows

The issue I am have…

526 views

Hello All;
(SQL Server, is what it will run on, for the production environment.
Access Database is what it will run in, for demonstration)

This is the code.
The query is sent through Jquery, to …

4330 views

The job of the query would be to take a table, like the one on the left, and convert it into a table like the one on the right:

429 views

Hi Experts,

I have a Query and need the criteria to select a specific record or all records.

The data in the field is:
- BUR-2*
- BUR-20

The query criteria is contained in a field called …

2354 views
Online Training Solution
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Dear Expert,

I have an excel file , this excel file contains so many worksheets, I have used successfully and thankfully the -below mentioned- code published in …

1748 views

My OS is win 10 pro 64 bit.  I have Office 365 Business Essentials, and I use Access 2016.  I have a application where I have a Form for data entry.  
When the Form is opened, there is a command …

433 views

Hello,

How can I view the count from the code below?

??  msgbox "My Count is " & mycount

(CODE)

327 views

Is it possible to have multiple tables for use on a tabbed form?  I want each tab to have a separate table as it's record source.  Each table would have a common number key field for …

227 views

I have a form with a text field and a command button.  The text field contains the path to a document on a computer.  For example: C:\Users\Steve\Documents\CompanyName\123456.005.pdf

Then the user …

324 views

I would like to create a ticket description field on MS Access, which grab a data from other fields and create a ticket description Automatically.
1. field - PC or Wyse
2. field - Location
3. field…

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

Microsoft Access

216K

Solutions

173

Articles & Videos

51K

Contributors

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.

Related Topics

  1. Query Syntax
  2. Visual Basic Classic
  3. Microsoft Applications
  4. Databases
  5. Microsoft Excel
  6. Microsoft Office