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

News      User Comments     History     Notify Me
Thu 11/16
13:40
Microsoft Access Email SeminarMicrosoft Access Email Seminar by Thomas F: Thank you for your seminar and responding to the earlier post. I now have the group email I wanted. My question now is when I try to query my list of people to receive the email I get an error message [Run-time-error Too Few parameters Expected 1] If this is something I can get from one of your lessons I will be glad to  more...
Thu 11/16
0:51
Microsoft Excel ForumMove Row by Toine v: How can i make a macro that moves a row if a cel hase a sertain value i put in it. Reply from Alex Hedley: So you type in a value in a give cell, is this cell always in the same column? You then want that row to move? How many rows do you wish to move it?
Wed 11/15
13:43
Microsoft Access ForumCombo Box Updating One Record of Source Table by Jackie M: I have a combo box that keeps updating the first record of my source table. Any ideas how to keep that from happening? I have recreated the combo box a couple of times and check my preferences and don't seem to be able to locate the issue. I did select the save for later option not the store  more...
Tue 11/14
3:12
Microsoft Access ForumOpening a Blank Record by Karen Rolstone: Hello. Can someone kindly advise how you set a form to a blank record when you open it to stop users erroneously overtyping existing data? I would be very grateful for any advice. Reply from Alex Hedley: Design View Properties under the Data Tab Set Data Entry property to Yes
Private Sub Form_Open(Cancel As  more...
Tue 11/14
3:04
Microsoft Access ForumUpdating a unit price in a stock inventory databas by Karen Rolstone: Hello. Does anyone know how to update the unit price of an item in an inventory database when new stock is purchased from differing suppliers? In Expert 8.5 Richard said it would be covered in an advanced class. I'm up to Expert 15.3 and nothing yet. If I just change the unit  more...
Tue 10/31
21:08
Microsoft Access ForumAppend Query by Catrina J: I am trying to automate an append query after watching the Access 2013 Expert 15 video. My goal is to be within a form that is based on a different query, push a button, and have some of the data on my form append to my "Updated" table. I created the button based on what I learned in the video, but my records are not being added. I have confirmed the  more...
Fri 10/27
18:54
Microsoft Access ForumValidation rule Access by Phill I: Hello all, I added an validation rule to my works Data Base. The rule allowed me to add a number greater than 100 to various fields, 0 Or >100 .Work fine via keyboard entries, however we have a numpad pop up feature via double click. With the numpad I can only input numbers from 0 to 100, would appreciate any help to get numpad feature to  more...
Fri 10/27
12:29
Microsoft Access ForumDynamic List Combo Box by Margaret C: In my data base, I need to list the members of a project team. I have a multi-select combo box that works well. However, If someone is marked as "no longer current", they are deleted from the list and also deleted from any previous projects. Can you design a dynamic List/Combo box that does not change the records? Reply from Alex  more...
Tue 10/24
0:21
Microsoft Access ForumHappy Birthday Rick by MUBEEZI M: I am writing to wish my beloved teacher a happy birthday! May the Lord grant you many more productive years ahead! MICAH
Sun 10/22
10:38
Microsoft Access ForumRepair Files by Richard L: I can't open a database file. How do you fix a file that is corrupt and unreadable? Reply from Alex Hedley: Use the backup you made? Try a new blank database and import the objects from the broken one. /compact Access target
Sun 10/22
7:31
Access Calendar SeminarI am making a calendar Calendar seminar lesson 6 by Masih O: I am making a calendar (Calendar seminar lesson 6). I cannot find Calendar control in my ActiveX controls. I did some searching on the net and found out that Access 2010 don't have a calendar control. What do I do now??? Reply from Alex Hedley: If you read the comments you will  more...
Sat 10/21
2:45
Microsoft Access Forumhelp with a Query Criteria by MICHAEL J: Thanks Alex. I found a different way to do it. I,m just moving onto Union Tables so maybe I,ll try it later Reply from Alex Hedley: What way did you do it, could be useful to others to share.
Sat 10/21
0:42
Microsoft Access ForumRelationships by John M: Thank you Alex: I found an error when I traced back to Expert 3 for I had not created a One-to-One Relationship between CustomerT and CustomerExtendedT.
Sat 10/21
0:01
Microsoft Access ForumZoom by Gary W: Doesn't seem to work for me; it could be because I am using access through a Citrix receiver connection from an iMac. Thank You Reply from Alex Hedley: You could add a button or an event that runs DoCmd.RunCommand acCmdZoomBox
Fri 10/20
14:54
Microsoft Access ForumControl Youtube with Access by Harry M: Is there a way to embed youtube in access form and click a button to record time stamps as video plays (ie click and record 2:33 has been played). Then I'd like to click the time, and move to that part of the video. Reply from Alex Hedley: You can use a WebBrowser Control, you can interact with the webpage and youtube  more...
Fri 10/20
5:43
Microsoft Access ForumZoom by Gary W: How do you zoom in? one of the instruction videos showed zooming in while in design view; I cannot find how to do this. Reply from Alex Hedley: Access Beginner 1 06. Entering Data, Part 1 (11:09) SHIFT-F2 to open Zoom window
Wed 10/18
14:42
Microsoft Access ForumRacing Table Design by David L: The next task is to award points for the drivers in each race. First place gets 46 points; second gets 42, third gets 41, etc. In Excel, I used a VLOOKUP table so that each placement would be matched with the appropriate point total. Is there a similar feature in Access? Reply from Alex Hedley: more...
Wed 10/18
2:10
Microsoft Access Forumhelp with a Query Criteria by MICHAEL J: Hope i can explain what I want to do. I have 2 Tables, IncomeT and ExpenseT In both Tables I have a Date Field [IncomeDate] & [ExpenseDate]. After bringing in the fields on the query I want to create a report that would group record between a range of dates that match in both tables. Example Income from Nov 1 to Nov 5 and  more...
Tue 10/17
0:46
Microsoft Access ForumVB dot NET by Samuel M: Dear Rost, All VBA module you thought as , can we use those module in VB.NET ? I mean those module you create separetly and usually you call them in forms controls . you know that I have been waiting for lomg time your promise to make videos on VB.Net but I guest that you do not care about. also tell me if there is a equivavalant in VB.Net for DLook Up ,  more...
Sun 10/15
14:31
Microsoft Access ForumRelationships by John M: In my Expert Level 4's FamilyMemberF with Michele, Richard III and Lauryn on it, when I drag this into CustomerExtendedF it will not show any detail. Only one new record {empty} is available. I have inserted the cousin which was successful. Any ideas where I've made a mistake? Reply from Alex Hedley: Did you setup the Link Master/Child fields? It  more...

See More Comments...


See Complete Blog History

Change Layout


News      User Comments     History     Notify Me
 
 
  Dismiss
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
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