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  
NEW Release: Access Expert 25    dismiss

News      User Comments     History     Notify Me
Thu 9/18
What Access Topics Do YOU Want?How to move Access to Azure by Gary Samuels: I've moved an Access/SQL database to the Azure Cloud. I have setup Azure Storage with public containers to hold documents and images which are displayed in a form or opened by hyperlink with the associated application. Downloading isn't to hard but how the heck do I upload using only VBA?
Thu 9/18
Microsoft Access ForumRules Engine by Gerald W: I need to build a rules engine database. I have search the internet for an example DB, however,I cannot find anything on the subject. Right now we have a buch of excel workbooks with business rules and control over the updates to the rules, who changed the update, when it was lasted updated, or any other nformation such as messages that should present when a  more...
Wed 9/17
Access 2010 Beginner 3Date Function by Joseph Beniacar: Hi Richard, Would the DATE() function update the cell with the new date "each" time you close it down and reopen it another day?
Tue 9/16
Microsoft Access Expert 11Open Form Multiple Conditions by Alex Hedley: If [ContactID] and [CustomerID] are on [ContactF] then when you open the form [CommunicationF] have their "Default Values" set to =[Forms]![ContactF]![CustomerID] and =[Forms]![ContactF]![ContactID] Alex
Tue 9/16
Weekly Access HangoutWeekly Access Hangout by lauro c: weekly access hangout is a great idea but since we are all busy and our time frames may not fit, you can do so Rich on your own convenience and just post it.. if you can staggard the time at different time of the day based on previous subcribers' recommendation and just post the time. Then you can probably save the encounters as an archive  more...
Tue 9/16
Microsoft Access Expert 11Open Form Multiple Conditions by Lynda C: Hi Richard There are three forms involved here. My CustomerF - which has all my customer info My ContactF - which shows people and their positions within the relevant CustomerF e.g Esme Cole - Sales Manager, Keith Cole - Property Manager etc and then I have my CommunicationF - which reports all communication  more...
Tue 9/16
Microsoft Access Expert 11Open Form Multiple Conditions by Lynda C: Hi Again, I mean when I am on the customers contact form, I want to click a button, that opens the CommunicationF, and have both the ContactID and CustomerID fields populate with the relevant details from the ContactF.
Tue 9/16
Access Work Order SeminarAccess Work Order Seminar by Lynda C: Hi Richard, I am still having problems with the schedulingF returning errors. I believe this is to do with my location settings and the date format. I have downloaded your student database, and it is returning the same error. When I type in the begindatetime field, I get the following error: Run-time error '3075': Syntax  more...
Tue 9/16
Microsoft Access ForumCreating buttons to open forms by Stefanie M: I went to Property Sheet and changed its format to "No" visible.
Tue 9/16
Microsoft Access Expert 11Open Form Multiple Conditions by Lynda C: Hi Richard, I'm wanting both fields to drop in on the CommunicationF by default
Mon 9/15
Microsoft Access Forumhow to set up table by Cherylynne: when you say set up a share table i am not sure why as I do not need the shares only the name and address of the shareholder which I have when I set up the share holders. So still not sure how this would work for me even if I do set up a share table as some people have shares in 2 or more companies and I do not want to send out 2 or 3 emails  more...
Mon 9/15
Microsoft Access Expert 10IIF Function by Brian Farley: So for the homework, I put the IIF function for the quote and paid as fields on the report instead of part of the query. Any Con to doing that, other than you can't get to that field from another report? Is there a limit on how many fields you can have in a query? Thanks
Mon 9/15
Microsoft Access 327Comment by Richard Lanoue: Yes I would like to see partials...
Mon 9/15
Microsoft Access ForumDisplaying Decimals by Peter Brooks: I tried that Richard, but it still shows 1.50 when the form shows, correctly, 1.5
Sun 9/14
Microsoft Access Expert 11New Record at Top by Lynda Chase: Hi Richard Is there a way to get the 'new record' in a continuous form, to appear at the top, rather than the bottom of the list?
Sun 9/14
Microsoft Access ForumCustom icon by michelle m: Thanks Richard, I have made the icons in paint but cant seem to save them with the ICO file extension. Will google it. Thanks again
Sun 9/14
Microsoft Access Expert 11Open Form Multiple Conditions by Lynda Chase: Hi Richard, My customer table is linked to a contact table that shows the 'managers' of different locations. I am trying to add a button to my customercontactF which will open up my communications form with two where criteria (customerID and contactid) So i can not only see customer communications, but communications  more...
Sun 9/14
Microsoft Access ForumCustom icon by Alex Hedley: http://www.xiconeditor.com/
Sun 9/14
Access 2010 Beginner 9Can you change the default font by simon b: There would appear to be only two settings in Access 2013 to change the anything to do with the font. Access options Datasheet Default font here you can change the font size weight and make it underline or italic But as Richard says the font type is a windows setting. You can under Object Designers settings  more...
Sun 9/14
Microsoft Access ForumDisplaying Decimals by Peter Brooks: I have a form where the customer enters numbers with none or up to 2 decimal places as necessary. I have set the field 'QTY' to Double in the table and numbers show correctly on the form, e.g. 1 1.25 and 1.5 etc. However, the equivalent field on the report I can only get it to show either two decimal places or round up any two decimal  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