Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

Sorry, but for security reasons, this feature only works for Thread descriptions that have only alphanumeric characters in them (A-Z,0-9). Richard still has to scrub all of the OLD descriptions from the system.


Microsoft Access Forum
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

This forum is for the discussion of Microsoft Access.

Access is my personal specialty. Have questions? Comments? Want to discuss how to do something? Post it here. Also, I get a LOT of questions sent to me in Email from people around the world. I'll post the interesting ones in here. Feel free to comment on them.

Click Here To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

Permanent Link
Keywords: microsoft access forum
Post New Topic

Read Own Icons On the Ribbon by Jan H @ 5/18/2018
Is there any EASY WAY to use own icons on the ribbon?

Reply from Alex Hedley:

I've hopefully got a course released soon on creating your own ribbons.
There's a bit of XML involved in some hidden tables but it's easier once you know how.
Show Just This Thread        Post Reply
Read Duplicate Values on Multiple fields by Brent R @ 5/15/2018
I found your tips on "Microsoft Access Duplicate Values on Multiple Fields" it is very close to what I am looking for but I would like to allow it to check for combinations of First Names and Last Names and make sure there are not duplicates in the table how can I do this? I have a field in the ContactT called FName and LName and the combination of the two can not be duplicated in the table so when the form is closed I would like it to check before upodating and prompt with error when duplicate is found.

Reply from Alex Hedley:

Have you seen the Composite Keys Tip?
Show Just This Thread        Post Reply
Read I want to use access to track payments by Robert R @ 5/10/2018
I don t think you have covered how to handle payment when they bounce or when they decline if your customers pay by check or credit card.
Specifically how to keep balances correct in the event of a declined or bounced check and how to notify a rep if the accounting is a divergent department and you are the rep for the customer who gave you the bad check or credit card.

Reply from Alex Hedley:

You could add an extra column of cleared and set that automatically on Cash payments and then set them for others that need checking.
Show Just This Thread        Post Reply
Read Display a Single Record on a Report by Kirk R @ 5/10/2018
I have been trying to display a single record on a report and have run into a roadblock.  I have created a query based on the report and have set the criteria to Forms!Formname!Fieldname.  This seems like it should work, but everytime I run the query, the qyery asks me for the parameter forms!formname!fieldname.  The form is open and is set to the record I want to see, but i can't seem to get it to work.

Reply from Alex Hedley:

Check the name of the Field on the Form, it may have changed spelling.
Show Just This Thread        Post Reply
Read Forum Search by Gregory C. Smith @ 5/7/2018
How do I search the forum?  I didn't see a search box anywhere in the forum pane. I am trying to make a hot link in a subreport to open a form on that record. I have tried several WHERE statements in a macro.
I can manually enter a record in the parameter box that shows up in the error.  I have no trouble links in subforms to open a different form using a similar WHERE such as [RequisitionNum]=[Forms]![frmContractObligationsTracking]![sfrmContractObligationsTracking]![RequisitionNum]
I cannot figure out why I cannot create the WHERE in a subreport in a report to use the link in Report View.
The link in the subreport opens the form but does not pass the value of the AutoNo to the form's ARR_ID.

Reply from Alex Hedley:

There is a SEARCH box in the top right corner of every page.
Is the link in the main report or the sub report? Might just need the sub report value.
Show Just This Thread        Post Reply
Read Homework by William E @ 5/4/2018
I am on Access Expert level 10.  As a student, I thought I was doing great....until we got the homework. Then I failed miserably.  I haven't been able to complete one task correctly.  I find them to be much to difficult for this level, and it's very discouraging.  If anyone else is willing to admit this, here's a suggestion.  Instead of 3,4, or 5 assignments, how about just one.  And make it something that is in exact relationship to what we just learned.  Like an Iif statement after we learned Iif statements.  If there is no one else, and it's just me, maybe I should start the course over.  Thanks

Reply from Alex Hedley:

Try not to get too disheartened, it's annoying when you can't do something straight away but don't give up.
Can you share the question and what you tried and we can work together to see about a solution.
Show Just This Thread        Post Reply
Read Production Schedule Updates by Richard S @ 4/30/2018
Hi folks,

