Search results

Thank you so much JHB! It works perfectly!!!!!!

I'm attaching the backend again! This has all the tables required. The table for the frm_mot_tab is "MOTReviewT" Thanks and sorry for the inconvenience!

JHB : I've attached the backend to this post! Sorry about that.

JHB : The name of the form is the "frm_mot_tab".

Gasman - The error isn't from the code because commented out the code and it still throws the same error. I have three other forms that follow the same naming conventions , same code and the same process and they work fine. I'm pretty new to MS Access. Arnelgp - I do not have the...

Gasman - The error isn't from the code because commented out the code and it still throws the same error. I have three other forms that follow the same naming conventions , same code and the same process and they work fine. I'm pretty new to MS Access. Arnelgp - I do not have the...

This is the code: Private Sub Command455_Click() Dim strSQL1 As String Dim strSQL2 As String Dim strSQL3 As String Dim strSQL4 As String strSQL1 = "INSERT INTO MOTReviewIterations ( fk_project_id, [Date], [Is the project located on an arterial street, " _ & "located in a comme], [A Traffic...

I have a form in which i put a button and built a "on-click" command. I've attached the error file along with this thread. This only started to occur once i put the on-click VBA in. It was working fine before that. When I click on the help section i get the following message: "This error occurs...

Oh okay.I'm gonna try and explain the design, So I totally have six checklists forms and tables and a master table called the project table that consists of the projectid(Autonumber) as a primary key that tracks all the projects. The checklists have their own primary...

Yes! It tracks what the user has entered for that sentence.

The form that I have is a checklist with the drop downs and i couldn't post the field names as they are confidential. That is the reason I recreated the code, all the fields are a set of questions in the checklist that have three options "yes,no,NA". I'm pretty new to the Access world.

I have two tables(main table and history table) and a form for the Main table. The Main form consists of multiple drop downs. I want to track the history of the selections in those drop downs. So when a user makes several changes in the Main form, the previous selections need to go to the...

Thank you!

Thank you! it worked fine.

I have the following code that i need to write in vb after button click but i'm not able to write it because it is too big. I know that you could use "_" or "& _" for strings. But these are fields columns in the table and i'm pretty new to MS Access. Any help is appreciated. The Sample code...