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.

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...

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

Show 4 More Replies...

Michelle Seidelin
12 days ago

Hello again

Wondering if you would be willing to have a look at my database I would send youa cut down version without the sensitive personal information with just some dummy data to see if you can figure out where I have gone wrong I may be showing up as a developer student but I'm still working on the expert level please let me know and I will send you a link to a copy of cut down version without my instore information via OneDrive

Michelle thank you for any help you may be able to give

Richard Rost
12 days ago

I've moved this post to the Access Developer Network. If you want someone to work on your database for you, post it here, not in the general Access Forum. See Rule #5.

Adam Schwanz
12 days ago

Hello Michelle, sorry, I don't have the free time right now to look at your database. If you're looking to pay a fee to get it done I can make some time but stuff like this is best learned with trial and error on your own. Rick shows all the code you need in the video, if you have that in exactly, it works.

Michelle Seidelin
12 days ago

SORRY Richard this was done by mistake

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.

Show 3 More Replies...

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

Show 9 More Replies...

Joseph Messina
31 days ago

Hi Richard:

Please see screen shots of my SCAT database. I did what you told me to do. I understand if you aere very busy and swamped still. I'm not sure if you are still booked taking on projects. But, I don't need anything done with the database. I just want to know if i can send you my database just to take a look at to let me know what you think about it how I built it and to make sure looks good to you. Can you please let me know? I just want want your opinion how I did what you told me what to do with the continuous form.

Richard Rost
30 days ago

Hi Joseph. Sorry, but I don't have time right now to look at any databases, but your forms look fine. If everything is working, great. You do realize you've got some sensitive personal info in your screen shots, right? This is a PUBLIC forum. Do you want me to remove it?

Joseph Messina
30 days ago

Sorry I didn't realize that. I didn't mean to do that.. Sorry again, Yes you can remove them. I just wanted to show you how everything looks when I fixed the form took out the splitform and created the continuous form. Sorry again that some of the screen shots I posted that had some personal info. I will remember that for now on. I understand what you are saying. Just want to let youn know that i'm doing good how you are telling me not to have split forms and make continuous forms like i did. Also I been watching the lessons i get every week from you and also watching the techhelp videos. If anyhing else I do and want to show you. I will send you screen shots with the forms or with out any personal info or anything. I'm defnitelty so proud of myself what I'm doing and learning things. Thanks to the best instructor.

Joseph Messina
30 days ago

Hi Richard:

Thank you for removing that for me. Again, I will remember not to do not with personal information I definitely understand it is a public forum. I'm so glad I'm learnig all these different things with Access. So glad I'm learning from all the lessons and your techhelp videos. I'm definitely so proud of myself that i'm learning all these different things in Access and from all the lessons I get from you and the techhelp videos. Definitely help a lot. I keep on saying this. I will definitely continue to lear to get up there so I can do a lot more in Access. If I need you to look at anything else i do in Access with y databases to see how I am doing with them I willl just send you screen shots. I truly understand you are very busy and don't have time to llok at databases right now. In your opinion do you think I'm doing a great job with my databases so far?

Adam Schwanz
30 days ago

Hey Joseph, everyone has their own opinions on how a database should look. I see you've left a few comments wanting input on how your database looks. It doesn't look too bad, and remember what's most important is that you like it, and that it does what you want it to do. At the end of the day you're the one that has to keep looking at it :). Keep learning and if you have any problems we can try to help point you in the right direction in the forums, don't worry about appearances.

Joseph Messina
30 days ago

HI Adam:

Thank you so much for letting me know. I understand what you are saying. I've bee watching the lessons I get from Richard every week and also been watching the techhelp videos. I like the way I built my databases and learning how to different things so I can do something in any of my databases that i learned from the lessons and techhelp videos.

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

Show 15 More Replies...

Adam Schwanz
2 months ago

Not reviewing the video lessons, so hopefully I'm not shooting this way out into left field. Just assuming what you mean. If you mean it has no record source. I don't think you can do that with an unbound form. It has to have some way to link the list to the form. I use a code like this, I don't remember what lesson but I got the basics of it somewhere along the way in the dev classes.