Was wondering when to expect Access Developer-8;  please advise when you get a moment.

Hope all is well & till later,
Rick S.
San Antonio, TX

Reply from Alex Hedley:

Should be released soon.
Show Just This Thread        Post Reply
Read Snap To Align by Glen S @ 4/30/2018
Is there a way to snap to align all of the front and end edges of fields in the form design section at a single time?

Reply from Alex Hedley:

There should be options in the ribbon.
Or you could group everything, but rich usually suggests breaking that.
Show Just This Thread        Post Reply
Read Homework Access 9 Expert by William B @ 4/29/2018
Access Expert 9 Homework. I restricted this to a Nested IIF Statement. I m not sure if this will restrict other abilities later. But as an end report I felt it was appropriate.    

=IIf([ISPaid],"Paid In Full",IIf([QuoteOrInvoice],"Quote Statement","Invoice For Payment"))
Show Just This Thread        Post Reply
Read Access limitations by Brandon J @ 4/26/2018
Hello sir,

     I know you ve talked in class about how Access has a 2 GB size limit, which can be overcame by splitting the database. What other limitations does Access have? For example, how many times can you split a database? Also, what is the maximum number of users a single Access database can support, simultaneously? When is it time to look into SQL server?

Thank you!

Reply from Alex Hedley:

Splitting just means putting tables etc in another file, you can have every object in it's own db, I wouldn't recommend it but that's the limit.
MS Article: Access specifications
Show Just This Thread        Post Reply
Read Creating Employee Vacation Database by John S @ 4/25/2018
Yes I did. Thanks. I have a new problem.
I have a form that shows an employees accrued hours, hours used, and remaining hours. i need the remaining hours to subtract from each new used hours entered. right now I have to mentally add the new hours with the existing hours used to get the correct remaining hours. what am i missing? i tried the AfterUpdate function, but it's not working for me. any ideas as to what i am doing wrong?

Reply from Alex Hedley:

Can you share the code you tried?
Show Just This Thread        Post Reply
Read Running Total by Roger R @ 4/24/2018
Having trouble getting the DSum function to generate a running total by groups.  My query has a field that is coded as:  RT: DSum("[Sum of Totbush]","[TransmasTotalsCornQ1]","CropYr=" & [CropYr] And "No<=" & [No]).  The CropYr and No fields are number fields that are sorted in ascending format.  When the query is run, I get a sum total for all the groups for each record.  If I remove the second part of the criteria that evaluates the No field, the query will produce a running total for each crop year for each record.  I need for the query to produce a running total of the "Sum of Totbush" field that is reset for each change in crop year, but is sum totaled by each month (ie No) in the year.  

Thanks in advance for your assistance.

Screen shot follows:
CropYr Sum Of Totbush Month No RT FiscalMonth MName CompNo
2017 12382.8628 6 24209 1718818.2299 1 Jun 24209
2017 9579.6429 8 24211 1718818.2299 3 Aug 24211
2017 34537.7964 9 24212 1718818.2299 4 Sep 24212
2017 38238.92 10 24213 1718818.2299 5 Oct 24213
2017 55374.2785 11 24214 1718818.2299 6 Nov 24214
2017 62170.0169 12 24215 1718818.2299 7 Dec 24215
2017 13425.3557 1 24216 1718818.2299 8 Jan 24216
2017 29144.9914 2 24217 1718818.2299 9 Feb 24217
2017 786.0714 3 24218 1718818.2299 10 Mar 24218
2017 9821.4256 4 24219 1718818.2299 11 Apr 24219

Reply from Alex Hedley:

This blog post may help.
Show Just This Thread        Post Reply
Read Different email different addresses by Richard W @ 4/17/2018
I have a NameT and an AddressT.  If John Smith has two or more addresses, how to I keep "John Smith" from being listed for each separate address (and the same problem occurs with email addresses, telephone numbers etc).

Reply from Alex Hedley:

