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 > Help > AccessDev.NET
 
AccessDev.NET AccessDev.NET

Microsoft Access Developer Network

Welcome to the Access Developer Network. I get tons of requests for help. Too many. While I love helping people, there are only so many hours in the day. I quite simply am stretched pretty thin between my various projects, and I would honestly spend my time doing what I do best: recording new video tutorials. I'm more than happy to take on TechHelp questions in the "how do I...?" format, or even projects that I can turn into new courses, templates, or modules for the ABCD.

As of February 2021, I no longer want* to accept projects that involve me working with databases that I haven't built myself. I'm happy to show you how to do something new in a video, but I'm not troubleshooting problems anymore. Plus, about a year ago I suffered an injury that left me blind in one eye and gives me random migraines, so it's difficult for me to work too many hours at a stretch. I feel bad promising people help and not being able to deliver on time. I'll still offer consulting services if you want me to build something new for you, or show you how to do something, and I can make it into a video lesson.

However, I know that there are a TON of other Access developers out there looking for work. Some of them are my students! I know that a lot of my more experienced students would love the opportunity to help out the new guys. So, that's why I'm starting the Access Developer Network. This is a Forum where people who need help with their databases can post what they need, and other Developers can help them out - for free, or for a fee. That's for you to decide amongst yourselves. To start out, I'm going to keep this informal as a way to help out both problem seekers and solvers. It's not work I want to do anymore, and I know a lot of you need help, and a lot of you have help to offer. Win/win/win. If this starts to take off, we'll make it more formal later on with an appropriate project management system. But again, let's keep it friendly to start. Help each other out. Feel free to negotiate.

So, if you need help with a database, post your needs below. Be as descriptive as possible. I can't promise that someone else will be able to provide you with assistance, but I've got a lot of Developer-level students who I know can handle most tasks when it comes to Access. If you see the Developer Badge (above, right) next to their name, you know they've completed most of my Developer classes. I'm ONLY allowing my Developer students who have completed most of my classes to big on projects here. I'm also inviting a few other select Access Developers who I know and trust to do good work (a few other MVPs and people I know from other Groups and Forums around the Web). Not just anyone can sign on here and offer assistance (so if you're a developer and I don't know you, chances are you won't be accepted).

Yes, only my students can post in my message forums. So if you're looking to post a project here, you'll need a student account and logon. The good news is, you can become a student for just $1 by enrolling in any of my Beginner Level 1 courses. If you don't need the course, consider it the fee for posting your project in a Forum visited by some of the best Access developers on the Web. I know. I trained them. :)

Developers: if you're interested in picking up some consulting work, 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 receive new comments.

* I'll still provide troubleshooting services if you really, REALLY, want me to. However it's not the kind of work I want to be doing. Therefore, I'll be raising my rates for this kind of work considerably. Everyone has their price, after all. 

 

Search combo box Upload Images   Link 
Abraham Breuer 
6 days ago
What can be the problem?
I Am Having a normal form, tried to make a search Combobox but when I select a value in the search Combobox it does search it just stays on the record like before the search Read More...
Abraham Breuer
6 days ago
does NOT search
sorry
Richard Rost
6 days ago
Impossible to tell without seeing it. Something is set up wrong.
Add a Reply
Multiple Addresses Upload Images   Link 
Joseph Messina 
12 days ago
Can anyone help me with something in my contact database.  I want to try to setup a thing in my database with my email addresses, phone numbers and addresses.  I have contact database and in the form i have basic information like firstname lastname address email and phone numbsers.  With the phone numbers, email and addresses i want to create a subform in the main form that i can click on button address, email and phone numbers that I can have multiple phone numbers, addresses and email addresses for 1 contact like what Richard has in the ABCD database.  Really if someone can give me advise what i can do to have multiple addresses, email and phone numbers.
Richard Rost
11 days ago
The ABCD literally gives you step by step instructions on how to set this up. Are you looking for someone else to set it up for you?

If so, Developers, here you go. :)
Ray White
11 days ago
Are you looking for someone else to set it up for you?
Add a Reply
Developer Services Upload Images   Link 
Mike Thoman 
12 days ago
Combining over 25 years of midrange computer programming experience with a handful of years developing with Microsoft Access, I am ready to provide high quality support at an affordable rate.
Add a Reply
AccessDevNET Upload Images   Link 
John Davy 
13 days ago
Hi Richard, I'll be happy to help beginner and intermediate programmers with Access.

