Search results

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

Hi, I'm looking to use a list box that is on what we'll call Form1 to control what record is selected on Form2 with the linking field between the two forms being idNumber. Thanks, Joel

Thanks Alright, that's kind of what I thought. That's too bad. Oh well. Thanks, Joel

Do you have to have access on your computer to run an access database? The reason I'm asking is that I've built a database for a non-profit organization and they don't have all that much money. So, if they don't have to buy access then it would be good for them. Thanks for any help. Joel

Hi, I'm trying to count on a form Client who's control source is the table Client. I am trying to count the number of times that an id# on my form occurs in the Visitation table. This query should show up in a text box on my client form. What is the best way to do this. Thank you for any...

Worked Thanks Thank you guys it worked