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

Two tables had their structure changed. And on the forms I added a few more text boxes. I deleted the 50 records, however when I add a new record the ID began at 950. Is there a way to make the ID go back to 900. So in my changed database the ID goes to 950 with 50 testing records. In the old...

Sorry, I am somewhat new at this. I am not quite sure what you are telling me to do. I dont want to delete all the records, but I would like to delete the last 50 records, if that is possible. My ID number is the autonumber. It is to keep track of the forms. If you could explain what I should do...

The only problem with this is that some of my tables have extra columns. I have the correct tables on my changed Database, but I added 50 records when I was testing the Database. Is there a way I can delete these 50 records, while also starting the autonumber back at where I left off. 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...

Any help please?

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