I'd have these as SubForms and only list the none duplicate data.
Show Just This Thread        Post Reply
Read Training Database by Gina D @ 4/14/2018
Hi Alex/Richard,
I've created a Training Database and need help. I would like to have a subform populate with all Mandatory & Recommended Training required for that Position Title when I select it in my ComboBox on the main form. I also need to use this form for any other additional training & qualifications the employee may have completed or previously obtained. In addition, some training has timeframes for when it must be completed from date of employment.
1. EmployeeID
2. Course Category
3. Course Name
4. Course Requirement (Mandatory (Red) or Recommended (Light Orange), Completed(Green))
5. Course Duration (1 day, 2 days, 1 week etc...)
6. Course Due Date (the expiry date from date of employment)
7. Obtained Date
8. Expiry Date
9. Course Provider
10. Subject Expert

You help would be greatly apricated   also if you have free already covered something similar please let me know where I can find the training.
Many thanks
Gina D

Reply from Alex Hedley:

Have you created your Queries to get the information you require?
You can then create SubForms displaying this information, filtered on EmployeeId.
Show Just This Thread        Post Reply
Read Access 323 Student Test Taker by Gioia H @ 4/14/2018
Hello, I'm trying to modify this for my needs for multiple surveys. I want it to say what Question # I'm on. I used a Dcount to get how many questions based on my survey ID but I can't figure out how to get the number of the question I'm on. I.E. Question 4 of 20... What code/function can I use to get the current question #?

Reply from Alex Hedley:

You might be able to use Form.CurrentRecord property.
Show Just This Thread        Post Reply
Read Capturing the value from a Parameter driven Query by Richard S @ 4/10/2018
Hi folks,

Sorry for the long post...

I have a Query that asks for a parameter.  Once the query has run, I want to export the resulting records to an Excel spreadsheet, using the value of two fields as part of the new spreadsheet naming convention.

I'm still something of a "newbie" in VBA, so am struggling on how to capture the value of a text field named "ORG"  and another text filed named "Campus_Dept".

I have tried DLookup, but keep getting a "3326 - Recordset is not updateable"  error message.

I have over 100 "ORG's" to process... and will end up repeating this whole evolution about every 2 months or so.

Please advise how best to be able to capture the actual value of these two fields  "ORG"  and  "Campus_Dept"  from a parameter driven query that will alwasy return at least 1 row.

Much appreciated & till later,
Rick Stockstill
San Antonio, TX

Reply from Alex Hedley:

You could add those values as a column to your Query then when you export they'd show, but they'd be there for every row.
Show Just This Thread        Post Reply
Read Inventory by Julio S @ 4/9/2018
Where I can find training in how to create an inventory database which tracks item quantities?

Reply from Alex Hedley:

The Work Order Seminar may cover what you need, check out the Outline and summary video.
Show Just This Thread        Post Reply
Read Mouse right click stopped working by Bob W @ 4/5/2018
A couple days ago, the mouse right click stopped working in form title bars in both of the databases on both of my computers.  It works on file names in the list of tables, queries, and forms.  I added "Edit,", "Datahsheet," and "Sql" to the quick access toolbar.  That works.

Was there a windows update or Office update that broke Access?

Reply from Alex Hedley:

Is there anything on the MS Forums?
Show Just This Thread        Post Reply
Read Microsoft Access Forum by Richard W @ 4/2/2018
I am making a simple database to use to collect customer survey info. My plan is to have a main form with a sub form of questions with yes no check boxes for answeres. I am having trouble getting the sub form to display all 20 questions.
Thanks in advance for the help

Reply from Alex Hedley:

The Web Database has a Test Taking example.
Or Access 323
Show Just This Thread        Post Reply

Show Older Posts         Collapse All Topics


Post Your Comments or Subscribe
    If you would like to be notified of new posts on this forum,
    just enter your email address below. It will be kept private.
If you just want to subscribe to get email updates when this forum is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 7+2:
  Notify me when the this forum is updated
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



You may want to read these articles from the 599CD News:

3/23/2018Microsoft Access Developer 7
2/22/2018Microsoft Access Developer 6
2/22/2018Access Assistance Available
2/21/2018Putting Access Databases Online
2/18/2018Microsoft Access Developer 5
2/10/2018Microsoft Access Developer 4
2/1/2018Access Tip: Salary History
7/19/2017Access Developer 2 and 3 Released
7/19/2017Microsoft Access Developer 3
7/19/2017Microsoft Access Developer 2

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