Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
Home > Forums > Access
 
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 can post here. If you'd like to become a student, all you have to do is enroll in one of my courses, which you can do for as little as $1. 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.

NEW: Access Developer Students, make sure you subscribe to the Developer Student Forum.

Click Here to Post a comment and start a new discussion

Please read the FORUM RULES before posting.

 

Refresh or Requery Upload Images   Link 
Mark Desens 
2 months ago
Hi I just signed on and paid for the beginner level 2 not quite the expert yet. I need help with my tables. I am building a database for my nonprofit organization. I have one table named volunteer signup, these volunteers will be added to our list inside the database. Now I got that table in a form view and when I add volunteers in clears the form out to add volunteers to a volunteer signup query. As they signup using the form the query doesn't automatically add the person I need to refresh the query to see them. How do I make the query add them so I can see them without refreshing it?
Adam Schwanz
49 days ago
If I'm understanding what you're asking... You're saying you have a form and when you add a new volunteer it doesn't update until you close and reopen it? You should just need to me.refresh

Access Tip: Requery v. Refresh
Mark Desens
49 days ago
Hi Adam, I have one form and one table called list and a quarry made from the list. I fill out the form with new volunteers and press save button, it fills in the list automatically but not the quarry. After investigating a little more I finally got the quarry to auto fill with the people I add from the form. Now I just need the form to clear so I can add new people but it doesn't clear. How do I get the form to clear now.
Adam Schwanz
49 days ago
I'm still not sure I follow exactly what you're doing, maybe a picture would help if you use the upload images button to the top right of your post?

So you're filling out a form that is bound to your table? If so you just need to go to a new record.

If it's unbound fields, you just need to set the value back to "" in the save button. FieldName = "" for all of them.
Mark Desens
49 days ago
Hi Adam, after several hours yesterday Sat and part of this Sunday morning I finally found why it wasn't clearing. Yes your right. I was doing it while my signup form in design view in the Property Sheet. I should have been in the command button wizard and select like you said new record, which cleared the form. Thanks. Now in my Counseling log form I put the save record button there too correctly this time, but some of the fields are not clearing. I watched Richards video on how to make a table with the explanations of the Data Type. I learned a lot from that. Now after I watched I chose each field with the data type. After filling it out for practice I saw that the name and notes were not clearing, which the data type is short text nothing special added to them either.
Mark Desens
49 days ago
Hi Adam again, I am learning little at a time. I put down that my Counseling Log form wasn't clearing all the way. Well after redoing the ones that are not clearing. finally it is all clearing. Thanks.
Adam Schwanz
49 days ago
Glad you got it figured out
Mark Desens
48 days ago
Hi Adam, I'd like to buy the expert training videos but I need permission from my Director. Until then I have a question. I made another table/form for my Director to view all records but one at a time, however I'd like for the records to open in a secondary window so she can move that windows around to view the records with a next button and a back button too. What do you guys call that?
Richard Rost
48 days ago
Mark, watch this: Blank Database Template
Mark Desens
48 days ago
Thanks Richard, I'll watch it as I get time.
Mark Desens
47 days ago
Thanks Richard I did watch it last night but only half of it, I was falling asleep. Now I am trying to put together 4 forms into a report. Could I use 4 tables to create the 1 report or should I create the quarry from the tables and create the report?
Kevin Robertson
47 days ago
You can't create a report from multiple table without first creating a query. Build your query first, then use that to generate your report.
Richard Rost
47 days ago
Falling asleep? Are you saying my videos are boring? Damn. You sound like my girlfriend. LOL

And yes, like Kevin said, you should join your tables together in a query first. Make sure that looks good. Then build your report from that. You COULD do it without a query but that would require subreports, and you're probably not ready for that yet.
Mark Desens
47 days ago
what video/video's do you recommend to watch about relationships. One to one, one to many, many to many. Another is understanding the property sheet layout with the 4 tabs. For starters.
Mark Desens
47 days ago
Hi Richard and everyone else. I just bought the expert level 2 about relationships. I like all the videos I did watch. Time to learn more now. Thanks!
Richard Rost
46 days ago
Expert 1 & 2 spend a lot of time on relationships. There's also the Relationships Seminar.
Mark Desens
46 days ago
Hi Adam, Richard and Kevin. In my database when I showed my Director she asked me a question. First our nonprofit is a suicide hotline and we record each call we get to the counselor who is helping the caller. The counselor operates on a 4 hour shift. My Director is asking when the Counselor comes in on their shift and logs in the counseling form comes up after pressing login, but their name is not automatically on the form. How can we get the counselor's name who signs in on their shift to automatically come up on the counseling form. Thanks.
Richard Rost
46 days ago
Do you care about tight security? In other words, can you trust your users to just pick their logon name from a list and not "cheat." If you need tight security, you'll need my Security Seminar. If you trust your users then you can create a simple logon form and get their username that way. I cover that in the Extended Cut for the Database Password video. Or you could even just make a form with a combo box that has all your users in it and they can pick who they are. OR you could get their Windows logon name. There's a million ways to do it - and it all depends on what level of security you want.
Mark Desens
45 days ago
Hi Richard and yes your right, lot's of ways to do it. Me and the Director needs to go through that and discuss how we need to secure it. Possibly with no security now, Don't know. We have a talk about that. Thanks for the information.
Mark Desens
44 days ago
HI to all, I saw this before and should have wrote it down. How while creating a table as one of the fields is labeled phone number do you automatically insert the brackets and dashes so all you need to do is put the phone number.
Kevin Robertson
44 days ago
Use the Input Mask Property for the field.
Mark Desens
43 days ago
Thanks Kevin, I saw that a few hours after posting my message. Now to anyone who can help me understand this. I have watched the video/video's on relationship. I have watched other video's on relationship. I am trying to do the relationships on my database for my tables. But still I just don't get how to do it. I have watched several video's of them from different people from 2 weeks ago and I just don't get it.
Kevin Robertson
43 days ago
Relationships
Scott Axton
43 days ago
Mark -
It kind of seems to me like you are hippity hopping about a little bit.  
I understand that you are excited to learn and see something you want to try -- BUUUTTT...  I want you to succeed and not be frustrated.  
You, by your own writing, have gone from beginner lessons to expert lessons to advanced concepts in the matter of about 8 days from what I can see.

