Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Microsoft Access

217K

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

Hello everyone out there in Experts Exchange World!  My name is Terri and I am new to this site.  The reason I decided to become a member is hopefully be able to learn from all of YOU EXPERTS!  I have decided to learn Microsoft Access and learn how to build databases.... I am not new with it by all means but absolutely NO EXPERT... In fact I would say I am just a step above the beginner..... so I am praying one of you out there in Expert Exchange land will soon become my best buddy in education.... lol
7
 
LVL 66

Expert Comment

by:Jim Horn
C'mon in, the water's fine, and we have some serious Microsoft Access rock stars that hang out in the Access zone and can answer questions.  

For a humorous tutorial on how to help them help you, much of it learned in the Access zone, check out Top 10 Ways to Ask Better Questions.

Thanks for joining.
Jim
1
 

Author Comment

by:Terri Anderson
Thank You for the warm welcome!
0
Use Case: Protecting a Hybrid Cloud Infrastructure
LVL 4
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Last chance! Today is the final day to enroll in August’s CompTIA IT Fundamentals course. Premium Members, Qualified Experts, and Team Accounts unlock 30 days of free access. Enroll today!



3
Having a problem in Microsoft Access?    Make this your first stop (after applying all patches first of course!):

https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Access-54962069-14f4-4474-823a-ff7e5974a570?ui=en-US&rs=en-US&ad=US

and see if it's a known issue.   The Access team will be trying to be very diligent in posting all known problems.
3
hello guys, i am trying to parse a array result rest that i got from kraken
i would like to know how can i access a key on the array that was returned by thir api, bellow is the response from the api.
Array
(
    => Array
        (
        )

    [result] => Array
        (
            [descr] => Array
                (
                    [order] => sell 1.12300000 XBTUSD @ limit 120.00000
                )

            [txid] => Array
                (
                    [0] => OAVY7T-MV5VK-KHDF5X
                )

        )

)
i would like to extract the txid from the result set i tried this away but did not work
echo array['result']['txid'];

can some one help me out here ?
thanks in advance.
Rafael
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi Rafael,

Welcome to Experts Exchange.

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange...
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
cannot open log for source msExchange setup you may not have write access Error when trying to uninstall Exchange 2007 SP1
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi Khaled,

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange...
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
Some news from the Microsoft Access world - lots happening!

New data connectors are rolling out:
Link to or import data from Dynamics 365: https://support.office.com/article/636079c1-9fc3-4fca-8410-6596d62223da
Link to or import data from Salesforce: https://support.office.com/article/7375ffb6-1d6a-46f1-bb0c-c6ac3c58f5a0

as well as New Accessibility features:
https://techcommunity.microsoft.com/t5/Access-Blog/Accessibility-Updates-in-Access/ba-p/75244

and new are Access case studies.   Here is the first:
https://techcommunity.microsoft.com/t5/Access-Blog/Customer-Story-quot-A-future-for-children-quot-ZUKI/ba-p/85336

Keep these links handy for info on new features and announcements:

What's new page:
https://support.office.com/en-us/article/What-s-new-in-Access-2016-76454345-f85d-47af-ace1-98a456cb3496

Access Team Blog:
https://techcommunity.microsoft.com/t5/Access-Blog/bg-p/AccessBlog

as they list new and updated features in Access as they are announced.
3
How do you make 0 a default in query
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi George,

Welcome to Experts Exchange.

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
Filtering records to the Last Financial Year to Date in Access.
0
 
LVL 66

Expert Comment

by:Jim Horn
Asking questions using complete sentences would also help.  Check out Top 10 Ways to Ask Better Questions for some helpful tips on how to get answers quickly around here.
0
 
LVL 66

Expert Comment

by:Jim Horn
Also check out the SQL Server Calendar Table series on how to create your own date table to handle things like financial years.   The code is written in SQL Server but the concept still applies for Access developers.
0
Check out this email I got from Google (DUH!):


Help keep your Google Account secure

Hi Ryan,
These apps & sites that aren't from Google have permission to access your account, notmyrealemail@gmail.com. Do you still want to allow access?
Review non-Google apps & sites

Windows
Read, send, delete, and manage your email, Manage your calendars, Manage your contacts
See all

Why you’re getting this email
Apps & sites can ask for permissions to see and change things like your emails, contacts, and documents.
Learn more
0
 
LVL 63

Expert Comment

