Search results

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

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

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

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

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

Hi, I created a switchboard using the built in switchboard manager. I then accidentally deleted my switchboard from my project(stupid mistake on my part). However, the manager is not letting me put the switchboard back into the project. Is there a way to do this? Thanks for any help. Joel

Hi, I'm trying to open a form use a command button. I open the other form using the DoComd method and then I have it go to a New Record. My problem is that I can't figure out how to get an id box to be populated with the id value on my parent form. I can open up a form on a record that...

Hi, I'm trying to open up a form named "Case" from a subform named "Case List". "Case List" is on the form "Client". I'm opening case with a control button on the subform. I want "Case" to be opened to the same caseID that is selected in "Case List". This is the code I have now...

How do you save a value from a text box in something that is not it's control source? Thanks for any help. Joel

Hello, I have what is probably a relatively simple question. I have one form and I am looking to save the value of an object in three different records, each record is in a different table. How would I go about doing this? Thank you for any help you can provide me with.