Microsoft Access

221K

Solutions

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

Developing in Microsoft Access?


Then you should join NADD 2019
Netherlands Access Developer Day 2019 - 14 September

It’s a great opportunity to get up to speed with the latest Microsoft Access technology.
Get real world tips about how to get the most out of Access and VBA.
Meet and network with international fellow Access developers!

1
HTML5 and CSS3 Fundamentals
LVL 13
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Ranking rows in Microsoft Access


EE-Rank.png
To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order.
But how to rank dupes? Five methods exist, and they can all be implemented in pure SQL or using VBA.

Ranking rows in Microsoft Access
0

DJoin

DJoinAs you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcactRelated and similar functions. Further, it offers better read-out of Multi-Value fields.

My latest article:

Join (concat) values from one field from a table or query
1
Install and run a Microsoft Access application with one click

A revised article on this topic has been published:
Deploy and update a Microsoft Access application with one click
Microsoft Access on Windows 10
Deploying a Microsoft Access application in a normal Windows environment is not difficult but takes a few steps. The method and script provided here will - literally - turn the process into a one-click process for the user, even in a Citrix environment.
0

ISO 4217 Currency Codes in VBA


Currency codesShould you need to maintain a table of current currency codes, here is how: ISO 4217 Currency Codes in VBA

My article demonstrates two sources:
ISO itself (the definitive source)
Currency Converter API
0
I decided to write a DatePicker replacement for the DateTimePicker control, since Microsoft no longer support it, the various solutions I found on the internet were nowhere near satisfying.

 You'll find some more detail about it here:
https://www.experts-exchange.com/discussions/221622/Looking-for-beta-testers.html.

Feel free to comment.
0
How to re-read database for record with a key passed as an argument?

I have two forms: one a list of Products; and second, an edit page of additional Product information.  I have an event on On Dbl_Click on the List page with the following code:

DoCmd.OpenForm "Product_Edit", acNormal, , , acFormEdit, acDialog, Product_Nbr.Value

While I am able to see the Product_Nbr Argument being passed into the Product_Edit form, I'm not able to have this second form display this particular record.  It only displays the first record in the Product table.  

How to I tell Access to re-read the product table based on the Product_Nbr being passed into it?


Thanks....

Andre.
0
LVL 28

Expert Comment

by:Brian B
You have entered this as a post not a question, so most Experts will not see it. If you still need assistance you may want to repost this using the "ask a question" button.
0

Author Comment

by:Andre Fischer
Thank you for your assistance.  I was able to get it to work by specifying the Filter as:

WhereCondition:="Products.[Product-Nbr] = " & Me.Product_Nbr.Value,


Andre.
0
1
LVL 62

Expert Comment

by:Jim Dettman (EE MVE)
Very nice!

Jim.
0
Don't like the current themes in the newest version of Access?   Microsoft is rolling out two new ones.  For details, see:

https://products.office.com/en-US/business/office-365-roadmap?filters=access

and look under "In Development".  And if your looking for all the latest that is happening with Access, use the the red "Filters" button, select "Access", and then click apply.
0
LVL 62

Author Comment

by:Jim Dettman (EE MVE)
Munna,

  You have placed a question as a comment on a post...you need to ask this as a question please.Click the blue "Ask a question" button on the home page.

Thanks,
Jim.
0

Expert Comment

by:Munna Lal
Ohh! Sorry, Now i am going to ask this question in new thread.
0
0
Learn Ruby Fundamentals
LVL 13
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

For those of you wondering what might be up and coming in Office, one way to stay on top of that is the office 365 road map page:  https://products.office.com/en-us/business/office-365-roadmap?filters=#abc

and checking the "In Development" section.  For those interested in Microsoft Access, you will find a new feature listed there:

"Access: New charts for modern data visualization
Introducing new charts to help you visualize data managed in Access in an appealing and modern way. Add any of the new eleven chart types, including a combo chart, to a form/report to visualize your data and make informed decisions."

