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
Tue 5/2
9:42
Microsoft Excel ForumPurchase Question by ADAM S: Yes, i used the same email address. I have looked in the Theater, logged out & back in. However I am still not seeing anything. Reply from Alex Hedley: I've passed this onto Rich, he'll be in touch shortly. Did you get an email confirmation with an Order #?
Tue 5/2
9:04
Microsoft Excel ForumPurchase Question by ADAM S: I purchased the Beginner Level 2 courses this morning at 10:45 am. The order confirmation stated that my courses would be availible in 20 mins, however it's been and hour and 15 mins and they haven't posted yet. Can someone please advise? Thanks, Adam Reply from Alex Hedley: It should be available in the online theater. Did you use a  more...
Mon 5/1
19:30
Microsoft Access ForumStopwatch applet by David B: I need a stopwatch applet. I want to be able to press a macro button when a patient begins a task and when I hit stop have the time (to 0.01) recorded in the corresponding field. Any advice? Cheers DNB Reply from Alex Hedley: The DateTime Seminar  more...
Mon 5/1
18:12
Access Work Order SeminarPurchase Order by Shallena A: I have spent a week trying to figure this out. I am looking for any suggestions on the direction i should take to accomplish what i am trying to do. I get a Purchase Order with a list of things to complete - some are tower and some are Civil(ground) and I have an "other" category. I have to assign each of the items (there could be 20 or more items  more...
Mon 5/1
18:01
Access Work Order SeminarPurchase Order by Shallena Ayers: I submitted a question about my issue relating my work order table and schedule table. I thought a visual might help. Job Form Job Table I get a Purchase Order with a list of things to complete - some are tower and some are Civil(ground) and I have an "other" category. I have to assign each of the items (there could be 20 or more items on the  more...
Sat 4/29
20:47
Microsoft Access ForumFilter on Report by Liza G: Created a table. There is a field with a value list. This table was made to create a form. Looking to create a report in which the records are grouped together based on which item is selected on the value menu. The grouping function pertains to "fields". Reply from Alex Hedley: You could create a Report already grouped by those items  more...
Sat 4/29
15:19
Microsoft Access Advanced 5Microsoft Access Advanced 5 by Ray W: How many Access Advanced videos are you going to do before you start on the Developer videos? Reply from Alex Hedley: I'm sure Rich mentions this in a video, only a couple more then onto the Developer, if there are any requests for other Macro topics he'll go back and add more.
Sat 4/29
14:52
Access Work Order SeminarPurchase Order by Shallena Ayers: Hi Richard, In my database i am building with you I receive a Purchase Order from my customer... The purchase order has a list of services they need done (lets say there are 4 services... 2 tower and 2 ground type services). I enter each service into my Jobsite Total form (where you made the materials form). so i dropdown box and add each  more...
Sat 4/29
11:15
Microsoft Access ForumAutomatic transaction number by Gregory C. S: I used the link in an email to see the updated post. I did not see a warning that I should log into the site before viewing the post. I tried to post a reply but after hitting the submit button, I was told to log on. Did I waste time writing a reply or is the reply still salvageable? Reply from Alex Hedley:  more...
Sat 4/29
8:39
Microsoft Access ForumAutomatic transaction number by Gioia H: Yay thanks i figured it out. I made two queries to get it to work the first: SELECT DISTINCT DMax("PurchaseOrderID",'tblPurchaseOrders')+1 AS [Max], Format(Now(),"yyyymm") AS Now FROM tblPurchaseOrders; Then the second one: SELECT "K" & [Now] & "" & [Max] AS NewPO FROM qryNewPOCalculate; Not perfect but works. Good  more...
Fri 4/28
15:36
Microsoft Access ForumAuto Tab to next field by Richard L: In certain forms like entering credit card info or activation codes, there are a series of fields. For example: a credit card fields are four fields and have four characters each. in the first box I type the first four characters, but after I enter the fourth character, the cursor moves to the next field for it's four characters. How  more...
Tue 4/25
4:59
Change to the ForumsChange to the Forums by Edward R: Security is so inconvenient. But I would be happy not to read spam posts so my word is thanks.
Tue 4/25
4:56
Microsoft Access ForumLists Access Memo Fields by Edward R: I have forms that the client submits two of them are in list form. Last, Fist Item2 Item3 When data entered they are in the long text field on a single line separated by a comma. Being they are read in as a list and the end user wants to see them as a list what is the proper way to do this? As entered they are not in alpha order  more...
Sun 4/23
23:32
Microsoft Access ForumFilter on Report by Liza G: How to create a filter on text box in a report? Reply from Alex Hedley: Why not make a filter on a Form with a button to open the Report?
Sat 4/22
12:00
Microsoft Access ForumAutomatic transaction number by Gioia H: I'm trying to do something similar. I want to create a customer order number that would start with the letter K then take the year and month then increment from there. (K201704...) This info would populate my order text field on a form automatically. Can you help? Reply from Alex Hedley: Tip more...
Fri 4/21
8:36
Microsoft Access ForumOne table or Multiple by Danmawia K: I am just beginning to learn MS Access (I am in Beginner Level 1) My question is: To make Students database Class I to Class XII Should I make different table for each Class or make one table for all? Reply from Alex Hedley: 1 Class Table with a Name, add a record for each class and use the ClassID Autonumber to make  more...
Thu 4/20
11:49
Microsoft Access ForumRandom code generator by Ingrid L: Hello, I am working on a project for a clinic and they want a authorization code generator. How can introduce a code generator on Access? Thank you Reply from Alex Hedley: Seminar Registration Seminar Tip more...
Thu 4/20
9:50
Microsoft Access ForumForm Subform interaction by James M: I have a form/subform relationship between my Companies and Produts that I run from a Query in order to see only the products in which I have an immediate interest. The problem is with navigation. For example, if the subform contains 3 products, I have to click my "GoToNext" button 3 times in order to see the next company. How do I  more...
Wed 4/19
16:02
Access Work Order Seminarwhen i print more than 1 customers report the head by Shallena Ayers: Sorry that i didnt include this with my previous issue of the header only printing on the first customer report. But I also noticed that my sub form information from the first report is shown on all customer reports. If go to each work order and print just that work order...  more...
Wed 4/19
15:46
Access Work Order Seminarwhen i print more than 1 customers report the head by Shallena Ayers: when i print more than 1 customers report the header stuff only shows up on the first report. its like it thinks the other customer reports are part of the same report so no header info needed. I dont see that you did anything with the header one way or the other. What will  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