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!

SQL to insert PDF doc into table Link 
Eric Michalek     
Today 9:04 am
Did some research and still can't figure it out.
The goal:
A form where users drag and drop in scanned (PDF documents).  So far I am using a bound object frame as it gives me the thumb nail view.  Then they click a command button that fires off an insert into SQL statement. Read More...
Richard Rost
Today 9:06 am
Honestly, I've never done this before. I did spend a few days trying to figure out ANY way to do drag-and-drop with Access just using text boxes. Couldn't do it. Access doesn't support drag-and-drop without 3rd party add-ons, and I hate those. Personally, I'm against storing objects like PDF files INSIDE your database. That makes it big and bloated (and slow). I'd recommend storing them in a server folder and putting links to them in your database. I talk about this in my Imaging Seminar.
Add a Reply
Creating customer reference number Link 
Sue Warrington   
Today 7:42 am

I have a table which stores all the information about a case study relating to specific projects i.e. one project can have many case studies.  I would like to create a unique Case study refence number (via a form) which needs to be a combination of project number and sequential number.  e.g. 14SIP091.01, 14SIP091.02; 14SIP092.01; 14SIP092.02. I've been trying to use Dmax and concatenate with the project number which doesn't work.  Has anyone else managed this and point me to some sample code.  Many thanks  Sue
Richard Rost
Today 7:45 am
I just showed how to make a custom incrementing order number in this TechHelp video. The Extended Cut Member's Edition shows how to make the invoice numbers unique for each customer, which is almost exactly what you need (projects instead of customers).
Add a Reply
select customer with combo box Link 
Fred Evans   
Today 7:42 am
Hello Richard,
I have a table of customers
I have a combo box on the heading of a form. the idea is that the combobox will display a list of the customers following my entering of the first letters of the customer name and allow me to scroll down the list to find the required name. when I click the required name the customer record must display in the body of the form. Read More...
Richard Rost
Today 7:49 am
Sorting the combo box alphabetically is just something you set up when you create the combo box. The wizard gives you a sorting option. Run through the wizard again and recreate the box. As far as the search goes, Access Beginner 8, lesson 6 covers creating a Search Combo Box.

See... this is why I love the badges next to your names. I can see that you're a Beginner student and can answer your question accordingly. There is a better way to do this, but it requires programming. You'll get there. For now, this is the best solution for you.
Add a Reply
New TechHelp Videos Link 
Richard Rost 
Sun 8/9
Howdy Access Lovers. I just wanted to make a quick post to let all of you know about the new TechHelp videos I've posted in the past week or so.

I'll post this here as a digest maybe once a week or so. If you want to get notifications as soon as I release new videos, make sure you Subscribe to either my YouTube channel or the Computer Learning Zone News page. The TechHelp videos have become kind of like a daily video podcast for me. I love making them, answering questions, etc. Read More...
Add a Reply
Contact Form Link 
Austin Ritner    
Sat 8/8
When I select a customer to add a new contact in the subform, I select them from the combo box, type the message in the notes section, save and close.

I open the contactR and the name doesn't show up. I feel like something is linked wrong.
Alex Hedley   
Sat 8/8
If you open the ContactT does the record exist?
If so what is its CustomerID (foreign key)?
Richard Rost
Sun 8/9
Make sure you Refresh the record before opening the report. If the little pencil is still showing in the record selector, the record is dirty which means it hasn't been saved to the table yet. The report won't see it. Refresh then Open Report.
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/10/2020Access 101 Free
8/10/2020Access Subform in a List Form
8/9/2020Access Odd or Even?
8/9/2020Access AutoNumbers Good or Bad?
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

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