I use the analogy of driving.  You would never just wake up one Friday morning and say, "I've never driven before but I think I'll get in the car at 5 PM and hop on the highway during rush hour to learn."

My advice (AND Richard's teaching) is sit down and watch the videos through the first time with out doing anything, other than maybe taking notes.  Let it soak in.  Then watch it again and DO the database as he's teaching it.  That is the fastest way to lock it into your brain.

The second piece of advice I have for you is don't skip around. Don't do yourself a disservice by not getting the basics down before moving on.
Mark Desens
43 days ago
Hi Scott and thanks for the advice and yes I have done that and I did make the tables and queries following his training. I did watch them and understood them. But even before I made forms I watched several video's about relationships. 2 friends of mine where I live help me understand little basic stuff several years ago about tables. Roberts video's in the beginners level 1 and 2 made more sense about the fields in the tables. Then when he talked about the relationships with the tables he made was like a foreign language as I listened. Looked at more video's about relationships from different people and still as they were describing them a little more it still no sense.  I think the way I need to go is a different approach, someone look at my tables and I explain our tables and they give their idea about how to do the relationships.
Mark Desens
43 days ago
After reading your note Scott I went back to my relationships table and looked at it. I am now seeing the first part of it. One table has a list of all workers. All workers are not helping people on the phones. Part of the workers are Receptionist that take the calls and pass them on the workers. One table has the Receptionist for one worker. Another table has one worker for many calls. That worker is worker 1. Anther table has the shift worker 1 is on, which is a 4 hour shift. I hope this makes sense to you. Now 4 tables. One table feeds the other 3 tables. One to many relationship. Now should I make 2 tables instead of one. One for the Receptionist and one for the workers? or could I just keep them all on the same table? Note-Some workers act as Receptionist until they get someone who will reception for them.
Scott Axton
43 days ago
Think of it this way.
Say there are 10 houses on your street. If you live on Oak St.  How do you tell some one where you live?
The easiest way would be you address #.  You live at 123 Oak St and 1 is the "id" of the house.

So if you have a people table.
PersonID  1 = Mark
PersonID  2 = Sue
PersonID  3 = Joe

The way to "relate" or associate the people with the house is to add a Foreign Key (the PersonID)
to the house table.

HouseID  PersonID  Street
1             1             123 Oak St
2             3             454 Main St
3             2             777 Oak St

So Joe (#3) is related to HouseID 2 - 454 Main St.
and Sue (#2) belongs to HouseID 3 - 777 Oak St

Remember the id's are just for Access to use.  NOT you.  It tells Access that this is a unique record and that is how it knows the relationship (in a nut shell) to the other records it the other table.
Does that help?
Richard Rost
43 days ago
Mark, people are people. You can assign them different roles. For example, you have a sales person, a service technician, and a customer service rep. All of them go in your EmployeeT. However your customer might be assigned each of these three people in different roles. So... the customer table might have:

CustomerID: 100
FirstName: Joe
LastName: Smith
SalesPersonID: 1234
ServiceTechID: 4567
CustServID: 2554


Each of these are links to an EmployeeID in the EmployeeT table. They're all just different employees in different roles.
Scott Axton
43 days ago
Reading you last message it is not exactly clear what you are trying to accomplish.  Try and tell me like I'm a 3rd grader what it is you are trying to do or track.
You may actually have extra tables.  
Is the receptionist not a worker to?  It's all semantics.
The calls belong to the Client or person you are helping (in my mind).  Not to a Recp. or Worker.
Maybe take a look at the Customer Contact Template.  That might help you.

I really recommend you looking into the memberships Richard offers for the Tech Help.  For the price of a Starbuck coffee (a month) you get TONS of resources in the extended cuts that you don't see in just the free videos.


Mark Desens
43 days ago
Hi Richard and Scott. Hey Scott sorry for coming across that way, didn't mean to. And thanks to the both for the help. I do understand a little more but still I just need to keep watching those relationship video's until it sinks in and yes I need to look into the tech help also. Thanks again.
Mark Desens
42 days ago
Hi Richard, I was looking at some of the seminars and advanced classes and wow the stuff you can do in access is tons of it. My Director is asking about security. I saw a Youtube video on how to password protect the access application in order to go into and keep working on your database, very impressive. Now she is asking when new people come in and use the database for the first time and we show them how to use it and input their name and address and login. Does any of your advanced classes teach how to input a code so when one of the new users input their name and address it will pop up a windows asking them if they want to create a password to protect their data? then they can put a password of their choice in so next time they log in then they just input their password and go to their data.
Adam Schwanz
42 days ago
Did you watch the Security seminar? That thing is awesome for doing stuff like that.

You could just make an inputbox that pops up and asks them to set the password, then set their password in the user table to that value.
Mark Desens
41 days ago
This is another question from the Director as I showed her a little progress. It is about the time spent on a call. I heard from the beginner video's that using a calculated field in a query is better. I watched a video that does date diff in the query but as I opened my table up it does a pop up and wants me to input the time first and end time before the table opens. Is there a way to code it in the query when people open the table and put the start time and then the end time on that call, it will then tell you the time you spend on that call after you put the time in first?
Scott Axton
40 days ago

Scott Axton
40 days ago
Mark -
The short answer is yes.    See:  Time & Billing

Do yourself a favor - Get to know the site a bit better.  Richard has spent countless hours providing one of THE BEST websites I've ever seen for information.  There are multiple ways to find what you are looking for:
First the Search Box in the upper right corner.  Second down at the bottom in the Learn section the first choice is Access Index.  Third, Goto the TechHelp videos page and press Ctrl-F and put in your search term.
I guarantee that your question has probably been asked and answered multiple times.  We're happy to help on specific questions but can't possibly play what if....
If you need development assistance that is available too for a price.  See: Microsoft Access Developer Network

.
Richard Rost
40 days ago
Mark, this is what you need: Get a Value from an Open Form

You make a form. Put two fields on it: StartDate, EndDate. Use these as criteria for your query. Also watch FormName. Just keep watching the lessons. I see from your account that you skipped around. You didn't finish all of the Beginner lessons. There's a lot of good stuff in there, which is why I suggest people DON'T skip levels.
Mark Desens
38 days ago
Hi Richard and thanks for letting me know I went back and yes your right I didn't finish watching. Now I need to finish that lesson and keep on going little at a time. I tried going into the courses but it gave me an error. I had to go to my courses in order to finish watching. Can you refresh mine account?
Scott Axton
38 days ago
Mark -
Richard is out of town for a couple of days.  It's not you - There is an issue with the web pages.
I believe he's due back today or tomorrow.  Hang tight.
Mark Desens
38 days ago
Hi Richard and everyone else. I really enjoyed the video on making the list form and a button to see s specific form from the list form from inside the list form. I showed my director and she really liked the way you displayed it. The list form as a pop up and the specific record from the list form as a pop up too. Now I had to redo the list and the specific form to show in more detail like she was asking but now the list form does pop up but the individual form doesn't pop up again, that individual form comes up on that windows and I have to X out of that form to open the list form again to select another individual form. I cannot figure out why the individual form won't pop up like the list again.
Mark Desens
37 days ago
Hi, I finally caught on to what happened. As I was watching beginner level 7 video after work the continuous form 1 it explained it. to make a form first then the list form and link the two together. Then it will pop up separately. Thanks very good teaching.
Mark Desens
37 days ago
Hi what video shows more information about the form fields? Format, Data, Event, Other and all?
Mark Desens
37 days ago
The Form property sheet not form fields
Scott Axton
36 days ago
Property Sheet Overview
Mark Desens
35 days ago
Hey guys i have a problem here, I went through one of my query and checking out video about datediff. I did the run under design tab and it did work good but then I pressed the wrong button. I pressed the update button and not the run button, got a lille excited about the datediff working after several attempts and finally got it while watching the video. Is there anyway to turn update off until I know more about it.
Scott Axton
35 days ago
Ummm....
Now could you try that in English?
Richard Rost
34 days ago
Yeah, sorry Mark, but I've got no idea what you're talking about. And if you have a new DIFFERENT problem, it's time to start a new conversation thread (below). This one's getting pretty long. :)
Add a Reply

Show All Comments

Start a NEW Conversation
 
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:

9/19/2021Project Management
9/17/2021Overlapping Windows
9/16/2021Inventory
9/10/2021Benefits of Access
9/10/2021Access on a Phone
9/5/2021Prevent Deletion
9/4/2021Booklet Template
9/4/2021Inspections Template
8/29/2021What is Microsoft Access?
8/27/2021Union Query
 

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
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: microsoft access forum  PermaLink