by:☠ MASQ ☠
So did you checkout that you've actually given that permission and it's still needed?
(https://support.google.com/accounts/answer/3466521)

A quick check here and no-one has "Windows" specifically listed as an OAuth authorized app.

Even if correct it's always worth checking your settings regularly :)
0
 

Author Comment

by:Ryan
Windows 10 is just set up that way as I have the only email address I use set up as my Microsoft account.  I just thought it was funny.
0
Verizon Cloud Breach As many as 6 million U.S. Verizon customers' PINs, names, addresses, and account details are at risk after one employee at Verizon did not safeguard access to customer information. Take action to protect yourself by changing your PIN immediately.
1
What does it mean to be "Always On"?
LVL 4
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Aruba wireless getting web page access blocked, Please contact administrator, category: uncategorized,
reputation: 0.

Authentication:ErrorCode       216

Your help will be truly appreciated
0
 
LVL 25

Expert Comment

by:Brian B
Try asking this as a question so the appropriate Experts will see it: https://www.experts-exchange.com/askQuestion.jsp
1
Outlook blocked access to the following potentially unsafe attachments" message in Outlook
0
 

Expert Comment

by:Wales (Waylon) Bester
Found this too recently and ISP said it was listed as spam even though I know it wasn't. Seems to happen with pdf a lot. Try add to whitelist and check if server is not maybe blacklisted
1
 
LVL 1

Expert Comment

by:Akhil Vinay Mandava
Sometimes outlook unblock the access
0
bitcoin_photo_via_shutterstock.jpg
This just in... Humans Still the Weakest Link

"The fact that access appears to have been initiated by initially compromising an employee's personal PC is a very worrying development – highlighting huge failings on so many levels, from an employee education and training standpoint, all the way to administrative and technical controls, to monitoring and enforcement." -  David Kennerley, director of threat research at Webroot.

More on TheRegister.
5
 
LVL 2

Expert Comment

by:Christopher Rourke
Good ol' PEBCAK :) Thanks for the article link.
1
 

Author Comment

by:Drew Frey
Happy to share, Christopher! There's an educational component most people could use to help combat PEBCAK :)
1
4
 
LVL 7

Expert Comment

by:Brian Matis
Nice when all the major browser makers get on-board with establishing a new standard!
1
1
Are you attending Cisco Live this month? So are we! While we'll be attending as company representatives, we're fascinated to compare our experience to those of a tech professional. Want to share your story? Contact us at ewooddell@experts-exchange.com for more information.  
5
Access Team at Microsoft starts new blog as part of the Microsoft Tech Community page:

https://techcommunity.microsoft.com/t5/Access-Blog/bg-p/AccessBlog
2
Microsoft has finally established a blog for Access at the Microsoft Tech Community driven by the Access Team itself:

Access Blog

Only one entry yet, but more should follow.
2
2
Free Backup Tool for VMware and Hyper-V
LVL 1
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

2
Picoware has announced an update to their Tree View control for Microsoft Access:

https://www.picoware.de/info/history.htm?do=return&dispatch=engine

Note: this is not in any way an endorsement of this product or an "ad"....just letting everyone know that it's out there and updated.   Since this is one of the common requests on Access User Voice, I thought it would be of interest to people.

The page does translate to English, just click "English" in the upper right after the page loads.
4
10
Bigint support for SQL in Access 2016 via O365 started to roll out last night  for the early adopter group.
1
 
LVL 58

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
I believe it started with version 1702,  build 7870.2031, but I am not 100% positive on that.

Jim.
0
 
LVL 75
That's what I have at the moment.  Forgot to update last night ...
Must be beyond that version.
0
Helen Feddema is one of our resident Microsoft Access experts.  She just published two new articles today.  If Access is something you're interested in knowing more about, then follow Helen!
https://www.experts-exchange.com/members/Helen_Feddema.html
2
IMPORTANT MICROSOFT ACCESS ANNOUNCEMENT:  Access Services (Access Web Apps) will be phased out:

https://techcommunity.microsoft.com/t5/Office-Retirement-Blog/Updating-the-Access-Services-in-SharePoint-Roadmap/ba-p/57148
4
 
LVL 9

Expert Comment

by:James Bilous
Might want to throw the MS Access topic on this to get some visibility.
1
 
LVL 58

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Excellent point<g>!

Jim.
2

Microsoft Access

217K

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.