Learning is not attained by chance, it must
be sought for with ardor and diligence.
-Abigail Adams
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me
Sun 11/15
Microsoft Access ForumAccess 2013 runtime by Ray W: Is there any way to install Access 2013 runtime and it not corrupt any other versions of Access runtime that may be installed on the computer? I have customers that run my program with Access 2003 runtime and when they install a new program that runs with Access 2013 runtime the programs that run Access 2003 runtime will not run any more.  more...
Sat 11/14
Microsoft Access ForumFormula by Bob Lilly: Hi Alex I was able to come up with a formula that did the trick. The formula below is for the original worksheet but not for the example shown here. '=IF(C4=D10,1,IF(D4=D10,1,IF(E4=D10,1,IF(F4=D10,1,IF(G4=D10,1,"")))))
Sat 11/14
Microsoft Access ForumObject dependencies by Michael L: Dear Alex I imagined that Access would have a tool to give an overview of the complex dependencies and relations that we build into the tables, forms, queries and reports. I thought that this is what the "Object Dependencies"-tool does, I'm just not sure how to interpret what is displyed. Was hoping Richard would teach us to use this  more...
Fri 11/13
Customer Service PolicyCustomer Service Policy by Ignacio A. Zamudio: I enjoyed the basic access on youtube. Got me started. I want to incorporate my data from excel to access.The field names are not same. What is the easiest and quickest way? Reply from Alex Hedley: Check out Expert 20.
Fri 11/13
Microsoft Excel ForumFormular in Excel by Bob Lilly: A B C D E 6 27 25 35 52 No1 No2 No3 No4 No5 6 27 25 35 52 13 23 29 33 42 7 24 35 34 55 I m trying to write a formula that will look at Cells A2:E2 to see if there any any cell that match the value in C6, and if so placed a 1 in column F6. Reply from Alex Hedley:  more...
Fri 11/13
Microsoft Access ForumVBA Select Distinct query by Robert: Hi Alex, I did work it out with the line: Set rs1 = db.OpenRecordset("select distinct ccmodel from CarModelT where CarsMakeID= " & TempMake). The purpose was to filter the ccmodel in particular from the list of car makers (CarsMakeID). The other fields weren't necessary and they caused confusion. Robert Reply from Alex Hedley:  more...
Fri 11/13
Digital Photography ForumDigital Photography Forum by Jacqueline jones: Want to learn this problem
Thu 11/12
Microsoft Access ForumYou can t assign a value to this object by Brad J: Working through the Expert 22. On the Add product drop down box, when I hit enter, I"m getting the subject message and the detail is Error 3021, SetValue action, Arguments SalesTaxRate, Forms!OrderF!SalesTaxRate. In addition, it does not appear that the calculated fields in the OrderDetailQ for SalesTax and  more...
Thu 11/12
Access 2010 Beginner 2stupid question why does my form not have the do by Heather Hudson: stupid question - why does my form not have the dots in the grid? Having trouble linig up text boxes. Reply from Alex Hedley: See this Tip.
Thu 11/12
Microsoft Access ForumAccess 2007 by Ray W: Has anybody have trouble with using SubForms with Access 2007? Reply from Alex Hedley: There's problems all over that release.
Thu 11/12
Microsoft Access ForumAccess 2007 by Ray W: I have a form that will work great in Access 2003 and Access 2010 But not in Access 2007. Is Access 2007 worth using? or to many bugs in it? Reply from Alex Hedley: Don't use it, very buggy.
Thu 11/12
Access 2010 Beginner 1I sat back and relaxed and watch courses 1 thru 7 by Guadalupe Pinon: I sat back and relaxed and watch courses 1 thru 7. I got just one small question which has been on my mind all along. How would you setup when there's an election of whether the person is a male or female? Help! ~ Wally Reply from Alex Hedley: Add another Field of  more...
Thu 11/12
Access 2010 Beginner 3Phone Option Input Mask by Resat Ilgaz Demirel: For some reason I am not getting Phone option in my input masks. Reply from Alex Hedley: What data type is the Field?
Thu 11/12
Microsoft Excel Forumexcel vba by manilara: Dear Experts I have multiple workbook saved in folder i want copy data from closed books and paste into mastersheet particular criteria is sum the column F:F and average the column G:G after 20th rows copy from Month_FEB.xlsx Month_JAN.Xlsx Paste Into Master.xlsx Path is C:\Users\maninata\Desktop\Personal\Excelforum\VBA\TASK_1 Find the  more...
Wed 11/11
Microsoft Access Forumusing data from excel in access by Line: Hi, I want to add a field to a table which link names in one field to a autofill number (like a reference number )which is pulled from an excel spreadsheet so it autofills. Any ideas how i can do this? Thanks Reply from Alex Hedley: more...
Wed 11/11
Microsoft Access ForumEncrypting database by Sivaram G: I have no idea about row level locking. Reply from Alex Hedley: Did you split the db?
Wed 11/11
Microsoft Word 101I would like to know if you have anything on word by Anonymous: I would like to know if you have anything on word 2016 that is where I am working right now. I am aware of this viersion. the newer version is what I need now. Reply from Alex Hedley: The Word Course List is more...
Wed 11/11
Microsoft Access ForumEnter Parameter Value by Khaja: Hi,I was trying to follow lesson 2 from payables seminar, I did the docmd open form code , but when I double click on payee name it says " enter parameter value " , I did same as shown in video, where am i wrong, please assist. Reply from Alex Hedley: Does the parameter have a name?
Tue 11/10
Microsoft Excel ForumGrouping dates into date ranges by Michael G: Hi, I've looked at VLOOKUP and Pivot Tables but so far no luck. I have a long list of dates ranging from 1/1/11 through 12/31/14. I want to change the dates into date ranges. The ranges are as follow: Before 1/1/12; 1/1/12-12/31/12; 1/1/13-6/30/13; 7/1/13-12/31/13; 1/1/14-6/30/14; 7/1/14-12/31/14. So for example,  more...
Tue 11/10
Microsoft Access ForumMicrosoft Access Forum by Selby H: Dear Richard, Is it possible to play a sound (piano chord) using access vba, using keyboard? All the best Selby Reply from Alex Hedley: Allen Browne has a tip. Declare Function apisndPlaySound Lib "winmm" Alias "sndPlaySoundA" _  more...

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
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