Sounds like we are going to get a major new feature!   Of course, if your part of the Office Insider program, you'll be one of first to be able to check it out!
0
Microsoft has added a page to their Office Templates which provides templates for five types of Access databases (Asset Tracking, Contacts, Students, Event Management, and Task Management).  I have not had a chance to review these databases, but this is the first move we have seen in quite some time to add anything "Access" to Office marketing, and is good news.

Please download these templates and encourage others to do so.  If we generate enough traffic, maybe we will be able to get additional templates on the website.

0
0
With this "gap", Microsoft is going to have an improvement to the Controlled Folder Access functionality (luckily they accepted to change it). Look out for the next update ... Meanwhile, I foresee there will malware that will attempt the bypass (really soon...)
 http://www.securitybydefault.com/2018/01/microsoft-anti-ransomware-bypass-not.html
0
AI and machine learning humanize app development and marketing

Machine learning is being used as a marketing tool as it can access user data and gather additional insights on the users’ behavior and engagement preferences.
While artificial intelligence (AI) has been around for a while, scientists have recently made massive breakthroughs in the field of machine learning, a subfield of AI, as noted by NPR.


https://goo.gl/w4K83B
0
Adding awesome vector clipart to LibreOffice

I was recently poking around with LibreOffice and figured out how easy it is to add great vector clip art to ones LibreOffice gallery collection.  My experience with both LibreOffice and the site that provides so many awesome clip art images in vector and many other formats was so pleasant, I figured I would post this tutorial to give then both some love.

Step one in the tutorial is where we download the vector images we want to add to our gallery. This is where flaticon.com comes in.  They have over six hundred thousand icons - all of which you can download in multiple image formats including .png, .svg, .eps and .psd.  Many of the icons are available with their free account but you can get full access to a richer set of icons with their premium plans. Plans range from about $7.50 to $9.99 per month at the time of this writing. If you like their work, consider getting one of their premium plans.  

Gallery1.PNG  Gallery2.PNG











Once you are on flaticon.com, if you are a free user look for one of the icon packs with the [S] in the top left corner - this means the pack is available for free. Icon packs are saved as zip files by default, so you will need to unzip the folder to a familiar location on you hard drive such as Photos folder if you are using Windows - as I am in this tutorial.

With the folder unzipped, you are now ready to fire up LibreOffice. I am using LibreOffice Version: 5.3.4.2 (x64).



Gallery3.PNG
0
We have a List where data is fed through  a form i.e (+ New), I would like to restrict it in a way that majority of the Sharepoint users can only view the List and not be able to access the options in the red box. Only assigned users can have access to the red box.RFLForm.jpg
0
LVL 23

Expert Comment

by:Ferruccio Accalai
Is this meant as a question? If so open a question instead of a post
0

Author Comment

by:RFLafferty
Thank you
0
Exploring SQL Server 2016: Fundamentals
LVL 13
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

I have an access form, "frmCompetition" with a subform, "sfrmDogBrace." This is a database for field trials for bird dogs.   I would like to filter the contents of the subform based on selections I make in 3 separate comboboxes in the main form.  Any advice?  I've tried makeing the underlying query of the subform reference the contents of the 3 comboboxes as criteria.  No luck. Is there some vba code I could use?  My comboboxes are cboyear, cboday, and cbo brace.
0
LVL 62

Expert Comment

by:Jim Dettman (EE MVE)
Use the blue "Ask a Question" button in the page header.

Posts are for sharing news items.

Jim.
0
LVL 62

Expert Comment

by:Jim Dettman (EE MVE)
or something that you did and want to share, without writing an article or doing a video (think blog type stuff).

Jim.
0
0
In exchange 2007, wondering if anyone knows how to limit the view of specific public fodders to certain people or security groups.

I know how to limit access (ie author, contributor, editor, etc) but a client has asked that only certain people be able to see certain public folders to reduce the overall amount of viewable public folders (to reduce "clutter" if you will) for everyone viewing the public folder structure. ....
0
LVL 28

