Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Courses   Tips   Templates   Forums   Help   Order   Contact   Logon  
Home > Forums > Access
Microsoft Access Forum

Welcome to the Microsoft Access Forum. Access is by far our most popular topic here at Computer Learning Zone. This forum is for everyone to read but only students (paid customers) can post here. If you'd like to become a student, all you have to do is enroll in one of my courses. After you create a logon, you will have full access to the Forums.

Subscribe to this forum and receive an email update whenever new posts are added. You will also be notified by email if any conversations you are involved in receieve new comments. Yes, even non-students can subscribe to update notifications.

Having problems with your Access database? Before posting your question, check to see if it's already been answered. You can use the Search feature to look for keywords. There's also the Access Troubleshooting Checklist which covers solutions to many common problems.

Click Here to Post a comment and start a new discussion!

Link Parent Child Same Table Link 
Juan C Rivera     
Wed 8/5
I like to idea of self join...I like to kick out a report showing the isbasic group and under it Child link.
I like to use this to further try to make column and add expense by FY.  Any one out there with an Idea of how to do this?  V/r Read More...
Add a Reply
Access 2016 Calendar Link 
Thomas Corbett    
Tue 8/4
Hi, I am able to create a calendar in access 2016 using the active x controls and I have assigned it to a table / field but is it possible to display another field displaying text (from a field in the same table) in the calendar view?
Richard Rost
Tue 8/4
Are you using the Calendar Control ActiveX object? If so, not really. It's very limited. This is why I created my Calendar Control Replacement and the DateTime Picker. You can do whatever you want with those because they're just forms built in Access.
Add a Reply
Error Handling in Macros Link 
Shelagh Fagan     
Tue 8/4
I have an Append To history macro that I needed to have controls to stop the user running it twice. I used a composite index key set to "unique". Works great. But when you try to rerun I get a long error message part of which says " unable to append... due to key violations'. To make it user friendly I added an OnError, GoTo Error Message at the top of the macro, bypassing the rest of the macro. It never works. It doesn't do the append correctly but it runs the rest of the macro without my error message. I've tried adding [MacroError].[Description]. No luck. Why doesn't the OnError detect the key violation? I bet Rick has a video on this?
Richard Rost
Tue 8/4
Honestly, I really don't like error handling in macros. It's clunky and I've had problems with getting it to work myself in the past. I would try to talk you into rewriting your macro as VBA code and using proper error handling in that. I just covered how to do this in Developer 15, Lesson 2. You can always open the macro up in Design View and then go to Design > Convert to Visual Basic if you don't want to rewrite it yourself.
Add a Reply
Concatenate Link 
Carlos Espinosa     
Tue 8/4
VendorProductT field StyleNumber (text) has values such as VB127GWH2X0025NF.

Will rename the field to Style: but want to bring only VB127-2X.

How can we pick and choose certain characters within a field? Read More...
Richard Rost
Tue 8/4
You'll need concatenation but you'll also need LEFT and MID. In your case:

NewField: Left(S,5) & "-" & Mid(S,9,2)

Where S is your StyleNumber, of course.
Carlos Espinosa    
Tue 8/4
Thank you Richard.
Add a Reply
Power Automate Link 
Sabina Compassi 
Mon 8/3
What is the use of Powerautomate, how can it be made useful with Access/Sharepoint?

Richard Rost
Mon 8/3
Hi Sabina. Power Automate is a tool from Microsoft to help automate tasks. I have played with a few of these services myself like Zapier and IFTTT.

I don't see any direct "Flows" for Access, but there are a bunch of them on there for Excel Online, SharePoint, and SQL Server. It's great for data collection. For example, there's:

- Save tweets to an Excel Online spreadsheet
- Track Microsoft Forms responses in Excel and notify thru Email
- Copy SharePoint list items to Excel and Email

You can make up your own custom flows too. So let's say someone adds a record to your SharePoint list, you could have it send an Email. And since you can connect Access to SharePoint, it's a handy thing to have.
Add a Reply

Show Older Comments...
View in Table Format

Post a New Comment or Question
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

8/6/2020Access Sync Up Remote Database
8/6/2020Access Customer Codes
8/5/2020Access Custom Sequential Number
8/4/2020Access Restore Deleted AutoNumber
8/1/2020Access Custom Sort Order
7/30/2020Access SharePoint Seminar
7/29/2020Microsoft Access Developer 16
7/29/2020Is There a Free Version of Access?
7/28/2020Access Disallow Editing Data
7/25/2020Access NZ Function NULL to Zero

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: microsoft access forum  PermaLink