An investment in knowledge
pays the best interest.
-Benjamin Franklin
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 

News      User Comments     History     Notify Me
Sat 4/25
6:37
Access 2010 Beginner 1Zoom In by Brenda Peterson: I have a HP Pavilion laptop and you said to make the notes area bigger press Shift+F2 but that doesn't work on my computer. F2 just dims the screen. Is there another way to make the notes area bigger? (Access 2013 Beginner 1 Video 6 Entering Data Time Index 18:15) Reply from Alex Hedley: You might need to use an FN or Function Key, usually in blue,  more...
Sat 4/25
4:48
Microsoft Access ForumAutomated Invoice by Flynn: How do I create an automated routine for my invoices? Reply from Alex Hedley: Hi Flynn, What automation are you wanting to perform? You'll need to give me a little more information to help here.
Fri 4/24
18:56
Access 2010 Expert 2Default value for customer by vince Hughes: I have been trying to get a Default value for customerID in my data base have went through video 4 times and do not think I'm missing a step. My problem is I have set the default value in properties to: Forms![ContactF]![CustomerID]and it does change to the right person in data base when I click on button in customerF but the  more...
Fri 4/24
12:21
Microsoft Access ForumFormat back color to be like gray by Bob Lilly: Hi Alex: It worked like a piece of cake. Thanks a million. Bob Lilly Reply from Alex Hedley: Awesome :)
Fri 4/24
5:38
Microsoft Access Expert 22Address DLookUp Address Sheet1 Customer by Jeffrey Ervin: Address: DLookUp("Address","Sheet1","Customer=""" & [Customer] & """ AND [Order Date]=#" & [MaxOD] & "#") I got this to work but only when messing around with order dates from the table sheet1, for eg. I had to make the date for Customer "XYZ Inc" at "1001 Starship' more recent then  more...
Thu 4/23
19:50
Microsoft Access Forummdb file creation when compacting and close by Uriel R: We all have the same read-write permissions Reply from Alex Hedley: Are they full rights? Do you have delete permissions too? The compact/repair creates a new db, copies over the objects, then deletes the old one, if there are permissions issues this could cause a problem. If you run-as  more...
Thu 4/23
16:12
Microsoft Access Expert 22dlookup function by Jeffrey Ervin: Hi Having Problems with the dlookup function, just cannot get it to work. At 13:00 Fixing non relational. Reply from Alex Hedley: Can you share your code please
Thu 4/23
14:22
Microsoft Access ForumFormat back color to be like gray by Bob Lilly: Hi Alex: I have an access file that contains 33,000 rows and 200 columns. All the cells contain a null, 1 or -1. Is there a way that I can format all the cells that contain a -1 to show the back color to be light gray. Thanks in advance. Bob Lilly Reply from Alex Hedley: Have you tried a more...
Thu 4/23
14:17
Access 2010 Expert 1Database Password by Rachel Mychajluk: Hi there. This might be very obvious, but I'm noticing that I need a password to open the associated database online. Is that listed somewhere? Thank you! Reply from Alex Hedley: The db password matches the Course password which you can find in the My Course link in your account. more...
Thu 4/23
12:26
Microsoft Access ForumIdiosyncracy in Producing Report by Charlotte K: I have a simple report that selects a record from a table. It works great with all but one record. I have examined the errant record, even retyped it and still the report does not pick it up. Are there certain reserved syllables or letters in the record that are not compatible with Access? The Query does not  more...
Thu 4/23
11:52
Access 2010 Beginner 4Indexing is not an option by Toni Woodbridge: Example please? Reply from Alex Hedley: Relationships are covered in Expert 1 When you create a Table you'll usually have an AutoNumber Field as your ID. When you want to create a Relationship to another Table you can add a Foreign  more...
Thu 4/23
10:21
Excel 2010 Beginner 2Copy Formula by Ginny Y: OK, but what if I'm entering new information into that cell where the total is? My columns are Name, Date, Title, Type, XHours and YHours. I'd put TOTAL in cells E5 and F5. Now I have to enter information in Row 6, including into cells E5 and F5. Are you saying that I should just drag the formulas from E5 and F5 down into E6 and F6 and so on, as I add  more...
Thu 4/23
8:44
Excel 2010 Beginner 2Copy Formula by Ginny Yager: Hi Richard, this is probably coming up in a future lesson (I'm only on Beginner Level 2-3), but it's something I'm being asked to do now. I need to create a spreadsheet for training. I know how to insert a formula to get a total, but what if I'm not finished entering information? If I put the formula in cell E24, but still have to enter other  more...
Thu 4/23
6:50
Microsoft Access Email SeminarEmail Merge to Word Multiple Accounts by Brauna Rosen: Hi Richard, If I want to use the Email Merge to Word and I have a few email accounts in Outlook, how do I choose the correct "From" email address? Great Seminar! Thanks, Brauna Reply from Alex Hedley: You can't unfortunately You'll have to create a profile with just one account, not multiple  more...
Thu 4/23
1:51
Microsoft Access Forummdb file creation when compacting and close by Uriel R: No, it just creates a file named "Database.mdb", I wouldn't mind it but sometimes it tries to save or retire data form it and it gives me an error, my database is fine after it and no problem but they "Database.mdb" file stays behind and it uses space on the hard drive. Other users use the database  more...
Wed 4/22
16:37
Microsoft Access ForumRecord Input form will not assign new primary key by Lee A: Record Input form will not assign new primary key for new record - thus, no new record. It did work -- I don't know how I destroyed it. I have multiple interrelated tables. Reply from Alex Hedley: Is the Record Source for your Form a Query? If you open the Query does it have  more...
Wed 4/22
13:02
Microsoft Access Expert 7I m trying to place a control button in my databas by Yolande Villeneuve: I'm trying to place a control button in my database so I may open another table. I have done it before with Access 2010 but now with 2013 it will not work. The message is "The expression On Click you entered as the event property setting produced the following error:  more...
Tue 4/21
14:46
Microsoft Access ForumSpreadsheet to Database by Art Seemann: I learned from the first lessons how to paste data to Access from a spreadsheet. So, now can I add more data from a spreadsheet to the table created with the first spreadsheet? Reply from Alex Hedley: You can keep adding data to the same table If the columns match just copy and paste it into a new row.
Tue 4/21
13:51
Microsoft Access Forummdb file creation when compacting and close by Uriel R: I have access 2010 32 bit version and I always use the close and compact option on access. Lately I have noticed that overtime I exit any database a mdb file is created. Is this normal? Why access does that? Reply from Alex Hedley: The Compact and Repair tool is the same way you create a  more...
Tue 4/21
11:16
Microsoft Access ForumEnd of Month calc by Bill Plamondon: Alex, I have tried the tip and it works for me. My problem was with the Intermec devices conflicting with the module. Reply from Alex Hedley: Intermec devices?

See More Comments...


See Complete Blog History

Change Layout


News      User Comments     History     Notify Me
 
 

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