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

Hello,

I am creating a form to fill in information for a table that creates an invoice report. In the subform there are job numbers, tasks, descriptions, and amounts. In the main part of the form …

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

I have  a table
let say that the fields are:
Rec#
StartDate
Status and so...
i need to calculate the number of days between StartDate and today
in excel i will use NETWORKDAYS(Date1,now(), list…

913 views

I am trying to import emails from a folder in Outlook to Access.  The problem I am having is that some of the Mailobject items won't work.

These two will work.
rst("Subject") = Mailobject.Subject …

816 views

I have a table with SellPrice and Cost. I need to find out the percentile difference (Profit) between the two and display it as percent. So, if SellPrice was 100.00 and Cost was 50.00, the Profit …

1811 views

I have an Access 2016 database that I've written on a Windows 7 with Access 2016 and am able to register the MSCAL.OCX in the SysWow64 folder. The Date Select works fine on the work computer. However,…

412 views

Is it possible to alter the date picker in access so users can only select a Monday date?

35 views

We have an issue where some records entered on the form have the same exact information except for the bottom two fields that are different (Defect quantity and defect doe). Basically I am looking for…

312 views

A recent development happened many times to me on Saturday to today.  We have a access query that I send to a csv file in an export.  The query has about 15000 records.   I have run this procedure …

410 views

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

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 …

917 views
Ransomware-A Revenue Bonanza for Service Providers
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

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…

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

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

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

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

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

310 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

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.

318 views
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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)

320 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 *…

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

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

4332 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