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!

Access Online Database Link 
Jan Schoeman    
Today 9:34 am
Good afternoon Richard. I have been following the access 2013 beginner lessons. Currently on lesson 7. I need some advice, to see if I am on the right path. I want to create a data base where my insurance clients / insurance companies can login and create their own quote. Read More...
Richard Rost
Today 9:34 am
Hi Jan. You can certainly build a database to track all of that information in Access, however Access by itself is NOT an online database. You have a couple of different options. You could build a web site with ASP and have your users enter information that way, and then you could pull the data down to your Access database for processing and then publish info back up to the web site. I cover this in my Web Database Seminar or my Web Sync Seminar. The downside of this is that it's more difficult to build. The upside is that they don't need any special software. They can just use a web browser.

Another option is that you could distribute a front-end copy of Access to your users and keep the data online. This way they are working in Access and you can use all of the functionality of Access (forms, reports, etc.) but your data is stored on a central server. I show how to do this in my Access Sharepoint Seminar and my upcoming Access Online SQL Server Seminar. The downside of this is that your users have to have Access or at least a Runtime copy. The pro is that it's easier to set up.
Add a Reply
Alternate for Serial Number Link 
Rick Bradnam    
Today 9:08 am
Hello all.  Richard, you had mentioned you were looking for an alternate name for the serial number field in the Asset Management Database Seminar.  I am taking that seminar right now (it is great, highly recommend it) and building a database to be used to track mechanical equipment in a high rise hotel.  I needed to reserve "serial number" to refer to parts and machines because they are often important when ordering replacement parts.  I also intend to use bar codes in the future so have instead used the term "Identifier". This will allow me to barcode anything.  My intention is to barcode both mechanical equipment and locations.  Guest rooms for instance, will be barcoded and a scan of the bar code will not only open the preventative maintenance form but also reference past maintenance calls so deficiencies can be checked.  This reserves the actual serial numbers of mechanical equipment to differentiate them from other identical model units or validate they are under warranty etc.
Richard Rost
Today 9:08 am
Good idea. Yeah, in the years since I recorded that Seminar, I've kind of standardized on using "Serial Number" to refer to a SPECIFIC ITEM whereas "Product Code" refers to a type of product. You might sell a "2 TB Hard Drive" and it has a Product Code of "JSHDSU231" which refers to the entire line of that hard drive, but a specific hard drive has an individual serial number of "29381839843739" for example.

Thanks for the tip! And yes, lots of people have been bugging me to put together a Bar Code Seminar. It's in the works!
Add a Reply
SQL to insert PDF doc into table Link 
Eric Michalek     
Mon 8/10
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
Mon 8/10
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.
Eric Michalek    
Tue 8/11
Storing the PDF inside the database is temporary, and it frees IT persons from having to constantly adjust permissions for folders in the share drive.
Users drag and drop the PDF into the frame, click a button, SQL inserts new record in table (but need vba to get the PDF contents into the table).  Once it is there, administrators approve the record.  When they approve the record, VBA creates a folder for the PDF, moves it to the folder which frees up that data space, and creates a link so it can be viewed later on.  There are only 2 persons who need control to edit or delete the PDF.  Again this is getting around ID persons as well as preventing someone from deleting or modifying the approved PDF document.
Add a Reply
Creating customer reference number Link 
Sue Warrington   
Mon 8/10

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
Mon 8/10
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   
Mon 8/10
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
Mon 8/10
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.
Fred Evans  
Tue 8/11
hello richard
thanks for that but i still have a problem. my table is 6000 records long and when i enter a name from way down the alphabet i am getting a message that the item is not in the list
please help

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/11/2020Access Maximize App Window
8/10/2020Access Beginner Courses
8/10/2020Access Beginner Level 1
8/10/2020Access 102
8/10/2020Access 101
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

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