Microsoft Access

216K

Solutions

171

Articles & Videos

46K

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. Microsoft Excel
  5. Databases
  6. Microsoft Office
  7. Microsoft SQL Server
  8. Microsoft Development
  9. VB Script
  10. VBA
Refine results

Hi Experts,
I have created a sub-form that uses a combo box to select records based on a query that returns only those records that are active (by using a yes/no field).  There are text boxes in the …

113 views
Free Tool: SSL Checker
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have an MS Access application that allows me to open/select files and or folders.  This has always worked well, but I could now do with something with a bit more security.  One of the things I'd …

59 views

Hello Experts,
In my project, I have to configure our web application to use HTTPS  in IIS settings for serving client requests.
In the process, I created a root ca certificate from my CA server of …

521 views

I have 2 tables.

SKUs
SkuRestrictions


Skus are products and SkuRestrictions are restrictions on a product.
A Sku can have multiple Sku Restrictions.

I need my query to remove the records …

1317 views

I had this question after viewing ms/link form - subform field not recognised (https://www.experts-exchange.com/questions/29017877/ms-link-form-subform-field-not-recognised.html).

On continuation …

39 views

On my MS/ACCESS app I have a form that contains a master field, named [fld_marcacaoSelecionada]. On open the field is correctly computed and show a proper value.

The I have a subform, based on a …

39 views

In my query under the ID (Autonumber) I have placed <>3 Or 4 Or 5 Or 13 Or 16 Or 18

I have tried down the "or" column under the field also.

But it is not working! It still returns most of them.…

419 views

I have a report and part of the report looks like:



Using the first column as an example, I'm trying to figure out how to DCount the records that are >110%, between 106 and 109.9, between 101 …

112 views

In the code below how would I say for each record in rst2  Field ImageURL  
I have tried rst2("ImageURL") Access Error 3251 Operation is not supported for this type of object.
Thanks!
(CODE)

315 views

I have 2 loops. The "For Each Loop " is nested in the "Do While Not Loop".

(CODE)


I am needing there to be a Criteria for the "For Each Loop"  such as
rst1("SkuID").value = …

813 views
Free Tool: Site Down Detector
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

We have a very simple append query that updates our inventory table with
the most current information.  Every year when we do a physical count I append
the records. The inventory table has about …

414 views

Where would I check to see why, after I sorted newest to oldest, the quote #s wouldn't be 1163, 1162, 1161 (all written on same day)?
It is in the correct order in the subreport, but not in the …

1317 views

how do I get and set a file attributes in ms/access - vba?

59 views

I developing my first access application with a SQL Server back end. I've not used SQL before and I'm exploring the functionalities that come with the SQL backend.  With help from EE I developed a VBA…

824 views

Sorry for the Title Gore.

I have a cell where users enter qualification codes.  Sometimes it's a single code, but sometimes it's multiple codes separated with a comma.

I have a table with …

77 views

I am a NUB to SQL Server, developing an Access 2013 back end DB in SQL 14.0 Developer.

I see that it is very easy to implement compression on both tables and indexes to reduce the size of the …

537 views

First let me say I am at best an Access "Hacker" and I already know this database does not use all the correct syntax and naming conventions. Over the years, thanks to you folks, I have gotten better,…

618 views

Jim Dettman provided a potential solution here: -
https://www.experts-exchange.com/questions/28583375/Why-is-it-showing-Deleted-in-all-fields-and-records-in-my-Access-2010-linked-table.html#a40506986…

2035 views

I'm just in the process of deploying my Access database for testing and I noticed a very strange issue on my user permissions table.  It seemed to be causing me all sorts of strange problems when used…

923 views
Ransomware: The New Cyber Threat & How to Stop It
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

I've been asked to push some data to an external web service using Access 2010. After researching this all day, it looks like many suggestions point to using Visual Studio to create a dll that …

1919 views

I have a Query called "Qry_EbayAddFixedPriceItem1" in that query it has 4 records. With the loop code I am using it appends the exact same values from record 1 only....But it does it 4 times.

I …

1019 views

I have a form in which I'm trying to save data to a table.  I have similar code that I  used for another form in the same database which saves to a different table that works perfectly, but this code …

616 views

I'm having a bit of a weird issue with Access that I have a question currently open for.  However, on a possibly related note, I would like to know what the above query prefixes are and can I …

314 views

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where

0168 views

I have a database that contains pictures (one picture per record).  I would like to create a report that displays those pictures in a grid format (3 x 3).  Is this possible?

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

Microsoft Access

216K

Solutions

171

Articles & Videos

46K

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. Microsoft Excel
  5. Databases
  6. Microsoft Office