Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Courses   TechHelp   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!

Locations as assets Link 
Rick Bradnam    
Fri 8/14
Good morning all.  Richard, I am laying out the form of my asset management data base before the final build.  I will be having a location feild in my AssetsT and parent child relationships to sub locations i.e. LobbyRestaurantCashierStand...or 7thFloorRoom712. Read More...
Richard Rost
Fri 8/14
If it's the same type of "entity" (person, place, thing) then I don't see a reason to make a separate table. You could make an entity "type" so you could separate locations from items. It's up to you. Only you best know how to set up YOUR database. I know databases, but I don't know YOUR business as well as you do. Plus it's just turning 9am here in Florida and the coffee hasn't kicked in yet. :)
Rick Bradnam   
Fri 8/14
Fair enough...I am also undercaffinated at the moment.  I copied over the Asset Management stuff I built in the seminar and converted it to Location after removing a bunch of irrelevant fields.  Seems to be working pretty well with parent and child records.  If it is problematic later it is yet another lesson learned here.  I may build it both ways just for fun.  Thanks for the quick rely!
Add a Reply
Banking Interest Link 
Otto Friesen     
Thu 8/13
I am working on a database where I have a table with transactions similar to a checking account. I have like deposits and withdrawals. I now need to calculate interest on those transactions every month for every account and add that interest transaction to the table as well. Does anybody have a template to give me a jump start?
Richard Rost
Thu 8/13
I don't have a template for this, but it would make for a good one! Is anyone else interested?
Add a Reply
Splitting a subreport in two parts Link 
Emy Ng Hang     
Thu 8/13
Hello, I have a report with a subreport in the details section along with other textboxes and data. The subreport is too long to fit on the first page of the report. How can I show the first part of the subreport on the first page and the other part to continue on the 2nd page of the report?
Richard Rost
Thu 8/13
I really hate subreports. They don't work well half the time and you miss out on cool formatting tricks. Use a query. Join together the records from your parent and subreports into one recordsource. Same technique I use to create invoices in Access Expert 9, which I see you have.
Emy Ng Hang    
Thu 8/13
The reason I'm using subreports is because I'm trying to replicate a real report that has 4 parts and a specific format order. For example, the 1st part is about the customer (contains 5 textbox about the customer), 2nd part is about emergency contact info (with five text boxes that describe it: name, address, phone number...). If the customer has 5 emergency contact the 2nd part of the report must show 25 text boxes vertically (two columns, title on the left, data on the right), 5 text boxes for each customer. Part 3 and 4 of the report are similar to part 2. The report needs to show all 4 parts in one continuous report, like a 5 page report. If there is another way of creating this report please shed me some light? Thanks in advance.
Add a Reply
Open Form Based On 2 Values Link 
Emy Ng Hang     
Wed 8/12
I have 3 forms. first form has a listbox of vendors when the user select one vendor, it would open a second form with a listbox of clients, then when the user select a client, it would open a third form with info of the client. Because there are clients that can have two or more vendors I would like the third form only to show info about the clients (2nd form) of the selected vendor (1st form). Is that possible?
Richard Rost
Wed 8/12
Yes, but without programming the only way you could do that would be with a query. You would bring in both of those tables and their related values into one query with the proper joins. Now for each of the required IDs, you would have criteria


Then you would make your third form based on the results of this query.

You could do it more impressively with 3 list boxes on the same form, but that would involve some programming. That's the topic of Access Developer 14.
Emy Ng Hang    
Wed 8/12
Thanks Richard!
Add a Reply
Access Online Database Link 
Jan Schoeman    
Wed 8/12
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
Wed 8/12
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

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/14/2020Access NZ Function NULL to Zero
8/14/2020Access AfterUpdate & DLookup
8/14/2020Microsoft Access Crash Course
8/14/2020Access TechHelp
8/13/2020CopyFileA Function
8/13/2020Access Turn Off Warnings
8/13/2020MsgBox Prompt Yes No Cancel
8/12/2020Navigation Pane Minimize Restore
8/12/2020Ribbon Minimize and Restore
8/12/2020Application Window Maximize Restore

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