An investment in knowledge
pays the best interest.
-Benjamin Franklin
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
NEW: Microsoft Access Developer Level 4 and 5  - New MYOLP Pricing    dismiss

News      User Comments     History     Notify Me
Sun 2/18
Microsoft Access ForumMicrosoft Access Forum by Susan W: Thank you.
Sat 2/17
Microsoft Access Forumparameter query by Roderick K: beginner lesson 5 parameter query. Is the a way to enter two parameters. Like "NY" and "OH"? Reply from Alex Hedley: You could create two inputs [Input1] and [Input2]
Fri 2/16
Microsoft Access ForumExporting with format by Virginia M: thank you for your reply, but I found out the problem. Perhaps this was wrong to do but I created one Invoice and from that I copied to create Deposit Invoice and Grooming Invoice (of course I changed what needed to change) however there was a misspelling in one of the field names and as soon as I corrected the misspelling it is  more...
Wed 2/14
Microsoft Access Developer 4Microsoft Access Developer 4 by Kenny N: Thanks so much for the tip on the Dim statement! I never realized I was inadvertently dimming my variables as variants because I was not writing out my variable types individually. That explains some mysterious error messages I have been getting when trying to pass variables to subs and functions!
Tue 2/13
Microsoft Access ForumLaunchCD function by Joni M: I am also having problems using this function ever since I switched to Office 365. Reply from Alex Hedley: What issue are you getting?
Tue 2/13
Access Imaging SeminarLaunchCD VB by Joni M: I believe the last part should read "LaunchCD = Trim(... not rim
Sun 2/11
Microsoft Access 321321 Sample by Kim Beaul: I can not download the sample files - the password I am using doesn't work. I am using the password from My Courses Page Access 321 Dynamic List Boxes, Multi-Select Reply from Alex Hedley: The download page states "The password is the same as the INSTALLATION PASSWORD for the  more...
Sat 2/10
Microsoft Access 320For access 2013 2016 and Office 365 which version by Gioia Heiser: For access 2013, 2016 and Office 365 which version DAO library should we use? Reply from Alex Hedley: Which versions do you have available?
Sat 2/10
Access Split Database SeminarAccess Split Database Seminar by Joya: I am also interested in this.[See below] Currently I split a database and about 5 employees are using the one FE.accde file. We haven't had any issues, but let me know if you are aware of any. Did you ever make this seminar? That might work better for me. THANKS! The mini seminar you mentioned here:[However, if you have the  more...
Fri 2/9
Microsoft Access ForumMicrosoft Access mdb by FRED TARNELL: I am 75 yrs old. I have been semi retired for over 10 yrs. I want to get up to date on Access 16. I have a .mdb that I can email someone. I tried opening and converting according to MS. No luck. I want to pay someone to open and convert to MS Access 16. Reply from Alex Hedley: Try creating a blank new db in 2016 so an  more...
Tue 2/6
Microsoft Access ForumConvention by Dennis O: I am not sure if I have a cartesian query which is joining 3 items per attendee, one for each year? However, I did notice that I have a "copy of MemberF" I no longer use this one but I added more to this page that I am using. If I delete this copy could that be the answer to the multiple entries? If the member was at the 2016, 2017, 2018 convention it is listed  more...
Tue 2/6
Microsoft Access ForumConvention by Dennis O: This is what I found out. The new entry is in the "MemberT". The new entry is also listed on the "MemberListF". The Record Source is "MemberSortedQ". When I open the Master Roster (Main Menu)and select the new entry, it opens to a blank form with a (New) Member ID.If I fill this form again, it will set up a new ID. Will list it on the Main Menu Master List but  more...
Tue 2/6
Microsoft Access ForumRandom Seed value by Richard S: In Expert 26 on the Random number lesson, is there any reason to not use the RND() function as the seed ? Something like Rnd(rnd()) ? Thoughts ? Till later, Rick S. San Antonio, TX
Mon 2/5
Back in the SaddleData Replication by Adonis B: Yes, offline usage is necessary due to the amount of queries that run within the application to access the data. Some forms-reports take longer than a minute in running all the queries before actually displaying something if all the tables are online (ODBC SQL server). Because of the number of queries on the database, user will have to work with this  more...
Sun 2/4
Back in the SaddleDeveloper 4 by Mac W: Waiting on Developer 4 Reply from Alex Hedley: It's been released. See the outline.
Sun 2/4
Microsoft Access ForumMicrosoft Access Forum by Susan W: I just realized my second question was similar to my first.The reason I was getting that message (?NAME)was because the field EmployeeID had an extra space in the Employee Form which was not in the Employee Table. d Reply from Alex Hedley: Have you added a space in the Field name i.e. "Employee ID" not "EmployeeID". Try not to  more...
Sun 2/4
Microsoft Access ForumCombo box Search by Naser A: I put the combo box on the page header of the Form. It appears only on design mode but does not show up in Form View or Layout mode. Reply from Alex Hedley: Put it in the FORM header not the PAGE header.
Sat 2/3
Microsoft Access ForumConvention by Dennis O: I'm not sure. Can you refresh my memory. Where can I go to find out how to write a Cartesian query? I may not because you mention one for every year. Reply from Alex Hedley: Access 223
Sat 2/3
Back in the SaddleBack in the Saddle by Ray W: I thought Richard was back in the Saddle? Reply from Alex Hedley: D4 has just been released, D5 is in production.
Sat 2/3
Microsoft Access ForumMicrosoft Access Forum by Susan W: I did not have the all the necessary fields listed in my table. I do have another question, though. I have an employee form and a customer form, both with EmployeeID fields. However, one is working correctly with the ID # showing, but the other has #Name? in the EmployeeID field instead of the number. Both seem to be set-up the same  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