Search results

I have a search form, which has a text box. The user can type in text and then click search. The text box can have numbers or letters. It then searches for the text in a table. I was wondering if anyone knew how to write the code for the If statement. The text box can only have 4 characters. I...

Does anyone know how to put a specific part of a text of a message box on the next line. MsgBox("Click OK and Immediately Insert the ID " & right(Me.Discl, 2) & "-" & Me![Number] & ".") I would like the numbers to be on the next line. So it would read "Click OK and Immediately Insert the...

I have a database that contains a few tables and queries etc. I made a copy of this database so that I could change some of the VB code with out affecting the database information. I have completed all the code and now I want to input those old tables into my finished verion. I am not sure how...

I have this bit of code that pulles up the query "ID answer" based on inputs the user gives. I wanted to open the first record on that list of "ID Answer." in a form view. I added the openform function but it does not work. It does not open the form. I was wondering if anyone had any...

Hope everyone is having a great day. This is my first post. I am very new at Access and Visual Basic. My boss has given me a database which he wants me to fix. I have run into a problem. I have a form which has a button on it called "update." The user enters information such as the Status, or...

Hope everyone is having a great day. I am very new at Access and Visual Basic. My boss has given me a database which he wants me to fix. I have run into a problem. I have a form which has a button on it called "update." The user enters information such as the Status, or the Title. After...