Private Sub CustomerList_DblClick(Cancel As Integer)
    If IsNull(CustomerList) Then
    Exit Sub
    Else
    DoCmd.OpenForm "CustomerF", , , "CustomerID= " & CustomerList
    End If
End Sub

If yours is similar to this, it will never return a valid customerID because it's not bound to any table that has the ID in it.

Graham Hendricks
2 months ago

Hi Adam thanks for the reply, it is not working because the ALL the text fields in the Customer form are unbound.
Already try that option:
If IsNull(CustomerList) Then
    Exit Sub
    Else
    DoCmd.OpenForm "CustomerF", , , "CustomerID= " & CustomerList
    End If
End Sub

Any other solutions from your side?
Regards,
Graham

Alex Hedley
2 months ago

Why is is unbound?

Adam Schwanz
2 months ago

To open an unbound form based on a customerID in the list box, you'd have to tell it what values you wanted it to load. The easiest way (I don't suggest, this is way overcomplicating it) to do that would be to make every unbound field a DLOOKUP based on the ID from the previous forms search listbox. I'd just make them bound.

Graham Hendricks
2 months ago

Hi Alex, the Customer Form are base on Developer 18 lesson 4 and 5. The record set for the customer form works 100%. Need to be able search for the customers in that form, even with another customer search form. Hope you can help? Regards

Alex Hedley
2 months ago

Dev 18

Alex Hedley
2 months ago

But why are you doing it this way?
Lesson 4/5 was just a way to show you an example of how to use RSs

Why would you not bind the CustomerF to the CustomerT/CustomerQ?

Usually you'd have a search form and when you select the Customer you want you can open the single form with all its data.

Adam Schwanz
2 months ago

Ah this lesson was recordsets, my answers were only slightly into left field then :). But yea, unless you have some strange reason, I'm with Alex, just bind it.

Graham Hendricks
2 months ago

Already tried the CustomerF to the CustomerT then received numerous errors like duplicate indexes. First when create the customer form that link to CustomerT it works fine then after while give Index error messages, that is the reason why want to use RS

Alex Hedley
2 months ago

Is CustomerF a single form?
Is this one youve made yourself or one from the Template?

Adam Schwanz
2 months ago

If you don't get it solved here in the forum and want to send it to me I'll take a look later tonight when I get some free time. Unless Juan is already looking at it.

aschwanz@hotmail.com

Graham Hendricks
2 months ago

Thanks Adam, can I send the database tomorrow to you. Will send you the customer form with the search form , is that okay?
Alex I used the template and based the customer form on it.
Thanks guys for your help in advance

Juan C Rivera
2 months ago

I'm here if you guys need help.

Adam Schwanz
2 months ago

Yes, that's fine. You can send it to me or Juan, we will help if we can.

Graham Hendricks
2 months ago

Thanks guys, will forward db later

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...

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?

Show 4 More Replies...

Abraham Breuer
2 months ago

tried a lot of different ways but doesn't fix the problem I have no ole objects maby something to do with ActiveX
but I have no clue what ActiveX is Do you cover this topic anywhere?

Richard Rost
2 months ago

Only to tell you NOT to use them. In fact I just searched my outline, and the 2nd line under Access Developer 18, Lesson 1 says "Problems with ActiveX Controls." Try moving the form to a brand new, empty database WITHOUT any other ActiveX controls in it, and see if it works there.

Richard Rost
2 months ago

Could also be caused by having a table or form with an OLE Field. Again, I hate those. Get rid of them.

Abraham Breuer
2 months ago

Found that when I use the form wizard I don't get this error message, and the subform is working fine.
It's for sure the ActiveX control, however, I don't have any idea what ActiveX is, I guess I will need to have Patience until I get to Developer 18!!!
I believe that these obstacles give me the way to understand better how things work, experience doesn't just mean more years but proper understanding!!

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.

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?

Show 13 More Replies...

Richard Rost
3 months ago

I think that's what he's looking for, yes. He asked if I would do it for him - set his database up like the ABCD with the multiple addresses - but I just don't have the time to do it.