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