Recent content by jazzscreamer

Thanks, I knew it had to be simple. Joel

Hi, I'm still a newbie when it comes to VB and VBA. I have coded in C++ for years and I was wondering what the correct way is to write code that can be reused by calling it in other parts of the program. What I'm talking about is just like a function in C++, but I don't know the correct way...

Hi, After sleeping on it overnight I came up with the solution today. Thank you. Joel

Hi, Thanks for your response. This would work if it was only a YesNo message box. However, it is a YesNoCancel message box. This means I need to have an If, ElseIf, Else statement. Again thank you for your response. Joel

Hi, I'm using a YesNoCancel message box. A skeleton of how I'm using it looks like this: If msgBox = Yes Then ..... ElseIf msgBox = No Then ..... End If The problem is that this displays my message twice. How do I do this without displaying the message twice. Thank you in advance. Joel

Hi Pat, Thanks for your reply. I got it figured out. Thanks anyway. Joel

Hi, Thank you, I have already read that and tried that syntax and have also tried the syntax that I posted. However, neither syntax has worked and I don't know why. Thank you again though for your response.

Hi, I am trying to copy my information from text boxes on one form over to text boxes on a subform that is on a seperate form. I have already read the Forms/Subform FAQ and I have successfully done this before. However, for some reason this is not working. If someone can just look at this...

Hi, I'm trying to turn off automatic updating so that the user has to click my save button. I know there must be a way to do this, I just can't figure it out. Thanks, Joel

For anyone that wants to know... Here is how I ended up doing this. I made new form, put all of my buttons on the top of it like a toolbar, then I made a subform and put my original form in this subform. This way the subform scrolls, but the toolbar stays stationary.

That is a good idea. I had thought of that but I didn't know if that was the proper way to get it done. Thanks, Joel

Hi, I'm sure this question has been answered a thousand times but I can't seem to find the answer that I'm looking for in the old posts. I am trying to put a toolbar on my form itself, not use an access toolbar in access. I have it so that the access window behind is closed, so all that you...

Hi, I know that this will work. But, how do I do it while still keeping my forms seperate? It seems that making my two forms nested subforms will make it so they are both on the same form. I'm looking for my CaseLookUp form to be a seperate form, not part of the Case form. Is there a way to...

I have a form called CaseLookUp. This form is opened in the Load Function of the Case form. CaseLookUp should be populated only with records belonging to a certain idNumber on the Case form. How do I make it so that this happens. If you have any question feel free to ask. Thanks, Joel

Thank you again As always, great advice. Thanks again, Joel