Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Courses   Seminars   Templates   Help   TechHelp   Forums   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. If neither of those things help, make sure you post exactly what you're doing, what the specific error message is, what you've tried, and any other details we might need to help you. Don't just say, "I get an error." Tell us what the error is and what you're doing. We're not mind readers. I wish. LOL

Click Here to Post a comment and start a new discussion

 

Get Value From Report Link 
Christina Terrazas 
2 hours ago
Hi Rick,
Can you remind me which lesson talks about displaying a value from a report onto a form in Access?

Thank you,

Christina
Richard Rost
2 hours ago
I'm not sure I've covered this in any of my classes because it's not something you'd normally do. Just like you can get a value from an open form like this:

Forms!CustomerF!CustomerID

You can also get a value from an open report like this:

Reports!InvoiceR!InvoiceID

It's unreliable, however, if you've got a report with more than one record displayed.

Access Expert 2 covers the Form part.
Add a Reply
Auto Add Products Link 
Eugenia Bettis 
3 hours ago
I do have a small question. I need to from my product list. Load three things at once is that possible from using Product combo. Example when I pick canoe from list I need to load paddles and cushions. I tried the tutorial method but not about to setup right. So do I keep trying that method or is there a better way. Read More...
Richard Rost
3 hours ago
So, you're saying when one product is added to the order, you want the system to add other dependent products automatically? This could certainly be done. In fact, I had something like this on my outline for the Developer classes already.

Product Grouping. This would allow you to create a Group, in your case "Canoe Package" and when you pick that it would add all of the items in the group to the order. I used to have packages for PCs, so I'd pick "Alpha PC Package" and it would load this hard drive, this motherboard, etc. And then you can opt to use the Parent's Group Price (for a discounted bundle) or use individual pricing for the line items.

Hang in there. It's coming up soon. Probably in D25 next week.
Add a Reply
Charting Timestamps Link 
Austin Ritner 
23 hours ago
For my dispatching database, I need to see how many calls took longer than a certain amount of time to arrive on scene once they were enroute. Example: Response time should be no longer than 7 minutes. Read More...
Alex Hedley
23 hours ago
You could create an extra calculated column that works out the difference between the two times, then add conditional formatting to show if it's greater than or less than 7
Austin Ritner
23 hours ago
A-ha! Made a query from a query (which still confuses me slightly haha) and made that new field ResponseTime: EnrScene criteria being "00:07:00" and it worked!
Add a Reply
Push a Form to Others Link 
Betti Schuler 
29 hours ago
I am creating a way for our Senior Executives to enter data to the database I have created. I have been through the Forms lessons on Access quite awhile ago. I'm going to go back through them again so I can create a great form, but I also don't want to waste time (as I have a deadline to meet). My question is: Is it possible to push this form to the end users (Senior Executives) when they DON'T have MS Access? I've tried searching this concept on the Internet - but cannot find a clear answer. If it's possible - is it covered in the MS Access Forms lessons (beginning or advanced?) Thank you for any help & direction!
Richard Rost
28 hours ago
Unfortunately, Access doesn't work that way. If you want them to be able to work with your database directly, they need to have Access installed. You can get away with just the free Runtime edition if they don't need to be able to edit the database structure, which is usually the case.

If you want them to work with your data without installing Access, then you'd have to use a web-based solution, or something like SharePoint.
Betti Schuler
28 hours ago
Hi Richard. Thank you so much for your response. You are correct in that they do not need to be able to edit the database structure. But trying to get our IT department to allow any additional apps or software (which I guessing is what would be the case for Runtime) is next to impossible Another question if you have a moment...my company does have SharePoint. Could you give me a starting point of what to look at? Does SharePoint have a forms component? If so, how does that interface with Access? Thanks again. I have so many questions - but am willing to do the research/work on my own, just need a little direction
Add a Reply
Getting runtime error 3141 Link 
Sharon Esdaille 
29 hours ago
It is probably something simple I'm overlooking but I can't seem to figure it out. Can you help?

If Me.proCategoryType = 1 Then
        strSQL = "SELECT [Projecttbl].[ProjectNUM] AS ProjectNUM & ([Projecttbl].[ProjectNUM], 500)+1 AS MaxOfProjectNUM " & _ Read More...
Alex Hedley
28 hours ago
Try a , instead of an &
AS ProjectNUM &
=>
AS ProjectNUM,
Add a Reply
Product Planner Database Link 
Graham Hendricks 
35 hours ago
Thanks for Dev24.Can you consider a product planner database in your next Dev25?
Richard Rost
24 hours ago
I need more details. What would you like to see in a "product planner" database?
Add a Reply
Order Cost Link 
Michelle Seidelin 
2 days ago
Hello Richard

Wondering if you can suggest where I could find a way of working out my costs on the job the only solution so far I have come up with is make a duplicate of order T and or day detailed T and associated forms but that seems a long way around it I noticed you do teach something in an old class called 313 which looks like it is VBA coding you talk about how to hide it on the invoice wondering if you are going to cover something like that somewhere but without VBA coding or even with VBA coding when in the developer series Read More...
Richard Rost
25 hours ago
If you mean that you want to calculate your cost vs. what the retail sale price on the order is, then yes, that's relatively easy to do. Just add UnitCost to each line item in addition to UnitPrice which is what you sell it for. This is covered in Access Expert 8.
Add a Reply
SendKeys Is Evil Link 
Nancy Troutman 
2 days ago
What is wrong with my code?   I need the scroll lock be pressed so that an Autohotkey script gives me quick access to Unicode characters.

Instead of turning on the Scroll Lock key, it toggles the Scroll Lock key.  So "SendKeys "{scrolllock}", True" will toggle the Scroll Lock off it is already on. Read More...
Richard Rost
2 days ago
It's funny that you mention SendKeys. I just spent about 10 minutes in Access Developer 24 telling everyone how SendKeys is evil and you should never use it. I used it, too, when I first started using Access back in 1994. No. It's evil. Don't use it.
Nancy Troutman
33 hours ago
Arggghhhhh!   I want the 3 days I spent trying to make it work back!
Add a Reply
Worth Switching to Access? Link 
Richard Rost 
2 days ago
I just wanted to share this email I received today, as well as my response:

"I like your training videos, but first need to know if Access right for me. Present state: using Excel to record all weekly shipment details to customers. Each shipping week is separated by weekly tabs. Typical # of rows per week is 50 depending upon the mode of shipment. Is there a benefit of spending the time and expense developing a Access database?" Read More...
Add a Reply
Input Mask Position Link 
Michelle Seidelin 
2 days ago
Hello Richard

I have just been thinking is there a way of making the input mask put in the first two digits as a default I went and put in 03 in the default part of the field but it came up three digits in not at the start Read More...
Richard Rost
25 hours ago
I don't think this is possible with just the simple input mask setting. It will probably require some coding.
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.
 
Subscribe
 

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

1/27/2021Suppress Warnings
1/27/2021Action Queries
1/26/2021Caps Lock On Off
1/26/2021Set Caps Lock State
1/26/2021Get Key State - Free
1/26/2021Using Recordsets
1/25/2021Access Developer 25
1/25/2021Access Developer 25 Lessons
1/25/2021Access Developer 25
1/25/2021Access Developer 24
 
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search The Site
Waiting List
Production Schedule
Code Vault
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
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