Administrative Comment

by:Andrew Leniart
Hi classanets,

What you've done here is made a "Post".  The Post function is designed to share information with the Experts Exchange community.

You'll get much better results if you use the Ask a Question button.

It's the big blue button at the top of your browser screen. See below...

Ask a Question

Hope that's helpful.

Andrew
EE TA
1
This is a copy of part of the article located here:
http://www.tomshardware.com/news/how-to-fight-fcc-net-neutrality,36017.html

net neutrality
vote takes place 12/14/17:


Even so, it is the work of but a moment, so we all may as well do it. Go to www.fcc.gov/ecfs/filings/express, and under Proceeding, enter 17-108 (the dystopian-named “Restoring Internet Freedom” order). Fill in the form very, very, very carefully, ensure you get an email confirmation, and submit.

Your voice will be louder, as it were, with a phone call. Call the FCC and leave a message letting the agency know that you want to keep net neutrality as it is. Dial 1-888-225-5322, and be polite, patient, and persistent. You want Option 1, Option 4, Option 2, Option 0. Enter a complaint on proceeding 17-108.

Here’s a sample script: “Hi, my name is ___, and I live in [city], [state]. I’m registering a complaint about the proposed repeal of net neutrality, because it will hurt American consumers, reduce internet access, and restrict the open flow of information. I strongly oppose the undoing of net neutrality, which is at the core of proceeding 17-108. Thank you.”

Then call your members of Congress. The FCC commission is appointed and makes these decisions, but Congress can pressure the agency to do the right thing, and it can also put forward legislation to make net neutrality law instead of just policy. Find your congresscritter at https://contactingcongress.org/, and call the local office …
1
I need assistance here, I have many tables in Access (about 9), which I want to export just by clicking a tab to a single excel sheet. I have tried some code and it did not work, I will appreciate if I can be assisted....
0
LVL 40

Expert Comment

by:Rob Henson
Alabi, you have raised a post here. You will get better response from Experts if you raise this as a question. Use the big blue button at the top of the screen or this link:

https://www.experts-exchange.com/askQuestion.jsp
1

Author Comment

by:ALABI ADEWALE
Thanks Mr. Rob Henson, I appreciate. I already post there, expecting replies
0
EQIFAX DATA BREACH.

The Equifax data breach is one of the deadliest cyberattacks in the modern times not only in terms of affected people but also due to the intensity of accessed personal data. Equifax reported that between mid-May and June 2017, their system was hacked and the personal information of 173 million customers was exposed. Below we highlight some incites about this breach and then take a look at exactly how this was accomplished at the bottom.

Accessed information

According to Equifax, the hackers were able to access customer’s names, Social Security Number, customer’s date of birth, card numbers, addresses and driver’s license numbers.

Why this breach is one of the deadliest attacks

The Yahoo data breach in 2016 had 1 billion customers affected where only the passwords and phone numbers were accessed. But in the case of Equifax, sensitive data was accessed which means that:

Criminals can use the Social Security number to other credit accounts using a customer’s names.
Hackers can also maneuver their way and shop online using the credit card details obtained.
The hackers can sell the data to other criminals which makes the effect very grave.
An accessed customer’s data is not immune to future’s fraud, extortion and blackmail. The accessed information can haunt a customer forever.
How to find out if your information was exposed

Equifax has established a “Potential Impact” tab on its website (www.equifaxsecurity2017.com) that helps …
0
LVL 9

Expert Comment

by:Sean Plemons Kelly, CISSP
This was literally copied and pasted from hackingloops.

Let's go to a "Security" site from a company that hid the fact that they had a massive data breach that affected (more or less) everyone with a credit score in the US. Let's plug in our SSN anyway (fun fact, it doesn't matter if you are on a secure system or using encryption if the destination isn't secure).
0

Microsoft Access

221K

Solutions

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.