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

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

Click Here to Post a comment and start a new discussion

Questionnaire Upload Images Link
Leo Rivera
11 hours ago

Rick please give an heads up I am preparing a quality control questionnaire that will be completed for all accounts an I am stuck I do not have idea how to relates this tables. Any idea? Or any course you recommend me to see?

Richard Rost
9 hours ago

Well, I haven't done this exactly. I did create a Test Taker database in Access Developer 9 and 10, which is a very similar format. You basically need a SurveyT, a QuestionT, and assuming it's multiple choice an AnswerT. Then another table to hold the responses. Another option, you could use the ABCD to track questionnaire responses in the Misc Data fields. However, this would make a cool TechHelp video. There are a ton of questions from members in front of you, however. How soon do you need a solution?

Continuous Form Format Upload Images Link
Richard Lanoue
22 hours ago

Hi Richard,
I always forget this. Is there a way to format a continuous form where certain fields on certain records change (as in make invisible) while other fields do not (remain visible). I've done something like this before but always forget how. Read More...

Richard Rost
12 hours ago

Yeah, you have to use Expression Is. See Hide Field Continuous Form.

Blank List Box Upload Images Link
Jacey Cortega
28 hours ago

I just completed Access Developer 8. I'd like to know how to start the list box without any client information. I will have over 300 records and do not want to deal with the extra load time.

Richard Rost
27 hours ago

Good question. You could leave the RowSource property empty when the form loads. And if you really want to speed things up, don't fire the event to requery it until it's length is at least 2 or 3 characters.

Hyperlink Combo box shows URL Upload Images Link
Mark Fannin
30 hours ago

I made a form using a combox box to find open job numbers. The Job Number field is a hyperlink in the table. The combo box brings the hyperlink URL text. How do I get rid of the URL text and just see the job number? Picture attached. I've gone through all the properties and it's driving me nuts. Many thanks.

Mark Fannin
30 hours ago

Richard Rost
27 hours ago

This is one of the reasons I tell people NOT to use the Hyperlink data type. In fact, I'm re-recording Access Beginner 1 now, and I specifically told people NOT to use it for the email address field, which I did the last time I recorded it in 2013. It's just a mess. You have to use the HyperlinkPart function to decode it and pull it apart into its pieces (address, visible name, etc.). I cover it in Access Expert 5. Since you're a Platinum member, I'd be happy to do a TechHelp video on it since I haven't covered it yet. Let me know.

Show 2 More Replies...

How to round a field which sum Upload Images Link
Michelle Seidelin
3 days ago

Hello Richard.
please look at the photo above as you will see I have been able to divide the minutes giving me the right amount of minutes except minutes come out at 2.45 to get this total I divide the total minutes by 60 but I don't know how to round the last part where would the round go I've tried a couple of places and not sure do you have any videos on how to round a sum these results show up in a form as you can see not a query or data view will uploao phota as soonit lets me Read More...

Michelle Seidelin
3 days ago

Have done more tests and discovered things are not as close as I thought they were when I put in a 30 minute AND it comes out wrong what I have done of course the void maximum minutes divided by 60
So there must be a more accurate way to do this hope someone out there can help

Show 8 More Replies...

Michelle Seidelin
3 days ago

I have done some more work on this problem and I have worked out as coming out at a fraction of an hour not minutes as I thought it was if anyone want me to send the query and form to them as I can build the information themselves and a safe database please contact me I can send the query to you is photos as you are able to duplicate the query

Richard Rost
2 days ago

Don't work with fractions of an hour. Figure out the total minutes per record. Add those up. Now you've got a number like 150 minutes. Integer divide by 60 to get 2 hours. Subtract the difference to get 30 minutes remaining.

Richard Rost
2 days ago

Access Expert 8 (which you have) has an employee work log very similar to this.

Michelle Seidelin
2 days ago

sending u a email

Richard Rost
2 days ago

Please don't. My inbox is overflowing. As I've explained numerous times... if you need tech support, you can post here in the Forums or use my Tech Support page. I don't have time to answer a million questions when I have already covered this stuff in my videos.

Adam Schwanz
2 days ago

I would make an unbound field called TotalMinutes on your form, and put this in it assuming your SUM fields are called HoursWorked and MinutesWorked.

=(HoursWorked*60)+MinutesWorked

Thatll give you the total minutes.
Then I'd make another unbound field and put this in it

=[TotalMinutes]\60 & Format([TotalMinutes] Mod 60,"\:00")

On your screenshot, this would return 72:27 (72 hours and 27minutes total)

If you just want to round your own sum field, just use the round function, do something like =Round(Sum([MinutesWorked]/60),1) to round to 1 decimal or 0 to round to 0.

Alternatively you can just do \60 instead of /60 to round to integer.

Richard Rost
36 hours ago

Here you go: Timesheets

Michelle Seidelin
30 hours ago

Thanks

Clearing Combo Boxes Upload Images Link
Joseph Messina
3 days ago

