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

Welcome to the Microsoft Access Forum. Access is by far our most popular topic here at Computer Learning Zone. This forum is for everyone to read but only students (paid customers) can post here. If you'd like to become a student, all you have to do is enroll in one of my courses. After you create a logon, you will have full access to the Forums.

Subscribe to this forum and receive an email update whenever new posts are added. You will also be notified by email if any conversations you are involved in receieve new comments. Yes, even non-students can subscribe to update notifications.

Having problems with your Access database? Before posting your question, check to see if it's already been answered. You can use the Search feature to look for keywords. There's also the Access Troubleshooting Checklist which covers solutions to many common problems. If neither of those things help, make sure you post exactly what you're doing, what the specific error message is, what you've tried, and any other details we might need to help you. Don't just say, "I get an error." Tell us what the error is and what you're doing. We're not mind readers. I wish. LOL

Click Here to Post a comment and start a new discussion

 

Set Focus Link 
Michelle Seidelin 
2 days ago
Hello Richard

Just can't remember which lesson or tech help video you showed how to set focus to a certain field e.g. first name now that I have the DSUM working to get the next number instead of having the auto number is my customer number which you course which was caught way back at the beginning on level I now that I am trying to make it better I need to know which lesson to give the focus to the first name field is there is another field before that I don't want to set the tab to this one as I need to be able to use the first field when I need to Read More...
Richard Rost
25 hours ago
Use either Control.SetFocus or DoCmd.GoToControl

SetFocus / GoToControl
Michelle Seidelin
14 hours ago
Hello Richard I notice the set focus shortcut you have given me is to develop the 13 I am only up to develop a six as far as purchasing and only up to expert 12 as far as building can you suggest an easier way of setting the focus I tried to fiddle around with the tab order and the tab order seem to change okay I wanted to start on first name but when you go to a new record using a new record button which is the way it set up at the moment on the customer table/customer form there is no sign of the flashing cursor until I push the tab key any suggestions thanks for all your help

Michelle
Add a Reply
Record Source Disappears Link 
Abraham Breuer 
2 days ago
Hi Richard!
I am having problems when selecting my record source for my form, I select a source but it does not appear to work it just stays blank
any Idea what's going on???
Richard Rost
2 days ago
Sounds like this falls under "weird stuff" to me. Run down the Troubleshooter.
Abraham Breuer
2 days ago
the solution was: Restart Access. Close and restart your database!!!!
thank you very much
Add a Reply
Customer Numbers Existing Link 
Michelle Seidelin 
2 days ago
Hello Richard and Alex

Is there a way of inserting customer numbers automatically from the description you given at this website https://599cd.com/tips/access/incrementing-your-own-counter/
Read More...
Richard Rost
2 days ago
I don't think I covered how to do this for existing customers. It would be a little more challenging, probably beyond a TechHelp video. A simple DMAX won't cut it for existing records. Probably best done with a Recordset loop. I'll add it to a Developer class soon.
Michelle Seidelin
2 days ago
Hello Richard

Thank you I fought a bad later on and be easy to do it by just putting the numbers in even though there is 400  numbers it shouldn't take too long to type 1 to 400 in is it how many customers I have my business is nothing like yours is this the small home business
Add a Reply
Separate Username from Email Link 
Emad Al-Baghli 
2 days ago
I have a lot of E-mails I want to extract "user name", for example first column "emadb@gmail.com" and the other column will be only "emadb"
Thanks
Richard Rost
2 days ago
One of my Gold Members just asked me this question a few days ago. It will be a TechHelp video shortly. It's basically some string functions: InStr, Left, Right, etc. Hang in there.
Add a Reply
Access Backup Itself Link 
Nancy Troutman 
3 days ago
I really like how Access runs after splitting the database.   But I hate the weekly chore of opening each of the backend databases to create a back-up.   Online instructions only back-up the front-end.  Is there any way to tell Access to back-up itself automatically, lets say every Friday at 10pm or something like that?  With the date as part of the back-up name.
Richard Rost
2 days ago
Yeah, you can have Access backup the back-end files. I actually have a routine that I wrote for my own database that I am planning on releasing as a template very soon. I wanted to let it run in my office for a few months to make sure there were no glitches. It's been running fine for about 6 months now, so I'll release it soon. Essentially as long as none of the back-end tables are IN USE, it works fine. Otherwise the file is skipped. So you need to make sure everyone is out of the database.
Alex Hedley
2 days ago
You could also create a quick script that runs on a Windows Task Schedule:

