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. 

 

Help Building Database Upload Images   Link 
Kimya Wyatt 
4 days ago
We are a trucking company and have brokers/shippers and our contract drivers.  I've started a database where we can input load and shipper information via a form and create invoices.  I want to now implement pay stubs for our drivers which would include all their loads for a given pay period, charge backs and their net pay.  I'm looking for someone willing to support me through the many road blocks I came across as I build, and of course am willing to pay for the support. Thanks!
Adam Schwanz
3 days ago
I would be willing to help if you want to contact me at aschwanz@hotmail.com to discuss what you need and costs

Thanks
Adam
Kimya Wyatt
3 days ago
Thank you!  I will send you an email now.
Add a Reply
timesheet not hiding unvoiced Upload Images   Link 
Michelle Seidelin 
12 days ago
Hello everyone wondering if someone would be able to help for some reason, I am missing the code in timesheet to hide the invoiced items as in for video call timesheet extended cut the rest of it seems to be working perfectly wondering if anybody has any suggestions I can send I cut down version without sensitive information to anyone who may be able to help I am only up to expert 12 but have done up to this end timesheet using VBA coding as shown Read More...
Add a Reply
What have I done wrong Upload Images   Link 
Michelle Seidelin 
12 days ago
Hello everyone

I am trying to add the timesheet to the database which I built in an earlier class everything is working as far as I can see except that doesn't ask me do I want to create an invoice and it doesn't hide there invoiced items I must have missed something out here is the code that I have in the button which does the invoicing Read More...
Adam Schwanz
12 days ago
If thats all the code you have you are missing stuff. Watch the extended cut again, mainly from 22minutes onward and see if that helps
Michelle Seidelin
12 days ago
thanks
Add a Reply
Help needed with a search box Upload Images   Link 
Nicole Muller 
27 days ago
Hi, I'm just learning Access and I have one major obstacle that I can't figure out how to solve. I'm hoping a more advanced developer can help. I have one table with client names and information. I have another table with referrals.  Each client can have multiple referrals.  I'm trying to build a search box where I can search to see if a client already exists and if they do, add the new referral.  If they are not found in the search, it means I need to add a new client.  I've tried to do this with having the client lookup in the top of the form and the referral information in a subform. If I use a combo box, it wants me to choose someone and doesn't like if I don't make a choice. Any suggestions on how to do this? Thank you.
Adam Schwanz
26 days ago
You can do this with a text box and an after update event. It's going to take some VBA coding. The text box searching is covered in Access Dev 8 (it's search as you type with key press but can be used on after update) you would just need to add in a DLOOKUP in the afterupdate event, if it returns null then some code to open up your new client form. If you're just beginning this is probably out of your current scope of understanding. I'd suggest just keep going with the lessons and learning, if it's that urgent me or some of the other devs on here do consults for hire, but it's going to be more rewarding in the end if you kept learning.
Nicole Muller
26 days ago
Hi Adam,
Thanks for your speedy response. I'm glad this is something that can be programmed. You are right that it's out of the scope of my present learning. I do plan to continue classes so that I can manage and make changes to the database. I am interested in learning more about your fee for service. I'm a social worker and am trying to learn this so that I can better serve and understand the client need and referral trends. So, I am trying to learn and build this on top of a 50-60 hr week.
Add a Reply
SCAT Database Upload Images   Link 
Joseph Messina 
32 days ago
Hi Richard:

I'm so proud of mysrlf.  I fixed my SCAT database.  I took out the split form that I had and created a continuous form and moved my search by date range to the continuous form and buttons I had on the other form.  I understand if you are very busy still swamped if you are.  I would like to know if I can send you the dstabase to take a look at it to see what you think about it.  I don't any help with it.  I juzt want you to look it over to see what you think how i built it and tske a look at eveeything in the VBA code.  Can you pleaze lwt me know.  I know will be paid support if you look at it or if you just want me to send you screen shots.  Can you please let me know?
Joseph Messina
31 days ago

Joseph Messina
31 days ago

Add a Reply
Search for Customers Upload Images   Link 
Graham Hendricks 
2 months ago
Hi fellow Developers. I design the customer form base on Developer 18 lesson 4 and 5. Now I need to search for the customers from a search form. After I design the search form[Search as you type] and The Search Form works 100% . Read More...
Juan C Rivera
2 months ago
I like to see what was done can you share the database so I can see.  No promise but will give it a shot.

V/r
Juan
Graham Hendricks
2 months ago
Hi Juan , yes I can  share this database with you. What is your email ? Thanks in advance for your help.

Regards
Graham
Add a Reply
Search for customers Upload Images   Link 
Graham Hendricks 
2 months ago
Hi Developer students. I design the customer form base on Developer 18 lesson 4 and 5. Now I need to able to search for the customers from a search form. After I design the search form[Search as you type] and The Search Form works 100% . Read More...
Add a Reply
SubField Error Upload Images   Link 
Abraham Breuer 
3 months ago
anyone to help me?
I am having trouble when adding data to my subform, when I add a line to the subform I get this error (see below the screenshot) and the child's field (The field which should be making the relation between the master and subform) doesn't get edited Read More...
Abraham Breuer
3 months ago

Richard Rost
3 months ago
Did you run down the Troubleshooter?
Add a Reply
Search combo box Upload Images   Link 
Abraham Breuer 
3 months 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
3 months ago
does NOT search
sorry
Richard Rost
3 months ago
Impossible to tell without seeing it. Something is set up wrong.
Add a Reply
Multiple Addresses Upload Images   Link 
Joseph Messina 
3 months 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
3 months 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
3 months ago
Are you looking for someone else to set it up for you?
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:

5/2/2021Split Commissions
4/30/2021Close Form
4/30/2021Close All Forms
4/29/2021Quick Queries #3
4/26/2021Combining Names
4/18/2021Volume
4/8/2021Age, Part 2
3/30/2021Accounts Receivable
3/28/2021Time & Billing
3/28/2021Time & Billing Template
 

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