Hi Richard:

I was watching Beginner 8 in my courses. I see in beginner 8 has how to create combo boxes and also to use a combo box to search for a record in a database. How can i clear the combo box after I search for a record?

Richard Rost
2 days ago

At the Beginner level, with that kind of a combo box, you really can't. You can do it at the Advanced level with a macro, or some VBA at the Developer level using an AfterUpdate event.

Joseph Messina
2 days ago

I understand what you are saying. I was able to get it work to clear the combobox after i do a search. I created a button to clear it and wheni click the clear button clears the combo box and and data in the form and also created a button to show all data again. The combobox i have in my form for contact name to search for contact it field I have in my contact table labeled contact name. I have lastname and firstname. I would like to have the combo box in my form to show contacts names not be able to enter the new contact in the combobox every time i neter a new contact in my contactf. I don't want to go back to the table to enter the contact in the contactname field. I wnt to have the combobox with lastname, firstname and for the contact to go in the combobox after I enter new contact in my form so I don't have to go back and forth from the ContactF back to the ContactT everytime. I understand if you are very busy and swamped. If you want me send you my database so you ca se

Show 7 More Replies...

Joseph Messina
2 days ago

I know will be paid techhelp if you can look at my database. That why I'm asking you first before i fill out the form and send you my database.

Richard Rost
2 days ago

No. Looking at your database is not "paid TechHelp." TechHelp has to be a question in the form of "how do I...?" Troubleshooting your database or fixing your database or adding things to your database is not TechHelp. And as my Consulting page says right now, I'm completely booked up. I don't have time to be looking at files. Sorry. What you need will probably involve a little programming which is probably beyond your skill level right now. Keep learning. Keep watching the lessons. Work your way up through the Expert series to the Developer series, and you should have a better understanding of how to do this. For me to just keep answering your questions with answers that are over your head does you a disservice. I WANT you to learn this stuff. That's what you're here for. But you have to learn how to walk first before you can run.

Richard Rost
2 days ago

It's like explaining nuclear fusion to someone from the year 1500. They just don't have the science background to comprehend it. You need a better understanding of combo boxes and relationships before you jump into event programming and VBA.

Joseph Messina
2 days ago

I truly understand what you are saying to me. You are right. I will continue to lear. I love learning new stuff and different things. I'm starting to watching beginner level 9.

Joseph Messina
2 days ago

Sorry about that Richard. Again, I truly understand what you are saying and will contnue to learn and watc the lessons I get. I love watching the lessons and videos and learning.

Richard Rost
2 days ago

Please don't think that I'm being rude. I'm not. I'm just trying to explain it as politely as possible. I had the same situation with my daughter. When she was about 8 or 9 years old, I took her to see a movie. While we were waiting for the film to start, she asked where the Moon came from. I did my best to explain to her that about 4.5 billion years ago, a Mars-sized planetoid struck the Earth and most of our mantle ended up in orbit, slowly coalescing into what we have today as the Moon. She gave me a blank stare and proceeded to eat her popcorn. Without a good working knowledge of some basic astrophysics, what I was explaining to her was meaningless. Today, she knows that stuff pretty well after years of schooling. Keep learning. You'll get there.

Joseph Messina
2 days ago

ok I see what you are saying. I will learning and I know I will get there.!

Late Binding vs Early Binding Upload Images Link
Ray White
3 days ago

Late Binding vs Early Binding..
What is it and when to use one or the other?

Richard Rost
2 days ago

Good topic for a video! Give me a little bit to present this topic... properly. :)

String Function Upload Images Link
Tim Schmidt
3 days ago

Could you assist me in what I am doing wrong in the following. I am just trying to add a * at the end of a text field named LastName so that the total lrngth will be 50.
= [LastName] & & String(50-Len([LastName],*)) Read More...

Richard Rost
3 days ago

In the AfterUpdate event for that field, try this:

LastName = LastName & String(50-(Len(FirstName)),"*")

That's if you want to CHANGE the field. You could always just use a query to display the data that way.

Richard Rost
3 days ago

I'd throw an extra space in there too, and use a Monospaced font (like Courier) if you want all the letters to be the same width.

Show 2 More Replies...

New Developer Student Forum Upload Images Link
Richard Rost
4 days ago

Hey guys. I just set up a new Forum for Access Developer Students. If you're still at the Beginner or Expert level, this Forum is fine for you. The new Forum is to discuss topics at the Developer level (upcoming class material, etc.)

DevOps Upload Images Link
Alex Hedley
5 days ago

Found an interesting tool:
DevOps

Could work well alongside the vcs

Ray White
4 days ago

Is DevOps a custom Access install builder to install your custom Access Apps to end users?
Never heard of it.

Ray White
37 hours ago

Alex Is DevOps a custom Access install builder to install your custom Access Apps to end users?
Never heard of it

Show 2 More Replies...

Show Older Comments...
View in Table Format