You would need to amend the following to copy not move but the initial principles are there
Rename and archive a File
Add a Reply
Gantt Chart Planner Anyone Link 
Richard Rost 
3 days ago
Anyone interested in a Gantt Chart Planner for Access? Good for scheduling and project management.
Add a Reply
Open Form by Combo Link 
Nancy Proctor 
4 days ago
Hi Richard,

I'm trying to figure out how I can open a specific form based on a selection I make from a combo box.

I'm thinking I can somehow build a macro using the IIf function somehow, but I haven't been able to figure it out and it's probably better to write it in code builder using VBA.  Do you have any prerecorded lessons that I can purchase that explain how to do this? Read More...
Richard Rost
4 days ago
How is the form that's opened determined? What are you selecting in the combo box? If it's just that you want a list of forms in the combo box, then that's easy. Otherwise, yes, I would do what you suggest: make an IF THEN block (or a SELECT CASE statement) in VBA and open the appropriate form. Tell me exactly how this form is chosen and I'll help you out. I haven't done anything like this in any of my classes, but it would make a cool TechHelp video.
Nancy Proctor
4 days ago
In my table [TBL_Patients], I have a combo box field named [Cover_RX].  For context, Cover Rx is a medication discount program.  The combo box selections for that field is either "Yes" or "No".  Basically, I document if each patient enrolled into the discount program or not.  On the after update event, if "Yes" is selected, I'd like the popup form [FRM_Cover_RX_Yes] to open.  That form gets it data from the table [TBL_Cover_RX_Yes].  There are several fields in that table allowing me to document information that a pharmacy would need so the patient could get his/her discount on meds.  If "No" is selected, the popup form [FRM_Cover_RX_No] would open with a field allowing me to document why the patient does not have this discount.
I use this in the "where condition =" line in my macro to ensure that info is documented on the right patient: ="[Patient ID]=" & [Patient ID]
Add a Reply
Repeat Customers Link 
Michelle Seidelin 
4 days ago
Hello Richard

In my customer T I have a field called repeat customer which is a checkbox yes no field what is the best way of showing this in a form I was thinking it would be similar to how we set up groups would this idea work or is there a better way of doing this this would be a form on its own no sub form required what I am thinking it would be the customer I and the field called repeat customer is I said which is our yes no field Michelle
Alex Hedley
4 days ago
Which form are you wanting to show this in?
A CustomerListF or a single CustomerF?
Who determines they are a repeat customer?
If its just a checkbox, like you say, why cant you just have that on your form?

Youve mentioned sub form - what data are you wanting to show here? A sub form is for showing related records, for example customer contacts. A customer calls and you add notes about that.
Being a repeat customer is a single thing.
Richard Rost
4 days ago
Yeah, a simple checkbox would do. Why invent the steam engine when a hammer fixes the problem? :)
Add a Reply
Highest of 3 Link 
Joe Hood 
5 days ago
Hello Richard,
I have 3 Number fields on a form. I would like to add a text box that defaults to the highest of those 3 fields. Have not been able to figure a way to do that. Any suggestions?
Thanks, Read More...
Richard Rost
5 days ago
How about an IIF function:

=IIF(Field1>Field2 AND Field1>Field3,Field1,IIF(Field2>Field1 AND Field2>Field3,Field2,Field3))

Should do the trick. :)
Joe Hood
5 days ago
Thank you Sir! Worked Perfectly, your help is very much Appreciated.

Joe
Add a Reply
MS Word Mail Merge Link 
John Orcutt 
6 days ago
using MS Word mail merge instead of Reports in Access
Do you ever cover that in your classes?
Alex Hedley
6 days ago
There's an old tip
There's also an old course Word 201 which goes into much more detail, it may look a little different as it's using old versions of the apps.

You can always use the search to see where it's mentioned on the site: Mail Merge
Richard Rost
5 days ago
Yeah, I covered that EONS ago. I'm preparing to re-record all of my old Word lessons. Hang in there another week or two.
Add a Reply

Show Older Comments...
View in Table Format

Post a New Comment or Question
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

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

1/18/2021Separate Username in Email
1/16/2021Access Developer 24
1/16/2021Access Developer 24 Lessons
1/16/2021Access Developer 24
1/16/2021Access Developer 23
1/16/2021Last Name, First
1/16/2021Latest Templates
1/15/2021Access Gantt Chart Planner
1/14/2021Invoicing
1/13/2021Switch Function
 
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search The Site
Waiting List
Production Schedule
Code Vault
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: microsoft access forum  PermaLink