Access 2007-2019
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  


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 data in a single form to two tables by Les S @ Wed 10/30
Is there a way to set up a form as to when information is entered in a field it populates in two different tables?
Show Just This Thread        Post Reply
Read 2000ish record in DB by Mohamed Hashem T @ 10/7/2019
Hi all,
I am tring to build a database for an IT vendor where I exported the Partners database ( 2000ish record) I also exported another list of Partners( 450 ish record) purchased the last 4 Qs.
I am trying to link those tables together. As per Access Expert 1 the instructor was adding the Contact ID to the Customer ID manually and obviously I wont be able to added in a 450ish records 1 by 1. How to create the relationship.
Show Just This Thread        Post Reply
Read OLE Object by Dan C @ 10/3/2019
I have office 356, and when i try to drag and drop a bmp file into the OLE box on a form all i get is an icon no photo. can someone please tell my this does not work the same as is does in the lesson.
Show Just This Thread        Post Reply
Read Microsoft Access Forum by Joseph M @ 9/26/2019
Is there a way to programmatically assign a table name to a table created by a make table query? I would like to be able to append a date to the name of the table for easy reference. I thought I heard Ric say there is a way of doing that and he would include it in a future class. Has he done that yet?
Show Just This Thread        Post Reply
Read Combo Box by Mohammad H @ 9/25/2019
my database is a bit different than the example you shown. I have some companies who are my clients and there are some employees working in different positions within these companies(clients). One client can have many employees whom I want to create a contact history. now I created two tables one for companies and the other for their employees. How to create a combo box showing both company name and its employee on the contact history form. I cannot figure out this.
Show Just This Thread        Post Reply
Read Drag and drop the edge of a window by Eric M @ 9/24/2019
Since my office computers were updated I have noticed it is extremely hard to resize anything in access.

Move you mouse to the edge of a form click and drag to make it wider?

Seems simple enough.

BUT... since the update it is almost impossible to get the pointer on the exact spot where the mouse pointer changes to the double arrow so you can click and drag.
Show Just This Thread        Post Reply
Read Up and Down Command button Picture by Eric M @ 9/24/2019
I would like a command button that when clicked, the arrow changes direction up and down.  and then based on the direction, it does something.

Currently, I make this work by placing two buttons directly on top of each other so it appears as the same button and has the code.

Private Sub Qa14SortDB_Click()
    Qa14SortUB.Visible = True
    Me.Qa14SortDB.Visible = False
End Sub

Private Sub Qa14SortUB_Click()
    Qa14SortDB.Visible = True
    Me.Qa14SortUB.Visible = False
End Sub

Can this be done with one button?

If so, how does on change the direction using VBA.  And then how do you sort a field from the direction of that arrow?
Show Just This Thread        Post Reply
Read Many to Many relationship by JR @ 9/19/2019

This one is a hard nut;

I want to fill out a Workshop order.
I use a WorkOrderTable and a EmployeeTable

This order will be received by one empoyee, it will be designated to one employee, and it will be signed out by one employee when the workorder is done.
(The "one" employee can be different persons from the EmplyeeTable)

So how I put up a relationship with these conditions?

(I believe I must have a junction table, but how do we connect these?)

Thank you
Show Just This Thread        Post Reply
Read Email Seminar Send Email Without Outlook No L by John M @ 9/17/2019
I built the BulkEmailF and it has worked perfectly until recently.  I now receive a run-time error message as soon as the first email attempts to send:
Run-time error 2147220975 (80040211)
The transport error code was 0x80040217. The server response was not available
I have confirmed that the Gmail account is active, the password is correct and the code has not changed since it previously worked.  Any ideas?
Show Just This Thread        Post Reply
Read Access Calendar Seminar by John D @ 9/13/2019
In the sub s1 = "Date" & X
S2 = "Day" & X

x being the counter
Show Just This Thread        Post Reply
Read Monthly Calendar Seminar by John D @ 9/13/2019
Just finished videos for 2nd time and completed Monthly Calendar. All worked well except greying out boxes on Monthly Report. Code is same as video and is in detail section of report. Using Access 2016, Win 10. Can Rick take a look? Thanks  John
Show Just This Thread        Post Reply
Read Long refresh when VBA editor is active by Jan H @ 9/13/2019
When I use the database as a user the refresh time is resonable and the refresh does not happen so often. However, as soon as I open the VBA editor the refresh time is long and VERY often. If I close the VBA editor, the bad behaviour continues.
Is there something I can do?
Show Just This Thread        Post Reply
Read Database templates by jannette j @ 9/12/2019
I want to create like 3 database templates so my clients can choose what database format they would like. one with VBA code and all. I just do not know how to get started. I am trying to move more users in the plant where i work towards Microsoft Access and not so much to Excel. I thought if i can wshow them how great access is they would migrate over.
Show Just This Thread        Post Reply
Read Month to date sum by Wenyuan C @ 9/7/2019

Is there any way to sum month to date value?

Show Just This Thread        Post Reply
Read Microsoft Access Forum by Les S @ 9/5/2019
I am presently on Access Expert 4 part 3 Extended Customer forms. When I enter the address for a picture in the picture text field I keep getting Invalid control Property:Control Source and Not such field in the field list. I copied and pasted the path to the folder so I know that is correct. Any ideas on why this won't work?
Show Just This Thread        Post Reply
Read Copy and paste by Kalyana K @ 9/5/2019
Yes you can copy paste debase normal copy paste. if you need create folder and copy
Show Just This Thread        Post Reply
Read Microsoft Access More Users by Kalyana K @ 9/5/2019
You can learn lots of things. Crate table, forms, Query, Subform, Report, Analysising etx,.
Show Just This Thread        Post Reply
Read Printing single report by Stacy H @ 9/4/2019
Hello, is there a way to only print a single report (using a primary key) instead of having to print all reports? Other than setting pages on the print options, I would like to open a report specific to the primary key and print it.
Show Just This Thread        Post Reply
Read Microsoft Access Forum by Kenneth M @ 9/2/2019
I'm not sure if you covered this or not, can Excel formulas be used in Access?? .  For example: I have a formula of =IF('TrainingDate'="",180-TODAY()-'RegistrationDate',""). My students check into a course and are required to complete the course within 180 days. What I would like Access to do is to calculate the days between the two different dates and then display that number in another field, like days between and to toggle a yes/no field if students are over 180 days.
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 3+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:

8/15/2019Last Chance for Access CDs
8/1/2019Customer List Form Template
8/1/2019New Template Access Customer Database
7/30/2019Microsoft Access Developer 13
6/20/2019TIP: Validation Rules in Access
11/20/2018Microsoft Access Developer 12
8/25/2018NEW: Access Dev 9, 10, 11
8/25/2018Microsoft Access Developer 11
8/25/2018Microsoft Access Developer 10
8/25/2018Microsoft Access Developer 9

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
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