John
Add a Reply
ZipCode LookUp Changes Upload Images   Link 
David Pierce 
14 days ago
Hi All,
Maybe you would be interested in makeing some changes to the ZipCode LookUp Paid version that is on this site. What I would like done is the following:
Remove Edit Button
Replace Txt box "Zip" with a combo, add a not in list event to add, dbl click event to edit. Read More...
Ray White
9 days ago
Hi David
Just a thought on the Txt Box " Zip "
Why would you want a Combo Box?
It will slow down the forms load time having to load all of the Zip Codes in that Combo Box.
After you get 1000s of Zip Codes in that database you will see.
The Zip field already has code to check if the Zip Code is in the Zip database
and if not it will open the ZipLookupF form so you can add the new Zip Code.
And for the " dbl click Zip field event to Edit"
just take the code form the Edit button and place it in the Dbl click event in the Zip field.
Hope this helps.
Ray
Richard Rost
8 days ago
I agree with Ray. Making it a combo box will slow it down a lot once you get lots of records in there. If anything you could make the ZIP lookup text box a search as you type box that populates a listbox or something.
Add a Reply
Code Library Upload Images   Link 
David Pierce 
14 days ago
Hi all, I would like to see someone put together a db of good solid code samples of all the things like NotInList, DblClick, On Enter, on Load,  If Statements, Case Statements, DLookup, and all the things we use all the time but examples of each in different senarios such as filtering a form, not filtering a form, and so on... I would love to see someone who knows more about all these things than I and would gladly pay for it. Just go through the property window and go down the lsit and create this with various examples of different options and explain each one. Let me know if anyone is interested in creating this and a cost for it. I am quite sure it would be worth it.
Richard Rost
14 days ago
Hi David. This is one of the goals of the MyPath learning system that I started building. It's still in its infancy, but what I envision is very close to what you are talking about. If you want to learn about form design, you go to that section and watch whatever lessons you want about that topic. If you want to learn event procedures, you can go to that section. If you're not sure what you need, start at the beginning. My current lessons tend to be structured around what I think you need to learn next. MyPath will be structured more like a book index. Check it out. It's coming along slowly. I've got so many projects in progress right now.
David Pierce
14 days ago
Thanks Richard, I will be very interested in this. I struggle with these things all the time and need a reference liabrary to choose from. I get so frustraited with using the web to find a not in list event for specific things and so much i just cant remember as i dont use them enough to get them correct. So yes, please......
Add a Reply
Happy to Help Upload Images   Link 
Austin Ritner 
14 days ago
Will do my best to help everyone, since you've been such a great help to me.
Add a Reply
AccessDevNET Upload Images   Link 
Adam Schwanz 
15 days ago
I'd be happy to assist with what I can too, good way to give back for all your help :).
Paul Evans
7 days ago
Adam,

First of all may I thank you most sincerely for the helping hand you offered to me yesterday. Unfortunately I could not get this to work. Are you prepared to help me further please? I did not really understand the tie up from the buttons to the Unbound Text field. In case you are able to offer me more help I will copy the three Sub-routines that I am using. Are you able to copy them to a Word Document and edit them based on the suggestions that you made and return to me? Thank you very much.
Adam Schwanz
7 days ago
If you can e-mail me the code your using and a screenshot so I can make sure I understand what's going on then sure, I will try.

aschwanz@hotmail.com
Add a Reply
Ill Help the Developers Upload Images   Link 
Richard Rost 
15 days ago
I should probably add that I'll do my best to assist the Developers who are assisting the clients. I just don't have to time to work with people one-on-one anymore. But if you (the Developer) get stuck, let me know and I'll either crank out a video or tell you what to do.
Mubeezi Micah
14 days ago
I am in. Thanx for the opportunity
Add a Reply
AccessDevNET Upload Images   Link 
Juan C Rivera 
15 days ago
I am interested, can help beginners, and some intermediate.  And if I can't that's what the Net is for.

V/r
Juan
Add a Reply

Show Older Comments...
View in Table Format

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:

2/24/2021Access Developer Forum
2/24/2021Widows & Orphans
2/23/2021Access Runtime
2/22/2021Table-Level Validation
2/21/2021Images
2/20/2021Not Updateable
2/20/2021Troubleshooter
2/19/2021Filter Records
2/18/2021Access Developer 26
2/17/2021Access Developer 27
 

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 developer network forum  PermaLink