The roots of education are bitter,
but the fruit is sweet.
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me
Fri 4/19
Customer TestimonialsKid in a Candy Store by John Davy: I started watching the SQL 3 videos as soon as I downloaded them. I love them! I am like a kid in the candy store with your videos. I worked for the state education department for 30 years supervising teachers and you are the best I have ever seen. You are smart. You are masterful with Access. Most importantly - you are a great teacher! You  more...
Tue 3/12
Microsoft Access Developer 12Microsoft Access Developer 12 by Richard R: test
Sat 2/16
Microsoft Access ForumAccess Short Text Field Size by Gerald Y: In Access Beginner 3, Field Properties 1, where we talk about wasted space: It should be noted that for data in a text field, Access does not reserve space beyond what is necessary to hold actual values. See at the bottom of  more...
Thu 2/14
Microsoft Access Forumdivide two queries to get percentage by jannette j: want to join two queries so i can take the count of one query and divided by another query to get the percentage of work orders that were completed. the numerator query: [code]SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder FROM MaximoReport WHERE (((MaximoReport.WorkType) In  more...
Tue 2/12
Microsoft Access ForumMicrosoft Access Forum by david P: In Exper7 we learned about ManytoMany relationships. I am wondering if that relationship will work using the same table. Such as a CompanyXCompany. The reason I ask is how to perform a partnership with a company in CompanyT and a Partner from the same CompanyT. If I select a partner from the sub form, I would like to see the reverse show  more...
Tue 2/12
Microsoft Access Forumjoining queries to one by jannette j: i need to get some help with a doing some calculations with a lot of criteria into percentages.I have many of queries were simply to come up with a number that is a count of records with a specific criteria, to be used later in a calculation. Because those criteria are so lengthy, and change with each variation of the data i use  more...
Sun 2/10
Access Work Order Seminardbl clk by Matt: 10:40 you don't need to check because your picking a Value when you dbl clk the list box so can't eliminate the IF statement in the dblclk event? Reply from Alex Hedley: If memory serves its because you can double click a list box without actually having a selected/highlighted value so this is in place to make sure a value is passed to the necessary part.
Mon 2/4
Microsoft Access ForumDrop Down by Keith A: DROP DOWN List made by field lookup wizard works great. But.... If I try to do a query on using that field as a filter - it won't work as the value is a number - not the text from the list. Reply from Alex Hedley: Have you tried using the .Column property to get the value you need?
Mon 2/4
Microsoft Access ForumJoin Queries by jannette j: I have 11 queries that each of the quers have two one for numerator and another for denominator how can i combine all to create a crosstab query for a report.
Sun 2/3
Microsoft Access ForumAccess 2013 by Nelson Wallace: I think I am almost passed my use by date when it comes to learning but I am enjoying the challenge. I have come to a standstill while developing a program to keep track of my dividends on a financial year basis to tax purposes. By the way I am in Aus so we use En date format not US. The problem is although I have the ticker code as the first field. And  more...
Fri 2/1
Microsoft Access ForumJoin Queries by jannette j: i have two queries I want to join so i can get the percentages from each department of completed work orders but not sure how to go about it. I know i want a join and a crosstab query so i can display the results in a report. The first query calculates the numerator,
SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder,  more...
Tue 1/29
Microsoft Access ForumWizard by Susan W: The input wizard does not seem to be working for me. What could I be doing wrong? Reply from Alex Hedley: How is it not working?
Sat 1/26
Microsoft Access ForumWord Automation by Joseph M: I have a word document that I kick off using an access macro " run application" the document opens fine now I want to automate it so it will start printing on open. Any ideas? I also would like to word doc to close are return control to access. Reply from Alex Hedley: Have you tried recording a macro in Word and see what happens when you  more...
Wed 1/23
Asset Management Seminar Part 1Part 2 by Mary Phillips : I see Part 2 was intended a long time ago. Is it still a possibility? If so, when could it be expected? Thank you.
Wed 1/23
Microsoft Access ForumEnforce Referential Integrity by Ariel D: Hi, I'm currently working with Access Expert 8: Lesson 5-Order Detail Subform. I'm building up the relationships for the three tables: CustomerT, OrderT, and OrderDetailT. However, when I build the relationships for the OrderT and OrderDetailT and click the "Enforce Referential Integrity, then click OK an ERROR message  more...
Wed 1/23
Microsoft Access ForumCorrelate the selected date by jannette j: I need to correlate the selected date range in a form with the proper recordset. I think it can be done, but I would have to play with it a little to get the code right. There are built in functions in VBA to get the week number from a given date it would then just be a matter of the VBa is there any VBA that can do this  more...
Wed 1/23
Microsoft Access ForumBlank Record by Richard A: Is there a way to use a button on Form 1 to open Form 2 and go to a blank record? Reply from Alex Hedley: See this thread.
Tue 1/22
New ReleasesNew Releases by jannette j: when is new courses come out
Tue 1/22
Microsoft Access ForumUsing the enter key to kick off an action by Joseph M: Have you ever done a session where a user might fill in a text box with a name and then kick off the search using the enter key instead of a special button? If so what lesson was that in, if not...could you do one? Reply from Alex Hedley: You can add a shortcut to the button, just use a "&"  more...
Mon 1/21
Access Web Data Sync SeminarMobile Wunderground Code by Kristin Williamson: I sent my first email too quickly. When building my own form using the wunderground site, L1 = 14346, L2 = 14471, D = 145. So my MsgBox is 145 characters. I'm trying to find another website to use but so far no luck. Any ideas?

See More Comments...

See Complete Blog History

Change Layout

News      User Comments     History     Notify Me

Visual Basicindex
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 Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP